Complex Types and SQL:1999 Extensions to SQL to support complex types include: 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 Our description is mainly based on the SQL:1999 standard 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-5th Edition,Aug 9,2005. 9.9 ©Silberschat乜，Korth and SudarshanDatabase System Concepts - 5 9.9 ©Silberschatz, Korth and Sudarshan th Edition, Aug 9, 2005. Complex Types and SQL:1999 Extensions to SQL to support complex types include: 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 Our description is mainly based on the SQL:1999 standard 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