object relational database comparison n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Object Relational Database Comparison PowerPoint Presentation
Download Presentation
Object Relational Database Comparison

Loading in 2 Seconds...

play fullscreen
1 / 15

Object Relational Database Comparison - PowerPoint PPT Presentation


  • 116 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Object Relational Database Comparison' - jatin


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
object relational database comparison

Object Relational Database Comparison

by Neil Black, Steven Bruce & Marisa Di Filippo

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

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
relational databases cont

DEPARTMENT

DEPT

DESCRIPTION

LOCATION

1

Marketing

Glasgow

2

Payroll

Edinburgh

3

Public Relations

Glasgow

Relational Databases …cont
object orientation
Object-Orientation
  • An OOD supports the following
    • Abstraction
    • Encapsulation
    • Classes & Instances
    • Inheritance
    • Messages & Methods
    • Polymorphism
oodb features
OODB Features
  • Object Identity
  • Locking
  • Object Access
  • Dynamic Space Compaction
  • Navigation
object relational database
Object-Relational Database
  • Amalgamation of RDBMS & ODBMS
  • Adds limited Object-Oriented functions
  • Data still stored in tables
  • Supports new types of data (multimedia)
comparison of dbms
Comparison of DBMS
  • Defining standards:

RDBMS - SQL2(ANSI X3H2)

ODBMS - ODMG-v2.0

ORDBMS - SQL-3

slide11
Support for object-oriented programming:

RDBMS - Poor

ODBMS - Direct & extensive

ORDBMS - Limited mostly to new data types

slide12
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

slide13

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

slide14

Product Maturity:

RDBMS - Very mature. Well established.

ODBMS – Relatively mature.

ORDBMS – Immature; extensions are new, still being defined & are relatively unproven.

summary
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