Query Completion for Small-Scale Distributed Databases in PostgreSQL and MongoDB
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 M...
Saved in:
| Main Authors: | , , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Bucharest University of Economic Studies
2025-01-01
|
| Series: | Database Systems Journal |
| Subjects: | |
| Online Access: | https://www.dbjournal.ro/archive/36/36_2.pdf |
| Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
| _version_ | 1849703477884747776 |
|---|---|
| author | Marin FOTACHE Catalina BADEA Marius-Iulian CLUCI Codrin-Stefan ESANU |
| author_facet | Marin FOTACHE Catalina BADEA Marius-Iulian CLUCI Codrin-Stefan ESANU |
| author_sort | Marin FOTACHE |
| collection | DOAJ |
| description | 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. |
| format | Article |
| id | doaj-art-eaeee951b0f9465ca94b035abd7f31de |
| institution | DOAJ |
| issn | 2069-3230 |
| language | English |
| publishDate | 2025-01-01 |
| publisher | Bucharest University of Economic Studies |
| record_format | Article |
| series | Database Systems Journal |
| spelling | doaj-art-eaeee951b0f9465ca94b035abd7f31de2025-08-20T03:17:14ZengBucharest University of Economic StudiesDatabase Systems Journal2069-32302025-01-011611127RePEc:aes:dbjour:v:16:y:2025:i:1:p:11-27Query Completion for Small-Scale Distributed Databases in PostgreSQL and MongoDBMarin FOTACHE0Catalina BADEA1Marius-Iulian CLUCI2Codrin-Stefan ESANU3Alexandru Ioan Cuza University of Iasi, RomaniaAlexandru Ioan Cuza University of Iasi, RomaniaAlexandru Ioan Cuza University of Iasi, RomaniaAlexandru Ioan Cuza University of Iasi, RomaniaRelational/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.https://www.dbjournal.ro/archive/36/36_2.pdfpostgresqlcitusmongodbsqlaggregation frameworkolap performance comparison |
| spellingShingle | Marin FOTACHE Catalina BADEA Marius-Iulian CLUCI Codrin-Stefan ESANU Query Completion for Small-Scale Distributed Databases in PostgreSQL and MongoDB Database Systems Journal postgresql citus mongodb sql aggregation framework olap performance comparison |
| title | Query Completion for Small-Scale Distributed Databases in PostgreSQL and MongoDB |
| title_full | Query Completion for Small-Scale Distributed Databases in PostgreSQL and MongoDB |
| title_fullStr | Query Completion for Small-Scale Distributed Databases in PostgreSQL and MongoDB |
| title_full_unstemmed | Query Completion for Small-Scale Distributed Databases in PostgreSQL and MongoDB |
| title_short | Query Completion for Small-Scale Distributed Databases in PostgreSQL and MongoDB |
| title_sort | query completion for small scale distributed databases in postgresql and mongodb |
| topic | postgresql citus mongodb sql aggregation framework olap performance comparison |
| url | https://www.dbjournal.ro/archive/36/36_2.pdf |
| work_keys_str_mv | AT marinfotache querycompletionforsmallscaledistributeddatabasesinpostgresqlandmongodb AT catalinabadea querycompletionforsmallscaledistributeddatabasesinpostgresqlandmongodb AT mariusiuliancluci querycompletionforsmallscaledistributeddatabasesinpostgresqlandmongodb AT codrinstefanesanu querycompletionforsmallscaledistributeddatabasesinpostgresqlandmongodb |