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