Data warehousing and OLAP: improving query performance using distributed computing
Jorge Bernardino, Henrique Madeira · 2000
Data warehouses are used to store large amounts of data. This data is often used for On-Line Analytical Processing (OLAP) where short response times are essential for on-line decision support. One of the most important requirements of a data warehouse server is the query performance. The principal aspect from the user perspective is how quickly the server processes a given query: "the data warehouse must be fast". The main focus of our research is finding adequate solutions to improve query response time of typical OLAP queries and improve scalability using a distributed computation environment that takes advantage of characteristics specific to the OLAP context. Our proposal provides very good performance and scalability even on huge data warehouses. 1 Introduction In recent years, there has been an explosive growth in the use of databases for decision support. This was mainly due to the fact that information, one of the most valuable assets of an organization, can assis...