Extracting Supertypes/Subtypes from Legacy Relational Tables

• Main Author: 黃思綺
• Other Authors: 黃其彥
• Format: Others
• Language: zh-TW
• Published: 2009
• Online Access: http://ndltd.ncl.edu.tw/handle/15072023943524145321

碩士 === 國立臺北商業技術學院 === 商學研究所 === 97 === The thesis focuses on the field of database reverse engineering and proposes a method to extract supertypes and subtypes from given legacy relational tables. The method proposed in the thesis is quite different from those in previous studies, which need normalization assuming, original Data Definition Language. and Data Manipulation Language. On the contrary. our method obtains the relation without those constraiiits. It is useful in empirical conditions since it is difficult to get those data for legacy relational tables in many cases. The method can be adapted to many existing database reverse engineering in case of those data are unavailable.