Construction of Real Time Data Warehouse
Keywords:
dimensionality, extraction, integration, cleansing, optimization, DataMart, transactional, analyticalAbstract
Data warehouse is a copy of transaction data specifically structured for querying, analysis and reporting Data warehouse is a database application that actually store and collect the data from any particular business domain for decision support system. There are different ways to implement and design the data warehouse. Some processes are involved the data extraction, transformation and loading. Integration of the data from various sources in to the data warehouse is major concept. So, while the design of the data warehouse such that to entertain all these processes accurately then we can guarantee the data purity. Approach of recent times is becoming very much famous now days that is real time data warehouse. Real time data warehouse actually load the data from the transactional and operational data stores when in real time. As soon the data is coming up in the external data source it will appear into the real time data warehouse so this paper will cater the discussion of structure of real time data warehouse. Real time data warehouse approach has major deficit of extraction and loading process. It could be very efficient source of decision support system if we can eliminate the deficiencies.
References
B. H¨usemann, J. Lechtenb¨orger, G. Vossen, “Conceptual data warehouse modeling,” Proc. DMDW 2000.
W. Lehner, J. Albrecht, H. Wedekind, “Normal Forms for Multidimensional Databases,” Proc. 10th SSDBM 1998, 63–72.
G. Ozsoyoglu, D. A. Singer, and S. S. Chung, “Anti-tamper databases: Querying encrypted databases,” in Proceedings of the 17th Annual IFIP WG 11.3 Working Conference on Database and Applications Security, Estes Park, Colorado, Aug. 4-6 2003.
Tony R. Sahama, Peter R. Croll, “A data warehouse architecture for clinical data warehousing”, ACM International Conference Proceeding Series; Vol. 249, Queensland University of Technology, Brisbane, Queensland, 2007.
Mohammad Rifaie, Keivan Kianmehr, Reda Alhajj, Mick J. Ridley, “Data modelling for effective data warehouse architecture and design”, International Journal of Information and Decision Sciences 2009 - Vol. 1, No.3 pp. 282 - 300, ' School of Informatics, Bradford University, West Yorkshire, UK, 2009.
Khurram Shahzad, “Semi-star schema for operational and analytical requirements of SMEs”, International Journal of Management and Decision Making 2009 - Vol. 10, No.1/2 pp. 33 - 52, Department of Computer and Systems Sciences, Royal Institute of Technology (KTH)/Stockholm University, Forum 100, SE 164 40 Kista, Stockholm, Sweden, 2009.
V.Breazu-Tannen and R. Subrahmanyam. “Logical and computational aspects of programming with Sets/Bags/Lists,” In LNCS 510: Proceedings of 18th International Colloquium on Automata, Languages, and Programming, Madrid, Spain, July 1991, pages 60{75. Springer Verlag, 1991.
William H. Inmon, “Building the Data Warehouse”, John Wiley & Sons, Inc., New York, NY, 2005.
Ronald Gage Allan, “Data Models for a Registrar's Data Mart”, Business Intelligence Journal, Office of Student Financial Services Georgetown University, Washington, D.C. 2005.
Vasant Dhar, Roger Stein, seven methods for transforming corporate data into business intelligence, Prentice-Hall, Inc., Upper Saddle River, NJ, 1997.
Friedman, J. M. "Data Mining and Statistics: What's The Connections?" 29th Symposium on the Interface in Data Mining and the analysis of large data sets, Houston, TX. 1997.
Swapnil Gorhe, “ETL in Near-Real Time Environment: Challenges and Opportunities.
G. Graefe. “Query evaluation techniques for large databases.” ACM Computing Surveys, 25(2):73–170, 1993.
Senda Bouaziz1, Ahlem Nabli1, Faiez Gargouri “From Traditional Data Warehouse To Real Time Data Warehouse” Sfax University, Faculty of Sciences, BP 1171, Tunisia, MIRACL.
Swapnil Gorhe. “ETL in Near-Real Time Environment: Challenges and Opportunities” Computers and Information Science Auckland University of Technology Auckland, New Zealand.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2024 Sohail Irfan
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Authors who submit papers with this journal agree to the following terms.
