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

Home -> Community -> Usenet -> comp.databases.theory -> Relational vs. PICK/Object DBMS

Relational vs. PICK/Object DBMS

From: x <x-false_at_yahoo.com>
Date: Tue, 20 Apr 2004 19:17:24 +0300
Message-ID: <40854c6a$1@post.usenet.com>

Periodical discussions about the relational model/DBMS versus PICK or object model/DBMS take place in this newsgroup. I have some training in the relational model, but none in object/PICK like DBMS.
I would like to know which model/DBMS perform better (in terms of programmers productivity, system requirements, etc.) on the following problems (stated in terms of relational model) :

1)Been given the domains {A,A1,A2,...,An}, with large n and the following database schema:

answer the questions:
a) for {i1,i2,...,ip} given , find R(A,Ai1,Ai2,...,Aip) with the constraints R(A,Aik) = Rik(A,Aik) for all k in 1..p, R is minimal. b) for a in A given, find R(A,Ai1,Ai2,...,Aip) with the constraints:

Note:
a) No NULLs are allowed
b) R(X1,X2,...,Xp) is the projection of R on the attributes (X1,...,Xp)

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Received on Tue Apr 20 2004 - 11:17:24 CDT

Original text of this message

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