DATABASE REVERSE ENGINEERING Adma Archana CSC 532 TERM
DATABASE REVERSE ENGINEERING Adma Archana CSC 532 TERM PAPER LOUISIANA TECH UNIVERSITY
INTRODUCTION Database Reverse Engineering provides solution to the necessity for scientifically rebuilding the lost documentation of current systems that are to be maintained and to evolve in a world of increasingly complex technology
REVERSE ENGINEERING • • • Reverse Engineering a piece of software involves recovering or reconstructing its functional and technical specifications, starting mainly from the source code of the programs. It is a Complex Painful & Prone-to-failure activity.
• • • Reverse Engineering the data components of the application first, can be much more efficient than trying to cope with the whole application. Narrow semantic distance for data than for procedural parts Data is the most stable part of applications Semantic structure underlying file structures is procedure independent
Database design is made up of a sequence of four processes: • Conceptual Design • Logical Design Schema Simplification Schema Optimization Schema Translation 1. Physical Design 2. View Design
• • Reverse Engineering any Database consists of two major processes: Data Structure Extraction Data Structure Conceptualization
Data Structure Extraction: produces a complete description of the data structures according to the model of the DMS Data Structure Conceptualization: tries to make the semantics of the logical schema explicit by recovering the intention of the optimized DMS data structures
1. Untranslation: Inverse of Schema Translation 2. 3. forward process De-optimization: Inverse of Schema Optimization forward process Conceptual Normalization: intended to recover high level structures transformed by the Schema Specification
SPECIFIC DBRE PROBLEMS • • • Weakness of the DBMS models Implicit Structures Optimized Structures Awkward Design Obsolete Constructs Cross-model influence
DBRE TOOLS • Microsoft Visio 2002 Professional Edition * • • (Microsoft, IBM, Oracle, Sybase, others via ODBC) CASE Studio 2 – Database Modeling tool Dezign for databases - Datanamic
Conclusion Database Reverse Engineering tools can contribute to the program understanding – which a modest goal of software reverse engineering
REFERENCES • http: //citeseer. nj. nec. com/cache/papers/cs/12031/http: z. Szwww. i • • nfo. fundp. ac. bez. Sz~dbmz. Sz. DOCUMENTSz. Szdbrebook. pdf/hainaut 98 database. pdf** http: //citeseer. nj. nec. com/cache/papers/cs/16137/ftp: z. Szftp. info. fundp. ac. bez. Szpublicationsz. Sz. RP-95013. pdf/hainaut 95 requirement. pdf http: //citeseer. nj. nec. com/cache/papers/cs/25379/ftp: z. Szftp. info. fundp. ac. bez. Szpublicationsz. Sz. RP-98004. pdf/henrard 98 program. pdf http: //404. ieplugin. com/404. cgi? 404=http: //www. sei. cmu. edu/pub/ documents/99. reports/pdf/99 tr 010. pdf-reengineering http: //citeseer. nj. nec. com/cache/papers/cs/27089/http: z. Szwww. i nfo. fundp. ac. bez. Sz~dbmz. Szpublicationz. Sz 2002 z. Szwcre 02. pdf/strate gies-for-data-reengineering. pdf
- Slides: 14