PPT Slide

Two Flavors of O-R Object Extensions

• Object extension #1: Abstract data types (ADTs)
  • New column types and functions
    • E.g.,text, image, audio, video, time series, point, line, OLE...
    • For modeling new kinds of facts about enterprise entities

• Object extension #2: Row types
  • Types and functions for rows of tables
    • Includes inheritance, references, set-valued attributes
    • For modeling business objects with relationships & behavior

• Impact on schemas and query language: SQL3
  • Schemas: tables at the top, OO richness within
  • Queries: extensions to support the added richness
  • Structured types: support both ADT and row type object modeling needs (unified type system)

Previous slide

Next slide

Back to first slide

View graphic version