Performance Tuning Mechanisms for Implementation a Successful Data Warehouse

Abstract

Data warehouse is the design and implementation of process, tools to manage and deliver entire, timely accurate and logical information for decision making. It is accepted that information is a very powerful feature that can provide significant benefits to any organization. Data ware house are computer based data information system that optimized database query and reporting tool because of their ability to analyze data often from disparate database and in interesting ways. They are a way for managers and decision makers to extract information quickly and easily in order to answer question about their business

Data ware house is not magic –they require a great deal of very hard work. In many cases data ware house assignment are viewed as a stopgap evaluate to get users off to backs or to provide something for nothing .But data ware house require alert management. A data ware house is good investment only if end users actually can get important information quicker and cheaper than they can use modern technology.

I will give concept about how to perform and how to get the word out to the end user community and management has to recognize that the maintenance of any other mission –critical application. So management has to take decision for very high level of maintenance. Because previous researchers have focused on methodological, data related, operational, educational and technical issue of data warehouse implementation. There is require explore studies in which discuss organizational, project-related and environmental dimensions regarding implementation of data warehouse technology in general and in companies’ then we came to know that current scenario require the data warehouse to change.

Keywords: Data warehouse, decision making, management, maintenance, end user, critical application,