| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data Dictionary
SHERIE,
Use a reverse engineering tool, S-Designor or something similar (use the
trial period if you have no budget), and hope that they've either used
either referential integrity or at least same field names (can join tables
on same name), this will produce you a ER Model.You can then attempt to
document it. The way they designed it shouldn't be too weird after all it
should be relational, and back in the days of DB2 people knew how to design
a database, i.e. there wasn't the profusion of ERP packages etc.. that there
are now.
Sam
-----Original Message-----
From: Sherrie.Kubis_at_swfwmd.state.fl.us
[mailto:Sherrie.Kubis_at_swfwmd.state.fl.us]
Sent: Saturday, January 20, 2001 5:15 PM
To: Multiple recipients of list ORACLE-L
Subject: Data Dictionary
Listers:
I am embarking on a project that uses DB2 data accessed through Oracle's Transparent Gateway. Environmental modeling that uses this data will be outsourced to consultants, and I've got to be able to tell them what this DB2 data is. Since the DB2 folks have never documented their data, and have a very weird and different way of designing their database, the first phase of this project is to deliver a Data Dictionary with er diagrams of DB2 data so that we can understand what we have. (I know that this is goofy and that they should have been doing this all along, but I'm doing the best I can with what I have.) The DB2 folks have asked that the data dictionary process, after it's initial creation, be automated.
I'm wondering how other folks handle their production environment and metadata requirements. In our Oracle shop, which I'm responsible for, nothing goes into production without an ER Diagram, appropriately sized and tuned objects, and comments on the objects to place into Oracle's data dictionary. This has done well for us. How do other sites handle this type of thing when multiple DBMSs are involved? I always seem to have such a culture difference with the DB2 side of our house, and wonder if it's me or 'them'. Their methods, which they tell me are typical of DB2 sites, seem so illogical and time-consuming, not to mention costly.
Any insights from experienced folks would be appreciated.
Sherrie Kubis
Southwest Florida Water Management District
2379 Broad Street
Brooksville, FL 34604
352.796.7211 Ext 4033
Fax: 352-754-6776
sherrie.kubis_at_swfwmd.state.fl.us
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Sherrie.Kubis_at_swfwmd.state.fl.us
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sat Jan 20 2001 - 21:13:39 CST
 |
 |