| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Relational vs. PICK/Object DBMS
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)
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
![]() |
![]() |