Transcript CLUSTER DATABASE Computing with Clusters

DATABASE REVERSE
ENGINEERING
Adma Archana
CSC532 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
Physical Design
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
• Untranslation: Inverse of Schema Translation
•
•
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:zSzzSzwww.i
•
•
•
•
nfo.fundp.ac.bezSz~dbmzSzDOCUMENTSzSzdbrebook.pdf/hainaut98
database.pdf**
http://citeseer.nj.nec.com/cache/papers/cs/16137/ftp:zSzzSzftp.info.
fundp.ac.bezSzpubzSzpublicationszSzRPzSzRP-95013.pdf/hainaut95requirement.pdf
http://citeseer.nj.nec.com/cache/papers/cs/25379/ftp:zSzzSzftp.info.
fundp.ac.bezSzpubzSzpublicationszSzRPzSzRP-98004.pdf/henrard98program.pdf
http://404.ieplugin.com/404.cgi?404=http://www.sei.cmu.edu/pub/
documents/99.reports/pdf/99tr010.pdf-reengineering
http://citeseer.nj.nec.com/cache/papers/cs/27089/http:zSzzSzwww.i
nfo.fundp.ac.bezSz~dbmzSzpublicationzSz2002zSzwcre02.pdf/strate
gies-for-data-reengineering.pdf