Why choose a columnar database for modern analytics
July 27, 2018
When you need to analyze millions (or even billions) of rows of data on demand and in real time, what are your options? Do you need to turn to Hadoop? Or maybe an expensive hardware appliance? No—a columnar database is the answer.
Columnar databases are designed for analytical performance and flexibility, allowing you to:
- Decrease the need to read from disk
- Compress your dataset by 65-95%
- Eliminate the need for indexes
- Support ad hoc, on-demand queries at any scale.
We’ll use MariaDB AX, an open source columnar database for enterprises, to explore how you can make your analytics faster, more efficient, hugely flexible and infinitely scalable – while retaining all the benefits of standard SQL.