Object Relational Database Comparison. by Neil Black, Steven Bruce & Marisa Di Filippo. Introduction. Brief introduction to the 3 main databases: RDBMS ODBMS ORDBMS Compare the above systems Summary. EMPLOYEE. EMP_ID. FIRST_NAME. LAST_NAME. DEPT. SALARY. 1. Neil. Black. 1.
by Neil Black, Steven Bruce & Marisa Di Filippo
RDBMS - SQL2(ANSI X3H2)
ODBMS - ODMG-v2.0
ORDBMS - SQL-3
RDBMS - Poor
ODBMS - Direct & extensive
ORDBMS - Limited mostly to new data types
RDBMS - Table structures easy to understand; many end-user tools available
ODBMS - Ok for programmers; some SQL access for end users
ORDBMS - Same as RDBMS, with some confusing extensions
RDBMS - Provides independence of data from app, good for simple relationships
ODBMS - Objects are a natural way to model; can accommodate various relationships
ORDBMS - Provides independence of data from app, good for simple relationships
RDBMS - Very mature. Well established.
ODBMS – Relatively mature.
ORDBMS – Immature; extensions are new, still being defined & are relatively unproven.