International Journal of Advanced Innovative Technology in Engineering (IJAITE)

---

An Approach For Efficient Query Processing For Materialized View Selection And Maintenance

SARVESH ANASANE, PROF. SHYAM P. DUBEY

Abstract :

The ability to afford decision makers with both accurate and timely consolidated information as well as rapid query response times is the fundamental requirement for the success of a Data Warehouse. To provide fast access, a data warehouse stores materialized views of the sources of its data. As a result, a data warehouse needs to be maintained to keep its contents consistent with the contents of its data sources. To improve the affection of OLAP queries is an important aspect of data warehouse domain. It affects the efficiency of queries in data warehouse directly. Base on the PBUS algorithm, a novel method is proposed to select materialized views of multidimensional data called dynamic selection Strategy. Another technique is the hybrid mediator is an integration system where one part of data is queried on demand as in the virtual approach, while another part is extracted, filtered and stored in a local database. Statistical analysis on existing query set help to predict the attributes likely to be used for future queries. The materialized views are generated accordingly.

Keywords :

Full Text :

Download PDF

DOI :

Cite this paper :

References :

---