[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to main content
Springer Nature Link
Log in

Another Example of a Data Warehouse System Based on Transposed Files

  • Conference paper
Advances in Database Technology - EDBT 2006 (EDBT 2006)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 3896))

Included in the following conference series:

  • 1685 Accesses

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

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Similar content being viewed by others

References

  1. Boncz, P.A., Kersten, M.L.: MIL Primitives for Querying a Fragmented World. The VLDB Journal 8, 101–119 (1999)

    Article  Google Scholar 

  2. Chaudhuri, S., Shim, K.: Including Group-By in Query Optimization. In: Proc.Intl. Conf. on VLDB, Santiago, Chile, pp. 354–366 (1994)

    Google Scholar 

  3. 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)

    Google Scholar 

  4. 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)

    Google Scholar 

  5. 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)

    Google Scholar 

  6. Stonebraker, M., et al.: C-Store: A Column-Oriented DBMS. In: Proc. Intl. Conf. on VLDB, Trondheim, Norway, pp. 553–564 (2005)

    Google Scholar 

  7. 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)

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Dept. of Computer Science, Univ. of Pisa, Largo B. Pontecorvo 3, 56127, Pisa, Italy

    Antonio Albano

  2. Advanced Systems, Via Napoli 159, 80013, Casalnuovo di Napoli (NA), Italy

    Luca De Rosa

  3. Sisteme Avanzate Italo-Romane, Calea Victoriei 155, Bucarest 1, Romania

    Cristian Dumitrescu

  4.  

    Lucio Goglia, Roberto Goglia & Vincenzo Minei

Authors
  1. Antonio Albano
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Luca De Rosa
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Cristian Dumitrescu
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Lucio Goglia
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Roberto Goglia
    View author publications

    You can also search for this author in PubMed Google Scholar

  6. Vincenzo Minei
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. University of Athens, Greece

    Yannis Ioannidis

  2. University of Konstanz, P.O.Box D188, 78457, Konstanz, Germany

    Marc H. Scholl

  3. Sustainable Content Logistics Centre, Hamburg, Germany

    Joachim W. Schmidt

  4. Chair of Software Engineering for Business Information Systems, Technische Universität München, Boltzmannstraße 3, 85748, Garching b. München,  

    Florian Matthes

  5. Department of Informatics, University of Athens Panepistimiopolis, 15771, Athens, Greece

    Mike Hatzopoulos

  6. IPD, Universität Karlsruhe, Am Fasanengarten 5, 76131, Karlsruhe,  

    Klemens Boehm

  7. TU München, D-85748, Garching, Germany

    Alfons Kemper

  8. Technische Universität München, Germany

    Torsten Grust

  9. Institute for Computer Science, Ludwig-Maximilians Universität München,  

    Christian Boehm

Rights and permissions

Reprints 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)

Publish with us

Policies and ethics

Search

Navigation