DWPPT: Data Warehouse Performance Prediction Tool
نویسندگان
چکیده
The increasing demands for interactive response time from the users makes query performance one of the central problems of Data warehouse systems today. Performance is an important quality aspect of Data warehouse systems. Predicting the performance of Data warehouse systems during early design stages of their development is significant. Software Performance Engineering(SPE) promotes the idea that the integration of performance analysis into the software development process, from the earliest stages to the end, can ensure that the system will meet its performance objectives. This paper describes the features and use of a prototype tool, DWPPT(Data Warehouse Performance Prediction Tool) which is designed to analyze the performance of the Data warehouse in different environmental conditions. The tool supports SPE process for Data warehouse systems. The tool is useful for Data warehouse managers in identifying critical components, diagnosing problems and hence optimizing the overall design. Our objective is to investigate the impact of Data warehouse design factors on OLAP performance for different user populations and hardware configurations. An analytical and simulation modeling approach is used for the tool to predict performance of Data warehouse systems.
منابع مشابه
Predicting the Quality of Object-Oriented Multidimensional (OOMD) Model of Data Warehouse using Decision Tree Technique
Data warehouse is a powerful tool which makes decision faster and reliable in organizations where ‘information’ is the main asset of primary concern. It is necessary to assure the quality of the data warehouse information. Information qual ity depends on multidimensional model’s quality of data warehouse. In the last few years’ different authors have suggested several metrics to access the qual...
متن کاملToward a Fully De-identified Biomedical Information Warehouse
The Information Warehouse at the Ohio State University Medical Center is a comprehensive repository of business, clinical, and research data from various source systems. Data collected here is a valuable resource that facilitates both translational research and personalized healthcare. The use of such data in research is governed by federal privacy regulations with oversight by the Institutiona...
متن کاملA Proposed Framework for the Analysis of Source Data in a Data Warehouse
This paper introduces a framework for the analysis of data quality in source databases, prior to migration to the data warehouse. Additionally, as part of the framework, a tool for the collection of meta-data is proposed. The use of the framework, in conjunction with the tool, will allow the developer of a data warehouse to allocate the scarce resources available for data cleansing. This is acc...
متن کاملData Warehouse Modeler: A CASE Tool for Warehouse Design
Data warehouses have become an instant phenomenon in many large organizations that deal with a massive amount of information. Drawing on the experiences from the systems development field, we surmise that an effective CASE tool will enhance the success of warehouse implementations. Thus, we present a CASE tool designed to generate the SQL queries necessary to build a warehouse from a set of ope...
متن کاملAn epidemiological modeling and data integration framework.
OBJECTIVES In this work, a cellular automaton software package for simulating different infectious diseases, storing the simulation results in a data warehouse system and analyzing the obtained results to generate prediction models as well as contingency plans, is proposed. The Brisbane H3N2 flu virus, which has been spreading during the winter season 2009, was used for simulation in the federa...
متن کامل