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

Submit your paper
Know more
The week's pick
Responsive image
SFLA-Based Line Balancing and Task Optimization in Master-Slave Controlled Hanger Transportation Systems for Garment Production

Duc Hoang Nguyen
Random Articles
Reseach Article

DWH–Performance Tuning for Better Reporting

by Sandeep Bhargava, Naveen Hemrajani, Dinesh Goyal, Subhash Gander
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 32 - Number 1
Year of Publication: 2011
Authors: Sandeep Bhargava, Naveen Hemrajani, Dinesh Goyal, Subhash Gander
10.5120/3866-5303

Sandeep Bhargava, Naveen Hemrajani, Dinesh Goyal, Subhash Gander . DWH–Performance Tuning for Better Reporting. International Journal of Computer Applications. 32, 1 ( October 2011), 1-5. DOI=10.5120/3866-5303

@article{ 10.5120/3866-5303,
author = { Sandeep Bhargava, Naveen Hemrajani, Dinesh Goyal, Subhash Gander },
title = { DWH–Performance Tuning for Better Reporting },
journal = { International Journal of Computer Applications },
issue_date = { October 2011 },
volume = { 32 },
number = { 1 },
month = { October },
year = { 2011 },
issn = { 0975-8887 },
pages = { 1-5 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume32/number1/3866-5303/ },
doi = { 10.5120/3866-5303 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T20:18:00.597414+05:30
%A Sandeep Bhargava
%A Naveen Hemrajani
%A Dinesh Goyal
%A Subhash Gander
%T DWH–Performance Tuning for Better Reporting
%J International Journal of Computer Applications
%@ 0975-8887
%V 32
%N 1
%P 1-5
%D 2011
%I Foundation of Computer Science (FCS), NY, USA
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.

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

Computer Science
Information Sciences

Keywords

DWH- data warehouse BI- Business Intelligence

Powered by PhDFocusTM