Academic Journals Database
Disseminating quality controlled scientific knowledge

Selection & Maintenance of Materialized View and It's Application for Fast Query Processing: A Survey

Author(s): P. P. Karde | V. M. Thakare

Journal: International Journal of Computer Science and Engineering Survey
ISSN 0976-3252

Volume: 1;
Issue: 2;
Start page: 16;
Date: 2010;
VIEW PDF   PDF DOWNLOAD PDF   Download PDF Original page

Keywords: Data Warehousing | Query processing cost | Storage space | View Materialization | View Selection | ViewMaintenance.

Quick response time and accuracy are important factors in the success of any database. In large databases particularly in distributed database, query response time plays an important role as timely access to information and it is the basic requirement of successful business application. A data warehouse uses multiple materialized views to efficiently process a given set of queries. The materialization of all views is not possible because of the space constraint and maintenance cost constraint. Materialized views selection is one of the crucial decisions in designing a data warehouse for optimal efficiency. Selecting a suitable set of views that minimizes the total cost associated with the materialized views is the key component in data warehousing. Materialized views are found useful for fast query processing. This paper gives an overview of various techniques that are implemented in past recent for selection of materialized view. The issues related to maintaining the materialized view are also discussed in this paper. Here some future aspects are also stated that might be useful for recent researchers.

Tango Jona
Tangokurs Rapperswil-Jona

     Affiliate Program