materialized View

Question

Hi, In Rdbms-: What is materialized View? Thanks

Jignesh Trivedi · Answer

hi, A Materialized View is effectively a database table that contains the results of a query. The power of materialized views comes from the fact that, once created, databse server can automatically synchronize a materialized view's data with its source information as required with little or no programming effort. Materialized views can be used for many purposes, including: * Denormalization * Validation * Data Warehousing * Replication. hope this help. http://www.databasejournal.com/features/oracle/article.php/2192071/Materialized-Views-in-Oracle.htm

Satyapriya Nayak · Answer

Hi Arjun, A materialized view is a replica of a target master from a single point in time. The master can be either a master table at a master site or a master materialized view at a materialized view site. Whereas in multimaster replication tables are continuously updated by other master sites, materialized views are updated from one or more masters through individual batch updates, known as a refreshes , from a single master site or master materialized view site Please refer the below link http://docs.oracle.com/cd/B10501_01/server.920/a96567/repmview.htm Thanks

materialized View

Answers (2)