Complex Types Systems


complex data type is usually a composite of other existing data types.

Complex data types are those that include record type and collections which are used to handle data in record format or in an array format.

Complex type systems and object orientation enable E-R model concepts, like generalization, identity of entities, multivalued attributes and S specialization, which are represented directly with simple attributes to the relational model. No complex translation will required for this task.

The features allow composite attributes and multivalued attributes of E-R diagrams to be represented directly.

Type definitions in programming languages, are not stored in a database, and can be seen only by programs that include a text file containing the definitions.

Complex type systems usually support other collection types, such as arrays and multisets.