Malloc Corporation - dataMigrationCaseStudy
Oracle Database, Database Structure, Referential Integrity,
Task #1: Design new Oracle database.
Target database has to be designed however in order to do that
source database and data has to be fully understood. It is common
misconception that this can be done only by analyzing application.
Unless your application is based on a spreadsheet - it simply cannot
be done. The only way to understood the database structure and data
is to look at the database and data itself. Having data model (ER
Diagram) will definitely help understood database structure however
it will not do much when it comes to understanding data stored in
the database, its format, usage, patterns, spreads, etc. Also, many
legacy databases do not implement referential integrity and
sometimes are not even properly designed so even rudimentary data
rules are implemented and controlled at the application level and
not by database engine.
, Oracle Database
, Referential Integrity