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

1. Database Creation, Update & Deletion

It's possible to create databases using the SlicingDice's Control Panel and the SlicingDice's API. Read this page to learn how to create a database using the API.

There are two types of databases on SlicingDice: test and production databases. Below are the differences between them:

  • Test Database
    A test database can be used to try SlicingDice and define your data model before creating a production database. All test databases are free, but the data retention is only 7 days, so SlicingDice will automatically delete any data stored for the database every 7 days after its creation.

  • Production Database
    The production database is the official database you are going to use when inserting and querying your data for real.

Test Databases are for small tests only!

The test environment should not be used for insertion or query performance evaluations, as it uses less than 1% of the SlicingDice's infrastructure.


Creating a database using the control panel

Watch this quick video below to learn step-by-step how to create databases using the SlicingDice's Control Panel.


Database wizard explained

Below we explain each one of the steps and fields required when creating a database and some screenshots with built-in examples.

Step 1 - Database Setup

Field
Description

Database Name

The name of your database. Can be edited at any time.

Database Labels/Tags (Optional)

Possible labels/tags you might want to associate to a database, in order to organize it. Can be edited at any time.

Database Description

Database description. Can be edited at any time.

Database Type

Can either be Test or Production. It's only possible to change a Test database to Production, not the other way around.

Pricing Model

The pricing model you want to use for your database. Can be changed at any time. Access the SlicingDice pricing models page to learn more.

Insertion Load

The insertion throughput you want your database to have. Can be changed at any time. Access the SlicingDice pricing models page to learn more.

Query Load

The query throughput you want your database to have. Can be changed at any time. Access the SlicingDice pricing models page to learn more.

Step 2 - Schema Definition
This step can be done later, at any time. You don't need to define all your database schema during the database creation process.

  • Column Creation:
Field
Description

Column Name

The name of your column. Can be edited at any time.

Column API Name

The API name of your column. Cannot be edited once it's created.

Column Description

The description of your column. Can be edited at any time.

Dimension

The dimension in which your column will be created. Cannot be edited once it's created. Read the dimension page to learn more.

Column Data Type

The type of data you want for the column. Cannot be edited once it's created. Access the supported data types page to learn more.

Column Data Storage Type

The type of storage you want the column to have, store the latest inserted value or keep a list of all values inserted. Cannot be edited once it's created. Access the supported data types page to learn more.

  • Dimension Creation:
    Access the dimension page to learn more about creating dimensions.
Field
Description

Dimension Name

The name of your dimension. Can be edited at any time.

Dimension API Name

The API name of your dimension. Cannot be edited once it's created.

Default Dimension

SlicingDice automatically creates a default dimension - dimension - Dimension is a concept used in SlicingDice to describe a way to group columns for a database. Each database can contain multiple dimensions and each dimension can contain multiple columns. On SlicingDice every database has at least one dimension (created by default), that is similar to the concept of a table, on relational databases. Dimensions are normally used to insert the same kind of data you inserted on another dimension, but associating it for a different type of entity. But it's also possible to use a dimension like a table on a relational database, where you normally create tables and build relations between them. for you to store data. You can rename this default dimension - dimension - Dimension is a concept used in SlicingDice to describe a way to group columns for a database. Each database can contain multiple dimensions and each dimension can contain multiple columns. On SlicingDice every database has at least one dimension (created by default), that is similar to the concept of a table, on relational databases. Dimensions are normally used to insert the same kind of data you inserted on another dimension, but associating it for a different type of entity. But it's also possible to use a dimension like a table on a relational database, where you normally create tables and build relations between them. name at any time.

Step 3 - Database Whitelist (Optional)
Access the Protect the Database page to learn more about how the Database Whitelist works.

Field
Description

Database IP Address or Website Domain Whitelist

The IP addresses or website domain that are allowed to connect to the database. Can be edited at any time.

Step 4 - Custom Database Keys (Optional)
Access the Protect the Database page to learn more about how the Custom Database Keys works.

Field
Description

Database Key Name

The name of your database key. Can be edited at any time.

Database Key Permission Level

The type of the database key you want to create. Can be edited at any time.

Database Key Description

The description of your database key. Can be edited at any time.

Columns to whitelist for this Database key

The list of columns of the database that you want to associate to the custom database key. Can be edited at any time.

Step 5 - Confirmation
Summary of all information and configurations defined for the new database before finally creating it.

Once the database is created, it will be immediately available for inserting and querying data, and automatically appear on the list of databases.


Updating your database

After you created your database, you can modify some aspects, like add new dimensions, columns, create new relations, and more.

To update your database, follow the steps presented below.

Step 1 - Go to Database
In your Control Panel, go to your Database Overview.

Step 2 - Find the Database that you want to update
In the Database tab, you can have several Databases.
In this example, we'll update the user database. After the database selection, go to next step.

Step 3 - Edit your database
In the Actions section, click in the Edit Database button (pencil within a square icon).
You'll be presented in this following screen.

As you can already perceive, the screen is similar to when you're creating your database. The only difference is there is not a confirmation step.

Database edition

As Editing Database operations didn't have a place to confirm your actions, every "Save Changes" button click will perform the operation immediately.


Deleting a database

In order to delete a database, you have to access the SlicingDice's control panel and follow the steps presented below.

Step 1 - Go to Database
In your Control Panel, go to your Database Overview.

Step 2 - Find the Database that you want to delete
In the Database tab, you can have several Databases.
In this example, we'll delete the user database. After the database selection, go to next step.

Step 3 - Delete your Database
After you choose your database, go to the Actions section, and then click on the button Delete Database (with the garbage can icon).

After you click on the button, you'll receive the following warning.

Click on the "Yes" button. Your database will be immediately deleted and you'll receive a confirmation message. Noticee that the database you just deleted does not appear more in the List of Databases.

That's it! You just deleted your first database!

Deleted database recovering

After you delete your database, you can not recover it! Think twice before deleting your database.