Re: domain questionnaire
From: David Cressey <david_at_dcressey.com>
Date: Sun, 25 Feb 2001 17:13:02 GMT
Message-ID: <y2bm6.35945$2X4.121996_at_petpeeve.ziplink.net>
Date: Sun, 25 Feb 2001 17:13:02 GMT
Message-ID: <y2bm6.35945$2X4.121996_at_petpeeve.ziplink.net>
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.comReceived on Sun Feb 25 2001 - 18:13:02 CET