The main commercial data warehouse systems available to-day are based on record-oriented relational technology optimized for OLTP applications. Several authors have shown that substantial improvements in query performance for OLAP applications can be achieved by systems based on transposed files (column-oriented) technology, since the dominant queries require grouping and aggregation on a few columns of large amounts of data. This new assumption underlying data warehouse systems means that several aspects of data management and query processing need to be reconsidered. We present the results of an industrial research project aimed at implementing an SQL-compliant prototype data warehouse system based on transposed files. The paper focuses on the data structures and algorithms to support the optimization of star queries with group-by, and presents an experimental evaluation of the implemented system that shows that it performs favorably with respect to a traditional row-store system.

Star Query Plans in SADAS: A Data Warehouse System Based on Transposed Files

ALBANO, ANTONIO;
2006-01-01

Abstract

The main commercial data warehouse systems available to-day are based on record-oriented relational technology optimized for OLTP applications. Several authors have shown that substantial improvements in query performance for OLAP applications can be achieved by systems based on transposed files (column-oriented) technology, since the dominant queries require grouping and aggregation on a few columns of large amounts of data. This new assumption underlying data warehouse systems means that several aspects of data management and query processing need to be reconsidered. We present the results of an industrial research project aimed at implementing an SQL-compliant prototype data warehouse system based on transposed files. The paper focuses on the data structures and algorithms to support the optimization of star queries with group-by, and presents an experimental evaluation of the implemented system that shows that it performs favorably with respect to a traditional row-store system.
2006
8860680182
File in questo prodotto:
Non ci sono file associati a questo prodotto.

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11568/102024
 Attenzione

Attenzione! I dati visualizzati non sono stati sottoposti a validazione da parte dell'ateneo

Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus ND
  • ???jsp.display-item.citation.isi??? ND
social impact