Best OLAP Databases for JMP Statistical Software

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora is five times faster that standard MySQL databases and three time faster than standard PostgreSQL database. It offers the same security, availability, reliability, and cost-effectiveness as commercial databases, but at a fraction of the cost. Amazon Aurora is fully managed and maintained by Amazon Relational Database Service, (RDS). This automates tedious administration tasks such as hardware provisioning, database setup, patching and backups. Amazon Aurora is a distributed, fault-tolerant and self-healing storage that auto-scales up 64TB per database instance. It offers high availability and performance with up to 15 low latency read replicas, point in time recovery, continuous backup to Amazon S3, replication across threeAvailability Zones, and continuous backup to Amazon S3.

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.

SAP HANA is an in-memory database with high performance that accelerates data-driven decision-making and actions. It supports all workloads and provides the most advanced analytics on multi-model data on premise and in cloud.

IBM Db2®, a family of hybrid data management tools, offers a complete suite AI-empowered capabilities to help you manage structured and unstructured data both on premises and in private and public clouds. Db2 is built upon an intelligent common SQL engine that allows for flexibility and scalability.