WHY POSTGRES?

• Past DBMS systems

  • Data management

• Needs of Other Applications

  • Object management
  • Knowledge management

• POSTGRES Provides it ALL (sort of in 1991)!

Notes:

• Data Management: fixed format records, traditional transaction management and query facilities.
  

• Object Management: Efficiently storing and manipulating non-traditional data types such as bitmaps, icons, text, polygons, etc.

• Problem area: CAD programs engineering applications

• Knowledge Management: The ability to store and enforce a collection of rules that are part of the semantics of an application.

• For integrity constraints and derivation of data that is not stored.

• EXAMPLE: Newspaper layout.

• Data Management: Billing info for subscription and advertisement

• Object Management: text, bitmaps, and icons(banners)

• Knowledge Management: Layout rules advertising and article placement.