Ontology-based conceptual design of ETL processes for both structured and semi-structured data

International Journal on Semantic Web and Information Systems

Volumn 3, Issue 4, 2007, Pages 1-24

  Skoutas, Dimitrios ^a   Simitsis, Alkis ^a  

^a NATIONAL TECHNICAL UNIVERSITY OF ATHENS   (Greece)

Author keywords

Conceptual design; Data semantics; Data warehousing; ETL; Ontology; Semantic matching; Workflow diagram

Indexed keywords

CONCEPTUAL DESIGN; DATA WAREHOUSES; GRAPHIC METHODS; ONTOLOGY;

CONCEPTUAL MODEL; DATA SEMANTICS; GRAPH-BASED REPRESENTATIONS; SEMANTIC CORRESPONDENCE; SEMANTIC MATCHING; SEMANTIC WEB TECHNOLOGY; SEMI STRUCTURED DATA; WORKFLOW DIAGRAMS;

METADATA;

EID: 70249144124     PISSN: 15526283     EISSN: 15526291     Source Type: Journal    
DOI: 10.4018/jswis.2007100101     Document Type: Article

References (50)

1. Abiteboul, S. (1997). Querying semi-structured data. In Proceedings of the International Conference on Database Theory(pp. 1-18
2. Abiteboul, S., Suciu, D., & Buneman, P. (2000). Data on the Web: From relations to semi-structured data and XML. San Francisco, CA: Morgan Kaufmann.
3. Arens, Y., Knoblock, C. A., & Shen, W.M. (1996). Query reformulation for dynamic information integration. International Journal on Intelligent and Cooperative Information Systems, 6(2/3), 99-130.
4. th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems (pp. 13-24).
5. Ballard, C. (1998). Data modeling techniques for data warehousing. IBM Red Book.
6. Baader, F., Calvanese, D., McGuiness, D. L., Nardi, D., & Patel-Schneider, P. F. (2003). The Description Logic Handbook: Theory, Implementation, Applications. Cambridge, UK: Cambridge University Press.
7. th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (pp. 99-108).
8. Bianchini, D., & De Antonellis, V. (2004). Ontology-based integration for sharing knowledge over the Web. CAiSE International Workshop on Data Integration over the Web (pp. 82-89).
9. Borst, W. N. (1997). Construction of engineering ontologies (PhD thesis, University of Twente, Enschede).
10. Boehnlein, M., & Ulbrich-vom Ende, A. (1999). Deriving the initial data warehouse structures from the conceptual data models of the underlying operational information systems. In Proceedings of the ACM 2nd International Workshop on Data Warehousing and OLAP (pp. 15-21).
11. Buneman, P. (1997). Semistructured data. In Proceedings of the ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (pp. 117-121).
12. Calì, A., Calvanese, D., De Giacomo, G., & Lenzerini, M. (2004). Data integration under integrity constraints. Information Systems, 29(2), 147-163.
13. Calvanese, D., De Giacomo, G., & Lenzerini, M. (1999). Answering queries using views in description logics. In Working Notes of the Knowledge Representation Meets Databases Workshop (pp. 6-10).
14. Calvanese, D., De Giacomo, G., & Rosati, R. (1999). Data integration and reconciliation in data warehousing: Conceptual modeling and reasoningsupport. Networking and Information Systems, 2(4), 413-432.
15. Catarci, T., & Lenzerini, M. (1993). Representing and using interschema knowledge in cooperative information systems. Journal of Intelligent and Cooperative Information Systems, 2(4), 375-398.
16. Fagin, R., Kolaitis, P. G., Miller, R. J., & Popa, L. (2005). Data exchange: semantics and query answering. Theoretical Computer Science, 336(1), 89-124.
17. Fagin, R., Kolaitis, P. G., & Popa, L. (2005). Data exchange: Getting to the core. ACM Transactions on Database Systems, 30(1), 174-210.
18. Garcia-Molina, H., Papakonstantinou, Y., Quass, D., Rajaraman, A., Sagiv, Y., Ullman, J. D., Vassalos, V., & Widom, J. (1997). ?The TSIMMIS approach to mediation: Data models and languages. Journal of Intelligent Information Systems, 8(2), 117-132.
19. Golfarelli, M., Lechtenbörger, J., Rizzi, S., & Vossen, G. (2006). Schema versioning in data warehouses: Enabling cross-version querying via schema augmentation. Data & Knowledge Engineering, 59(2), 435-459.
20. st International Workshop on Data Warehousing and OLAP (pp. 3-9).
21. th International Workshop on Data Warehousing and OLAP (pp. 40-47).
22. rd International Workshop on Data Warehousing and OLAP (pp. 9-16).
23. Halevy, A. Y. (2001). Answering queries using views: A survey. The VLDB Journal, 10(4), 270-294.
24. Horrocks, I. (2003). Implementation and optimisation techniques. In F. Baader, D. Calvanese, D. McGuinness, D. Nardi, P. F. Patel-Schneider (Eds), The Description Logic Handbook: Theory, Implementation, and Applications. Cambridge University Press, 306-346.
25. Horrocks, I., & Patel-Schneider, P. F. (1999). Optimizing description logic subsumption. Logic and Computation, 9(3), 267-293.
26. nd International Workshop on Design and Management of Data Warehouses (pp. 6.1-6.11).
27. IBM. IBM Data Warehouse Manager. URL http://www-3.ibm.com/software/data/ db2/datawarehouse/
28. Informatica. PowerCenter. URL http://www.informatica.com/products/ powercenter/
29. Kimball, R., & Caserta, J. (2004). The Data Warehouse ETL Toolkit. John Wiley & Sons.
30. Kimball, R., Reeves, L., Ross, M., & Thornthwaithe, W. (1998). The Data Warehouse Lifecycle Toolkit. John Wiley & Sons.
31. th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems (pp. 30-39).
32. st ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems (pp. 233-246).
33. th ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems (pp. 60-69).
34. rd International Conference on Conceptual Modeling (pp. 191-204).
35. th ACM International Workshop on Data Warehousing and OLAP (pp. 57-66).
36. Microsoft. Data Transformation Services. URL http://www.microsoft.com/ sql/prodinfo/features/
37. rd International Workshop on Design and Management of Data Warehouses (pp. 5.1-5.12).
38. Papadakis, N., Skoutas, D., Raftopoulos, K., & Varvarigou, T. (2005). STAVIES: A system for information extraction from unknown Web data sources through automatic Web wrapper generation using clustering techniques. IEEE Transactions on Knowledge and Data Engineering, 17(12), 1638-1652.
39. Patil, A. A., Oundhakar, S. A., Sheth, A. P. & Verma K. (2004). Meteor-S Web service annotation framework. In Proceedings of 13th International World Wide Web Conference (pp. 553-562).
40. Peralta, V. (2003). Data Warehouse Logical Design from Multi-dimensional Conceptual Schemas. CLEI.
41. Phipps, C., & Davis, K. (2002). Automating data warehouse conceptual schema design and evaluation. In Proceedings of the International Workshop on Design and Management of Data Warehouses (pp. 23-32).
42. Popa, L., Velegrakis, Y., Miller, R. J., Hernandez, M. A., & Fagin, R. (2002). Translating Web data. In Proceedings of the International Conference on Very Large Data Bases (pp. 598-609).
43. Rahm, E., & Bernstein, P. (2001). A survey of approaches to automatic schema matching. The VLDB Journal, 10(4), 334-350.
44. th International Conference on Conceptual Modeling (pp. 117-132).
45. th ACM International Workshop on Data Warehousing and OLAP (pp. 67-76).
46. th ACM International Workshop on Data Warehousing and OLAP ().
47. Smith, M. K., Welty, C., & McGuinness, D. L. (2004). OWL Web Ontology Language Guide. W3C Recommendation. URL http://www.w3.org/TR/owl-guide/
48. nd International Conference on Conceptual Modeling (pp. 307-320).
49. Vassiliadis, P., Simitsis, A., Georgantas, P., Terrovitis, M., & Skiadopoulos, S. (2005). A generic and customizable framework for the design of ETL scenarios. In Information Systems, 30(7), 492-525.
50. th ACM International Workshop on Data Warehousing and OLAP (pp. 14-21).