Ponencia en Congreso:
Modelling and querying star and snowflake warehouses using graph databases

dc.contributor.authorVaisman, Alejandro Ariel
dc.contributor.authorBesteiro, María Florencia
dc.contributor.authorValverde Melito, Maximiliano Javier
dc.date.accessioned2020-06-26T20:51:31Z
dc.date.available2020-06-26T20:51:31Z
dc.date.issued2019
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.isbn978-3030-302-77-1
dc.identifier.issn1865-0929
dc.identifier.urihttp://ri.itba.edu.ar/handle/123456789/2231
dc.language.isoenen
dc.relationinfo:eu-repo/grantAgreement/ANPCyT/PICT/2017-1054/AR. Ciudad Autónoma de Buenos Aires
dc.relationinfo:eu-repo/semantics/altIdentifier/doi/10.1007/978-3-030-30278-8_18
dc.subjectALMACENES DE DATOSes
dc.subjectBASES DE DATOS ORIENTADAS A GRAFOSes
dc.subjectSISTEMAS DE INFORMACIONes
dc.subjectOLAPen
dc.subjectANALISIS DE DATOSes
dc.titleModelling and querying star and snowflake warehouses using graph databasesen
dc.typePonencias en Congresoses
dc.typeinfo:eu-repo/semantics/acceptedVersion
dspace.entity.typePonencia en Congreso
itba.description.filiationFil: Vaisman, Alejandro Ariel. Instituto Tecnológico de Buenos Aires; Argentina.
itba.description.filiationFil: Besteiro, María Florencia. Instituto Tecnológico de Buenos Aires; Argentina.
itba.description.filiationFil: Valverde Melito, Maximiliano Javier. Instituto Tecnológico de Buenos Aires; Argentina.

Archivos

Bloque original
Mostrando 1 - 1 de 1
Cargando...
Miniatura
Nombre:
Vaisman1_2019_INGINFORMAT.pdf
Tamaño:
313.48 KB
Formato:
Adobe Portable Document Format
Descripción:
Ponencia_Vaisman
Bloque de licencias
Mostrando 1 - 1 de 1
No hay miniatura disponible
Nombre:
license.txt
Tamaño:
1.6 KB
Formato:
Item-specific license agreed upon to submission
Descripción: