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.
Chapter PDF
Similar content being viewed by others
Keywords
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
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)
Halevy, A.Y.: Answering queries using views: A survey. The VLDB Journal 10, 270–294 (2001)
Chen, H., Wu, Z., Wang, H., Mao, Y.: Rdf/rdfs-based relational database integration. In: ICDE, p. 94 (2006)
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)
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)
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)
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)
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)
Goasdoue, F.: Answering queries using views: a krdb perspective for the semantic web. ACM Transaction on Internet Technology, 1–22 (2003)
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)
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)
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)
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)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Chen, H. et al. (2006). Towards a Semantic Web of Relational Databases: A Practical Semantic Toolkit and an In-Use Case from Traditional Chinese Medicine. In: Cruz, I., et al. The Semantic Web - ISWC 2006. ISWC 2006. Lecture Notes in Computer Science, vol 4273. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11926078_54
Download citation
DOI: https://doi.org/10.1007/11926078_54
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-49029-6
Online ISBN: 978-3-540-49055-5
eBook Packages: Computer ScienceComputer Science (R0)