Best OLAP Databases for Tableau

StarTree Cloud is a fully-managed real-time analytics platform designed for OLAP at massive speed and scale for user-facing applications. Powered by Apache Pinot, StarTree Cloud provides enterprise-grade reliability and advanced capabilities such as tiered storage, scalable upserts, plus additional indexes and connectors. It integrates seamlessly with transactional databases and event streaming platforms, ingesting data at millions of events per second and indexing it for lightning-fast query responses. StarTree Cloud is available on your favorite public cloud or for private SaaS deployment. StarTree Cloud includes StarTree Data Manager, which allows you to ingest data from both real-time sources such as Amazon Kinesis, Apache Kafka, Apache Pulsar, or Redpanda, as well as batch data sources such as data warehouses like Snowflake, Delta Lake or Google BigQuery, or object stores like Amazon S3, Apache Flink, Apache Hadoop, or Apache Spark. StarTree ThirdEye is an add-on anomaly detection system running on top of StarTree Cloud that observes your business-critical metrics, alerting you and allowing you to perform root-cause analysis — all in real-time.

icCube serves as a seamless alternative to SQL Server Analysis Services, offering a variety of advanced features: - A logically compatible OLAP model, with assistance for smooth migration - Continued support for Excel and other XMLA/MDX clients - Flexible deployment options, including a Docker version - Real-time dynamic MDX security, providing cell-level detail protection - Cutting-edge OLAP functionalities, including: - Over 100 new MDX functions - Categorization features - Subcube capabilities - Native integration with Java Additionally, icCube includes a patented MDX debugger. As an extra bonus, it also features a web-based BI solution that can be easily embedded.

SingleStore, previously known as MemSQL, is a highly scalable and distributed SQL database that can operate in any environment. It is designed to provide exceptional performance for both transactional and analytical tasks while utilizing well-known relational models. This database supports continuous data ingestion, enabling operational analytics critical for frontline business activities. With the capacity to handle millions of events each second, SingleStore ensures ACID transactions and allows for the simultaneous analysis of vast amounts of data across various formats, including relational SQL, JSON, geospatial, and full-text search. It excels in data ingestion performance at scale and incorporates built-in batch loading alongside real-time data pipelines. Leveraging ANSI SQL, SingleStore offers rapid query responses for both current and historical data, facilitating ad hoc analysis through business intelligence tools. Additionally, it empowers users to execute machine learning algorithms for immediate scoring and conduct geoanalytic queries in real-time, thereby enhancing decision-making processes. Furthermore, its versatility makes it a strong choice for organizations looking to derive insights from diverse data types efficiently.

Trino is a remarkably fast query engine designed to operate at exceptional speeds. It serves as a high-performance, distributed SQL query engine tailored for big data analytics, enabling users to delve into their vast data environments. Constructed for optimal efficiency, Trino excels in low-latency analytics and is extensively utilized by some of the largest enterprises globally to perform queries on exabyte-scale data lakes and enormous data warehouses. It accommodates a variety of scenarios, including interactive ad-hoc analytics, extensive batch queries spanning several hours, and high-throughput applications that require rapid sub-second query responses. Trino adheres to ANSI SQL standards, making it compatible with popular business intelligence tools like R, Tableau, Power BI, and Superset. Moreover, it allows direct querying of data from various sources such as Hadoop, S3, Cassandra, and MySQL, eliminating the need for cumbersome, time-consuming, and error-prone data copying processes. This capability empowers users to access and analyze data from multiple systems seamlessly within a single query. Such versatility makes Trino a powerful asset in today's data-driven landscape.

OpenText Analytics Database is a cutting-edge analytics platform designed to accelerate decision-making and operational efficiency through fast, real-time data processing and advanced machine learning. Organizations benefit from its flexible deployment options, including on-premises, hybrid, and multi-cloud environments, enabling them to tailor analytics infrastructure to their specific needs and lower overall costs. The platform’s massively parallel processing (MPP) architecture delivers lightning-fast query performance across large, complex datasets. It supports columnar storage and data lakehouse compatibility, allowing seamless analysis of data stored in various formats such as Parquet, ORC, and AVRO. Users can interact with data using familiar languages like SQL, R, Python, Java, and C/C++, making it accessible for both technical and business users. In-database machine learning capabilities allow for building and deploying predictive models without moving data, providing real-time insights. Additional analytics functions include time series, geospatial, and event-pattern matching, enabling deep and diverse data exploration. OpenText Analytics Database is ideal for organizations looking to harness AI and analytics to drive smarter business decisions.

