Browse > Article
http://dx.doi.org/10.9708/jksci.2011.16.7.035

OWL/Relational Mapping Rules to Use Relational Databases as OWL 2 Web Ontologies  

Choi, Ji-Woong (Dept. of Computer Science, Soongsil University)
Kim, Myung-Ho (School of Computer Science and Engineering, Soongsil University)
Publication Information
Journal of the Korea Society of Computer and Information / v.16, no.7, 2011 , pp. 35-47 More about this Journal
Abstract
This paper proposes a set of rules to automatically generate OWL ontologies from relational databases. The purpose of the rules is to allow semantic access to existing RDB data without any database schema transformation and data migration process. In other words, the rules help a RDBMS play as a web ontology repository as well. However, the use of the mapping rules between RDB and OWL proposed by other studies for the objective causes troubles as follows. First, databases including the tables with a specific structure can't be translated into OWL. Second, the process for extracting an OWL individual unnecessarily lead to database join operations, or several SQL queries. On the other hand, our rules is designed to prevent these problems, can generate OWL classes and properties from database schemas and can generate OWL individuals from the database instances. In addition, an ontology generated by our rules is an OWL 2 DL ontology.
Keywords
Web Ontology Language; Relational Database; Semantic Web; Mapping Rules;
Citations & Related Records
연도 인용수 순위
  • Reference
1 P.V.Biron, and A. Malhotra, "XML Schema Part 2: Datatypes Second Edition," W3C Recommendation 28 October 2004, http://www.w3.org/TR/xmlschema-2/
2 B. Motik, P.F.Patel-Schneider, and B. Parsia, "O WL 2 Web Ontology Language Structural Specific ation and Functional-Style Syntax," W3C Recomm endation 27 October 2009, http://www.w3.org/TR/2009/REC-owl2-syntax-20091027/
3 G. Bumans, and K. Cerans, "RDB2OWL: a Practical Approach for Transforming RDB Data into RDF/OWL," Proceedings of the 6th International Conference on Semantic Systems, Graz, Austria, 2010.
4 N. Cullot, R. Ghawi, and K. Yetongno, "DB2OWL: A Tool for Automatic Database-to-Ontology Mapping," In Proceedings of the 15th Italian Symposium on Advanced Database Systems (SEBD 2007), Torre Canne di Fasano (BR), Italy, pp. 491-494, June 2007.
5 M. Li, X. Du, and S. Wang, "Learning Ontology from Relational Database," Proceedings of the 4th International Conference on Machine Learning and Cybernetics. Vol. 6 pp. 3410-3415, 2005.
6 S. Sane, and A. Shirke, "Generating OWL Ontologies from Relational Databases for the Semantic Web," International Conference on Advances in Computing, Communications and Control, pp. 157-162, 2009.
7 Z. Xu, S. Zhang, and Y. Dong, "Mapping between relational database schema and OWL ontology for deep annotation," Proc. of IEEE/WIC/ACM Int. Conf. on Web Intelligence, , pp. 548-552, Hong Kong, China, 2006.
8 C. Blakeley, "RDF Views of SQL Data (Declarative SQL Schema to RDF Mapping)," OpenLink Software, 2007.
9 S. Zhou, G. Meng, H. Ling, H. Zhang, "Tool for Translating Relational Databases Schema into Ontology for Semantic Web," 2010 Second International Workshop on Education Technology and Computer Science, etcs, vol. 1, pp. 198-201, 2010.
10 T. Berners-Lee, "Weaving the Web," HarperBusiness, 2000.
11 S. Auer, S. Dietzold, J. Lehmann, S. Hellmann, and D. Aumueller, "Triplify - Light-weight linked data publication from relational databases," Proceedings of the 18th International Conference on World Wide Web (WWW) 2009.
12 C. Bizer, and R. Cyganiak, "D2RQ - Lessons Learned," Position paper for the W3C Workshop on RDF Access to Relational Databases, Cambridge, USA, 2526 October 2007.