A Hybrid SQL Query Execution Model for JSON Data: Balancing Resource Efficiency and Analytical Performance
Abstract
The rapid growth of unstructured and semi- structured data has necessitated the development of efficient query execution frameworks capable of handling complex data formats such as JSON. This paper presents a hybrid framework that intelligently leverages Apache Drill and DuckDB to optimize SQL query execution on JSON data. Our framework dynamically selects the appropriate query engine based on dataset size, available memory, and the nature of the SQL workload, effectively balancing memory efficiency with analytical performance. We explore the advantages of using Apache Drill for complex joins and nested JSON data, while DuckDB is employed for analytical queries when sufficient memory resources are available. Experimental results demonstrate the framework’s capability to reduce execution time and enhance resource utilization across various workloads. By providing insights into hybrid query processing techniques, this work aims to contribute to the efficient management of JSON
data in modern data-driven applications.
Keywords:
Hybrid Framework, SQL Queries, JSON Data, Apache Drill, DuckDB, Query Execution, Memory Utilization, Analytical Workload
Published
Issue
Section
License
Copyright (c) 2024 International Journal on Emerging Research Areas
This work is licensed under a Creative Commons Attribution 4.0 International License.
All published work in this journal is licensed under the Creative Commons Attribution 4.0 International License (CC BY 4.0). This license permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited.
How to Cite
Similar Articles
- K.M Gishma, K.B Annmaria , V.N Ramna Parvan , Anagha Suresh, Athira Shaji, LIP READING AND PREDICTION SYSTEM BASED ON DEEP LEARNING , International Journal on Emerging Research Areas: Vol. 3 No. 1 (2023): IJERA
- Fabeela Ali Rawther , Abhinay A K, Anagha Tess B, Alan Joseph , Adham Saheer, Evaluating Annotation Consistency in Offensive Language Detection: A Data Analytics Approach on the TweetEval Dataset , International Journal on Emerging Research Areas: Vol. 5 No. 1 (2025): IJERA
- Tiny Molly v, Alanta Maria Shaji , Adithya Biju , Anjali Krishna Satheesh , Athulya Pradeep, Literature Survey On Cloudsentry AI , International Journal on Emerging Research Areas: Vol. 6 No. 1 (2026): IJERA
- Minu Cherian, Sivakami Sudesh, Sivani M Kumar, Sneha J Kannan, Sneha Rose Vinod, A Review Based On Deep Learning Techniques Of Ovarian Cancer Detection , International Journal on Emerging Research Areas: Vol. 6 No. 1 (2026): IJERA
- Kashinath Remeshkumar, Abhijith R R Abhijith, Dan Philip Bobby, Kevin Varghese Theveril, Hema H H Hema, Zero Shot Low Light Image Enhancement using Vision Language Models and Semantic Diffusion , International Journal on Emerging Research Areas: Vol. 6 No. 1 (2026): IJERA
- Jyothika Anil, Milan Joseph Mathew, Namitha S Mukkadan, Reshmi Raveendran, Rintu Jose, Driver Drowsiness Detection Using Smartphone Application , International Journal on Emerging Research Areas: Vol. 3 No. 1 (2023): IJERA
- Betzy Babu Thoppil, Midhun P Mathew, Sania Elsa Reji, Nazreen Shanavaaz, Unnimaya v Ashok, Nila S S Nila, Comparative Study of Deep Learning Models for Pneumonia Classification , International Journal on Emerging Research Areas: Vol. 6 No. 1 (2026): IJERA
- Eric Biji Varghese, MediLens: An AI-Powered Medicine Information and Assistance System , International Journal on Emerging Research Areas: Vol. 6 No. 1 (2026): IJERA
- Fabeela Ali Rawther, Abhinay A K, Anagha Tess B, Alan Joseph, Adham Saheer, Survey of Machine Learning and Deep Learning Approaches for Automated Hate Speech Detection and Sentiment Analysis in Multilingual Contexts , International Journal on Emerging Research Areas: Vol. 4 No. 2 (2024): IJERA
- Alan K George, Arpita Mary Mathew, Asin Mary Jacob, Elizabeth Antony, Shiney Thomas, Lung Cancer Subtype Classification Using Deep Learning Models , International Journal on Emerging Research Areas: Vol. 5 No. 1 (2025): IJERA
You may also start an advanced similarity search for this article.