Query Completion for Small-Scale Distributed Databases in PostgreSQL and MongoDB

Marin Fotache, Catalina Badea, Marius-Iulian Cluci and Codrin-Stefan Esanu
Additional contact information
Marin Fotache: Alexandru Ioan Cuza University of Iasi, Romania
Catalina Badea: Alexandru Ioan Cuza University of Iasi, Romania
Marius-Iulian Cluci: Alexandru Ioan Cuza University of Iasi, Romania
Codrin-Stefan Esanu: Alexandru Ioan Cuza University of Iasi, Romania

Database Systems Journal, 2025, vol. 16, issue 1, 11-27

Abstract: Relational/SQL and document/JSON data stores are competing but complementary technologies in OLAP (On-Line Analytical Processing) systems. Whereas traditional approaches for performance comparison use query execution time, this paper compares two distributed setups deployed on PostgreSQL/Citus and MongoDB by focusing solely on query completion within a 10-minute timeout. The TPC-H benchmark was converted into a denormalized JSON schema in MongoDB. An initial set of 296 SQL queries was executed in PostgreSQL/Citus and then mapped to MongoDB’s Aggregation Framework. Completion success was collected across six scenarios defined by two data sizes (0.01 GB, 0.1 GB) and three node counts (3, 6, 9). Relationships between completion rates and query parameters were assessed using statistical tests and machine learning techniques.

Keywords: PostgreSQL; Citus; MongoDB; SQL; Aggregation Framework; OLAP performance comparison (search for similar items in EconPapers)
Date: 2025
References: Add references at CitEc
Citations:

Downloads: (external link)
https://www.dbjournal.ro/archive/36/36_2.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:aes:dbjour:v:16:y:2025:i:1:p:11-27

Access Statistics for this article

Database Systems Journal is currently edited by Ion Lungu

More articles in Database Systems Journal from Academy of Economic Studies - Bucharest, Romania Contact information at EDIRC.
Bibliographic data for series maintained by Adela Bara ().