Abstract
A majority of the work on reverse engineering has been done on extracting entity-relationship and object models from relational databases. There exist only a few approaches that consider ontologies, as the target for reverse engineering. Moreover, the existing approaches can extract only a small subset of semantics embedded within a relational database, or they can require much user interaction for semantic annotation. In our opinion, the potential source of these problems lies in that the primary focus has been on analyzing key correlation. Data and attribute correlations are considered rarely and thus, have received little or no analysis. As an attempt to resolve the problems, we propose a novel approach, which is based on an analysis of key, data and attribute correlations, as well as their combination. Our approach can be applied to migrating data-intensive Web pages, which are usually based on relational databases, into the ontology-based Semantic Web.
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
Stojanovic, L., Stojanovic, N., Volz, R.: Migrating Data-intensive Web Sites into the Se-mantic Web. In: Nyberg, K., Heys, H.M. (eds.) SAC 2002. LNCS, vol. 2595, Springer, Heidelberg (2003)
Kashyap, V.: Design and Creation of Ontologies for Environmental Information Retrieval. In: Proceedings of the 12th Workshop on Knowledge Acquisition, Modeling and Manage-ment, KAW (1999)
Chiang, R., Barron, T., Storey, V.: A Framework for the Design and Evaluation of Reverse Engineering Methods for Relational Databases. Data and Knowledge Engineering 21(1), 57–77 (1996)
Fraternali, P.: Tools and Approaches for Developing Data-intensive Web Applications: A Survey. ACM Computing Surveys 31(3), 227–263 (1999)
Atzeni, P., Mecca, G., Merialdo, P.: Design and Maintenance of Data-Intensive Web Sites. In: Proceedings of the 6th International Conference on Extending Database Technology, pp. 436–450 (1998)
Comai, S., Fraternali, P.: A Semantic Model for Specifying Data-Intensive Web Applica-tions using WebML. In: International Semantic Web Working Symposium, SWWS (2001)
Lawrence, S., Giles, C.: Accessibility of Information on the Web. Nature (400), 107–109 (1999)
Berners-Lee, T.: XML 2000. Semantic Web Talk (2000), http://www.w3.org/2000/Talks/1206-xml2k-tbl/slide10-0.html
Gruber, T.: A Translation Approach to Portable Ontology Specifications. Knowledge Acquisition (5), 199–220 (1993)
Erdmann, M., Maedche, A., Schnurr, H., Staab, S.: From Manual to Semi-automatic Se-mantic Annotation: About Ontology-based Text Annotation Tools. In: Buitelaar, P., Hasida, K. (eds.) Proceedings of the Workshop on Semantic Annotation and Intelligent Content, COLING (2000)
Behm, A., Geppert, A., Dittrich, K.: On the migration of relational database schemas and data to object-oriented database systems. In: Proceedings of the 5th International Conference on Re-Technologies for Information Systems, pp. 13–33 (1997)
Melton, J., Simon, A.: Understanding the New SQL: A Complete Guide. Morgan Kaufmann, San Mateo (1993)
Kifer, M., Lausen, G., Wu, J.: Logical Foundations of Object-oriented and Frame-Based Languages. Journal ACM (42), 741–843 (1995)
Decker, S., Brickley, D., Saarela, J., Angele, J.: A Query and Inference Service for RDF (1998), http://www.w3.org/TandS/QL/QL98
Dogan, G., Islamaj, R.: Importing Relational Databases into the Semantic Web (2002), http://www.mindswap.org/webai/2002/fall/Importing_20Relational_20Databases_20into_20the_20Semantic_20Web.html
Noy, N., Klein, M.: Ontology Evolution: Not the Same as Schema Evolution. Knowledge and Information Systems (5) (2003)
Maedche, A., Staab, S., Stojanovic, N., Studer, R., Sure, Y.: Semantic Portal. The Seal Approach. In: Fensel, D., Hendler, J., Lieberman, H., Wahlster, W. (eds.) Creating the Semantic Web, MIT Press, Cambridge (2001)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Astrova, I. (2004). Reverse Engineering of Relational Databases to Ontologies. In: Bussler, C.J., Davies, J., Fensel, D., Studer, R. (eds) The Semantic Web: Research and Applications. ESWS 2004. Lecture Notes in Computer Science, vol 3053. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-25956-5_23
Download citation
DOI: https://doi.org/10.1007/978-3-540-25956-5_23
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-21999-6
Online ISBN: 978-3-540-25956-5
eBook Packages: Springer Book Archive