
Query Language and Database Design
- ANSI/ISO standards compliance
        - SQL standard supplied (e.g. SQL-89, SQL-92 entry level, any SQL3 support, etc.)
        - SQL-92 catalog schema views
        - ANSI isolation levels supported
- left, right and full outer joins
- declarative referential integrity
        - declarative cascade delete
        - declarative cascade update
- ability to modify existing designs
        - rename table
        - modify data type of existing column
        - add/drop column in existing table
        - add/drop constraint in existing table   
- more than one unique constraint per table
- object-oriented design support (abstract types, inheritance)
- object references (REFs)
- computed columns  
- can build an index on a computed column
- computed tables


Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 


Mon, 31 Jan 2000 17:38:56 -0400 (AST)
The Hermit Hacker <scrappy@hub.org>
PCLabs Survey, Part VI: Query Language and Database Design