Modelling and querying star and snowflake warehouses using graph databases

Vaisman, Alejandro Ariel; Besteiro, María Florencia; Valverde Melito, Maximiliano Javier

ponencia en congreso.page.titleprefix
Modelling and querying star and snowflake warehouses using graph databases

dc.contributor.author	Vaisman, Alejandro Ariel
dc.contributor.author	Besteiro, María Florencia
dc.contributor.author	Valverde Melito, Maximiliano Javier
dc.date.accessioned	2020-06-26T20:51:31Z
dc.date.available	2020-06-26T20:51:31Z
dc.date.issued	2019
dc.description.abstract	"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."	en
dc.identifier.isbn	978-3030-302-77-1
dc.identifier.issn	1865-0929
dc.identifier.uri	http://ri.itba.edu.ar/handle/123456789/2231
dc.language.iso	en	en
dc.relation	info:eu-repo/grantAgreement/ANPCyT/PICT/2017-1054/AR. Ciudad Autónoma de Buenos Aires
dc.relation	info:eu-repo/semantics/altIdentifier/doi/10.1007/978-3-030-30278-8_18
dc.subject	ALMACENES DE DATOS	es
dc.subject	BASES DE DATOS ORIENTADAS A GRAFOS	es
dc.subject	SISTEMAS DE INFORMACION	es
dc.subject	OLAP	en
dc.subject	ANALISIS DE DATOS	es
dc.title	Modelling and querying star and snowflake warehouses using graph databases	en
dc.type	Ponencias en Congresos	es
dc.type	info:eu-repo/semantics/acceptedVersion
dspace.entity.type	Ponencia en Congreso
itba.description.filiation	Fil: Vaisman, Alejandro Ariel. Instituto Tecnológico de Buenos Aires; Argentina.
itba.description.filiation	Fil: Besteiro, María Florencia. Instituto Tecnológico de Buenos Aires; Argentina.
itba.description.filiation	Fil: Valverde Melito, Maximiliano Javier. Instituto Tecnológico de Buenos Aires; Argentina.