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

Here you'll find answers to the most frequent asked questions about SlicingDice.
Your questions are not answered? Talk to us!

FAQ about SlicingDice

What is SlicingDice?

The All-in-One Data Warehouse, provided by SlicingDice is an easy to use, fast and cost-effective cloud-based platform, designed for any data challenge. You don't need to spend time configuring, tuning and managing infrastructure.

Why is SlicingDice "All-in-One"?

Because SlicingDice provides optional built-in tools to work through your whole data pipeline, in a serverless platform with a powerful API.
This package of features doesn't exist in any other solution on the market, so if you decide to use one of our competitors' platform, you'll likely need to hire third-party tools to build all of your company's data solution. This will lead you to waste time and money trying to figure out how to connect all the pieces together.

Currently, we offer Loading & Sync, VIsualization, BI, Machine Learning and Virtualization modules.

How can it be so fast yet so cheap?

We have our own innovative compression technology. Data compression is one of the parts which our developers have put a huge amount of time and effort. Because of that, it’s common for us to see compression ratios between 1/10 and even 1/30 of the original data size when inserting it on SlicingDice database, S1Search.

There's no magic trick about what we do and the logic is pretty straightforward: as we can store our customer's data using just a fraction of its original size, it costs us much less than any other solution, so we can offer much more affordable pricing models.

Due to the economy of scale, the more customers we get, the more S1Search servers we add, making our average storage cost even lower, allowing us to decrease our prices.

How can you assure my data is secure?

We comply with some of the highest security standards and regulations. Since we've built our database from the ground up, we have a proprietary encoding that makes it harder for outsiders to affect our code or client data. Also, we have tight infrastructure security and store data redundantly in three very secure datacenters in different locations. You can know about our compliance and security measures here.

How often would your technical team be available for support?

24 hours per day, 7 days per week.

How does SlicingDice's Control Panel work?

SlicingDice's Control Panel allows you to perform anything you need to do within SlicingDice: queries, insertions, deletes, updates, etc. Our documentation shows real-life examples using our control panel. Click here to read our docs about Control Panel.

Can I use SlicingDice as a Business Intelligence (BI) tool?

Yes, but remember that you need to load your data in order to use SlicingDice's BI tool. You can’t use the SlicingDice's BI Tool with external data providers, all data must be in SlicingDice. You can learn about our Business Intelligence Tool here.

I already have a BI tool, but I know SlicingDice has its own, what should I do?

You can test our Data Visualization and BI tools for free and see if they fit your needs. If not, you can use our data warehouse as a source for your BI tool, as it is ready to connect to all established BI solutions.

What kind of analysis does SlicingDice support?

We support all kinds of data analysis possible using these queries.

If one of my queries don't complete in less than 10s, what should I do?

We'll automatically refund you USD 0,10.

How can I access SlicingDice?

Through our Control Panel. You can learn more about the Control Panel. here

How can I report that something is wrong with my account?

Talk to our support team.

How can I use permission lists?

In the Control Panel, "Identity and access" -> "Roles and Policies" you can create profiles and control their access to almost every SlicingDice feature. Check more about it in our Permission Group documentation.

How can I create a support ticket?

In our Control Panel -> "Support". Click on the "Create new ticket" button and type your message.

How can I start using SlicingDice?

Simply go to our site and register. You can create a test database for free.

What's SlicingDice downtime?

At the moment we have 99,9% availability. You can check our status page for more information.

Tell me more about your data centers.

We work with three data centers on three different countries for redundancy, to provide maximum stability and performance 24/7. All of them are well-known infrastructure providers and adhere to very strict safety and availability protocol. You can learn about our infrastructure partners here

Must I use SlicingDice's Workbench or can I use another one?

You can use any workbench tool you prefer by using our JDBC and ODBC drivers.

I need to make an analysis of data in real time. Is that possible by using SlicingDice?

We support near-real-time data insertion (maximum 5 seconds between insertion and query availability).

Would SlicingDice offer me queries with milliseconds precision?

No. Right now our precision is in seconds.

What SlicingDice is good at?

Returning fast queries using many columns, storing time-series, being easy to maintain, hold a huge amount of data and charge small prices to provide an All-in-One data solution for your company. Read more about what are our advantages and with more details about what we're good at.

What SlicingDice is NOT good at?

As we use a columnar database, SlicingDice is not good at retrieving everything about an entity all the time, working as a transactional database, storing case-sensitive data, building snowflake schemas and being instantly consistent. Read more about what are our restrictions and with more details about what we're not good at.

What is "serverless"?

A way to perform computing in a cloud-based environment, with the cloud acting as a server and every server maintenance duty being performed by the cloud administrator.

