Abstract
The major commercial data warehouse systems available today 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 only 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 some preliminary results of an industrial research project which is being sponsored by the Italian Ministry of Education, University and Research (MIUR) to support the cooperation of universities and industries in prototyping innovative systems. The aim of the project is to implement an SQL-compliant prototype data warehouse system based on a transposed file storage system. The paper will focus on the optimization of star queries with group-by.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Boncz, P.A., Kersten, M.L.: MIL Primitives for Querying a Fragmented World. The VLDB Journal 8, 101–119 (1999)
Chaudhuri, S., Shim, K.: Including Group-By in Query Optimization. In: Proc.Intl. Conf. on VLDB, Santiago, Chile, pp. 354–366 (1994)
Datta, A., Ramamritham, K., Thomas, H.M.: Curio: A N ovel Solution for Efficient Storage and Indexing in Data Warehouses. In: Proc. Intl. Conf. on VLDB, Edinburgh, Scotland, pp. 730–733 (1999)
French, C.D.: One size fits all Database Architectures do not Work for DDS. In: Proc. of the ACM SIGMOD Intl. Conf. on Management of Data, San Jose, California, USA, pp. 449–450 (1995)
Galindo-Legaria, C.A., Joshi, M.M.: Orthogonal Optimization of Subqueries and Aggregation. In: Proc. of the ACM SIGMOD Intl. Conf. on Management of Data, Santa Barbara, California, USA, pp. 571–581 (2001)
Stonebraker, M., et al.: C-Store: A Column-Oriented DBMS. In: Proc. Intl. Conf. on VLDB, Trondheim, Norway, pp. 553–564 (2005)
Turner, M.J., Hammond, R., Cotton, P.: A DBMS for Large Statistical Databases. In: Proc. Intl. Conf. on VLDB, Rio de Janeiro, Brazil, pp. 319–327 (1979)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Albano, A., De Rosa, L., Dumitrescu, C., Goglia, L., Goglia, R., Minei, V. (2006). Another Example of a Data Warehouse System Based on Transposed Files. In: Ioannidis, Y., et al. Advances in Database Technology - EDBT 2006. EDBT 2006. Lecture Notes in Computer Science, vol 3896. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11687238_71
Download citation
DOI: https://doi.org/10.1007/11687238_71
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-32960-2
Online ISBN: 978-3-540-32961-9
eBook Packages: Computer ScienceComputer Science (R0)