期刊名称：Journal of Theoretical and Applied Information Technology
印刷版ISSN：1992-8645
电子版ISSN：1817-3195
出版年度：2018
卷号：96
期号：4
页码：1138
出版社：Journal of Theoretical and Applied
摘要：Database reverse engineering is the process of extracting and transforming database metadata to a rich set of models. These models must be able to describe data structure at different levels of abstraction, starting from physical to conceptual schema. The obtained schema may be used to ease, among others, database structure update, evolution and maintenance. In the past few years, the object oriented construct was merged into relational database. Nevertheless, a few methods of object relational database (ORDB) reverse engineering was presented. In this sense, the main goal of this article is to present an approach of database reverse engineering which cover the transformation of new added object construct. At the end of transformation we obtain a conceptual schema (CS) expressed as UML class diagram. The returned CS is extended with a set of OCL (Object Constraint Language) clauses which represent at a higher level of abstraction, the database integrity constraints. We provide a program that implements our approach for ORACLE 11g database management system.
