Abstract
The content of most Web pages is dynamically derived from an underlying relational database. Thus, the success of the Semantic Web hinges on enabling access to relational databases and their content by semantic methods. We define a system for automatic transformation of SQL DDL schemas into OWL DL ontologies. This system goes further than earlier efforts in that the entire system is expressed in first-order logic. We leverage the formal approach to show the system is complete with respect to a space of the possible relations that can be formed among relational tables as a consequence of primary and foreign key combinations. The full set of transformation rules is stratified, thus the system can be executed directly by a Datalog interpreter.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
An, Y., Borgida, A., Mylopoulos, J.: Inferring Complex Semantic Mappings between Relational Tables and Ontologies from Simple Correspondences. In: Proceedings of On The Move to Meaningful Internet Systems (2005)
Astrova, I., Korda, N., Kalja, A.: Rule-Based Transformation of SQL Relational Databases to OWL Ontologies. In: Proceedings of the 2nd International Conference on Metadata & Semantics Research (October 2007)
Barrasa, J., Corcho, O.: R2O, an Extensible and Semantically Based Database-to-Ontology Mapping Language. In: Bussler, C.J., Tannen, V., Fundulaki, I. (eds.) SWDB 2004. LNCS, vol. 3372, Springer, Heidelberg (2005)
Barbançon, F., Miranker, D.P.: SPHINX: Schema integration by example. Journal of Intelligent Information Systems (in press, available on-line SpringerLink)
Bizer, C.: D2R MAP - A Database to RDF Mapping Language. In: Proceedings of the Twelfth International World Wide Web Conference (WWW) (2003)
Chen, H., Wang, Y., Wang, H., Mao, Y., Tang, J., Zhou, C., et al.: Towards a Semantic Web of Relational Databases: a Practical Semantic Toolkit and an In-Use Case from Traditional Chinese Medicine. In: Proc. of the 5th International Semantic Web Conference (2006)
Du, H., Wery, L.: Micro: A normalization tool for relational database engineers. Journal of Network and Computer Applications 22(4), 215–232 (1999)
He, B., Patel, M., Zhang, Z., Chang, K.C.: Accessing the deep web. Communications of the ACM 50(5), 94–101 (2007)
Horrocks, I., Patel-Schneider, P.F.: Reducing OWL entailment to description logic satisfiability. In: Proceedings of the 2nd International Semantic Web Conference (2003)
de Laborda, C.P., Conrad, S.: Relational. OWL: a data and schema representation format based on OWL. In: Proceedings of the 2nd Asia-Pacific Conference on Conceptual Modeling, vol. 43, pp. 89–96 (2005)
de Laborda, C.P., Conrad, S.: Database to Semantic Web Mapping using RDF Query Languages. In: 25th International Conference on Conceptual Modeling (November 2006)
Li, M., Du, X., Wang, S.: Learning ontology from relational database. In: Proceedings of the Fourth International Conference on Machine Learning and Cybernetics (2005)
Miller, R., Haas, L.L., Hernández, M.: Schema mapping as query discovery. In: Proceedings of the VLDB Conference (2000)
Motik, B., Horrocks, I., Sattler, U.: Bridging the gap between OWL and relational databases. In: Proceedings of the 16th International Conference on World Wide Web (2007)
Noy, N., Rector, A. (eds.): Defining N-ary Relations on the Semantic Web. W3C Working Group Note (11/14/2007), http://www.w3.org/TR/2006/NOTE-swbp-n-aryRelations-20060412/
Smith, M.K., Welty, C., McGuinness, D.L. (eds.): OWL Web Ontology Language Guide. W3C Recommendation /REC-owl-guide-20040210/> (11/15/2007) (2004), http://www.w3.org/TR/
Dean, M., Schreiber, G. (eds.): OWL Web Ontology Language Reference. W3C Recommendation (11/14/2007), http://www.w3.org/TR/2004/REC-owl-ref-20040210/
Hayes, P. (ed.): RDF Semantics. W3C Recommendation (11/26/2007), http://www.w3.org/TR/2004/REC-rdf-mt-20040210/
Rodriguez, J.B., Gomez-Perez, A.: Upgrading relational legacy data to the semantic web. In: Proceedings of the 15th international Conference on World Wide Web (2006)
Sequeda, J.F., Tirmizi, S.H., Miranker, D.P.: SQL Databases are a Moving Target. In: Position Paper for W3C Workshop on RDF Access to Relational Databases (October 2007)
Stojanovic, L., Stojanovic, N., Volz, R.: Migrating data-intensive web sites into the semantic web. In: Proceedings of the ACM Symposium on Applied Computing (2002)
Wang, S., Shen, J., Hong, T.: Mining fuzzy functional dependencies from quantitative data. In: IEEE International Conference on Systems, Man and Cybernetics (October 2000)
Biron, P.V., Permanente, K., Malhotra, A. (eds.): XML Schema Part 2: Datatypes Second Edition. W3C Recommendation (11/26/2007), http://www.w3.org/TR/2004/REC-xmlschema-2-20041028/
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Tirmizi, S.H., Sequeda, J., Miranker, D. (2008). Translating SQL Applications to the Semantic Web. In: Bhowmick, S.S., Küng, J., Wagner, R. (eds) Database and Expert Systems Applications. DEXA 2008. Lecture Notes in Computer Science, vol 5181. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-85654-2_40
Download citation
DOI: https://doi.org/10.1007/978-3-540-85654-2_40
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-85653-5
Online ISBN: 978-3-540-85654-2
eBook Packages: Computer ScienceComputer Science (R0)