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
- Prof. Isabella Rossi, Dr. Luis Fernando PĂĄez, GEOSPATIAL ANOMALY DETECTION FOR ENHANCED SECURITY IN DELAY-TOLERANT NETWORKS , International Journal of Modern Computer Science and IT Innovations: Vol. 1 No. 01 (2024): Volume 01 Issue 01
- Dr. Oliver Bennett, Dr. Sophie Williams, Scalable Machine Learning Approach in R for Structural Classification and Behavioral Analysis of Massive Twitter Network Data , International Journal of Modern Computer Science and IT Innovations: Vol. 3 No. 06 (2026): Volume 03 Issue 06
- Dr. Rania E. El-Gamal, EMPIRICAL CHARACTERIZATION OF IOT FIRMWARE VERSION DIVERSITY AND PATCHING STATUS , International Journal of Modern Computer Science and IT Innovations: Vol. 2 No. 03 (2025): Volume 02 Issue 03
- Dr. Erik G. Johansson, Dr. Linnea K. Blomqvist, LEVERAGING PERSISTENCE AND GRAPH NEURAL NETWORKS FOR ENHANCED INFORMATION POPULARITY FORECASTING , International Journal of Modern Computer Science and IT Innovations: Vol. 2 No. 04 (2025): Volume 02 Issue 04
- Dr. Isabella D. Ricci, Dr. Farah A. Rahman, OPTIMIZING WEB DEVELOPMENT THROUGH STRATEGIC WEB FRAMEWORK ADOPTION , International Journal of Modern Computer Science and IT Innovations: Vol. 2 No. 05 (2025): Volume 02 Issue 05
- Dr. Sofia Duarte, Jiwon Park, SECURING LARGE-SCALE IOT NETWORKS: A FEDERATED TRANSFER LEARNING APPROACH FOR REAL-TIME INTRUSION DETECTION , International Journal of Modern Computer Science and IT Innovations: Vol. 2 No. 06 (2025): Volume 02 Issue 06
- Oleksandr Orlov, Engineering Compliant Enterprise Systems: Architectural Constraints and Quality Practices in Regulated Industries , International Journal of Modern Computer Science and IT Innovations: Vol. 3 No. 07 (2026): Volume 03 Issue 07
- Prof. Lucas F. Oliveira, SM9-ENHANCED KEY-POLICY ATTRIBUTE-BASED ENCRYPTION: DESIGN, ANALYSIS, AND APPLICATIONS , International Journal of Modern Computer Science and IT Innovations: Vol. 2 No. 06 (2025): Volume 02 Issue 06
- James T. Holloway, Modularity, Resilience, and Functional Redundancy: Integrating Microservices Architecture Principles with Tropical Montane Cloud Forest Dynamics , International Journal of Modern Computer Science and IT Innovations: Vol. 3 No. 01 (2026): Volume 03 Issue 01
- Anh N. Tran, Siew H. Lim, A Critical Analysis of Apache Kafka's Role in Advancing Microservices Architecture: Performance, Patterns, and Persistence , International Journal of Modern Computer Science and IT Innovations: Vol. 2 No. 10 (2025): Volume 02 Issue 10
You may also start an advanced similarity search for this article.