Overview of Query Materialization

Authors

  • Priyanka M. Yalagach
  • Kavitha G.
  • Mohammad Rafi

DOI:

https://doi.org/10.37591/ecft.v7i3.2605

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

Downloads

Published

2021-01-14

Issue

Vol. 7 No. 3 (2020)

Section

Review Articles

License

Declaration and Copyright Transfer Form

(to be completed by authors)

I/ We, the undersigned author(s) of the submitted manuscript, hereby declare, that the above manuscript which is submitted for publication in the STM Journals(s), is not published already in part or whole (except in the form of abstract) in any journal or magazine for private or public circulation, and, is not under consideration of publication elsewhere.

  • I/We will not withdraw the manuscript after 1 week of submission as I have read the Author Guidelines and will adhere to the guidelines.
  • I/We Author(s ) have niether given nor will give this manuscript elsewhere for publishing after submitting in STM Journal(s).
  • I/ We have read the original version of the manuscript and am/ are responsible for the thought contents embodied in it. The work dealt in the manuscript is my/ our own, and my/ our individual contribution to this work is significant enough to qualify for authorship.
  •  I/We also agree to the authorship of the article in the following order:

Author’s name                                    

 

1. ________________

2. ________________

3. ________________

4. ________________

 

We  Author(s) tick this box and would request you to consider it as our signature as we agree to the terms of this Copyright Notice, which will apply to this submission if and when it is published by this journal.