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
- Rina Kobayashi, Algorithmic Decision Engines and The Regulatory Frontier: A Multi-Dimensional Analysis of Machine Learning Architectures and Governance in Global Financial Ecosystems , International Journal of Modern Computer Science and IT Innovations: Vol. 3 No. 02 (2026): Volume 03 Issue 02
- Dr. Lukas Weber, Dr. Anna Schmidt, An Optimized Convolutional Neural Network Architecture for Accurate Skin Lesion Analysis and Intelligent Skin Cancer Prediction System , International Journal of Modern Computer Science and IT Innovations: Vol. 3 No. 05 (2026): Volume 03 Issue 05
- Serhii Svynarov, AI-Driven Automation in Cloud-Based Business Systems: A Practical Implementation Using Microservices Architecture , International Journal of Modern Computer Science and IT Innovations: Vol. 3 No. 05 (2026): Volume 03 Issue 05
- Dr. Elena Marovic, Hyperautomation-Driven Financial Workflow Transformation: Integrating Generative Artificial Intelligence, Process Mining, and Enterprise Digital Architectures , International Journal of Modern Computer Science and IT Innovations: Vol. 3 No. 01 (2026): Volume 03 Issue 01
- Dr. Nurul H. Zulkifli, Dr. Farah M. Rahimi, ACCOUNTABLE DATA AUTHORIZATION IN CLOUD ENVIRONMENTS: AN IDENTITY-BASED ENCRYPTION FRAMEWORK WITH EQUALITY TESTING , International Journal of Modern Computer Science and IT Innovations: Vol. 2 No. 01 (2025): Volume 02 Issue 01
- Dr. Elena M. Petrovic, Dr. Rajan V. Subramaniam, A COMPREHENSIVE REVIEW AND EMPIRICAL ASSESSMENT OF DATA AUGMENTATION TECHNIQUES IN TIME-SERIES CLASSIFICATION , International Journal of Modern Computer Science and IT Innovations: Vol. 2 No. 07 (2025): Volume 02 Issue 07
- John A. Prescott, A Unified Framework for Time-Sensitive and Resilient In-Vehicle Communication: Integrating Automotive Ethernet, Wireless TSN, and IoTEnabled Vehicle Health Monitoring , International Journal of Modern Computer Science and IT Innovations: Vol. 2 No. 08 (2025): Volume 02 Issue 08
- Alistair J. Finch, Sustainable Development and Mechanical Performance of Natural FiberâReinforced Polymer Composites: Comprehensive Analysis, Methodologies, and Future Directions , International Journal of Modern Computer Science and IT Innovations: Vol. 2 No. 05 (2025): Volume 02 Issue 05
- Rahul van Dijk, Advancing Circular Business Models through Big Data and Technological Integration: Pathways for Sustainable Value Creation , International Journal of Modern Computer Science and IT Innovations: Vol. 2 No. 12 (2025): Volume 02 Issue 12
- Dr. Julian C. Vance, Prof. Anya Sharma, Synergistic Integration of AI and Blockchain: A Framework for Decentralized and Trustworthy Systems , International Journal of Modern Computer Science and IT Innovations: Vol. 2 No. 08 (2025): Volume 02 Issue 08
You may also start an advanced similarity search for this article.