Open Access Open Access  Restricted Access Subscription or Fee Access

Overview of Query Materialization

Priyanka M. Yalagach, Kavitha G., Mohammad Rafi

Abstract


Abstract

A materialized view (MV) is the pre-calculated (materialized) result of a query. Unlike a simple view, the result of a materialized view is stored somewhere, generally in a table. Materialized views are used when immediate response is needed and the query where the materialized view bases on would take too long to produce a result. Materialized views have to be refreshed once in a while. It depends on the requirements how often a materialized view is refreshed and how actual its content is. Basically, a materialized view can be refreshed immediately or deferred. It can be refreshed fully or to a certain point in time.

 

Keywords: Database, materialized view, view, oracle, query, SQL, ware-house


Full Text:

PDF


DOI: http://dx.doi.org/10.37591%2Fecft.v7i3.2605

Refbacks

  • There are currently no refbacks.