USING ONTOLOGY META DATA FOR DATA WAREHOUSING

Alberto Salguero, Francisco Araque, Cecilia Delgado

2008

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 integration of temporal and spatial problem due to the nature of DWs. This paper presents our ontology based DW architecture for temporal integration on the basis of the temporal and spatial 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 and end user scheme and the use of an ontology model as the common data model.

References

  1. Araque, F., Salguero, A., Delgado, C., 2007a. Monitoring web data sources using temporal properties as an external resources of a data warehouse. ICEIS. 28-35.
  2. Araque, F., Carrasco, R. A., Salguero, A., Delgado, C., Vila, M. A., 2007b. Fuzzy Integration of a Web data sources for Data Warehousing. Lecture Notes in Computer Science (Vol 4739). Springer-Verlag.
  3. Araque, F., Salguero, A.., Delgado, C., Samos, J., 2006. Algorithms for integrating temporal properties of data in DW. 8th Int. Conf. on Enterprise Information Systems (ICEIS). Paphos, Cyprus. May.
  4. Haller, M., Pröll, B. , Retschitzegger, W., Tjoa, A. M., Wagner, R. R., 2000. Integrating Heterogeneous Tourism Information in TIScover - The MIRO-Web Approach. Information and Communication Technologies in Tourism, ENTER. Barcelona (Spain) Inmon W.H, 2002. Building the Data Warehouse. John Wiley.
  5. 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. 43-49.
  6. Sheth, A., Larson, J., 1990. Federated Database Systems for Managing Distributed, Heterogeneous and Autonomous Databases.” ACM Computing Surveys, Vol. 22, No. 3.
  7. Skotas, D., Simitsis, A., 2006. Ontology-Based Conceptual Design of ETL Processes for Both Structured and Semi-Structured Data. International Journal on Semantic Web and Information Systems, Vol. 3, Issue 4. pp. 1-24.
  8. Thalhammer, T., Schrefl, M., Mohania, M., 2001. Active data warehouses: complementing OLAP with analysis rules, Data & Knowledge Engineering, 39 (3), 241- 269.
  9. Vassiliadis, P., Quix, C., Vassiliou, Y., Jarke, M., 2001. Data warehouse process management. Information System. v. 26. 205-236.
Download


Paper Citation


in Harvard Style

Salguero A., Araque F. and Delgado C. (2008). USING ONTOLOGY META DATA FOR DATA WAREHOUSING . In Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8111-36-4, pages 497-500. DOI: 10.5220/0001710904970500


in Bibtex Style

@conference{iceis08,
author={Alberto Salguero and Francisco Araque and Cecilia Delgado},
title={USING ONTOLOGY META DATA FOR DATA WAREHOUSING},
booktitle={Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2008},
pages={497-500},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0001710904970500},
isbn={978-989-8111-36-4},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Tenth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - USING ONTOLOGY META DATA FOR DATA WAREHOUSING
SN - 978-989-8111-36-4
AU - Salguero A.
AU - Araque F.
AU - Delgado C.
PY - 2008
SP - 497
EP - 500
DO - 10.5220/0001710904970500