Designing ETL processes using semantic web technologies

DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP

Volumn , Issue , 2006, Pages 67-74

  Skoutas, Dimitrios ^a   Simitsis, Alkis ^a  

^a NATIONAL TECHNICAL UNIVERSITY OF ATHENS   (Greece)

Author keywords

Conceptual modeling; Data warehousing; ETL; Ontologies; Reasoning; Semantic web technology; Transformations

Indexed keywords

CONCEPTUAL DESIGN; DATA STRUCTURES; DATA WAREHOUSES; MATHEMATICAL TRANSFORMATIONS; ONTOLOGY;

CONCEPTUAL MODELING; DATA SOURCES; SEMANTIC WEB TECHNOLOGY;

SEMANTIC WEB;

EID: 34547641380     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1183512.1183526     Document Type: Conference Paper

References (28)

1. Arens, Y., Hsu, C.-H., Knoblock, C. Query Processing in the Sims Information Mediator. Advanced Planning Tech., 1996.
2. Ascential Software Inc.url:http://www.ascentialsoftware.com
3. Baader, F., McGuiness, D. L., Nardi, D., Patel-Schneider, P. (Eds). Description Logic Handbook: Theory, implementation and applications. Cambridge University Press, 2002.
4. Ballard, C. Data Modeling Techniques for Data Warehousing. IBM Red Book, ISBN 0738402451, 1998.
5. Boehnlein, M., Ulbrich-vom Ende, A. Deriving the Initial Data Warehouse Structures from the Conceptual Data Models of the Underlying Operational Information Systems. DOLAP, 1999.
6. Borst, W. N. Construction of Engineering Ontologies. PhD thesis, University of Twente, Enschede, 1997.
7. Goh, C.H.. Representing and Reasoning about Semantic Conflicts in Heterogeneous Information Sources. MIT, 1997.
8. Golfarelli, M., Rizzi, S. Methodological Framework for Data Warehouse Design. DOLAP, 1998.
9. Hahn, K., Sapia, C., Blaschka, M. Automatically Generating OLAP Schemata from Conceptual Graphical Models. DOLAP, 2000.
10. IBM. IBM Data Warehouse Manager, url: http://www-3.ibm.com/software/data/ db2/datawarehouse/
11. Informatica. PowerCenter. url:http://www.informatica.com/products/ data+integration/powercenter/default.htm
12. Kimball, R., et al. The Data Warehouse Lifecycle Toolkit. John Wiley & Sons, 1998.
13. Luján-Mora, S., Vassiliadis, P., Trujillo, J. Data Mapping Diagrams for Data Warehouse Design with UML. ER, 2004.
14. Mazon, J-N., Trujillo, J., Serrano, M., Piattini, M. Applying MDA to the development of data warehouses. DOLAP, 2005.
15. Mena, E., Kashyap, V., Sheth, A., Illarramendi, A. Observer: An Approach for Query Processing in Global Information Systems Based on Interoperability Between Pre-Existing Ontologies. CoopIS, 1996.
16. Microsoft. Data Transformation Services. url: www.microsoft.com
17. Moody, D.L., Kortink, M.A.R. From Enterprise Models to Dimensional Models: a Methodology for Data Warehouse and Data Mart Design. DMDW, 2000.
18. Oracle. Oracle Warehouse Builder Product Page. url: http://otn.oracle. com/products/warehouse/content.html
19. Papadakis, N., Skoutas, D., Raftopoulos, K., Varvarigou, T. STAVIES: A System for Information Extraction from Unknown Web Data Sources through Automatic Web Wrapper Generation Using Clustering Techniques. IEEE TKDE 17(12), 2005.
20. Peralta, V. Data Warehouse Logical Design from Multi-dimensional Conceptual Schemas. CLEI, 2003.
21. Phipps, C., Davis, K. Automating Data Warehouse Conceptual Schema Design and Evaluation. DMDW, 2002.
22. Simitsis, A. Mapping Conceptual to Logical Models for ETL Processes. DOLAP, 2005.
23. Simitsis, A., Vassiliadis, P., Sellis, T. State-Space Optimization of ETL Workflows. IEEE TKDE 17(10), 2005.
24. Smith, M. K., Welty, C., McGuinness, D. L. OWL Web Ontology Language Guide. W3C Recommendation. 2004.
25. Trujillo, J., Lujan-Mora, S. A UML Based Approach for Modeling ETL Processes in Data Warehouses. ER, 2003.
26. Wache, H., et al. Ontology-Based Integration of Information A Survey of Existing Approaches. IJCAI workshop on Ontologies and Information Sharing, 2001.
27. Vassiliadis, P., Simitsis, A., Georgantas, P., Terrovitis, M., Skiadopoulos, S. A Generic and Customizable Framework for the Design of ETL Scenarios. Information Systems 30(7), 2005.
28. Vassiliadis, P., Simitsis, A., Skiadopoulos, S. Conceptual Modeling for ETL Processes. DOLAP, 2002.