A Novel Semantic Discovery Method using Transaction Requirements in Database Reverse Engineering
Existing database reverse engineering approaches mainly analyze the database schema, especially the key constraints, to discover the relationships between relations and attributes. However these methods are only effective for direct semantics discovery, while large part of inferred semantics is still missing. This paper proposes a transaction-oriented semantic discovery method which analyzes the transaction requirements supported by a database to explore hidden semantics. Our method relaxes the constraints on normalization of database design to suit for wide range applications, and is effective for discovering transitive relationships, general-specific relationships and master-detail relationships.
database reverse transaction direct semantics inferred semantics
Fanwei Zhu Minghui Wu Jia Lv Jing Ying
College of Computer Science and Technology Zhejiang University Hangzhou, China
国际会议
2009 WASE International Conference on Information Engineering(2009年国际信息工程会议)(ICIE 2009)
太原
英文
561-564
2009-07-10（万方平台首次上网日期，不代表论文的发表时间）