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 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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org