Table Object and Data Type
BigObject analytics is designed to analyze multi-dimensional data in star or snowflake schema. Multi-dimensional data is organized into tables. There are two types of tables in BigObjects - the dimensional table and the fact table.
A dimension consists of a set of items with certain descriptive properties called attributes. For example, a business data is multi-dimensional. It could contain information such as product, channel and price. When such information is organized and stored in a table object, it is referred to as a dimension table in BigObject.
Let's place this in the ABC company example. As ABC company starts its business, the staff wants to first create a database for future analytics. The first thing he may want to create is the database of all of its members who happen to be customers of ABC company's clients. A dimension table called "Customer" may be created to look like this:
To refer an attribute a in a dimension table D, the user needs to specify as D.a. For example, Customer.Gender represents Gender attribute in Customer dimension table.
Table name and attribute name are case sensitive in BigObject.
Fact is the data needed to be analyzed. When fact data stored in a table object, it is referred to as a fact table in BigObject.
When ABC company staff creates the database, he will also store the transaction records into a table for future analysis. A fact table called "sales" is created by the staff that looks like the following:
Note that column Customer.id and Product.id refers to the column id in
Customer dimenstion table and id in
Product dimenssion table respectively.
BigObject supports following data types:
|STRING||Encoded string ended with NULL(0) character|
|VARSTRING||Variable-length string; suitable for non-repeatable strings to save space|
|BYTE||Single character(ASCII range 32-126)|
|FLOAT||4-byte floating point|
|DOUBLE||8-byte double precision floating point|
|DATE32||Year, month, and day of month (4 bytes long)|
|DATETIMEDOS||Date and time (4 bytes long)|
|DATETIME32||Date and time (4 bytes long)|
|DATETIME64||Date and time (8 bytes long)|
|IPv4||Internet Protocol version 4|
|IPv6||Internet Protocol version 6|
The default and maximum length of each string type is listed below:
|Type||default length||maximum length|
Below is the range for date related data types:
|year||-32768 - 32767||1980 - 2107||2000 - 2063||-32768 - 32767|
|month||1 - 12||1 - 12||1 - 12||1 - 12|
|day of month||1 - 31||1 - 31||1 - 31||1 - 31|
|hours||N.A.||0 - 23||0 - 23||0 - 23|
|minutes||N.A.||0 - 59||0 - 59||0 - 59|
|seconds||N.A.||0 - 58 (even only)||0 - 59||0 - 59|