Skip to Main content Skip to Navigation
Conference papers

Recommending Database Architectures for Social Queries: A Twitter Case Study

Abstract : Database deployment is a complex task depending on a multitude of operational parameters such as anticipated data scaling trends, expected type and volume of queries, uptime requirements, replication policies, available budget, and personnel training and experience. Thus, enterprise database administrators eventually rely on various performance metrics in conjunction to existing company policies in order to determine the best possible solution under these constraints. The recent advent of NoSQL databases, including graph databases such as Neo4j and document stores like MongoDB, added another degree of freedom in database selection since for a number of years relational databases such as PostgreSQL were the only available technology. In this work the scaling characteristics of a representative set of social queries executed on virtual machine installations of PostgreSQL and MongoDB are evaluated on a large volume of political tweets regarding Brexit. Moreover, Wiener filters for predicting the execution time of social query windows of fixed length over both databases are designed.
Document type :
Conference papers
Complete list of metadata

https://hal.inria.fr/hal-03287700
Contributor : Hal Ifip Connect in order to contact the contributor
Submitted on : Thursday, July 15, 2021 - 6:12:04 PM
Last modification on : Friday, August 13, 2021 - 4:29:53 PM
Long-term archiving on: : Saturday, October 16, 2021 - 7:09:31 PM

File

 Restricted access
To satisfy the distribution rights of the publisher, the document is embargoed until : 2024-01-01

Please log in to resquest access to the document

Licence


Distributed under a Creative Commons Attribution 4.0 International License

Identifiers

Citation

Michael Marountas, Georgios Drakopoulos, Phivos Mylonas, Spyros Sioutas. Recommending Database Architectures for Social Queries: A Twitter Case Study. 17th IFIP International Conference on Artificial Intelligence Applications and Innovations (AIAI), Jun 2021, Hersonissos, Crete, Greece. pp.715-728, ⟨10.1007/978-3-030-79150-6_56⟩. ⟨hal-03287700⟩

Share

Metrics

Record views

17