http://www.gnova.com/cup/cup2005/

Using OEChem to Extend PostgreSQL

• Introduction
  • RDBMS
    • Uses multiple tables or relations instead of one or more spreadsheets.
    • Enforces, or at least allows enforcement of keys, unique and foreign.
    • Typically has features: indexes, speed-cost analysis, sorting.
  • PostgreSQL
    • Grew out of Berkeley's original Ingres QUEL.
    • Comparable, not identical to Oracle, Microsoft Access, Sybase SQL server, Microsoft SQL server, My SQL.
    • Free, open source, user/developer community, Linux, Windows, support options.
  • Extensibility
    • SQL based, allows user-written functions to extend fucntionality.
    • SQL extensions vs. interfaces; new data types.
    • Oracle extension cartridges. Many chemical cartridge examples.