Evaluating Query Processing Architectures in Relational and Document Databases

  • Unique Paper ID: 182656
  • PageNo: 2732-2736
  • Abstract:
  • Query processing architectures in relational and document-oriented databases differ significantly in how they handle core operations like selection, sorting, and joins. Relational databases rely on fixed schemas, cost-based optimizers, and strong ACID guarantees to efficiently process complex queries with multiple joins. In contrast, document databases offer flexible schemas and horizontal scalability, using pipeline-based query execution with denormalized data models optimized for semi-structured data. This comparative analysis explores trade-offs in schema design, indexing strategies, query optimization, scalability, and consistency, providing insights to help choose the best database system for specific application needs.

Copyright & License

Copyright © 2026 Authors retain the copyright of this article. This article is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

BibTeX

@article{182656,
        author = {Nimisha Modi and Jayshri Patel},
        title = {Evaluating Query Processing Architectures in Relational and Document Databases},
        journal = {International Journal of Innovative Research in Technology},
        year = {2026},
        volume = {12},
        number = {2},
        pages = {2732-2736},
        issn = {2349-6002},
        url = {https://ijirt.org/article?manuscript=182656},
        abstract = {Query processing architectures in relational and document-oriented databases differ significantly in how they handle core operations like selection, sorting, and joins. Relational databases rely on fixed schemas, cost-based optimizers, and strong ACID guarantees to efficiently process complex queries with multiple joins. In contrast, document databases offer flexible schemas and horizontal scalability, using pipeline-based query execution with denormalized data models optimized for semi-structured data. This comparative analysis explores trade-offs in schema design, indexing strategies, query optimization, scalability, and consistency, providing insights to help choose the best database system for specific application needs.},
        keywords = {Query Processing, Relational Databases, Document Databases, Schema Flexibility, Database Scalability.},
        month = {January},
        }

Cite This Article

Modi, N., & Patel, J. (2026). Evaluating Query Processing Architectures in Relational and Document Databases. International Journal of Innovative Research in Technology (IJIRT). https://doi.org/doi.org/10.64643/IJIRTV12I2-182656-459

Related Articles