2 Replies Latest reply on Oct 15, 2015 5:54 PM by jperson

    Newbie with Questions? (domain vs logical vs structured) datatypes


      Just a couple of questions.

      1) What is a good definition of a domain? (I searched for one and could not find a clear definition)

      2) I believe logical are just your normal datatypes? (normal as define data) Please correct if I am wrong

      3) On the Entity Properties Screen:

          Under General Attributes:

                Under Attributes Properties:

                There are there three datatypes:

                1. Domain

                2. Logical

                3. Structured

      4) What is the difference between them and when should I use them ?

      Thank You

        • 1. Re: Newbie with Questions? (domain vs logical vs structured) datatypes
          Philip Stoyanov-Oracle


          short explanation:

          1) logical types - abstraction layer hiding native database types; you can create your own types if you don't like what is distributed with DM. Two mapping definitions are used by the product: - Logical type to native type (used in DDL generation) and native type to logical type (used in import for certain database). User defined native types can be created - for DB versions not supported in DM.

          2) Distinct type - another abstraction - such types exist in DB2 - kind of introduction of semantic on native database types (on logical types in DM). Doesn't restrict values in native type

          Instead of using database native type Numeric  you can have 2 new types Speed and Weight and use them for columns with related semantic

          3) Domain  - kind of semantic as in distinct types and also restricts possible values, so you are using logical type in domain definition and can define some constraints expressed as list of values, range of values or check constraint

          4) Structured type - introduced in SQL99 - covers object relational features, some of them implemented in Oracle and DB2/UDB for LUW.

          DM also uses them to represent definitions imported from Hive - Import from Hive and Oracle 12c External tables

          5) collection types - as the name imply they are collection of types - VARRAY, nested tables

          If you import OE sample schema then you'll get some examples of structured and collection types.