PCLabs Survey, Part VI: Query Language and Database Design

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
columnin 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