Re: Datasets vs. OOP

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Alfredo (alfredo_at_nospam.es)
Date: 05/10/04 

Date: Mon, 10 May 2004 14:25:08 GMT

On Mon, 10 May 2004 06:16:37 -0700, "Frans Bouma [C# MVP]"
<perseus.usenetNOSPAM@xs4all.nl> wrote:

> Agreed. The relational model is 'weak' when you look at it from an OO POV:

Striking statement!

The Relational Model is the direct application of thousands of years
of accumulated knowledge in math and logic. It is the direct
application of Predicate Logic and Set Theory. Disciplines developed
by people like Aristotle, Boole, Cantor, Frege, Godel, Rusell, etc.
The Relational Model is a very solid mathematical framework.

Compare this with OO which has as many different interpretations as
practicioners.

>you can't model inheritance for example without check constraints or even
>values in tables.

I am afraid that what you mean is not inheritance at all.

> I wrote something about this a year ago or so, and realized
>later that I was wrong: the relational model isn't weak because of that, it's
>just 'different'.

Indeed. The Relational Model is a data management approach. OO is a
set of coding guidelines. It is like to mix apples with oranges or
bacon with velocity as we say here :-)

Regards
  Alfredo

Relevant Pages

  • Re: Just one more anecdote
    ... >>Just on the off chance that perhaps someday you will want to do an ... > is that the RM is based on set theory. ... predicates) corrrespond nicely with things in the relational model. ...
    (comp.databases.theory)
  • Re: Future of Programming?
    ... > The Relational Model as the direct application of Set Theory and ... CLAIRE uses static type checking and dynamic type checking. ... CLAIRE programming features Sets, Relations, and Rules. ...
    (comp.object)
  • Re: Why use relational tables in OO (please just take a look inside)
    ... > Relational theory is merely an extension of set theory. ... > theory is incompatible with OO, then OO is obviously worthless. ... It is the query-based construction view of the relational model that is ...
    (comp.object)
  • Re: Datasets vs. OOP
    ... of accumulated knowledge in math and logic. ... application of Predicate Logic and Set Theory. ... The Relational Model is a very solid mathematical framework. ...
    (microsoft.public.dotnet.general)