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.
Integer
The integer data type (int) is used to represent whole numbers that can be stored within 32-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.

Integer

The integer data type (int) is used to represent whole numbers that can be stored within 32-bits.

Columns of type integer can store information such as:

Transaction IDs (3026049)
Identification numbers (24)
Dates (20161201)
Time (121837)

Dates and time are represented by the integer data type. For more information, see Dates and time.

Valid integer values are -2,147,483,646 to 2,147,483,646.

Note: If the values, or the results of mathematical functions applied to these values, will be outside of this range, use the decimal data type or the big integer data type instead.

In some places in the 1010data Insights platform, the integer data type (int) is also represented as i.