A Survey of Holistic Approaches for Distributed Database Systems: From Conceptual Model to Deployment
Open Access
- 10 July 2025
- journal article
- Published by Institute of Electrical and Electronics Engineers (IEEE) in IEEE Access
- Vol. 13, 120830-120851
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.Keywords
Funding Information
- FCT - Fundação para a Ciência e a Tecnologia, I.P., in the framework of the Project (UIDB/00326/2025, UIDP/00326/2025)
This publication has 81 references indexed in Scilit:
- Distributed Database Systems: The Case for NewSQL2021
- A Conceptual Framework for Dynamic Planning of Alternative Routes in Road Networks2020
- Principles of Distributed Database Systems2020
- An Analysis of a Methodology that Transforms the Entity-Relationship Model into a Conceptual Model for a Graph Database2018
- QBX: A CASE Tool for Data Mart DesignLecture Notes in Computer Science, 2011
- Top_Keyword: An Aggregation Function for Textual Document OLAP2008
- Entity-Relationship Modeling2000
- Extending the E/R Model for the Multidimensional Paradigm1999
- Abstraction in conceptual model designInternational Journal of Human-Computer Studies, 1997
- What makes a good data model? Evaluating the quality of entity relationship models1994