What is IBM® Db2® Big SQL?

IBM Db2 Big SQL is an enterprise-grade, hybrid ANSI-compliant SQL-on-Hadoop engine, delivering massively parallel processing (MPP) and advanced data query. Db2 Big SQL offers a single database connection or query for disparate sources such as Hadoop HDFS and WebHDFS, RDMS, NoSQL databases, and object stores. Benefit from low latency, high performance, data security, SQL compatibility, and federation capabilities to do ad hoc and complex queries.

Db2 Big SQL is now available in 2 variations. It can be integrated with Cloudera Data Platform, or accessed as a cloud-native service on the IBM Cloud Pak® for Data platform.

Benefits

• **Quickly query across platforms: **Access and analyze data and perform queries on batch and real-time data across sources, like Hadoop, object stores and data warehouses.
• **Flexibly scale: **Based on your requirements, shift workloads within public and private cloud and on-premises environments to achieve the hybrid cloud flexibility you need.
• **Drive real-time analytics: **Concurrently exploit Hadoop SQL queries across Hive, Hbase and Spark, using a single database connection — even a single query — to achieve analytics in real time.
• **Connect your data: **Make data available to data scientists and analysts with connections to IBM Watson® Studio and existing Jupyter Notebooks to federate to RDBMS and to Oracle, Db2 and IBM Netezza®.
• **Improve performance: **Numerous users can query at the same time, with the ability to run all 99 TPC-DS queries up to 100 TB, supporting multiple workers per node for efficient utilization.