Optimized Generation and Maintenance of Materialized View using Adaptive Mechanism

Main Article Content

Mr. Shailesh Kurzadkar, Prof. Abhijeet Bajpayee


Data Warehouse is storage of enormous amount of data gathered from multiple data sources, which is mainly used by managers for analysis purpose. Hence to make this data available in less amount of time is essential. Using Materialize view we can have result of query in less amount of time compared to access the same from base tables. To materialize all of the views is not possible since it requires storage space and maintenance cost. So it is required to select materialized view which minimizes response time of query and cost of maintenance. In this paper, effective approach is suggested for selection and maintenance of materialize view.
DOI: 10.17762/ijritcc2321-8169.150501

Article Details

How to Cite
, M. S. K. P. A. B. “Optimized Generation and Maintenance of Materialized View Using Adaptive Mechanism”. International Journal on Recent and Innovation Trends in Computing and Communication, vol. 3, no. 5, May 2015, pp. 2499-02, doi:10.17762/ijritcc.v3i5.4271.