Database history
Download
1 / 17

Database History - PowerPoint PPT Presentation


  • 245 Views
  • Updated On :

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

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 'Database History' - Anita


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

  • ITASCA http://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




ad