HOPEX Database Builder (Web) : MEGA Database Builder : Attribute and Column Types
   
Attribute and Column Types
 
Attribute Datatypes
Datatype Packages
Creating a New Datatype Package
Referencing Datatype Packages
Assigning Types to Attributes
Determining Column Datatypes from Attribute Types
Pivot Types
Connecting a Datatype to a Pivot Type
Connecting a Datatype to a Pivot Type in UML Notation
Mappings Between Pivot Types and Datatypes
Example of correspondence between pivot types and Oracle 8 datatypes
Creating New Datatypes
Creating Datatypes - Example for Oracle 10
Creating Datatypes - Example for SQL Server 7
Not all data has the same value type. Datatype determination enables indication of format and therefore facilitates handling by the different data processing tools.
HOPEXmanages datatypes at different modeling levels, assuring correspondence of datatypes at the logical level with datatypes handled by the different supported DBMSs.