Information System Architecture for Data Warehousing

  • Francisco AraqueEmail author
  • Alberto Salguero
  • Cecilia Delgado
Conference paper
Part of the Lecture Notes in Electrical Engineering book series (LNEE, volume 28)


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.


  1. 1.
    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)Google Scholar
  2. 2.
    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, USAGoogle Scholar
  3. 3.
    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–147Google Scholar
  4. 4.
    Vassiliadis P, Quix C, Vassiliou Y, Jarke M (2001) Data warehouse process management. Inf Syst 26:205–236CrossRefzbMATHGoogle Scholar
  5. 5.
    Thalhammer T, Schrefl M, Mohania M (2001) Active data warehouses: complementing OLAP with analysis rules. Data Knowl Eng 39(3):241–269CrossRefzbMATHGoogle Scholar
  6. 6.
    March ST, Hevner AR (2003) Integrated decision support: A data warehousing perspective. AIS SIGDSS Pre-ICIS Workshop Research Directions on Decision SupportGoogle Scholar
  7. 7.
    Inmon WH (2002) Building the data warehouse. John Wiley, New YorkGoogle Scholar
  8. 8.
    Harinarayan V, Rajaraman A, Ullman J (1996) Implementing data cubes efficiently. In: Proc. of ACM SIGMOD Conference, MontrealGoogle Scholar
  9. 9.
    Sheth A, Larson J (1990) Federated database systems for managing distributed, heterogeneous and autonomous databases. ACM Comput Surv 22(3)Google Scholar
  10. 10.
    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–756Google Scholar
  11. 11.
    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, CyprusGoogle Scholar
  12. 12.
    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–49Google Scholar
  13. 13.
    Araque F, Samos J (2003) Data warehouse refreshment maintaining temporal consistency. In: 5th Intern. Conference on Enterprise Information Systems (ICEIS), Angers, FranceGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC 2009

Authors and Affiliations

  • Francisco Araque
    • 1
    Email author
  • Alberto Salguero
    • 1
  • Cecilia Delgado
    • 1
  1. 1.Dpto. De Lenguajes y Sistemas InformáticosUniversity of GranadaGranada (Andalucía)Spain

Personalised recommendations