Complex Types and SQL Extensions introduced in SQL:1999 to support complex types: Collection and large object types Nested relations are an example of collection types Structured types Nested record structures like composite attributes Inheritance Object orientation Including object identifiers and references Not fully implemented in any database system currently But some features are present in each of the major commercial database systems Read the manual of your database system to see what it supports Database System Concepts-6th Edition 22.7 @Silberschatz,Korth and SudarshanDatabase System Concepts - 6 22.7 ©Silberschatz, Korth and Sudarshan th Edition Complex Types and SQL Extensions introduced in SQL:1999 to support complex types: Collection and large object types  Nested relations are an example of collection types Structured types  Nested record structures like composite attributes Inheritance Object orientation  Including object identifiers and references Not fully implemented in any database system currently But some features are present in each of the major commercial database systems  Read the manual of your database system to see what it supports