|
In this thesis, we propose a database reverse engineeringtool
for EER model. This tool covers a broad range that
includes extracting the information of currently existing DDL
commands in SQL and transforming them to a conceptual model
which wouldassist the maintainer to obtain more abstract
understanding concerning the database system. A compiler is
implemented to extract the needed information, which comprises
keys and attributes in the relations described in DDL
commands. Thisinformation is then used as the input of
reversing processes. Thereversing processes are derived as
the inversion of the forward transformation rule set.
However, some information was lost in the forward design
processes. The missing information is recovered through the
dialog between the system and the maintainer. In addition, a
graph editor is provided to get a better layout of the result.
|