Home
User basics
Learn about the key concepts and terminology that provide the foundation for the 1010data Insights Platform.
Data types and display formats
Data types govern how data is stored internally, and display formats control how that data is displayed.
Data types
There are four simple data types that represent how information is internally stored in the 1010data Insights Platform.
Big integer
The big integer data type (bigint) is used to represent whole numbers that are outside the range of the integer data type and can be stored within 64 bits.

User basics
Learn about the key concepts and terminology that provide the foundation for the 1010data Insights Platform.
- Versions
  The 1010data Insights Platform is available in both a stable production version of the system (Prime) and a version that provides access to the latest features (Beta).
- Sessions
  A session in the 1010data Insights Platform is an established period of communication between a user and the system. A single user ID can only have one session active at a time.
- Workspace
  The workspace is an individual instance of the 1010data Insights Platform user interface.
- Virtual memory
  The quantity of data that your session can handle at the same time is determined by the amount of virtual memory assigned to your user ID.
- Rows and columns
  Within the 1010data Insights Platform, you will manipulate rows and columns to view your data and perform new computations to gain further insight into your data.
- Data types and display formats
  Data types govern how data is stored internally, and display formats control how that data is displayed.
  - Data types
    There are four simple data types that represent how information is internally stored in the 1010data Insights Platform.
    - Integer
      The integer data type (int) is used to represent whole numbers that can be stored within 32-bits.
    - Big integer
      The big integer data type (bigint) is used to represent whole numbers that are outside the range of the integer data type and can be stored within 64 bits.
    - Decimal
      The decimal data type (dec) is used to represent 64-bit floating point values.
    - Text
      The text data type (text) is used to represent values that contain uppercase and lowercase letters, numbers, spaces, and symbols.
    - Dates and time
      While dates and times are typically stored in columns that have an integer or decimal data type, they must be specified in a valid form to produce the expected results.
  - Display formats
    Display formats control how values are displayed within columns in the 1010data Insights Platform.

Big integer

The big integer data type (bigint) is used to represent whole numbers that are outside the range of the integer data type and can be stored within 64 bits.

In most cases, columns of type bigint are used in links, selections, and tabulations. Columns of type bigint can also be specified as the G argument in g_functions such as g_sum(G;S;O;X).

Columns of type big integer can store information that cannot be represented within 32 bits such as:

Keys
Universally unique identifiers

Values in a column of type big integer are -9,223,372,036,854,775,806 to 9,223,372,036,854,775,806.

In some places in the 1010data Insights platform, the big integer data type (bigint) is also represented as j.

(Available as of version 11.25)