A Survey of Holistic Approaches for Distributed Database Systems: From Conceptual Model to Deployment

IF 3.4 3区计算机科学 Q2 COMPUTER SCIENCE, INFORMATION SYSTEMS

IEEE Access Pub Date : 2025-07-10 DOI:10.1109/ACCESS.2025.3587670

Gonçalo Carvalho;Jorge Bernardino;Bruno Cabral;Vasco Pereira

{"title":"A Survey of Holistic Approaches for Distributed Database Systems: From Conceptual Model to Deployment","authors":"Gonçalo Carvalho;Jorge Bernardino;Bruno Cabral;Vasco Pereira","doi":"10.1109/ACCESS.2025.3587670","DOIUrl":null,"url":null,"abstract":"Database modeling defines the logical design, structure, and specifications for data storage and access within a DataBase Management System (DBMS), a core component of any Information System (IS). While conceptual database models (e.g., Entity-Relationship (ER) diagrams, Unified Modeling Language (UML)) facilitate the transition to physical models, they still fall short when it comes to supporting distributed and multi-layered architectures. Current approaches lack unified modeling abstractions, forcing manual reconciliation between high-level designs and their distributed implementations, leading to inefficiencies, deployment risks, and reliance on specialized teams. Existing tools (e.g., Kubernetes, Terraform) automate infrastructure but remain disconnected from Conceptual Models (CMs), requiring error-prone manual translation. This paper assesses the current state of the art in holistic approaches that aim to integrate modeling and deployment, identifies critical gaps in end-to-end automation, classifies the available deployment tools, and highlights advances that could enable building a distributed data management system based solely on its CM, potentially leading to greater agility and reduced operational complexity. Finally, the paper discusses open questions and research directions that indicate promising areas for future investigation.","PeriodicalId":13079,"journal":{"name":"IEEE Access","volume":"13 ","pages":"120830-120851"},"PeriodicalIF":3.4000,"publicationDate":"2025-07-10","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"https://ieeexplore.ieee.org/stamp/stamp.jsp?tp=&arnumber=11077123","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"IEEE Access","FirstCategoryId":"94","ListUrlMain":"https://ieeexplore.ieee.org/document/11077123/","RegionNum":3,"RegionCategory":"计算机科学","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q2","JCRName":"COMPUTER SCIENCE, INFORMATION SYSTEMS","Score":null,"Total":0}

引用次数: 0

Abstract

Database modeling defines the logical design, structure, and specifications for data storage and access within a DataBase Management System (DBMS), a core component of any Information System (IS). While conceptual database models (e.g., Entity-Relationship (ER) diagrams, Unified Modeling Language (UML)) facilitate the transition to physical models, they still fall short when it comes to supporting distributed and multi-layered architectures. Current approaches lack unified modeling abstractions, forcing manual reconciliation between high-level designs and their distributed implementations, leading to inefficiencies, deployment risks, and reliance on specialized teams. Existing tools (e.g., Kubernetes, Terraform) automate infrastructure but remain disconnected from Conceptual Models (CMs), requiring error-prone manual translation. This paper assesses the current state of the art in holistic approaches that aim to integrate modeling and deployment, identifies critical gaps in end-to-end automation, classifies the available deployment tools, and highlights advances that could enable building a distributed data management system based solely on its CM, potentially leading to greater agility and reduced operational complexity. Finally, the paper discusses open questions and research directions that indicate promising areas for future investigation.

查看原文本刊更多论文

分布式数据库系统整体方法综述：从概念模型到部署

数据库建模定义了数据库管理系统（Database Management System， DBMS）中数据存储和访问的逻辑设计、结构和规范，DBMS是任何信息系统（Information System， IS）的核心组件。虽然概念数据库模型（例如，实体-关系图，统一建模语言）促进了向物理模型的过渡，但是当涉及到支持分布式和多层体系结构时，它们仍然存在不足。当前的方法缺乏统一的建模抽象，迫使在高级设计和它们的分布式实现之间进行手工协调，从而导致效率低下、部署风险和对专门团队的依赖。现有的工具（例如，Kubernetes, Terraform）自动化基础设施，但仍然与概念模型（CMs）断开连接，需要容易出错的手动翻译。本文评估了旨在集成建模和部署的整体方法的当前状态，确定了端到端自动化中的关键差距，对可用的部署工具进行了分类，并强调了可以构建仅基于其CM的分布式数据管理系统的进展，这可能导致更大的敏捷性和降低操作复杂性。最后，本文讨论了尚未解决的问题和研究方向，指出了未来研究的前景。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

求助全文

约1分钟内获得全文求助全文

来源期刊

IEEE Access COMPUTER SCIENCE, INFORMATION SYSTEMSENGIN-ENGINEERING, ELECTRICAL & ELECTRONIC

CiteScore

9.80

自引率

7.70%

发文量

6673

审稿时长

6 weeks

期刊介绍： IEEE Access® is a multidisciplinary, open access (OA), applications-oriented, all-electronic archival journal that continuously presents the results of original research or development across all of IEEE''s fields of interest. IEEE Access will publish articles that are of high interest to readers, original, technically correct, and clearly presented. Supported by author publication charges (APC), its hallmarks are a rapid peer review and publication process with open access to all readers. Unlike IEEE''s traditional Transactions or Journals, reviews are "binary", in that reviewers will either Accept or Reject an article in the form it is submitted in order to achieve rapid turnaround. Especially encouraged are submissions on: Multidisciplinary topics, or applications-oriented articles and negative results that do not fit within the scope of IEEE''s traditional journals. Practical articles discussing new experiments or measurement techniques, interesting solutions to engineering. Development of new or improved fabrication or manufacturing techniques. Reviews or survey articles of new or evolving fields oriented to assist others in understanding the new area.