DAP Relational Database Server II: Difference between revisions
From OPeNDAP Documentation
⧼opendap2-jumptonavigation⧽
| Line 5: | Line 5: | ||
=== Atomic (Simple) Types === | === Atomic (Simple) Types === | ||
==Table Test 1 == | |||
{| border="1" cellspacing="0" | {| border="1" cellspacing="0" | ||
| Line 75: | Line 87: | ||
|- | |- | ||
| table || || || | | 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'' | |||
|} | |||
|} | |} | ||
Revision as of 18:11, 21 April 2009
Introduction
Previous Design/Implementation
Data model representation
Atomic (Simple) Types
Table Test 1
| 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
| Catagory | Data Type | Description | Standardization | Logical DAP data type association. | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Boolean and binary types |
|
|
|
|
