Utilizing materialized views to formulate business intelligence

Abstract

To gain the competitive advantage, valid and timely information is the key. Information is produced and consumed at a very fast rate in today's era. This is the impact of data integration technologies which has acknowledged an unpredictable growth in the last few years. For the reason that of technological advancement, data analysis systems and techniques are developed which get into the data and find the unseen information which further can be used as Business Intelligence (BI). BI systems and technologies help the business managers to come across the historical data to analyze and forecast the future trends based on it. BI systems and technologies are essentially designed in context to Data Warehouse because of the density in the decision making process which desires to analyze a huge historical data. BI can broadly be categorized into Business Reporting and Data Mining. This paper focuses on the first category i.e. Business Reports and the authors suggest the utilization of Materialized Views to generate fast and relevant business reports to formulate the Business Intelligence.