Re: SQL1999-standard makes no reference to term "relational" - why?

From: Leandro Guimarães Faria Corsetti Dutra <lgcdutra_at_terra.com.br>
Date: Mon, 14 Oct 2002 11:50:01 +0200
Message-ID: <aoe409$krvnd$1_at_ID-148886.news.dfncis.de>


Lauri Pietarinen wrote:
> Could one take that to mean that one cannot make
> any statements of how "relational" a DBMS-product is
> by how well it conforms to the SQL-standard (or parts of it)?

        Yes, because SQL contradicts several relational model prescriptions and proscriptions.

> What does it mean to say that a DBMS-product is relational?

        That it conforms to the relational model... see Codd's 12 rules, which are obsolete but still useful, and Date's works.

        More specifically, it should be about relations, not tables; and about domains, not simple data types. But these are only some from several conflicting points.

-- 
  _
/ \ Leandro Guimarães Faria Corsetti Dutra        +41 (21) 216 15 93
\ / http://homepage.mac.com./leandrod/        fax +41 (21) 216 19 04
  X  http://tutoriald.sourceforge.net./      Orange Communications CH
/ \ Campanha fita ASCII, contra correio HTML      +41 (21) 644 23 01
Received on Mon Oct 14 2002 - 11:50:01 CEST

Original text of this message