skip to main content
10.1145/2811222.2811228acmconferencesArticle/Chapter ViewAbstractPublication PagescikmConference Proceedingsconference-collections
research-article

Supporting Data Integration Tasks with Semi-Automatic Ontology Construction

Authors Info & Claims
Published:22 October 2015Publication History

ABSTRACT

Data integration aims to facilitate the exploitation of heterogeneous data by providing the user with a unified view of data residing in different sources. Currently, ontologies are commonly used to represent this unified view in terms of a global target schema due to their flexibility and expressiveness. However, most approaches still assume a predefined target schema and focus on generating the mappings between this schema and the sources.

In this paper, we propose a solution that supports data integration tasks by employing semi-automatic ontology construction to create a target schema on the fly. To that end, we revisit existing ontology extraction, matching and merging techniques and integrate them into a single end-to-end system. Moreover, we extend the used techniques with the automatic generation of mappings between the extracted ontologies and the underlying data sources. Finally, to demonstrate the usefulness of our solution, we integrate it with an independent data integration system.

References

  1. A. Algergawy, S. Massmann, and E. Rahm. A clustering-based approach for large-scale ontology matching. In Proceedings of ADBIS, pages 415--428. Springer, 2011. Google ScholarGoogle ScholarDigital LibraryDigital Library
  2. H. Bohring and S. Auer. Mapping XML to OWL ontologies. In Proceedings of 13. Leipziger Informatik-Tage (LIT 2005), pages 147--156, 2005.Google ScholarGoogle Scholar
  3. S. Castano, V. De Antonellis, S. De Capitani di Vimercati, and M. Melchiori. Semi-automated extraction of ontological knowledge from XML data sources. In Proceedings of DEXA, pages 852--860. IEEE, 2002. Google ScholarGoogle ScholarDigital LibraryDigital Library
  4. F. Cerbah. Learning highly structured semantic repositories from relational databases: The RDBToOnto tool. In In Proceedings of ESWC, pages 777--781. Springer, 2008. Google ScholarGoogle ScholarDigital LibraryDigital Library
  5. I. F. Cruz, F. Palandri Antonelli, and C. Stroe. AgreementMaker: Efficient matching for large real-world schemas and ontologies. VLDB, pages 1586--1589, 2009. Google ScholarGoogle ScholarDigital LibraryDigital Library
  6. M. Dadjoo and E. Kheirkhah. An approach for transforming of relational databases to OWL ontology. International Journal of Web & Semantic Technology, 6(1), 2015.Google ScholarGoogle ScholarCross RefCross Ref
  7. J. David, J. Euzenat, F. Scharffe, and C. T. Dos Santos. The Alignment API 4.0. Semantic Web Journal, 2:3--10, 2011. Google ScholarGoogle ScholarDigital LibraryDigital Library
  8. G. De Giacomo, D. Lembo, M. Lenzerini, and R. Rosati. On reconciling data exchange, data integration, and peer data management. In Proceedings of ACM PODS, pages 133--142. ACM, 2007. Google ScholarGoogle ScholarDigital LibraryDigital Library
  9. C. P. De Laborda and S. Conrad. Relational. OWL - a data and schema representation format based on OWL. In Proceedings of CRPIT, pages 89--96. Australian Computer Society, 2005. Google ScholarGoogle ScholarDigital LibraryDigital Library
  10. S. Dessloch, M. A. Hernández, R. Wisnesky, A. Radwan, and J. Zhou. Orchid: Integrating schema mapping and etl. In Proceedings of ICDE, pages 1307--1316. IEEE, 2008. Google ScholarGoogle ScholarDigital LibraryDigital Library
  11. A. Doan, J. Madhavan, P. Domingos, and A. Halevy. Learning to map between ontologies on the semantic web. In WWW2002. ACM, 2002. Google ScholarGoogle ScholarDigital LibraryDigital Library
  12. R. Fagin, L. M. Haas, M. Hernández, R. J. Miller, L. Popa, and Y. Velegrakis. Clio: Schema mapping creation and data exchange. pages 198--236, 2009.Google ScholarGoogle Scholar
  13. R. Fagin, P. G. Kolaitis, R. J. Miller, and L. Popa. Data exchange: Semantics and query answering. Theoretical Computer Science, 336:89--124, 2005. Google ScholarGoogle ScholarDigital LibraryDigital Library
  14. M. Georgiu and A. Groza. Ontology enrichment using semantic wikis and design patterns. Studia Universitatis Babes-Bolyai, Informatica, 56(2), 2011.Google ScholarGoogle Scholar
  15. M. Granitzer, V. Sabol, K. W. Onn, D. Lukose, and K. Tochtermann. Ontology alignment - a survey with focus on visually supported semi-automatic techniques. Future Internet, 2:238--258, 2010.Google ScholarGoogle ScholarCross RefCross Ref
  16. W. Hu, N. Jian, Y. Qu, and Y. Wang. GMO: A graph matching for ontologies. In Proceedings of K-Cap 2005 Workshop on Integrating Ontologies, pages 43--50, 2005.Google ScholarGoogle Scholar
  17. W. Hu, Y. Qu, and G. Cheng. Matching large ontologies: A divide-and-conquer approach. Data and Knowledge Engineering, 67:140--160, 2008. Google ScholarGoogle ScholarDigital LibraryDigital Library
  18. Y. R. Jean-Mary, E. P. Shironoshita, and M. R. Kabuka. Ontology matching with semantic verification. Journal of Web Semantics, 7:235--251, 2009. Google ScholarGoogle ScholarDigital LibraryDigital Library
  19. P. Jovanovic, O. Romero, A. Simitsis, A. Abelló, H. Candón, and S. Nadal. Quarry: Digging up the gems of your data treasury. In Proceedings of EDBT, pages 549--552. OpenProceedings, 2015.Google ScholarGoogle Scholar
  20. P. Lambrix and H. Tan. SAMBO - a system for aligning and merging biomedical ontologies. Journal of Web Semantics, 4:196--206, 2006. Google ScholarGoogle ScholarDigital LibraryDigital Library
  21. M. Lenzerini. Data integration: A theoretical perspective. In Proceedings of ACM PODS, pages 233--246. ACM, 2002. Google ScholarGoogle ScholarDigital LibraryDigital Library
  22. J. Li, J. Tang, Y. Li, and Q. Luo. RiMOM - a dynamic multistrategy ontology alignment framework. IEEE TKDE, 21:1218--1232, 2009. Google ScholarGoogle ScholarDigital LibraryDigital Library
  23. L. Lubyte and S. Tessaris. Automatic extraction of ontologies wrapping relational data sources. In Proceedings of DEXA, volume 5690, pages 128--142. Springer, 2009. Google ScholarGoogle ScholarDigital LibraryDigital Library
  24. W. Mallede, F. Marir, and V. Vassilev. Algorithms for mapping RDB schema to RDF for facilitating access to deep web. In Proceedings of WEB. IARIA XPS Press, 2013.Google ScholarGoogle Scholar
  25. G. Petasis, V. Karkaletsis, G. Paliouras, A. Krithara, and E. Zavitsanos. Ontology population and enrichment: State of the art. Knowledge-Driven Multimedia Information Extraction and Ontology Evolution, pages 134--166, 2011. Google ScholarGoogle ScholarCross RefCross Ref
  26. J. Sequeda. On the semantics of R2RML and its relationship with the direct mapping. In Proceedings of the International Semantic Web Conference, pages 193--196. CEUR-WS, 2013.Google ScholarGoogle Scholar
  27. P. Shvaiko and E. Ome Euzenat. Ontology matching: State of the art and future challenges. IEEE TKDE, 2011.Google ScholarGoogle Scholar
  28. G. Stoilos, G. Stamou, and S. Kollias. A string metric for ontology alignment. In Proceedings of ISWC, pages 624--637. Springer, 2005. Google ScholarGoogle ScholarDigital LibraryDigital Library
  29. F. M. Suchanek, S. Abiteboul, and P. Senellart. PARIS: Probabilistic alignment of relations, instances, and schema. VLDB, 5:157--168, 2011. Google ScholarGoogle ScholarDigital LibraryDigital Library
  30. S. Wang, Y. Zeng, and N. Zhong. Ontology extraction and integration from semi-structured data. In Proceedings of AMT, pages 39--48. Springer, 2011. Google ScholarGoogle ScholarDigital LibraryDigital Library
  31. H. Zhang, W. Hu, and Y. Qu. Constructing virtual documents for ontology matching using MapReduce. In Proceedings of JIST, pages 48--63. Springer-Verlag, 2012. Google ScholarGoogle ScholarDigital LibraryDigital Library

Index Terms

  1. Supporting Data Integration Tasks with Semi-Automatic Ontology Construction

        Recommendations

        Comments

        Login options

        Check if you have access through your login credentials or your institution to get full access on this article.

        Sign in
        • Published in

          cover image ACM Conferences
          DOLAP '15: Proceedings of the ACM Eighteenth International Workshop on Data Warehousing and OLAP
          October 2015
          108 pages
          ISBN:9781450337854
          DOI:10.1145/2811222

          Copyright © 2015 ACM

          Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

          Publisher

          Association for Computing Machinery

          New York, NY, United States

          Publication History

          • Published: 22 October 2015

          Permissions

          Request permissions about this article.

          Request Permissions

          Check for updates

          Qualifiers

          • research-article

          Acceptance Rates

          DOLAP '15 Paper Acceptance Rate8of31submissions,26%Overall Acceptance Rate29of79submissions,37%

          Upcoming Conference

        PDF Format

        View or Download as a PDF file.

        PDF

        eReader

        View online with eReader.

        eReader