What are the advantages of being serverless?

It lowers the total cost of ownership, by requiring less manpower to manage the system and significantly lowering expenses when you need to scale. It's also a lot easier to scale or descale when needed, adapting to business needs without needing any configuration.

What are the disadvantages of being serverless?

In some serverless solutions, the lack of detailed control in the configuration of the server might restrict some use cases,making optimization a bit harder, for example. If you think this is a problem for you, please create a test database at SlicingDice and let us prove that even without this high granularity in tuning we have the best performance on the market.

How can I invite team members to my SlicingDice account?

Inside the Control Panel, on the ‘Identity and Access’ section you can invite users, create permission groups specify what can be accessed by each member invited. Learn more on creating users and creating permission groups

FAQ about Pricing

How does your pricing work?

We have two main pricing models - you can pay based on amount of data stored or number of columns.
Read more about our pricing here.

What pricing model is a better fit for my use case?

Our system can automatically detect which pricing model is best for you. If you have a lot of columns on your database, you should go with pay-per-gigabyte. Otherwise, you should try pay-per-column.
You can also manually select one of those options (and change it at anytime) when creating a database.

How do these data insertion and query load plans work?

You're limited to 60 queries every minute and 10 million inserts per day, meaning you have to wait a bit if you exceed those quantities. You can hire an extension plan to exceed those quantities if needed. Learn more about the pricing of the extension plans here.

Do I need to pay to access SlicingDice's Control Panel?

No, you can simply sign up, log in and create a free test database.

What does free and unlimited data storage means?

When you choose the pay-per-column model, you pay a fixed price, based on the number of columns. In other words, you can store an unlimited number of rows. This is possible because of our data compression technology built from scratch. Learn more about our technology.

You have a plan that charges per column. But I have A LOT of columns, how can SlicingDice still be cheap?

Because of our data compression technology, your data will take much less storage space than it does in other databases. Our pay-per-gigabyte model will still give you a very affordable price, much cheaper than the competition.

How can I calculate the pay-per-column price?

It's a fixed per-column price. So just multiply the number of the columns for per-column price. Keep in mind that in this model, the amount of data for each column is unlimited. Also, entityID column does not count towards pricing.

Note that pricing also include Insertion/Query plans and add-on pricing. Check more about pricing.

How can I calculate the pay-per-gigabyte price?

It's a fixed price per gigabyte stored. So just multiply the number of gigabytes for the per-gigabyte price. Keep in mind that in this model you leverage SlicingDice's proprietary *compression. Your data will take much less space than in other databases.

Note that pricing also include Insertion/Query plans and add-on pricing. Check more about pricing.

What is SlicingDice's payment methods?

At this moment, any credit card supported by Stripe that can be charged in US Dollars.

Do you guys charge by data throughput?

Yes, if you have more than 60 queries every minute or 1 million inserts per day. Check more about our Pricing Models.

How null values are calculated on your final price?

They are not calculated on final price.

How do I know when it's cheaper to pay-per-column or pay-per-gigabyte?

Our system can automatically detect which pricing model is best for you.

To know how much specifically each one would cost and/or how much you're saving by using the cheaper option, you'd have to calculate manually. Simply multiply the number of columns or gigabytes (depending on the chosen model) by its correlated individual price, found here .

You can also manually select one of those options (and change it at anytime) when creating a database.

FAQ about Database

Is SlicingDice a Relational Database?

No. As an OLAP, our main focus is to provide an analytical database, which is not the best option for cases like PoS or ERP systems. In SlicingDice, although you can build a Star Schema, you don’t need to, because the way our database stores data enables you to store every type of data together, in a single dimension.

What's the difference between test and production databases?

Test databases are free to use, the data you load is deleted every seven days and they have limited insertion/query throughputs, as they use limited resources from our infra-structure. Production databases are the standard database you use for working purposes, they use all of our infrastructure capability and you will be charged when you use them.

Who can have access to my database?

You and whomever you give access to. You can control access by database keys, whitelisting your database to specific IP/Domain Addresses and giving permissions to users.

How data modeling works on SlicingDice?

You can model your data in a denormalized model, where you insert all your data in a single dimension. It's also possible to store your data on SlicingDice using a Normalized model by creating a Fact Table and Dimension Tables and relating them using Foreign Keys. You can read about the benefits of each type of data model in our Database Schema Modeling documentation.

Can I create snowflake schema on SlicingDice?

SlicingDice allows the creation of star schemas as it support foreign key constraints, but it was not designed to be used for snowflake schemas.

How can I execute a query in SlicingDice?

