Complex Data Types(Object Oriented Databases)

Question1) What is the need for Complex Data Types

Answer1) While dealing with object oriented databases need of complex data types are very important.

To understand complex data types, we consider an example in which address is a field in a table.

• Entire address could be viewed as an atomic data item of type string. However this view would hide details such as the street , city, state and postal code which may be useful in certain queries.
• But if we break address into the components, writing queries would become more complicated as we have to mention each field.

• So the better alternative is to form structured data types, which allow a type ADDRESS with sub parts street,city,state & postal code.

 For further query visit www.gurukpo.com