What is the format of the data dictionary?

Question

Are there standard examples / samples of data dictionaries that document the database.

Answer 1

The official standard is ISO / IEC 11179 ..., which will make your head sore and refers to the semantic elements of documented data, when we usually need both semantic and physical (tables, fields, etc.) documentation in the real-world data dictionary .

Personally, I prefer (how you implement it, it depends on you) the physical and optionally logical Entity-Relationship models on the first page, input screen, or wherever the user of the data dictionary first “hits” (this provides a meta layer for details below).

:

[ | ]

(, , '' (  , , , ),  )

:

     

     

     

     

[] ... nullable, ,

. | "" | |   .

|   | ..

... , " " ! , ( ER), , .

Answer 2

, .

Oracle , DBA_*. , DBA_TABLES, DBA_TAB_COLUMNS .. SELECT TABLE_NAME FROM ALL_TABLES WHERE TABLE_NAME LIKE 'DBA%', .

, , USER_TABLES, USER_VIEWS, USER_TAB_COLS ..