Reverse engineering tools supporting LDBR model for logical database design

Based on reverse engineering and restructuring technologies, the Logical DataBase Redesign (LDBR) model is proposed to restructure logical database schemas from existing database files. We have developed PC based LDBR-supporting tools to provide analysts and designers with an automated environment that can extract valuable semantics from existing database files, analyze functional dependencies to determine candidate keys and normalize database files to generate new logical database schemas for re-engineering. At last, the ER model, a new abstraction, can be created. In addition, the statistics report of all null value, duplicate and redundant fields etc. can be shown from LDBR data dictionary