DWPPT: Data Warehouse Performance Prediction Tool
|
10.5120/18259-9183 |
Madhu Bhan, K.rajinikanth, D E Geetha and T v s Kumar. Article: DWPPT: Data Warehouse Performance Prediction Tool. International Journal of Computer Applications 104(13):1-8, October 2014. Full text available. BibTeX
@article{key:article,
author = {Madhu Bhan and K.rajinikanth and D E Geetha and T.v.s Kumar},
title = {Article: DWPPT: Data Warehouse Performance Prediction Tool},
journal = {International Journal of Computer Applications},
year = {2014},
volume = {104},
number = {13},
pages = {1-8},
month = {October},
note = {Full text available}
}
Abstract
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.
References
- Andrew Holdsworth. " Data Wareho,use Performance Management Techniques". White paper , Oracle Services Advanced Technologies Data Warehouse,1997.
- C. U Smith, Performance Engineering of Software Systems. Addison Wesley,1990.
- C. U Smith and L. G Williams, Performance Solutions :A practical Guide to creating Responsive, Scalable Software . Addison Wesley ,2002.
- Kahkipuro P, "UML–Based Performance Modeling Framework for Component Based Distributed Systems" in R. Dumke et al. (Eds): Performance Engineering,LNCS 2047,Springer,pp167-184,2001
- Peter Utton and Gino Martin,David Akehurst and Gill Waters, "Performance Analysis of Object–oriented Designs for Distributed systems" ,Technical Report , University of Kent at Canterbury,1999.
- Connie. U. Smith and Lioyd G. Williams,"Performance Engineering Evaluation of Object Oriented Systems with SPE-ED, in LNCS 1997,PP 135-153.
- Marc Diefenbruch,Jorg Hintelmann,Axel Hirche and Bruno Muller-Clostermann,"QUEST User Manual",VERSION 1. 3 June 1999 .
- HIT and HI-SLANG,An Introduction", Version 3. 1. 000.
- Vibhu Saujanya Sharma,Pankaj Jalote,Kishore S. Trivedi"Evaluating Performance Attributes of Layered Software Architecture", CBSE 2005, LNCS 3489,Springer-Verlag.
- D. E Geetha, T. V. Suresh Kumar, P. Mayank, K. Rajanikanth, (2010) "A Tool for Simulating Multi-tier Queuing Applications", Technical Report, Department of MCA, MSRIT, TRMCA 04.
- Wasserman, T. J. , Martin, P. , Rizvi, H. , "Sizing DB2 UDB® Servers for Business Intelligence Workloads", ACM, 2004
- Chunhua Ju,Minghua Han, "Effectiveness of OLAP- based Sales Analysis in Retail Enterpprises", Proc of ISECS International Colloquium on computing, Communication, Control and Management,2008.
- Transaction Processing Performance Council (TPC). 2008. TPC BenchmarkTM H. Retrieved from http://www. tpc. org/tpch/spec/tpch2. 8. 0. pdf.
- Madhu Bhan, T. V. Suresh kumar, K. Rajanikanth,"Size estimation of OLAP Systems" in the proceedings of CS & IT ,pp 431-441, 2013.
- William Roetzheim, "Estimating Effort Using Use-Case and UML Class-Method Points" UML World International Conference" 2006