database history
Download
Skip this Video
Download Presentation
Database History

Loading in 2 Seconds...

play fullscreen
1 / 17

Database History - PowerPoint PPT Presentation


  • 245 Views
  • 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.) .

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
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

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
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
oracle
Oracle
  • 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 http://o2tech.com
  • Gemstone http://www.gemstone.com
  • Objectstore http://www.odi.com
  • ITASCA http://www.iprolink.ch/ibex.com
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).

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

XSB

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

ad