CFP last date
20 May 2024
Call for Paper
June Edition
IJCA solicits high quality original research papers for the upcoming June edition of the journal. The last date of research paper submission is 20 May 2024

Submit your paper
Know more
The week's pick
Responsive image
Enhancing Privacy Preservation: Multi-Attribute Protection with P-Sensitive K-Anonymity

Twinkle Patel Kiran Amin
Random Articles
Reseach Article

DWPPT: Data Warehouse Performance Prediction Tool

by Madhu Bhan, K.rajinikanth, D E Geetha, T.v.s Kumar
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 104 - Number 13
Year of Publication: 2014
Authors: Madhu Bhan, K.rajinikanth, D E Geetha, T.v.s Kumar
10.5120/18259-9183

Madhu Bhan, K.rajinikanth, D E Geetha, T.v.s Kumar . DWPPT: Data Warehouse Performance Prediction Tool. International Journal of Computer Applications. 104, 13 ( October 2014), 1-8. DOI=10.5120/18259-9183

@article{ 10.5120/18259-9183,
author = { Madhu Bhan, K.rajinikanth, D E Geetha, T.v.s Kumar },
title = { DWPPT: Data Warehouse Performance Prediction Tool },
journal = { International Journal of Computer Applications },
issue_date = { October 2014 },
volume = { 104 },
number = { 13 },
month = { October },
year = { 2014 },
issn = { 0975-8887 },
pages = { 1-8 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume104/number13/18259-9183/ },
doi = { 10.5120/18259-9183 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T22:36:01.866263+05:30
%A Madhu Bhan
%A K.rajinikanth
%A D E Geetha
%A T.v.s Kumar
%T DWPPT: Data Warehouse Performance Prediction Tool
%J International Journal of Computer Applications
%@ 0975-8887
%V 104
%N 13
%P 1-8
%D 2014
%I Foundation of Computer Science (FCS), NY, USA
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
  1. Andrew Holdsworth. " Data Wareho,use Performance Management Techniques". White paper , Oracle Services Advanced Technologies Data Warehouse,1997.
  2. C. U Smith, Performance Engineering of Software Systems. Addison Wesley,1990.
  3. C. U Smith and L. G Williams, Performance Solutions :A practical Guide to creating Responsive, Scalable Software . Addison Wesley ,2002.
  4. 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
  5. 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.
  6. Connie. U. Smith and Lioyd G. Williams,"Performance Engineering Evaluation of Object Oriented Systems with SPE-ED, in LNCS 1997,PP 135-153.
  7. Marc Diefenbruch,Jorg Hintelmann,Axel Hirche and Bruno Muller-Clostermann,"QUEST User Manual",VERSION 1. 3 June 1999 .
  8. HIT and HI-SLANG,An Introduction", Version 3. 1. 000.
  9. Vibhu Saujanya Sharma,Pankaj Jalote,Kishore S. Trivedi"Evaluating Performance Attributes of Layered Software Architecture", CBSE 2005, LNCS 3489,Springer-Verlag.
  10. 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.
  11. Wasserman, T. J. , Martin, P. , Rizvi, H. , "Sizing DB2 UDB® Servers for Business Intelligence Workloads", ACM, 2004
  12. 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.
  13. Transaction Processing Performance Council (TPC). 2008. TPC BenchmarkTM H. Retrieved from http://www. tpc. org/tpch/spec/tpch2. 8. 0. pdf.
  14. Madhu Bhan, T. V. Suresh kumar, K. Rajanikanth,"Size estimation of OLAP Systems" in the proceedings of CS & IT ,pp 431-441, 2013.
  15. William Roetzheim, "Estimating Effort Using Use-Case and UML Class-Method Points" UML World International Conference" 2006
Index Terms

Computer Science
Information Sciences

Keywords

Software Performance Engineering Data warehouse On line Analytical Processing Simulation.

Powered by PhDFocusTM