Re: S.O.D.A. database Query API - call for comments

Tobias Brox wrote:
>
>
> I think it should be possible to make an object oriented database by
> building "object-orientedness" at the top of an RDBMS. And I think it
> should be possible to make it just as good as building a truely object
> oriented database from scratch. But I'm not going to prove that - at
> least not right now ;-)
>
> There are powers both within the relational model and the object model,
> and as far as I see, they don't contradict each other that much. One
> class (without inheritance) is a table, one object (without inheritance)
> is a row in the table. Inheritance is just a special case of a link
> between two objects - one object without inheritance, and another object
> just containing what's added in the child-class.
>
> Methods should be stored in the database somehow, and should replace the
> old triggers and stored procedures.

Storing a table row as an object messes up the query language. How about storing objects as column values in table rows. Then you can keep a declarative query language and be able to call methods on columns. Our ORDBMS (in beta) does this - http://www.firstsql.com/firstsqlj/

-- 
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
===================================================================
* Check out Database Debunkings (http://www.firstsql.com/dbdebunk/)
* "The Forum Where Database Matters Are Set Straight"