Performance Tuning Strategies for Data Ware House

There has been an extensive demand in the use of databases for decision support in these days. This was mainly due to the fact that information, one of the most precious assets of an organization, can assist in decision making and this way considerably improves the value of an organization. This phenomenon is a result of the increased availability of new technologies to support capable storage and retrieval of large volumes of data, namely data warehousing. 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 data ware house queries and improve scalability using an environment that takes advantage of characteristics specific to the data ware house context. Our propose model provides very good performance and scalability even on huge data warehouses.