Firebolt offers incredible speed and flexibility to tackle even the most daunting data challenges. By completely reimagining the cloud data warehouse, Firebolt provides an exceptionally rapid and efficient analytics experience regardless of scale. This significant leap in performance enables you to process larger datasets with greater detail through remarkably swift queries. You can effortlessly adjust your resources to accommodate any workload, volume of data, and number of simultaneous users. At Firebolt, we are committed to making data warehouses far more user-friendly than what has traditionally been available. This commitment drives us to simplify processes that were once complex and time-consuming into manageable tasks. Unlike other cloud data warehouse providers that profit from the resources you utilize, our model prioritizes transparency and fairness. We offer a pricing structure that ensures you can expand your operations without incurring excessive costs, making our solution not only efficient but also economical. Ultimately, Firebolt empowers organizations to harness the full potential of their data without the usual headaches.

HEAVY.AI is a pioneer in accelerated analysis. The HEAVY.AI platform can be used by government and business to uncover insights in data that is beyond the reach of traditional analytics tools. The platform harnesses the huge parallelism of modern CPU/GPU hardware and is available both in the cloud or on-premise. HEAVY.AI was developed from research at Harvard and MIT Computer Science and Artificial Intelligence Laboratory. You can go beyond traditional BI and GIS and extract high-quality information from large datasets with no lag by leveraging modern GPU and CPU hardware. To get a complete picture of what, when and where, unify and explore large geospatial or time-series data sets. Combining interactive visual analytics, hardware accelerated SQL, advanced analytics & data sciences frameworks, you can find the opportunity and risk in your enterprise when it matters most.

Apache Kylin™ is a distributed, open-source Analytical Data Warehouse designed for Big Data, aimed at delivering OLAP (Online Analytical Processing) capabilities in the modern big data landscape. By enhancing multi-dimensional cube technology and precalculation methods on platforms like Hadoop and Spark, Kylin maintains a consistent query performance, even as data volumes continue to expand. This innovation reduces query response times from several minutes to just milliseconds, effectively reintroducing online analytics into the realm of big data. Capable of processing over 10 billion rows in under a second, Kylin eliminates the delays previously associated with report generation, facilitating timely decision-making. It seamlessly integrates data stored on Hadoop with popular BI tools such as Tableau, PowerBI/Excel, MSTR, QlikSense, Hue, and SuperSet, significantly accelerating business intelligence operations on Hadoop. As a robust Analytical Data Warehouse, Kylin supports ANSI SQL queries on Hadoop/Spark and encompasses a wide array of ANSI SQL functions. Moreover, Kylin’s architecture allows it to handle thousands of simultaneous interactive queries with minimal resource usage, ensuring efficient analytics even under heavy loads. This efficiency positions Kylin as an essential tool for organizations seeking to leverage their data for strategic insights.

QuestDB is an advanced relational database that focuses on column-oriented storage optimized for time series and event-driven data. It incorporates SQL with additional features tailored for time-based analytics to facilitate real-time data processing. This documentation encompasses essential aspects of QuestDB, including initial setup instructions, comprehensive usage manuals, and reference materials for syntax, APIs, and configuration settings. Furthermore, it elaborates on the underlying architecture of QuestDB, outlining its methods for storing and querying data, while also highlighting unique functionalities and advantages offered by the platform. A key feature is the designated timestamp, which empowers time-focused queries and efficient data partitioning. Additionally, the symbol type enhances the efficiency of managing and retrieving frequently used strings. The storage model explains how QuestDB organizes records and partitions within its tables, and the use of indexes can significantly accelerate read access for specific columns. Moreover, partitions provide substantial performance improvements for both calculations and queries. With its SQL extensions, users can achieve high-performance time series analysis using a streamlined syntax that simplifies complex operations. Overall, QuestDB stands out as a powerful tool for handling time-oriented data effectively.