Data Types

The following data types are available:

• SHORT: 16-bit signed int
• INT: 32-bit signed int
• LONG: 64-bit signed int
• FLOAT: 32-bit floating point number
• DOUBLE: 64-bit floating point number
• STRING: text data

Table Configuration

Due to the nature of the data storage schema, newly created tables require additional setup to specify which columns can be used as categories. If no configuration is provided, the database will attempt to set up the table based on the inserted data. This approach may be suboptimal if the data is highly irregular.

An alternative approach is to explicitly specify which columns can be used as categories. This method requires some knowledge of the data to identify which table columns contain the least information.

Finally, an option is available to configure the table using an existing data set. This procedure will read the CSV file to determine which columns should be used as categories.

Create table: CREATE TABLE(column1 TYPE, column2 TYPE,...)

Create table with specified categories: CREATE TABLE(column1 TYPE [CAT NUM] , column2 TYPE [CAT NUM],...)

Create table configured from CSV file: CREATE TABLE(column1 TYPE, column2 TYPE,...) CONFIG FROM file_name

Loading Data

CSV load: LOAD TABLE FROM file_name

Select Query

The following is a general form of SELECT statement: SELECT column1, column2, ... FROM table [JOIN join_table on table_col = join_col ] [WHERE condition1, condition2, ...] [ORDER BY column1 [DESC], column2 [DESC], ...]