[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: XML vs relational database

• From: "Anthony B. Coates (XML-Dev)" <abcoatesecure-xmldev@y...>
• To: xml-dev@l...
• Date: Thu, 16 Aug 2007 14:10:51 +0100

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 <mike@s...> 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/

• References:
  • XML vs relational database
    • From: Sylvain LOISEAU <sylvain.loiseau@w...>
  • RE: XML vs relational database
    • From: "Michael Kay" <mike@s...>