Analytics¶

MariaDB SkySQL includes MariaDB Platform for Analytics.

MariaDB Platform for Analytics optimizes MariaDB Enterprise Server for analytical workloads by using the MariaDB ColumnStore storage engine. MariaDB ColumnStore turns MariaDB Enterprise Server into a columnar database for real-time analytics at scale to perform interactive, ad hoc queries on hundreds of billions of rows with standard SQL.

Analytical workloads have different demands than transactional workloads. Transactional workloads are generally characterized by a fixed set of queries using a relatively small data set. Analytical workloads are characterized by ad hoc queries on very large data sets. Where indexes can be used to optimize query performance for transactional workloads, the size of the data sets, and the ad hoc nature of the queries preclude the use of indexes to optimize for analytical queries.

MariaDB ColumnStore is designed specifically to handle analytical workloads. Data is written to disk by column rather than row and is automatically partitioned. No indexes are necessary.

MariaDB Platform for Analytics on SkySQL delivers the following features:

Topology

Storage Engine

Number of Instances

Columnar Storage

Object Storage
(Grows Infinitely)

Statistical Functions

Production-Ready

Development/UAT-Ready

ColumnStore

ColumnStore

1

Yes

Yes

Yes

Yes

Yes

Want both transactions and analytics? MariaDB ColumnStore is also available in a hybrid transactional/analytical processing (HTAP) configuration through MariaDB Platform for Smart Transactions.

Provision your service now.