Database reverse engineering method

Katarzyna Tubielewicz, Lech Tuzinkiewicz


In this paper the method of reverse engineering for database is presented. The proposed method takes into account relational schemas which are at least in the 1stNF. In this method is used ontology as a model of the considered domain. It allows to interpret the physical data models according to the ontology and reconstruct conceptual data models.


database; database reverse transformation; ontology

Full Text:



Andersson M.: Extracting an Entity Relationship Schema from a Relational Database through Reverse Engineering. Proceedings of the 13th International Conference on the Entity-Relationship Approach, Lecture Notes In Computer Science; Vol. 881. Springer-Verlag, London, UK, 1994.

Astrova I.: Reverse Engineering of Relational Databases to Ontologies. The Semantic Web: Research and Applications. Springer, Berlin/Heidelberg, 2004.

Astrova I., Korda N., Kalja A.: Storing OWL Ontologies in SQL Relational Databases. International Journal of Electrical, Computer and Systems Engineering ( Fall 2007), s. 242-247. Online on

Barbar A.: A User Driven Method for Database Reverse Engineering. Proceedings of the conference on Advanced Information Systems Engineering, CaiSE’01. The 8th Doctoral Consortium (Interlaken June 4-8,2001).

Casanova M.A., de Sa J.E.A.: Designing Entity-Relationship Schemas for Conventional Information Systems. Proceedings of the 3rd Conference on the ER Approach to Software Engineering (1983), s. 265-277.

Chiang R.H.L.: A knowledge-based system for performing reverse engineering of relational databases. Decision Support Systems, 13, 3-4 (March 1995), s. 295-312.

Chiang R.H.L., Barron T.M., Storey V.C: A framework for the design and evaluation of reverse engineering methods for relational databases. Data & Knowledge Engineering, 21, 1 (December 1996), s. 57-77.

Chikofsky E.: The Necessity of Data Reverse Engineering. In Preface to Data Reverse Engineering: Slaying the Legacy Dragon. McGraw-Hill, New York, 1996.

Chikofsky E.J., Cross J.H.: Reverse Engineering and Design Recovery: A Taxonomy (January 1990), s. 13-18.

Fahrner Ch., Vossen G.: Transforming Relational Database Schemas into Object-Oriented Schemas according to ODMG-93. Lecture Notes In Computer Science; Vol. 1013, Proceedings of the Fourth International Conference on Deductive and Object-Oriented Databases. Springer-Verlag, London, UK, 1995.

Gruber T.R.: A Translation Approach to Portable Ontology Specification. Knowladge Acquisition, 5 (1993), s. 199-220.

Harrison R., Chan C.: Distributed Ontology Management System. In Proceedings 18th Annual Canadian Conference on Electrical and Computer Engineering. (Saskatoon, Canada May 2005), s. 661-664.

Johannesson P.: A Method for Transforming Relational Schemas Into Conceptual Schemas. Proceedings of the Tenth International Conference on Data Engineering (Washington, USA 1994), IEEE Computer Society, s. 190-201.

Lubyte L., Tessaris S.: Extracting Ontologies from Relational Databases. Free University of Bozen-Bolzano, Bolzano, Italy, 2007.

Markowitz V.M., Makowsky J.A.: Identifying Extended Entity-Relationship Object Structures in Relational Schemas. IEEE Transactions on Software Engineering, 16, 8 (August 1990), s. 777-790.

Markowitz H.M., Malhotra A., Tsalalikhin Y., Pazel D.P., Burns L.M.: An Entity-Ralationship Programing Language. IEEE Transactions on Software Engineering, 15, 9 (September 1989), s. 1120-1130.

Navathe S., Awong A.: Abstracting Relational and Hierarchical Data With a Semantic Data Model. In Proceedings of the 6th International Conference on the Entity Relationship Approach (Amsterdam, The Netherlands 1987), North-Holland Publishing Co., s. 305-333.

Ramanathan S., Hodges J.: Extraction of Object-Oriented Structures from Existing Relational Databases. ACM SIGMOD Record, 26, 1 (March 1997), s. 59-64.