Database history l.jpg
This presentation is the property of its rightful owner.
Sponsored Links
1 / 17

Database History PowerPoint PPT Presentation


  • 217 Views
  • Updated On :
  • Presentation posted in: Pets / Animals

Database History. 1960s Legacy Systems: Hierarchical and Network DBMS 1970s Relational DBMS 1980s Non conventional DBMS. Non conventional DBMS (OO, Object Relational, Deductive, etc.) .

Download Presentation

Database History

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


Database history l.jpg

Database History

  • 1960s Legacy Systems: Hierarchical and Network DBMS

  • 1970s Relational DBMS

  • 1980s Non conventional DBMS


Non conventional dbms oo object relational deductive etc l.jpg

Non conventional DBMS(OO, Object Relational, Deductive, etc.)

Relational Database works well to store just text and numbers as long as there are not many multi-valued attributes.


Advantages of ordbms oodbms l.jpg

Advantages of ORDBMS,OODBMS

  • Multi-valued attributes,

  • Super/Sub-types: inheritance

  • Interfaces well with OOPL

  • Multi-media


Dbms oo l.jpg

Serve many applications

Integrity constraints

Concurrency

Security

Views

Easy query language

Permanent Objects

Classes and Objects

Properties and Methods

Events and Messages

Inheritance

Encapsulation

Multiple Inheritance and Polymorphism

DBMS + OO


Characteristics of oodbms l.jpg

Characteristics of OODBMS

  • Not as standard as Relational DBMS

  • Object ID (system unique, immutable, not visible by end-user)

  • Versions

  • Many different types of records as opposed to Relational DBMS (many instances of few different types of records)

  • Spatial Component


Common oo applications l.jpg

Common OO Applications

  • Computer-aided design (CAD)

  • Computer-aided manufacturing (CAM)

  • Geographic information systems (GIS)

  • Office Automation

  • Computer-aided publishing

  • Multimedia databases


Non conventional dbms l.jpg

Non Conventional DBMS

  • Object Relational (Extend the Relational Model)

  • Construct an OODBMS from scratch

  • Knowledge Base Management Systems (OODBMS).


Object relational l.jpg

Object Relational

  • Examples:

    Informix Universal Server (many OO features)

    Oracle(limited)

    MS-Access (very limited, picture field)


Informix universal server history l.jpg

Informix Universal Server-History

  • INGRES (Relational DBMS – UC Berkeley)

  • POSTGRES (OO features added to INGRES at UC Berkeley)

  • Montage -> Miro -> Ilustra

  • Ilustra + Informix (relational DBMS that dominated market in 80s with Sybase & Oracle).


Datatypes in informix us l.jpg

Datatypes in Informix US

  • Two dimensional data type (line circle, polygon, path)

  • Image data types: supports TIFF, GIF, JPEG, photoCD, GROUP 4 and Fax.

  • Time series data type

  • Opaque, Distinct, Row type and Collection Type


Oracle l.jpg

Oracle

  • Multivalued attributes using VARRAY

  • Object type

  • BLOB (Binary large object), CLOB (Characters), BFILE (Binary File), NCLOG (Intern. Characters)

  • 9i: Inheritance


Oodbms references products l.jpg

OODBMS references (products)

  • O2 http://o2tech.com

  • Gemstone http://www.gemstone.com

  • Objectstore http://www.odi.com

  • ITASCAhttp://www.iprolink.ch/ibex.com


Ordbms examples l.jpg

ORDBMS examples

  • Points, Lines and Circles

  • ASU: University DB Example


Knowledge base deductive db l.jpg

Knowledge Base/Deductive DB

  • Expert System + Database Technology

  • Stores rules instead of data

  • Basically Prototypes available at Universities and Research Institutions


Examples of knowledge base dbms l.jpg

Examples of Knowledge BaseDBMS

Datalog (combines PROLOG + Database technology).

http://goanna.cs.rmit.edu.au/~zahirt/Teaching/subj-datalog.html

XSB

http://www.cs.sunysb.edu/~kostis/Papers/xsb_ddb.html


Gis life expectancy l.jpg

GIS Life Expectancy


Gis population l.jpg

GIS Population


  • Login