Sample Header Ad - 728x90

What does it mean to "materialize"?

9 votes
2 answers
6496 views
While learning about "data layout", I came across the term *"materialize"*, which does not have a clear definition and explanation. What is materialize and what does materialize do? This question is not related to materialized views, and is not specific to any particular DBMS. ### Context The source that I am learning from: [Youtube Video from Prof. Dr. Jens Dittrich : Mapping Relations to Devices](https://www.youtube.com/watch?v=K1VVIbvIo9U&t=332s) . **At timepoint 9:24** we have this term *materialize*. He said that is a process from physical page to storage devices. And an additional question at this time point: Since physical pages should also belong to main memory, if we have a *main-memory database*, so the data layout only exists in main memory, will there be a *materialize* process?
Asked by Jigao (167 rep)
Dec 28, 2018, 02:23 PM
Last activity: Nov 15, 2023, 05:41 PM