A Reverse Design Tool for Relational Databases

• Main Authors: Hao-chich Chen, 陳浩傑
• Other Authors: Cheng-hong Cho
• Format: Others
• Language: zh-TW
• Published: 1994
• Online Access: http://ndltd.ncl.edu.tw/handle/63876925094233227858

碩士 === 國立臺灣科技大學 === 電機工程研究所 === 82 === 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.