Recommending Database Architectures for Social Queries: A Twitter Case Study - Inria - Institut national de recherche en sciences et technologies du numérique
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.
Fichier principal
Vignette du fichier
509922_1_En_56_Chapter.pdf (262.01 Ko) Télécharger le fichier
Origin Files produced by the author(s)

Dates and versions

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

Licence

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⟩
49 View
84 Download

Altmetric

Share

More