CONVERGENT DATABASE ARCHITECTURES: MULTI-MODEL DESIGN AND QUERY OPTIMIZATION IN NEWSQL SYSTEMS
Abstract
The contemporary data landscape, characterized by diverse data types and escalating volumes, has driven a significant evolution in database management systems. Traditional Relational Database Management Systems (RDBMS) often struggle with the scalability and flexibility required for modern applications, while NoSQL databases, though scalable, frequently compromise on transactional consistency. NewSQL systems have emerged as a hybrid solution, aiming to combine the ACID guarantees of RDBMS with the horizontal scalability of NoSQL. This report explores the critical need for multi-model capabilities within NewSQL DBMSs to efficiently manage heterogeneous data adhering to various data modelsâincluding relational, document, graph, and key-valueâwithin a single, unified database. It delves into the architectural considerations for supporting such diversity, examining storage paradigms like row-store, column-store, and hybrid approaches, alongside data distribution strategies such as sharding and partitioning. Furthermore, the paper investigates advancements in multi-model query languages, particularly SQL++ and extensions in SQL:2016, and discusses query optimization techniques essential for handling complex, hybrid workloads. Finally, it addresses the performance evaluation of these systems in big data environments, highlights current limitations, and outlines future research directions for achieving truly versatile and high-performing data management solutions.
Keywords
References
Similar Articles
- Hiroshi Tanaka, Architectural Synergies: Integrating Blockchain, Fog Computing, And Generative Intelligence for Secure Digital Twin Ecosystems in Cyber-Physical Systems , International Journal of Modern Computer Science and IT Innovations: Vol. 3 No. 02 (2026): Volume 03 Issue 02
- Ngozi Okafor, A Consumer-Driven Contract-Based Approach to Verifying User Interface Integration in Microservices Architectures , International Journal of Modern Computer Science and IT Innovations: Vol. 2 No. 10 (2025): Volume 02 Issue 10
- Eshmurodova Malikabonu, Odiljonov Ikromjon, Husanova Marjona, Mukhriddin Mukhiddinov, Data Science Approaches in The Education System and Their Pedagogical Significance , International Journal of Modern Computer Science and IT Innovations: Vol. 3 No. 05 (2026): Volume 03 Issue 05
- Alexander J. Morrison, Hyperautomation as an Institutional Catalyst: Integrating Generative Artificial Intelligence and Process Mining for the Transformation of Financial Workflows , International Journal of Modern Computer Science and IT Innovations: Vol. 3 No. 01 (2026): Volume 03 Issue 01
- Evgenii Lvov, Quality Assurance and Scalability: The Role of High-Test Coverage in Continuous Integration and Deployment Pipelines , International Journal of Modern Computer Science and IT Innovations: Vol. 3 No. 07 (2026): Volume 03 Issue 07
- Pedro C. Almeida, Prof. Laura B. Heinrich, LOCAL NODE COMPENSATION FOR ENHANCED STABILITY IN DISTRIBUTED SIGNED NETWORKS , International Journal of Modern Computer Science and IT Innovations: Vol. 2 No. 04 (2025): Volume 02 Issue 04
- Kseniia Pereshliuga, ALISMIA AI as a Tool for Digital Empowerment: Redesigning Client Interaction in Beauty Businesses , International Journal of Modern Computer Science and IT Innovations: Vol. 3 No. 05 (2026): Volume 03 Issue 05
- John Doe, Transforming Supply Chain Management Through Artificial Intelligence: A Holistic Theoretical Analysis , International Journal of Modern Computer Science and IT Innovations: Vol. 2 No. 09 (2025): Volume 02 Issue 09
- Dr. Elena MarkoviÄ, Hyperautomation as a Socio-Technical Paradigm: Integrating Robotic Process Automation, Artificial Intelligence, and Workforce Analytics for the Future Digital Enterprise , International Journal of Modern Computer Science and IT Innovations: Vol. 3 No. 01 (2026): Volume 03 Issue 01
- Dr. Abdulrahman O. Nassar, Dr. Cheng-Hao Lin, CHARACTERIZING CORE-PERIPHERY STRUCTURES IN NETWORKS VIA PRINCIPAL COMPONENT ANALYSIS OF NEIGHBORHOOD-BASED BRIDGE NODE CENTRALITY , International Journal of Modern Computer Science and IT Innovations: Vol. 1 No. 01 (2024): Volume 01 Issue 01
You may also start an advanced similarity search for this article.