Abstract
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 row-oriented tuples is called materialization.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
D.J. Abadi, D.S. Myers, D.J. DeWitt, S. Madden, Materialization strategies in a column-oriented dbms, in ICDE, ed. by R. Chirkova, A. Dogac, M.T. Ã-zsu, T.K. Sellis (IEEE, New York, 2007), pp. 466–475 Url: http://dblp.uni-trier.de/db/conf/icde/icde2007.html#AbadiMDM07
M. Grund, J. Krueger, M. Kleine, A. Zeier, H. Plattner, Optimal Query Operator Materialization Strategy for Hybrid Databases, in DBKDA (IARIA, Cancun, 2011), pp. 169–174
Author information
Authors and Affiliations
Corresponding author
Self Test Questions
Self Test Questions
-
1.
Which Strategy is Faster?
Which materialization strategy—late or early materialization—provides the better performance?
-
(a)
Early materialization
-
(b)
Late materialization
-
(c)
Depends on the characteristics of the executed query
-
(d)
Late and early materialization always provide the same performance.
-
(a)
-
2.
Disadvantages of Early Materialization
Which of the following statements is true?
-
(a)
The execution of an early materialized query plan can not be parallelized
-
(b)
Whether late or early materialization is used is determined by the system clock
-
(c)
Early materialization requires lookups into the dictionary, which can be very expensive and are not required when using late materialization
-
(d)
Depending on the persisted value types of a column, using positional information instead of actual values can be advantageous (e.g. in terms of cache usage or SIMD execution).
-
(a)
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Plattner, H. (2013). Materialization Strategies. In: A Course in In-Memory Data Management. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-36524-9_16
Download citation
DOI: https://doi.org/10.1007/978-3-642-36524-9_16
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-36523-2
Online ISBN: 978-3-642-36524-9
eBook Packages: Business and EconomicsBusiness and Management (R0)