1 / 15

Object Relational Database Comparison

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.

jatin
Download Presentation

Object Relational Database Comparison

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Object Relational Database Comparison by Neil Black, Steven Bruce & Marisa Di Filippo

  2. Introduction • Brief introduction to the 3 main databases: • RDBMS • ODBMS • ORDBMS • Compare the above systems • Summary

  3. EMPLOYEE EMP_ID FIRST_NAME LAST_NAME DEPT SALARY 1 Neil Black 1 750000 2 Marisa DI Filippo 1 100 78 Steven Bruce 2 35789 79 Hannah Bains 3 10 200 Gordon Russell 3 1 Relational Databases

  4. DEPARTMENT DEPT DESCRIPTION LOCATION 1 Marketing Glasgow 2 Payroll Edinburgh 3 Public Relations Glasgow Relational Databases …cont

  5. Object-Orientation • An OOD supports the following • Abstraction • Encapsulation • Classes & Instances • Inheritance • Messages & Methods • Polymorphism

  6. OODB Features • Object Identity • Locking • Object Access • Dynamic Space Compaction • Navigation

  7. Object-Relational Database • Amalgamation of RDBMS & ODBMS • Adds limited Object-Oriented functions • Data still stored in tables • Supports new types of data (multimedia)

  8. Comparison of DBMS • Defining standards: RDBMS - SQL2(ANSI X3H2) ODBMS - ODMG-v2.0 ORDBMS - SQL-3

  9. Support for object-oriented programming: RDBMS - Poor ODBMS - Direct & extensive ORDBMS - Limited mostly to new data types

  10. Simplicity of use: 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

  11. Simplicity of development: 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

  12. Product Maturity: RDBMS - Very mature. Well established. ODBMS – Relatively mature. ORDBMS – Immature; extensions are new, still being defined & are relatively unproven.

  13. Summary • Overall Relational Database are by far the most popular. • ODB used particularly in scientific fields to handle small amounts of complex data • ORDB now used for audio, image & video

More Related