hi dba ,
I went through the same problem here,where I reverse engineered a system
with no relations or integrity constraints and it was hell,since I guessed the
business rules and asked people from anywhere about the business of this
system,I don't want to remember this period of my life.
I 'm not
I'm working on a project which is converting from DB2 to Oracle and
possibly UDB. All of the current constraints are in the Cobol code and
none are database enforced. A version of the data model is stored in
Cool:Gen and we need to update this and use it to move all of the
constraints from the c
Any system with online 'live' updates as opposed to saving up all the
updates and running them through a batch process
would be considered an OLTP application.
Ron Smith
Database Administration
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 13, 2
I am starting a Data Warehouse project, possibly using Oracle Warehouse
Builder. One of the databases that I must bring together comes from IBM
DB2 database. We have reverse engineered a piece of their database so that
we can produce an ER diagram so that we can start understanding their data.
A