> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/analytics/mariadb-columnstore/use-cases.md).

# Use Cases

- [About MariaDB ColumnStore](https://mariadb.com/docs/analytics/mariadb-columnstore/use-cases/mariadb-columnstore-guide.md): MariaDB ColumnStore is a columnar storage engine ported from InfiniDB 4.6.7, designed for petabyte-scale analytics with linear scalability, columnar compression, and partitioning.
- [Using MariaDB With R](https://mariadb.com/docs/analytics/mariadb-columnstore/use-cases/r-statistical-programming-using-mariadb-as-the-background-database.md): Using MariaDB ColumnStore with R for statistical computing and graphics, providing a scalable analytical backend for R's data manipulation, modeling, and visualization workflows.
- [Query Accelerator](https://mariadb.com/docs/analytics/mariadb-columnstore/use-cases/query-accelerator.md): Query Accelerator (Alpha, ColumnStore 25.10.0 + ES 11.8.3+) lets MariaDB ColumnStore execute aggregation queries on InnoDB tables in parallel using engine-independent statistics.