1 / 20

OODBMS & ORDBMS

OODBMS & ORDBMS. Dr. Mario Guimaraes. Class Will Start Momentarily…. Database History. 1960s Legacy Systems: Hierarchical and Network DBMS 1970s Relational DBMS 1980s Non conventional DBMS. Limitations of RDBMS.

josephine-taylor
Download Presentation

OODBMS & ORDBMS

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. OODBMS & ORDBMS Dr. Mario Guimaraes • Class • Will • Start • Momentarily…

  2. Database History • 1960s Legacy Systems: Hierarchical and Network DBMS • 1970s Relational DBMS • 1980s Non conventional DBMS

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

  4. Advantages of ORDBMS,OODBMS • Multi-valued attributes, • Super/Sub-types: inheritance • Interfaces well with OOPL • Multi-media

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

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

  7. Common OO Applications • Computer-aided design (CAD) • Computer-aided manufacturing (CAM) • Geographic information systems (GIS) • Office Automation • Computer-aided publishing • Multimedia databases

  8. Non Conventional DBMS • Object Relational (Extend the Relational Model) • Construct an OODBMS from scratch • Knowledge Base Management Systems (OODBMS).

  9. Object Relational • Examples: Informix Universal Server (many OO features) Oracle (limited) MS-Access (very limited, picture field)

  10. 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) • IBM bought Informix

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

  12. POSTGRES: Open source • DBMS is free and can modify source code • Take over MySQL as the # 1 open source DBMS ?

  13. Oracle • Multivalued attributes using VARRAY • Object type • BLOB (Binary large object), CLOB (Characters), BFILE (Binary File), NCLOG (Intern. Characters) • 9i: Inheritance

  14. OODBMS references (products) • O2 http://o2tech.com • Gemstone http://www.gemstone.com • Objectstore http://www.odi.com • ITASCA http://www.iprolink.ch/ibex.com

  15. ORDBMS examples • Points, Lines and Circles • ASU: University DB Example

  16. Knowledge Base/Deductive DB • Expert System + Database Technology • Stores rules instead of data • Basically Prototypes available at Universities and Research Institutions

  17. Examples of Knowledge Base DBMS 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

  18. GIS Life Expectancy

  19. GIS Population

  20. End of Lecture End Of Today’s Lecture.

More Related