Re: [xml-dev] XML vs relational database

From
Anthony B. Coates (XML-Dev) <>
To
Date
2007-08-16T13:10:51Z
ID
<>
Thread
Re: [xml-dev] XML vs relational database
The so-called "rule 0" of relational databases *is* that all information  
has to be available in relational form, i.e. in queriable form.

http://en.wikipedia.org/wiki/Codd's_12_rules

Cheers, Tony.

On Thu, 16 Aug 2007 13:19:25 +0100, Michael Kay <> wrote:

>> In a relational database, a standard query
>> allows to retreive data, but does not allow to investigate
>> the design of the database
>
> Not true. The SQL standard defines a standard set of tables that hold
> metadata, ie. information about tables and columns. At any rate, it did  
> so
> about 20 years ago which was the last time I looked.
>
> Michael Kay
> http://www.saxonica.com/

-- 
Anthony B. Coates
Senior Partner
Miley Watts LLP
Experts In Data
UK: +44 (20) 8816 7700, US: +1 (239) 344 7700
Mobile/Cell: +44 (79) 0543 9026
Data standards participant: genericode, ISO 20022 (ISO 15022 XML),  
UN/CEFACT, MDDL, FpML, UBL.
http://www.mileywatts.com/