Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Implementation of boolean types.

Re: Implementation of boolean types.

From: Marshall Spight <marshall.spight_at_gmail.com>
Date: 19 Jul 2005 13:44:48 -0700
Message-ID: <1121805888.450787.157620@f14g2000cwb.googlegroups.com>


dawn wrote:
> Marshall Spight wrote:
>
> Yup! I've worked with tools that have a null value (yes "value") that
> models the null set and I've worked with SQL and it is so much easier
> and more intuitive to work with a 2VL and null value = empty set model.
> Design, development, trouble-shooting, and maintenance are all
> significantly easier with this model.
>
> This is one of several features where those attempting to implement
> relational theory took what was working in databases in the 70's (such
> as 2VL) and mucked it up, contributing to greater cost of ownership for
> data-centric applications.

Hmmm. I detect that perhaps you are trying to identify this issue as being somehow a consequence of RM? If so I would not agree; the issues are independent.

> Taking just this one issue, I suspect the
> path to getting the industry from here to there is via XML/XQuery,
> perhaps? However, I did read that SQLServer has an option of switching
> from 3VL to 2VL.

I don't think I'd agree with this either. SQL needs to be replaced, not fixed, and the XML-family of technologies are fundamentally flawed. I don't think any "data management" system that doesn't have a type system or a schema in version one is going to go anywhere. You can't retrofit these things; they have to be designed in from the start. (Yes, I know XML now has various ways to specify schema, with at least DTD and XMLSchema. [Does anyone anywhere think they are good?] Reminds me of the old saw about a man with two watches.)

Anyway, XML doesn't address data management; it's a document management system.

Marshall Received on Tue Jul 19 2005 - 15:44:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US