Logical data model data types generated from the OWL-to-logical transformation

The OWL-to-logical data model transformation process generates logical data model data types from OWL data types.
The following table shows the correspondence between OWL data types and logical data model data types:
Table 1. OWL to logical data model data type mappings
OWL data types Generated logical data model data types
owl:rational Not applicable
owl:real Not applicable
rdfs:Literal
  • CHAR
  • VARCHAR
  • CLOB
rdf:XMLLiteral XML
xsd:anyURI VARCHAR(32672)
xsd:base64Binary
  • BINARY
  • VARBINARY
  • BLOB
xsd:boolean BOOLEAN
xsd:byte SHORT
xsd:date DATE
xsd:dateTime TIMESTAMP
xsd:dateTimeStamp TIMESTAMP
xsd:decimal DECIMAL
xsd:double DOUBLE
xsd:duration INTERVAL
xsd:float FLOAT
xsd:gDay TIME
xsd:gMonth TIME
xsd:gMonthDay TIME
xsd:gYear TIME
xsd:gYearMonth TIME
xsd:hexBinary
  • BINARY
  • VARBINARY
  • BLOB
xsd:int INTEGER
xsd:integer INTEGER
xsd:language VARCHAR(32762)
xsd:long LONG
xsd:Name VARCHAR(32762)
xsd:NCName VARCHAR(32762)
xsd:negativeInteger INTEGER
xsd:NMTOKEN VARCHAR(32762)
xsd:nonNegativeInteger INTEGER
xsd:nonPositiveInteger INTEGER
xsd:normalizedString
  • CHAR
  • VARCHAR
  • CLOB
xsd:positiveInteger INTEGER
xsd:short SHORT
xsd:string
  • CHAR
  • VARCHAR
  • CLOB
xsd:time TIME
xsd:token VARCHAR(32762)
xsd:unsignedByte SHORT
xsd:unsignedInt INTEGER
xsd:unsignedLong LONG
xsd:unsignedShort SHORT

Feedback