Materialized View Selection and Preservation on Data centric Environment: A Survey
Author(s):
prajakta Bhoyar , Kanchan Warkar
Keywords:
Data Warehouse, Materialized View, View Selection Problem, Query processing cost, View Maintenance, Access Frequency, Threshold, Fuzzy logic.
Abstract
Data warehouse (DW) can be defined as a huge amount of data accumulated from a wide range of sources within a corporation and often used to guide management decisions. To avoid complex query evaluation based on already existing master table to increase the speed of queries posted to a data warehouse, we can use an already created snapshot results from the query processing stored in the data warehouse called materialized views. Appropriate Materialized views selection is one of the fragile and important decisions in designing a data warehouse for better efficiency and plays a vital role for successful business application. Materialized view creation and preservation are found extremely useful in quick query processing for data centric environment. In this paper, our main focus is on a variety of techniques that are implemented in past, recent for the selection and preservation of materialized view. Second, the most serious issues related to maintaining the created materialized view for effective query maintenance strategy are also discussed in this paper.
Article Details
Unique Paper ID: 147129

Publication Volume & Issue: Volume 5, Issue 4

Page(s): 354 - 359
Article Preview & Download


Share This Article

Join our RMS



Conference Alert

NCSEM 2024

National Conference on Sustainable Engineering and Management - 2024

Last Date: 15th March 2024

Latest Publication

Call For Paper

Volume 10 Issue 10

Last Date for paper submitting for March Issue is 25 June 2024

About Us

IJIRT.org enables door in research by providing high quality research articles in open access market.

Send us any query related to your research on editor@ijirt.org

Social Media

Google Verified Reviews

Contact Details

Telephone:6351679790
Email: editor@ijirt.org
Website: ijirt.org

Policies

Important Links

Browse Rsearch papers