MariaDB ColumnStore extends MariaDB Enterprise Server with distributed, columnar storage and a massively parallel processing (MPP) shared nothing architecture, transforming it into a standalone or distributed data warehouse for ad hoc SQL queries and advanced analytics without the need to create indexes. With MariaDB ColumnStore running in SkySQL you get a cloud data warehouse and DBaaS in one service. And, unlike cloud data warehouses, you have the option for scale-out distributed SQL and web, mobile and IoT edge analytics processing with MariaDB Xpand.
Data is stored in a columnar format for fast analytics and with up to 90% compression, reducing disk I/O and size of data on disk.
Data can be distributed across multiple database instances and queried in parallel to increase query performance and support massive datasets.
Data can be stored on Amazon S3 compatible object storage, on premises or in the cloud, to benefit from low-cost, unlimited storage.
MariaDB ColumnStore, with MariaDB Enterprise Server, MariaDB Xpand and MaxScale, supports our customers across various industries and delivers reduced costs, increased performance and better scalability than alternative solutions.
Analyze millions of quotes for trading in tens of milliseconds to estimate price point, profitability, and risk.
Analyze disparate and diverse data across multiple database instances and increase query performance and support massive datasets.
Analyze customer behavior for retail use cases such as cross-sell/up-sell, customer loyalty and churn.
Analyze ERP and IoT data to predict points of component and systems failure thereby increasing uptime and reducing maintenance costs.
Analyze large amounts of data with standard SQL, including joins with other tables (row or columnar).
Use Kafka and Spark connectors to ingest streaming data and publish machine learning results for interactive, ad hoc analysis.
CLI import tools as well as C, Java and Python connectors bypass the SQL layer to load data directly to storage from anywhere.