Re: domain questionnaire

Jan,

The question about Codd's requirement that meta data be stored in the same kind of structures as data makes me think of a lower level issue:

I've seen this done in two ways.

The first is to have multiple schemas in a database. One of the schemas is
"SYSTEM", or some such name, and the meta data is stored in there, for all
the schemas (including itself).

The second is to have a collection of tables with reserved names, such as
"RDB$RELATIONS" in every schema.

My preference is for the first of these two choices. But what are the pros and cons of each of the two choices?

--
Regards,
    David Cressey
    www.dcressey.com