Browsing by Author "Valverde Melito, Maximiliano Javier"
Now showing 1 - 2 of 2
Results Per Page
Sort Options
proyecto final de grado.listelement.badge Modelado y consulta de data warehouses usando bases de datos de grafo(2019-06) Besteiro, María Florencia; Valverde Melito, Maximiliano Javier; Vaisman, Alejandro Ariel"El objetivo de este proyecto es poder modelar y consultar un data warehouse usando bases de datos de grafos, de forma de poder comparar la performance del mismo en contraste con su alternativa relacional. Para ello se definirán distintos tipos de consultas que luego serán ejecutadas en ambos modelos, con el fin de determinar que situaciones se destaca cada uno de ellos en términos de performance."ponencia en congreso.listelement.badge Modelling and querying star and snowflake warehouses using graph databases(2019) Vaisman, Alejandro Ariel; Besteiro, María Florencia; Valverde Melito, Maximiliano Javier"In current “Big Data” scenarios, graph databases are increasingly being used. Online Analytical Processing (OLAP) operations can expand the possibilities of graph analysis beyond the traditional graphbased computation. This paper studies graph databases as an alternative to implement star and snowflake schemas, the typical choices for data warehouse design. For this, the MusicBrainz database is used. A data warehouse for this database is designed, and implemented over a Postgres relational database. This warehouse is also represented as a graph, and implemented over the Neo4j graph database. A collection of typical OLAP queries is used to compare both implementations. The results reported here show that in ten out of thirteen queries tested, the graph implementation outperforms the relational one, in ratios that go from 1.3 to 26 times faster, and performs similarly to the relational implementation in the three remaining cases."