— Data warehouse stores data accumulated over a period of time from disparate data sources for providing answers to analytical queries. These queries, which are long and complex in nature, have high query response time when processed against a large data warehouse. This response time can be reduced by constructing materialized views and storing them in a data warehouse. These views need to contain relevant and required information for answering future queries, so that future queries can be answered in a reduced response time to make decision making more efficient. A Materialized Views Construction Framework (MVCF), presented in this paper, lays down a strategy for constructing materialized views from previously posed queries on the data warehouse. The objective of MVCF is to enable construction of materialized views that are subject-specific and contain frequently accessed information that are capable of providing answers to future queries. This in turn would facilitate decision making.
— Data warehouse, materialized view.
T. V. Vijay Kumar is with School of Computer and Systems Sciences, Jawaharlal Nehru University, New Delhi-110067 (e-mail: firstname.lastname@example.org).
Kalyani Devi is with Business Solutions Department in Siemens Information Systems Limited, Gurgaon, Haryana-122001 (e-mail: email@example.com).
Cite: T. V. Vijay Kumar and Kalyani Devi, " An Architectural Framework for Constructing Materialized Views in a Data Warehouse," International Journal of Innovation, Management and Technology vol. 4, no. 2, pp. 192-197, 2013.