RE: Oracle 11i Data Model

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Thu, 2 Aug 2007 07:27:06 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB3097A87EB@x6009a.umb.corp.umb.com>

If the constraints are actually created, you can always look at dba_constraints and dba_cons_columns. Otherwise, data dictionary development is left as an exercise for the developer.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Suresh Chaganti Sent: Wednesday, August 01, 2007 4:40 PM To: oracle-l_at_freelists.org
Subject: Oracle 11i Data Model

After attending Siebel training some time back, this question came up.

In siebel, they have tools in which all the realtions between tables including referential integrity is documented and queried. I understand this is pretty much same is peoplesoft as well.

Oracle 11i model doesn have PK/FK defined for majority of the tables. For example, PO_header_id in po_vendors_all is NOT a primary key, but a check constraint with not null condition. Also there is no PK/FK between po_headers_all and po_lines_all, as defined at the DB level.

For Oracle, I know there are TRMs and I use them a lot. But to my knowledge, there is no "data dictionary" about application tables that would help use derive realtions by querying with in the application.

Is there an approach / method to derive relationships instead of looking at ERDs in TRMs? I guess I am asking is there something equivalent to what Siebel/peoplesoft provide in this area

Thanks in advance

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 02 2007 - 07:27:06 CDT