Call for Paper - May 2023 Edition
IJCA solicits original research papers for the May 2023 Edition. Last date of manuscript submission is April 20, 2023. Read More

DWH–Performance Tuning for Better Reporting

Print
PDF
International Journal of Computer Applications
© 2011 by IJCA Journal
Number 1 - Article 1
Year of Publication: 2011
Authors:
Sandeep Bhargava
Naveen Hemrajani
Dinesh Goyal
Subhash Gander
10.5120/3866-5303

Sandeep Bhargava, Naveen Hemrajani, Dinesh Goyal and Subhash Gander. Article: DWHPerformance Tuning for Better Reporting. International Journal of Computer Applications 32(1):1-5, October 2011. Full text available. BibTeX

@article{key:article,
	author = {Sandeep Bhargava and Naveen Hemrajani and Dinesh Goyal and Subhash Gander},
	title = {Article: DWHPerformance Tuning for Better Reporting},
	journal = {International Journal of Computer Applications},
	year = {2011},
	volume = {32},
	number = {1},
	pages = {1-5},
	month = {October},
	note = {Full text available}
}

Abstract

The concept of data warehouse deals in huge amount of data and lot of analytically queries runs on DWH, which covers base data in terms of thousands of gigabytes, to unveil the hidden pattern of business. So response time of query is exponential proportional (metaphorically) to involved base data. So we can say THUMB RULE as "MORE BASE DATE MORE ACCURATE RESULTS". But it will degrade the performance if not taken care properly. Also we, as human, hate to wait due to natural phenomenon encoded in our DNA. Lot of works has been done by many literates around the globe on DWH performance tuning by proposing many frameworks related with various focus data quality, Metadata management etc... In this paper, an effort has been made to discuss about the real industry problems and how we improve the performance of data warehouse by minimize the existing CPU cycles wisely using metadata driven approach.

Reference

  • Data Warehouse Performance Management Techniques, Andrew Hold sworth, Oracle Services, Advanced Technologies, Data Warehousing Practice. 2/9/96
  • Discover Teradata Meta Data Services
  • Performance Tuning Mechanisms for Data Warehouse: Query International Journal of Computer Applications (0975 – 8887) Volume 2 – No.2, May 2010
  • Teradata® RDBMS performance optimization, NCR Corporation
  • Oracle® Database Performance Tuning Guide10g Release(10.2)Part Number B14211-03
  • Metadata implementation with Ab Initio EME, Article by Mike Green on 13 May 2009