Recommending Database Architectures for Social Queries: A Twitter Case Study - Inria - Institut national de recherche en sciences et technologies du numérique Access content directly
Conference Papers Year : 2021

Recommending Database Architectures for Social Queries: A Twitter Case Study

Michael Marountas
  • Function : Author
  • PersonId : 1105471
Georgios Drakopoulos
  • Function : Author
  • PersonId : 1033610
Phivos Mylonas
  • Function : Author
  • PersonId : 992349
Spyros Sioutas
  • Function : Author
  • PersonId : 1058278

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.
Embargoed file
Embargoed file
0 0 25
Year Month Jours
Avant la publication

Dates and versions

hal-03287700 , version 1 (15-07-2021)

Licence

Attribution

Identifiers

Cite

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⟩
29 View
27 Download

Altmetric

Share

Gmail Facebook X LinkedIn More