|Materialized View Selection and Preservation on Data centric Environment: A Survey|
|prajakta Bhoyar , Kanchan Warkar|
|Cite This Article:|
Materialized View Selection and Preservation on Data centric Environment: A Survey, International Journal of Innovative Research in Technology(www.ijirt.org) ,ISSN: 2349-6002 ,Volume 5 ,Issue 4 ,Page(s):354-359 ,September 2018 ,Available :IJIRT147129_PAPER.pdf
|Data Warehouse, Materialized View, View Selection Problem, Query processing cost, View Maintenance, Access Frequency, Threshold, Fuzzy logic.|
|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.|
|Unique Paper ID: 147129|
Publication Volume & Issue: Volume 5, Issue 4
Page(s): 354 - 359
|Article Preview & Download|
Function Overloading Implementation in C++...
Paper ID : IJIRT148851
EXPERIMENTAL INVESTIGATION OF AIR SWIRL TECHNIQUE ...
Paper ID : IJIRT148850
ANALYSIS OF NEWTON RAPHSON METHOD...
Paper ID : IJIRT148847
DESIGN OF A MONITORING SYSTEM FOR WASTE MANAGEMENT...
Paper ID : IJIRT148846
Secant numerical method...
Paper ID : IJIRT148845