SlicingDice Documentation

SlicingDice - The All-in-One Solution Documentation

Welcome to the SlicingDice documentation. You'll find comprehensive guides and documentation to help you start working with SlicingDice as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    Guides

3. Create Dimensions

Dimension is a concept used by SlicingDice to describe a way to group columns for a database.
Each database can contain multiple dimensions and each dimension can contain multiple columns.

What is a dimension

What is a dimension explained by video

Watch this quick video below to learn what a dimension is, or go to the text explanation right below.

What is a dimension explained by text

A dimension is a way to group columns for a database. Each database can contain multiple dimensions and each dimension can contain multiple columns.

Differently from a relational database, where you normally create tables and build relations between them, SlicingDice doesn't have the concept of a table, because it doesn't have to.

As SlicingDice supports storing both types of data, attributes (non-time-series) and events (time-series) in the same dimension (that can be seen like a single table), without affecting the query performance or database storage size, there is no need to split/normalize the data into multiple tables, as it's commonly done in other databases.

The purpose of a dimension is simply to group all columns created, similarly how a table work in a database. We just don't call it "table", because that could give the impression that we expect you to model your schema in a relational way, and that is unnecessary using SlicingDice.

Default Dimension

SlicingDice automatically creates a default dimension for you when you create a new Database to store data. You can rename this default dimension name at any time. As you'll see, you can add new dimensions when creating a database or at any time in the future.


How to create a dimension

There are two ways for you to create dimension, one of them will be covered on this page:

You can learn the other way to create columns by checking the SlicingDice's API Docs.

  • Using the "auto-create": ["dimension"] parameter when inserting data using the SlicingDice API;

Creating dimensions using the control panel

Watch this quick video below to learn step-by-step how to create dimensions using the Control Panel.


When to create dimensions

You might want to create a new dimension when at least one of the following conditions apply:

  • The column and data you want to store are totally unrelated to the columns and data stored on the existing dimension, even if the entities are the same.

  • You want to insert data related to a different kind of entity in order to analyze other dimensions of the data. For example: associate website page views information to a web pages entity instead of users entity.