CFP last date
22 April 2024
Reseach Article

Optimization of Data Warehousing System: Simplification in Reporting and Analysis

Published on None 2011 by Preeti S Patil, Srikantha Rao, Suryakant B Patil
journal_cover_thumbnail
International Conference and Workshop on Emerging Trends in Technology
Foundation of Computer Science USA
ICWET - Number 9
None 2011
Authors: Preeti S Patil, Srikantha Rao, Suryakant B Patil
0f04a13a-c5f4-4595-84e1-51ff1646f2c9

Preeti S Patil, Srikantha Rao, Suryakant B Patil . Optimization of Data Warehousing System: Simplification in Reporting and Analysis. International Conference and Workshop on Emerging Trends in Technology. ICWET, 9 (None 2011), 33-37.

@article{
author = { Preeti S Patil, Srikantha Rao, Suryakant B Patil },
title = { Optimization of Data Warehousing System: Simplification in Reporting and Analysis },
journal = { International Conference and Workshop on Emerging Trends in Technology },
issue_date = { None 2011 },
volume = { ICWET },
number = { 9 },
month = { None },
year = { 2011 },
issn = 0975-8887,
pages = { 33-37 },
numpages = 5,
url = { /proceedings/icwet/number9/2131-db195/ },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Proceeding Article
%1 International Conference and Workshop on Emerging Trends in Technology
%A Preeti S Patil
%A Srikantha Rao
%A Suryakant B Patil
%T Optimization of Data Warehousing System: Simplification in Reporting and Analysis
%J International Conference and Workshop on Emerging Trends in Technology
%@ 0975-8887
%V ICWET
%N 9
%P 33-37
%D 2011
%I International Journal of Computer Applications
Abstract

A data warehouse maintains its functions in three layers: staging, integration, and access. Staging is used to store raw data for use by developers (analysis and support). The integration layer is used to integrate data and to have a level of abstraction from users. The access layer is for getting data out for users.

References
  1. Simitsis, A.; Vassiliadis, P.; Sellis, T.; “State-space optimization of ETL workflows”, Knowledge and Data Engineering, IEEE Transactions on Volume:17 , Issue: 10 Digital Object Identifier: 10.1109/ TKDE.2005.169 Publication Year: 2005, Page(s): 1404 –1419.
  2. Zhuolun Zhang; Sufen Wang; “A Framework Model Study for Ontology-Driven ETL Processes”, 4th International Conference on, Wireless Communications, Networking and Mobile Computing, 2008. WiCOM '08. Digital Object Identifier: 10.1109/ WiCom.2008.2651Publication Year: 2008, Pages: 1- 4
  3. Tang Jun; Cui Kai; Feng Yu; Tong Gang; “The Research & Application of ETL Tool in Business Intelligence Project”, International Forum on Information Technology and Applications, 2009. IFITA '09. Volume: 2 Digital Object Identifier: 10.1109/ IFITA.2009.48 Publication Year: 2009, Page(s): 620 - 623
  4. Xiaoyun Liu; Jianhua Chen; Yingchun Zha; “Design of ETL Aggregation Policy in Local Tax System (LTS)”, International Conference on Management and Service Science, 2009. MASS '09. Digital Object Identifier: 10.1109/ICMSS.2009.5300877 Publication Year: 2009, Page(s): 1 - 4
  5. Xudong Song; Xiaolan Yan; Liguo Yang; “Design ETL Metamodel Based on UML Profile”, International Symposium on Knowledge Acquisition and Modeling, 2009. KAM '09. Second Volume: 3 Digital Object Identifier: 10.1109/KAM.2009.112 Publication Year: 2009, Page(s): 69 - 72
  6. Simitsis, A.; Wilkinson, K.; Dayal, U.; Castellanos, M.; “Optimizing ETL workflows for fault-tolerance”, International Conference on Data Engineering (ICDE), 2010 IEEE 26th Digital Object Identifier: 10.1109/ICDE.2010.5447816 Publication Year: 2010 , Page(s): 385 - 396
  7. Lunan Li; “A framework study of ETL processes optimization based on metadata repository”, 2nd International Conference on Computer Engineering and Technology (ICCET), 2010 Volume: 6 Digital Object Identifier: 10.1109/ ICCET.2010. 5486338 Publication Year: 2010 , Page(s): V6-125 - V6-129
  8. Morris, H.; Hui Liao; Sriram, P.; Srinivasan, S.; Lau, P.; Shan, J.; Wisnesky, R.; “Bringing Business Objects into Extract-Transform-Load (ETL) Technology”, IEEE International Conference on e-Business Engineering, 2008. ICEBE '08. Digital Object Identifier: 10.1109/ ICEBE.2008.72 Publication Year: 2008,Page(s):709-714.
Index Terms

Computer Science
Information Sciences

Keywords

Data Warehousing Integration heterogeneity ETL data extraction cleaning and transformation