Abstract
One of the most complex issues of the integration and transformation interface is the case where there are multiple sources for a single data element in the enterprise Data Warehouse (DW). There are many facets due to the number of variables that are needed in the integration phase. However we are interested in the temporal integration problem. This paper presents our DW architecture for temporal integration on the basis of the temporal properties of the data and temporal characteristics of the data sources. The proposal shows the steps for the transformation of the native schemes of the data sources into the DW scheme. In addition we present two new components for temporal integration: Temporal Integration Processor and Refreshment Metadata Generator, which will be used for integrating temporal properties of data and generating the necessary data for the later refreshment of the DW.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Haller M, Pröll B, Retschitzegger W, Tjoa AM, Wagner RR (2000) Integrating heterogeneous tourism information in TIScover – The MIRO-Web approach. In: Proceedings Information and Communication Technologies in Tourism, ENTER. Barcelona (España)
Moura Pires J, Pantoquilho M, Viana N (2004) Real-time decision support system for space missions control. In: International Conference on Information and Knowledge Engineering, Las Vegas, USA
Oliva M, Saltor F (2001) Integrating multilevel security policies in multilevel federated database systems. In: Thuraisingham B, van de Riet R, Dittrich KR, Tari Z (eds) Data and Applications Security: Developments and Directions, Kluwer Academic Publishers, Boston, pp 135–147
Vassiliadis P, Quix C, Vassiliou Y, Jarke M (2001) Data warehouse process management. Inf Syst 26:205–236
Thalhammer T, Schrefl M, Mohania M (2001) Active data warehouses: complementing OLAP with analysis rules. Data Knowl Eng 39(3):241–269
March ST, Hevner AR (2003) Integrated decision support: A data warehousing perspective. AIS SIGDSS Pre-ICIS Workshop Research Directions on Decision Support
Inmon WH (2002) Building the data warehouse. John Wiley, New York
Harinarayan V, Rajaraman A, Ullman J (1996) Implementing data cubes efficiently. In: Proc. of ACM SIGMOD Conference, Montreal
Sheth A, Larson J (1990) Federated database systems for managing distributed, heterogeneous and autonomous databases. ACM Comput Surv 22(3)
Samos J, Saltor F, Sistac J, Bardés A (1998) Database architecture for data ware-housing: An evolutionary approach. In: Quirchmayr G et al (eds) Proceedings of the International Conference on Database and Expert Systems Applications, Springer-Verlag, Vienna, pp 746–756
Araque F, Salguero AG, Delgado C, Garvi E, Samos J (2006) Algorithms for integrating temporal properties of data in Data Warehouse. In: 8th International Conference on Enterprise Information Systems (ICEIS), Paphos, Cyprus
Oliva M, Saltor F (1996) A negotiation process approach for building federated databases. In: Proceedings of 10th ERCIM Database Research Group Workshop on Heterogeneous Information Management, Prague, pp 43–49
Araque F, Samos J (2003) Data warehouse refreshment maintaining temporal consistency. In: 5th Intern. Conference on Enterprise Information Systems (ICEIS), Angers, France
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2009 Springer Science+Business Media, LLC
About this paper
Cite this paper
Araque, F., Salguero, A., Delgado, C. (2009). Information System Architecture for Data Warehousing. In: Mastorakis, N., Mladenov, V., Kontargyri, V. (eds) Proceedings of the European Computing Conference. Lecture Notes in Electrical Engineering, vol 28. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-85437-3_45
Download citation
DOI: https://doi.org/10.1007/978-0-387-85437-3_45
Published:
Publisher Name: Springer, Boston, MA
Print ISBN: 978-0-387-84818-1
Online ISBN: 978-0-387-85437-3
eBook Packages: EngineeringEngineering (R0)