1.5. Materialization Table

A Materialization Table is a cached view of a virtual table. When a query is issued against this virtual table, the contents can be served from memory space or redirected to a another table so results can be fetched from the original sources.

Internal materialization creates temporary tables to hold the materialized table. While these tables are not fully durable, they perform well in most circumstances and the data is present in each Red Hat JBoss Data Virtualiation instance, removing the risk of a single point of failure and the network overhead of an external database.

External materialized views cache their data in a matgerialization table in an external database system.