Query Processing and Analysis from Distributed Data Warehouses

Abstract

Data warehouses must have efficient Online Analysis Processing (OLAP) that provides tools to satisfy the information needs of business managers, helping then to make faster and more effective decisions. The increasing use of decision support systems led to an explosion in the amount of business information that must be managed by the data warehouse. Improving query processing and analysis in such an environment is very difficult and can only be achieved by a combination of different approaches, in particular the use of materialized views, distributed data warehouses. This system tailored design framework for distributed data warehouse and OLAP. In this paper, we process and analyze the performance of distributed data warehouse with typical OLAP operations using different types of queries and this system can produce a variety of reports and information in time with accurately fast response for performance evaluation and decision making.