Advertisement

Towards a Semantic Web of Relational Databases: A Practical Semantic Toolkit and an In-Use Case from Traditional Chinese Medicine

  • Huajun Chen
  • Yimin Wang
  • Heng Wang
  • Yuxin Mao
  • Jinmin Tang
  • Cunyin Zhou
  • Ainin Yin
  • Zhaohui Wu
Part of the Lecture Notes in Computer Science book series (LNCS, volume 4273)

Abstract

Integrating relational databases is recently acknowledged as an important vision of the Semantic Web research, however there are not many well-implemented tools and not many applications that are in large-scale real use either. This paper introduces the Dartgrid which is an application development framework together with a set of semantic tools to facilitate the integration of heterogenous relational databases using semantic web technologies. For examples, DartMapping is a visualized mapping tool to help DBA in defining semantic mappings from heterogeneous relational schemas to ontologies. DartQuery is an ontology-based query interface helping user to construct semantic queries, and capable of rewriting SPARQL semantic queries to a set of SQL queries. DartSearch is an ontology-based search engine enabling user to make full-text search over all databases and to navigate across the search results semantically. It is also enriched with a concept ranking mechanism to enable user to find more accurate and reliable results. This toolkit has been used to develop an currently in-use application for China Academy of Traditional Chinese Medicine (CATCM). In this application, over 70 legacy relational databases are semantically interconnected by an ontology with over 70 classes and 800 properties, providing integrated semantic-enriched query, search and navigation services to TCM communities.

Keywords

Relational Database Semantic Mapping SPARQL Query Semantic View Query Interface 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

References

  1. 1.
    Buitelaar, P., Olejnik, D., Sintek, M.: OntoLT: A protégé plug-in for ontology extraction from text. In: Fensel, D., Sycara, K.P., Mylopoulos, J. (eds.) ISWC 2003. LNCS, vol. 2870. Springer, Heidelberg (2003)Google Scholar
  2. 2.
    Halevy, A.Y.: Answering queries using views: A survey. The VLDB Journal 10, 270–294 (2001)CrossRefMATHGoogle Scholar
  3. 3.
    Chen, H., Wu, Z., Wang, H., Mao, Y.: Rdf/rdfs-based relational database integration. In: ICDE, p. 94 (2006)Google Scholar
  4. 4.
    de Laborda, C.P., Conrad, S.: Bringing relational data into the semantic web using sparql and relational owl. In: International Workshop on Semantic Web and Database at ICDE 2006, pp. 55–60 (2006)Google Scholar
  5. 5.
    An, Y., Borgida, A., Mylopoulos, J.: Inferring complex semantic mappings between relational tables and ontologies from simple correspondences. In: International Semantic Web Conference, pp. 6–20 (2005)Google Scholar
  6. 6.
    Stuckenschmidt, H., van Harmelen, F., de Waard, A., et al.: Exploring large document repositories with rdf technology: The dope project. IEEE Intelligent Systems 19, 34–40 (2004)CrossRefGoogle Scholar
  7. 7.
    Halevy, A.Y., Ives, Z.G., Madhavan, J., Mork, P., Suciu, D., Tatarinov, I.: The piazza peer data management system. IEEE Trans. Knowl. Data Eng. 16(7), 787–798 (2004)CrossRefGoogle Scholar
  8. 8.
    Dou, D., LePendu, P., Kim, S., Qi, P.: Integrating databases into the semantic web through an ontology-based framework. In: International Workshop on Semantic Web and Database at ICDE 2006, pp. 33–50 (2006)Google Scholar
  9. 9.
    Goasdoue, F.: Answering queries using views: a krdb perspective for the semantic web. ACM Transaction on Internet Technology, 1–22 (2003)Google Scholar
  10. 10.
    Haase, P., Motik, B.: A mapping system for the integration of owl-dl ontologies. In: IHIS 2005: Proceedings of the First International Workshop on Interoperability of Heterogeneous Information Systems, pp. 9–16 (2005)Google Scholar
  11. 11.
    Abiteboul, S., Duschka, O.M.: Complexity of answering queries using materialized views. In: The Seventeenth ACM SIGACT-SIGMOD-SIGART Symposium on Principles of database systems, pp. 254–263 (1998)Google Scholar
  12. 12.
    Yu, C., Popa, L.: Constraint-based xml query rewriting for data integration. In: 2004 ACM SIGMOD International Conference on Management of Data, pp. 371–382 (2004)Google Scholar
  13. 13.
    Wache, H., Vögele, T., Visser, U., Stuckenschmidt, H., Schuster, G., Neumann, H., Hubner, S.: Ontology-based integration of information - a survey of existing approaches. In: Stuckenschmidt, H. (ed.) IJCAI 2001 Workshop: Ontologies and Information Sharing, pp. 108–117 (2001)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2006

Authors and Affiliations

  • Huajun Chen
    • 1
  • Yimin Wang
    • 2
  • Heng Wang
    • 1
  • Yuxin Mao
    • 1
  • Jinmin Tang
    • 1
  • Cunyin Zhou
    • 1
  • Ainin Yin
    • 3
  • Zhaohui Wu
    • 1
  1. 1.College of Computer ScienceZhejiang UniversityHangzhouChina
  2. 2.Institute AIFBUniversity of KarlsruheGermany
  3. 3.China Academy of Traditional Chinese MedicineBeijingChina

Personalised recommendations