IJIMT 2013 Vol.4(2): 192-197 ISSN: 2010-0248
DOI: 10.7763/IJIMT.2013.V4.390

An Architectural Framework for Constructing Materialized Views in a Data Warehouse

T. V. Vijay Kumar and Kalyani Devi
Abstract— 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.

Index Terms— Data warehouse, materialized view.

T. V. Vijay Kumar is with School of Computer and Systems Sciences, Jawaharlal Nehru University, New Delhi-110067 (e-mail: tvvijaykumar@hotmail.com).
Kalyani Devi is with Business Solutions Department in Siemens Information Systems Limited, Gurgaon, Haryana-122001 (e-mail: devi_kalyani14@yahoo.co.in).

[PDF]

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.

Copyright © 2008-2015. International Journal of Innovation, Management and Technology. All rights reserved.
E-mail: ijimt@ejournal.net