This page gives an overview about the data types supported by Polypheny.
|Bigint||8 bytes signed (two’s complement). Ranges from |
|Boolean||1-bit. Takes the value |
|Date||Represents a date. Format: |
|Decimal||A decimal number is a number that can have a decimal point in it. This type has two arguments: precision and scale. The scale can not exceed the precision.|
|Double||8 bytes IEEE 754. Covers a range from |
|Integer||4 bytes, signed (two’s complement). Covers a range from |
|Real||4 bytes, IEEE 754. Covers a range from |
|Smallint||2 bytes, signed (two’s complement). Covers a range from |
|Time||Represents a time of day without time zone. Can optionally be defined with a fractional second precision between 0 and 3. Format: |
|Timestamp||Represents a combination of DATE and TIME values. Can optionally be defined with a fractional second precision between 0 and 3. Format: |
|Tinyint||1 byte, signed (two’s complement). Covers a range from |
|Varchar||String (can contain letters, numbers, and special characters) with variable length. The maximum length is specified as parameter.|
An array is an ordered, contiguous collection that may contain duplicates. Polypheny-DB supports arrays of all scalar types.
In Polypheny-DB, arrays can have an arbitrary dimension and cardinality. Both are specified as arguments. Specifying -1 disables validation.
The dimension specifies how deep arrays can be nested. A dimension of one therefore means that nested arrays are not allowed while a dimension of two allows nested arrays but no nested arrays within nested arrays.
The cardinality specifies the number of elements (values and nested arrays) in every (nested) array.
Multimedia and File Types
Polypheny-DB natively supports storing files. In addition to the generic
FILE data type there are also additional types for multimedia content. Multimedia files are not checked by their file extension, but by their content type. See SimpleMagic.ContentType for more information.
|Audio||Accepted content types: AIFF, AUDIO_MPEG, MIDI, REAL_AUDIO, WAV|
|File||Accepts files of any type.|
|Image||Accepted content types: APPLE_QUICKTIME_IMAGE, BMP, GIF, JPEG, JPEG_2000, PBM, PGM, PNG, PPM, SVG, TIFF|
|Video||Accepted content types: APPLE_QUICKTIME_MOVIE, AVI, MNG, MP4A, MP4V, VIDEO_MPEG|