Best Columnar Databases for BigBI

The Apache Cassandra database provides high availability and scalability without compromising performance. It is the ideal platform for mission-critical data because it offers linear scalability and demonstrated fault-tolerance with commodity hardware and cloud infrastructure. Cassandra's ability to replicate across multiple datacenters is first-in-class. This provides lower latency for your users, and the peace-of-mind that you can withstand regional outages.

ANSI SQL allows you to analyze petabytes worth of data at lightning-fast speeds with no operational overhead. Analytics at scale with 26%-34% less three-year TCO than cloud-based data warehouse alternatives. You can unleash your insights with a trusted platform that is more secure and scales with you. Multi-cloud analytics solutions that allow you to gain insights from all types of data. You can query streaming data in real-time and get the most current information about all your business processes. Machine learning is built-in and allows you to predict business outcomes quickly without having to move data. With just a few clicks, you can securely access and share the analytical insights within your organization. Easy creation of stunning dashboards and reports using popular business intelligence tools right out of the box. BigQuery's strong security, governance, and reliability controls ensure high availability and a 99.9% uptime SLA. Encrypt your data by default and with customer-managed encryption keys

Amazon Redshift is preferred by more customers than any other cloud data storage. Redshift powers analytic workloads for Fortune 500 companies and startups, as well as everything in between. Redshift has helped Lyft grow from a startup to multi-billion-dollar enterprises. It's easier than any other data warehouse to gain new insights from all of your data. Redshift allows you to query petabytes (or more) of structured and semi-structured information across your operational database, data warehouse, and data lake using standard SQL. Redshift allows you to save your queries to your S3 database using open formats such as Apache Parquet. This allows you to further analyze other analytics services like Amazon EMR and Amazon Athena. Redshift is the fastest cloud data warehouse in the world and it gets faster each year. The new RA3 instances can be used for performance-intensive workloads to achieve up to 3x the performance compared to any cloud data warehouse.

Kudu clusters store tables that look exactly like the tables in relational (SQL), databases. A table can have a single binary key and value or a multitude of strongly-typed attributes. Every table has a primary key that is made up of one or more columns, just like SQL. This could be a single column, such as a unique user ID, or a compound key, such as a (host.metric.timestamp) tuple to a machine-time-series database. Rows can be easily read, updated, and deleted by their primary keys. Kudu's data model is simple and easy to use. It makes it easy to port legacy applications and build new ones. You can use standard tools such as Spark or SQL engines to analyze your tables. Tables are self-describing. Kudu's APIs were designed to be simple to use.