database history l.
Skip this Video
Download Presentation
Database History

Loading in 2 Seconds...

play fullscreen
1 / 17

Database History - PowerPoint PPT Presentation

  • Uploaded 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.) .

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

PowerPoint Slideshow about 'Database History' - Anita

Download Now 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
Database History
  • 1960s Legacy Systems: Hierarchical and Network DBMS
  • 1970s Relational DBMS
  • 1980s Non conventional DBMS
non conventional dbms oo object relational deductive etc
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
Advantages of ORDBMS,OODBMS
  • Multi-valued attributes,
  • Super/Sub-types: inheritance
  • Interfaces well with OOPL
  • Multi-media
dbms oo
Serve many applications

Integrity constraints




Easy query language

Permanent Objects

Classes and Objects

Properties and Methods

Events and Messages



Multiple Inheritance and Polymorphism

characteristics of oodbms
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
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
Non Conventional DBMS
  • Object Relational (Extend the Relational Model)
  • Construct an OODBMS from scratch
  • Knowledge Base Management Systems (OODBMS).
object relational
Object Relational
  • Examples:

Informix Universal Server (many OO features)

Oracle (limited)

MS-Access (very limited, picture field)

informix universal server history
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
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
  • Multivalued attributes using VARRAY
  • Object type
  • BLOB (Binary large object), CLOB (Characters), BFILE (Binary File), NCLOG (Intern. Characters)
  • 9i: Inheritance
oodbms references products
OODBMS references (products)
  • O2
  • Gemstone
  • Objectstore
ordbms examples
ORDBMS examples
  • Points, Lines and Circles
  • ASU: University DB Example
knowledge base deductive db
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
Examples of Knowledge BaseDBMS

Datalog (combines PROLOG + Database technology).