This topic is a spin off from Marshall's comment that he would like a
language with <OR> built into it, but he shies away from <NOT>.  It's far
enough off topic so that I wanted to start a new topic.
Some of you may be familiar with the idea that it's possible to generate all

A topic that I havnt seen addressed adequately is how to model concepts such
as subclasses and categories (according to the Elmasri 1985 terminology)
from an EER model to the physical model of a database. The guidelines
available (even from highly recommended books) are useful ...

It does not seem to exists any standard for how to define SQL
statements in a object oriented API. Currently different products have
completely different syntax. Until such standard exists, people can
always argue that it safer to type SQL statements directly as strings

Hi Gang,
I'm looking for some advice.
I have a table called Estimate that contains information about an estimate
given.

In Access Options, this can be set. I wonder if there are any good reasons
why someone should not use the latest ANSI standard of 92, considering they
develop a brand new database where no old SQL code exists.
Konstantinos

On two of the contracts I worked,  one of the things I was called upon to
work with was a pair of databases that had diverged, because different DDL
had been applied to the two.
I approached the first one by moderating a series of meetings between the

Last week I mentioned that I believed unique and referential constraints are
not used to their full potential, and that they could be used instead of
some of the constraints we see today.  Several kind souls argued the other
side of this and helped me to solidify my thoughts.  ...

Hi Gang,
Let's say you have a database that stores entries (example only) for
construction materials.
You have a table with all your materials and any dependencies.

Good morning,
Can anyone describe me the theory of Decision Trees algorithm which is used
MS SQL 2000  Analysis Services ?
Thanks,

Recently archeologists have uncovered a document which they believe is a
previously undiscovered Platonic dialogue.  Such a discovery would be a
priceless boon to modern philosophy, if true, but some computer scientists
believe it may also have applications to that field as well.  ...

What follows in more skunk works.  You have been warned!
On two of the contracts I worked,  one of the things I was called upon to
work with was a pair of databases that had diverged, because different DDL
had been applied to the two.

Here is something I do not see discussed often, or else I have missed it.
Is there much interest in discussing the upgrade operation on an RDB?
Compare an upgrade to everyday use.  In everyday production use, a database
is going through a series of serializable changes to state, ...

In one of the other discussions,  XML was listed as one of the bad things
perpetrated by the object oriented people.  And I've seen a lot of
discussion in here about using XML instead of a DBMS.
I've never had the opportunity to get up close and personal with XML.  I

I must be reading all day on the issue and I am more confused then when I
started.
I started my db's with natural keys as I initially was exposed to the theory
of relational db's and wasn't just assigned the task of building something

What do you think about this?
http://www.dbdebunk.com/page/page/1396086.htm
I can't agree more with this:
---