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
- Aneesh Varghese John, Aswathy Sadasivan, Augusto Varghese, Antony Jacob, Linsa Mathew, A Review of Online Donation Platforms , International Journal on Emerging Research Areas: Vol. 5 No. 1 (2025): IJERA
- Raihana Rasaldeen, Stefi Marshal Fernandez, Irin Rose Jaison, Ria Mariam , A Comparative Study of AI Models and AI-Based Approaches for Evaluating Subjective Answers in Exams , International Journal on Emerging Research Areas: Vol. 5 No. 1 (2025): IJERA
- Arun T S, Bhavana Rajesh Pillai, Devapriya L, Javaid Iqbal, Sreekala K S, Automated Hydroponics for Agricultural Applications , International Journal on Emerging Research Areas: Vol. 3 No. 1 (2023): IJERA
- Thomas Mathew Jose, Mathew Abraham, Sebastian Biju , Samuel Michael , Minu Cherian , Canine Dermal Analyser: Harnessing Artificial Intelligence and Deep Learning to Revolutionize Canine Skin Disease Detection , International Journal on Emerging Research Areas: Vol. 5 No. 1 (2025): IJERA
- Jesvin Jelson , Kesiya Rachel Johns, Mehak , Ken Jacob Zachariah, Neenu R, Custom Cart – Virtual try-on in e-commerce platforms using generative AI , International Journal on Emerging Research Areas: Vol. 5 No. 1 (2025): IJERA
- An Mariya Deve M D, Aswani Unni, Bhagya S, Abin Joseph, Dr. Aju Mathew George, Innovative Biochar Applications for Sustainable Water Purification , International Journal on Emerging Research Areas: Vol. 3 No. 1 (2023): IJERA
- Vinayak Prakash, Tresa Mariya Denny, Vivek Subash Nair, Sonal Varghese, Tom Kurian, FEATURE EXTRACTION AND CLASSIFICATION OF CERTIFICATES USING OCR , International Journal on Emerging Research Areas: Vol. 5 No. 1 (2025): IJERA
- Honey Joseph, Mathew Jobey, Joyel Xavier, Jerin Xavier, Jaice George, TutorConnect: A Transparent and Localized Tutoring Platform , International Journal on Emerging Research Areas: Vol. 5 No. 1 (2025): IJERA
- Rema M K, Muhamed Ajmal K R, Deepak T G, Roshini M, Muhammed Bazir, INTERACTIVE TOY , International Journal on Emerging Research Areas: Vol. 3 No. 1 (2023): IJERA
- Thomas P Reji, Vivek Vinod, Tomin Joe Justin, Sruthij S Nair, Tintu Alphonsa Thomas, Sphere : Smart Event Management Platform with Real-Time Updates and Seamless Collaboration , International Journal on Emerging Research Areas: Vol. 5 No. 1 (2025): IJERA
You may also start an advanced similarity search for this article.