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
- Jyothis Joseph, Angeetha Raju, Aparna Santhosh, Ashitha Jenish, K S Minu, Survey on Fake Profile Detection in Social Media , International Journal on Emerging Research Areas: Vol. 3 No. 1 (2023): IJERA
- Jesvin Saji, Johan Joseph, Irin Alex, Mathew Jobey, R Neenu, Deep Learning and Machine Learning Approaches for Satellite-Based Environmental Monitoring: A Comprehensive Survey , International Journal on Emerging Research Areas: Vol. 6 No. 1 (2026): IJERA
- Tebin Joseph, Pranav Thamban Nair, Sam Kattiveettil James, Mrs Tintu Alphonsa Thomas , Pest Prediction in Rice using IoT and Feed Forward Neural Network , International Journal on Emerging Research Areas: Vol. 4 No. 1 (2024): IJERA
- Elsa George , Alphonsa Francis, Anna Job, Ann Maria James, Shiney Thomas, YOLOv8-Driven Approach for Wildlife Detection and Recognition , International Journal on Emerging Research Areas: Vol. 5 No. 1 (2025): IJERA
- Anu Rose Joy, An overview of Fake News DetectionusingBidirectional Long Short-TermMemory(BiLSTM)Models , International Journal on Emerging Research Areas: Vol. 3 No. 1 (2023): IJERA
- Aman M Hafees, Aman Yunus, Aashish Tom Raju , Agnus Roy, Ansamol Varghese, PowerPath: A Mobile Application for Transformer Monitoring and Maintenance , International Journal on Emerging Research Areas: Vol. 5 No. 1 (2025): IJERA
- Sumi Joseph, Diana George, Ruthi Namburi, Dhanya Prathap, Artificial Intelligence in Opthamology:A study on different AIML approaches for Glaucoma prediction , International Journal on Emerging Research Areas: Vol. 6 No. 1 (2026): IJERA
- P Sathya Narayan, Safad Ismail, Developing an Empathetic Interaction Model for Elderly in Pandemics , International Journal on Emerging Research Areas: Vol. 3 No. 1 (2023): IJERA
- Sreyas George, Gregan George, Ruth Tennyson, Rishil Shajan, Dr. Juby Mathew, MindPulse: Employee Mental Health Detection and Attrition Prediction App , International Journal on Emerging Research Areas: Vol. 5 No. 1 (2025): IJERA
- Arun Robin, Tijo Thomas Titus, Ms. Minu Cherian, Improved Handwritten Digit Recognition Using Deep Learning Technique , International Journal on Emerging Research Areas: Vol. 3 No. 2 (2023): IJERA
You may also start an advanced similarity search for this article.