Re: Possible bridges between OO programming proponents and relational model



Cimode wrote:

I noticed a recurring commercial argumentation about creating
*behavior* into components (named classes). This caracteristics is
often presented as being a differentiation of relational model where no

such thing really exists (and in fact is not necessary). In a word, In

OO approach (for whatever it may rely on), one of the main limitation
of relational model would be not to allow its elementary components to
emulate elementary predefined processes (transformations for instance).


You don't have to worry all that much about what the relational model allows
or doesn't allow. As anybody here can tell you, there are no pure
relational databases in the Real World.

What we have is quasi-relational table-based systems that in fact can handle
processes very well.

The problem is in how you think about the process, especially
transformations. All transformations and processes can be mapped into
simple precise definitions of what values should be written to what columns
of what tables. In other words, processes resolve to database
specifications. If you can specify it, you can code it.

When trying to specify processes in terms of tables, the relational concepts
of unique key and foreign key come in very handy for specifying how data
should be moved from place to place as it is transformed. Adding basic
formulas finishes it off.

So sure, the RM can't do it, but who cares? Table-centric systems can.

--
Kenneth Downs
Secure Data Software, Inc.
(Ken)nneth@(Sec)ure(Dat)a(.com)
.



Relevant Pages

  • Re: Why all the max length constraints?
    ... that one need not specify max length constraints if implementing only ... the relational model is orthogonal to type. ... language Euler, which was invented by Niklaus Wirth, and consider the ...
    (comp.databases.theory)
  • Re: formal (theoretical) treatment of database indices
    ... theories of types can be combined with the relational model to allow formal studies of both individually, ... *not* to influence the interface. ... we could develop algorithms which could automatically map the data model on to physical storage. ... just being able to manually specify this sort of thing. ...
    (comp.databases.theory)
  • Re: Update Where non-unique key.
    ... operate on individual records with an Update or Delete. ... I was referring to the relational model as defined by Dr. E. F. Codd. ... like most relational database vendors provides some ... There is a daily table where a unique key is preferable but not ...
    (borland.public.delphi.database.ado)