|
|
| (85 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| == Introduction ==
| |
| === Previous Design/Implementation ===
| |
|
| |
|
| == Data model representation ==
| |
|
| |
| === Atomic (Simple) Types ===
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
|
| |
| ==Table Test 1 ==
| |
|
| |
|
| |
| {| border="1" cellspacing="0"
| |
| |+ [http://msdn.microsoft.com/en-us/library/ms187752.aspx Transact-SQL (Microsoft)]
| |
| !Type !! Range !! Storage Bytes !! DAP equiv.
| |
| |-
| |
| |bigint || || 8 bytes || none
| |
| |-
| |
| |int || || 4 bytes ||
| |
| |-
| |
| |numeric || || ||
| |
| |-
| |
| |decimal || || ||
| |
| |-
| |
| | bit || || ||
| |
| |-
| |
| |smallint || || 2 bytes ||
| |
| |-
| |
| |tinyint || || 1 bytes||
| |
| |-
| |
| | smallmoney || || ||
| |
| |-
| |
| | money || || ||
| |
| |-
| |
| | float || || 4 or 8 bytes ||
| |
| |-
| |
| | real || || 4 bytes ||
| |
| |-
| |
| | date || || ||
| |
| |-
| |
| | datetimeoffset || || ||
| |
| |-
| |
| | datetime2 || || ||
| |
| |-
| |
| | smalldatetime || || ||
| |
| |-
| |
| | datetime || || ||
| |
| |-
| |
| | time || || ||
| |
| |-
| |
| | char || || ||
| |
| |-
| |
| | varchar || || ||
| |
| |-
| |
| | next || || ||
| |
| |-
| |
| | nchar || || ||
| |
| |-
| |
| | nvarchar || || ||
| |
| |-
| |
| | ntext || || ||
| |
| |-
| |
| | binary || || ||
| |
| |-
| |
| | varbinary || || ||
| |
| |-
| |
| | image || || ||
| |
| |-
| |
| | cursor || || ||
| |
| |-
| |
| | timestamp || || ||
| |
| |-
| |
| | hierarchyid || || ||
| |
| |-
| |
| | uniquieidentifier || || ||
| |
| |-
| |
| | sql_variant || || ||
| |
| |-
| |
| | xml || || ||
| |
| |-
| |
| | table || || ||
| |
| |}
| |
|
| |
| == Table test 2 ==
| |
| {| border="1" cellspacing="0"
| |
| |+ PostgreSQL Data Types (from [http://www.faqs.org/docs/ppbook/x2632.htm Practical PostgreSQL])
| |
| !Catagory !! Data Type !! Description !! Standardization || Logical DAP data type association.
| |
| |-
| |
| | Boolean and binary types
| |
| |
| |
| {| border="1" cellspacing="0"
| |
| | boolean, bool
| |
| |-
| |
| | bit(n)
| |
| |-
| |
| | bit varying(n), varbit(n)
| |
| |}
| |
| |
| |
| {| border="1" cellspacing="0"
| |
| |-
| |
| | A single true or false value.
| |
| |-
| |
| | An n -length bit string (exactly n binary bits).
| |
| |-
| |
| | A variable n -length bit string (up to n binary bits)
| |
| |}
| |
| |
| |
| {| border="1" cellspacing="0"
| |
| |-
| |
| | SQL99
| |
| |-
| |
| | SQL92
| |
| |-
| |
| | SQL92
| |
| |}
| |
| |
| |
| {| border="1" cellspacing="0"
| |
| |-
| |
| | Boolean
| |
| |-
| |
| | ''None''
| |
| |-
| |
| | ''None''
| |
| |}
| |
| |}
| |
|
| |
| == Desired Features ==
| |
|
| |
| == Implementation Target ==
| |
