Database Reverse Engineering based on Association Rule Mining
Maintaining a legacy database is a difficult task especially when
system documentation is poor written or even missing. Database
reverse engineering is an attempt to recover high-level
conceptual design from the existing database instances. In this
paper, we propose a technique to discover conceptual schema
using the association mining technique. The discovered schema
corresponds to the normalization at the third normal form, which
is a common practice in many business organizations. Our
algorithm also includes the rule filtering heuristic to solve the
problem of exponential growth of discovered rules inherited with
the association mining technique.
Keywords: Legacy Databases, Reverse Engineering, Database
Design, Database Normalization, Association Mining
Download Full-Text
