• ISSN: 2349-6002
  • UGC Approved Journal No 47859
Author Login IJIRT Partner Network (IPN) Login

Materialized View Selection and Preservation on Data centric Environment: A Survey

  • Unique Paper ID: 147129
  • Volume: 5
  • Issue: 4
  • PageNo: 354-359
  • 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.
Download article email to a friend

Cite This Article

  • ISSN: 2349-6002
  • Volume: 5
  • Issue: 4
  • PageNo: 354-359

Materialized View Selection and Preservation on Data centric Environment: A Survey

Related Articles

Impact Factor
8.01 (Year 2024)
UGC Approved
Journal no 47859

Join Our IPN

IJIRT Partner Network

Submit your research paper and those of your network (friends, colleagues, or peers) through your IPN account, and receive 800 INR for each paper that gets published.

Join Now

Latest Publication

Archive

View More

Recent Conferences

NCSEM 2024

National Conference on Sustainable Engineering and Management - 2024 Last Date: 15th March 2024

Submit inquiry