Re: Help - Design metadata layer for dynamic joins

"AK" <aknntp_at_yahoo.com> wrote in message news:f54c6679.0411040917.6a150b76_at_posting.google.com...
| > | Are there any standard design patterns for designing and building such
| > | a metadata layer?
| > |
| > | Any examples, tips or reference articles would be appreciated.
| >
| >
| > take a closer look at oracle's data dictionary, all the information you
need
| > should be there
| >
|
| do you mean - directly use the data dictionary tables or somehow base
| the design i need on what is in there?
|
| i am not that familiar with the data dictionary (will start looking at
| it though). meanwhile, if you can elaborate a bit on how to go about
| using the data dictionary tables to achieve what i need, i'd
| appreciate it.
|
| thanks.
|
| - ak

as you investigate the DD, you'll find that it documents all PK and FK constraints, so as long as the database designers declared PK and FK constraints, all the metadata you need is already available

look at DBA_CONSTRAINTS (or ALL_CONSTRAINTS) and DBA_CONS_COLUMNS (or ALL_CONS_COLUMNS) ++ mcs Received on Thu Nov 04 2004 - 11:20:38 CST