Materialization Strategies

  • Hasso Plattner


SQL is the most common language to interact with databases. Users are accustomed to the table-oriented output format of SQL. To provide the same data interfaces as known from row stores in column stores, the returned results have to be transformed into tuples in row format. The process of transforming encoded columnar data into tuples is called materialization.


  1. [AMDM07]
    D.J. Abadi, D. S. Myers, D.J. DeWitt, S. Madden, Materialization strategies in a column-oriented DBMS, in ICDE, Istanbul, ed. by R. Chirkova, A. Dogac, M.T. Özsu, T.K. Sellis (IEEE, 2007), pp. 465–475Google Scholar
  2. [GKK+11]
    M. Grund, J. Krueger, M. Kleine, A. Zeier, H. Plattner, Optimal query operator materialization strategy for hybrid databases, in IARIA, pp. 169–174, 2011Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2014

Authors and Affiliations

  • Hasso Plattner
    • 1
  1. 1.Enterprise Platform and Integration ConceptsHasso Plattner InstitutePotsdamGermany

Personalised recommendations