Using code in our built-in workbench or directly via API.

What kind of programming language should I use to run commands on SlicingDice's workbench?

SQL or our JSON API commands.

How can I give people access to my database?

By giving them your Database Keys or defining roles.
Check the Permission Group Documentation, User Creation Documentation and Database Keys Documentation.

Once I create a database, can I delete it?

Yes, you can delete your database in Control Panel or delete your database using API.

Does SlicingDice accept any type of data format?

No. You can see all our supported data types here.

Does SlicingDice support geolocation data?

Yes. We support geolocation data and it can be queried together with every other data type. We even have geolocation event columns, which are latitude and longitude with a timestamp.

Can I edit my column's or dimension's API name?

No. You can edit your column name, but not the API name

How does your SQL based API endpoint work?

You simply make an API request with a SQL query in the request body, using specific API configurations. Click here to learn more about how it works.

How can I use SQL to access SlicingDice?

As you would use any SQL service - your preferred workbench or our workbench in the control panel. You can also use our API's SQL Endpoint to run SQL queries in your data.

Can SlicingDice run ANY type of query in less than 10s?

Yes, every type of query, even the complex ones. If we fail to give you a response under 10 seconds, we'll automatically give you a USD 0,10 discount on your invoice.

Can I use Uppercase and Lowercase data?

No. All our data is stored in lowercase.

From when is the oldest data that SlicingDice can retrieve?

The default is 1990-01-01, but we just have this limit for safety reasons. If you need to work with older data, contact us.

Do you have the concept of primary key on SlicingDice?

Yes. We call it entity-id, an unique value that identifies entities within the database. When you create a new dimension, the entity-id column is created by default for you and every dimension MUST have an entity-id. Read more about the entity-id.

How can I connect to my database?

You can easily connect to your SlicingDice's database by using our JDBC and ODBC drivers or using our Client Libraries, provided in the most popular programming languages. Also, we have a powerful API that you can connect to use your databases via JSON or SQL.

How many columns and dimensions can I add on one single database?

As many as you need!

Do you encrypt data in "rest mode"?

Yes, all the data in our system is encoded with our proprietary encryption. As soon as you insert your data, it will be encrypted. Check more about how we handle data security here.

FAQ about the Data Loading module

How can I load my data to SlicingDice?

Through our Data Load & Sync module or via API or SQL commands. Check more info here.

What is a data source and how can I add a data source to SlicingDice?

A Data Source is a location where the data is outside SlicingDice. You can add a Data Source from Control Panel, in our Data Loading & Sync module and add new data sources. Right now we have more than 150 options of data sources that you can use. Some examples: Amazon Redshift, Amazon S3, Google BigQuery, MySQL, Google Analytics, and so on.

Once I add a data source to SlicingDice, my data is already inserted?

No. By creating a Data Source you only have configured the source from which SlicingDice can extract data from. To really transfer data you have to create a Loading Job in the Control Panel.

What is a loading job?

A Loading Job is a connection to a Data Source that makes the mapping of the data from the data source and sends this data to a SlicingDice's database. When you start the loading job is when the data from your data source starts to flow to your SlicingDice's database. Read the Adding a Loading Job documentation to learn more about Loading Job.

What is your load performance?

It depends on the amount of data and the number of different sources but our time-to-insight is measured in minutes. Also, we support streaming of data and concurrent loading jobs.

FAQ about the Data Visualization module

What is the Data Visualization module?

A powerful module that enables users to analyze and create charts, dashboards and reports using data stored in their SlicingDice databases. Check our data visualization documentation page.

What kind of charts do you have?

Check all types of charts that we provide here.

Can I do interactions between charts?

Yes. You can see our documentation about Chart interactions for more information.

What's the difference between charts and saved charts?

Charts are attached to certain dashboard while saved charts are stand-alone and can be added to as many dashboards as needed. Saved charts are also updated across the board when you update them.

Can I have real-time dashboards by using SlicingDice?

Yes, dashboards are updated when data is updated.

What are measures, dimensions and calculations on your Data Visualization module?

Measures are the data values (columns) your chart will work with and Dimensions are the categories by which you group your measures. Calculations are the mathematical operators that will be applied to the Measures.

How can I create presentations with SlicingDice?

Using our Data Visualization module directly inside SlicingDice's Control Panel. You can read more about it in our Presentations documentation.

FAQ about SlicingDice's competitors

How SlicingDice is different from other data platforms?

You can check detailed comparison with the most popular data platforms here

What are the main differences between SlicingDice and other databases?

Simple pricing, guaranteed query times, little to no maintenance, focus on time-series data, built-in DataViz and data loading functionalities.


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.