IBM Db2 Big SQL V6.0 on HDP 3.1 is now available

IBM Db2 Big SQL V6.0 on HDP 3.1 is now available Learn more

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 HDFS, RDMS, NoSQL databases, object stores and WebHDFS. Benefit from low latency, high performance, security, SQL compatibility and federation capabilities to do ad hoc and complex queries.

Read the Cabot Partners Group, Inc., white paper: Total Value of Ownership (TVO) Assessment of the IBM + Hortonworks Solution for Analytics

Announcement: Db2 Big SQL is now part of the IBM Hybrid Data Management Platform

 

Product benefits

Icon representing the capability of Db2 Big SQL to access, query and analyze data across data warehouse and Hadoop

Access, query and analyze data across data warehouse and Hadoop

Understands commonly used ANSI SQL syntax to support batch and real-time data.

Icon representing the capability of Db2 Big SQL to scale with hybrid cloud-ready flexibility

Scale with hybrid cloud-ready flexibility

Shift workloads within public and private cloud and on-premises environments based on your application requirements.

Icon representing the capability of Db2 Big SQL to drive real-time analytics with Apache Spark integration

Drive real-time analytics with Apache Spark integration

Concurrently exploit Hive, Hbase and Spark, using a single database connection — even a single query.

Icon representing the capability of Db2 Big SQL to connect your data scientists to their data

Connect your data scientists to their data

Use IBM Data Science Experience and existing Jupyter Notebooks to federate to RDRMS and to Oracle, Db2 and Netezza®.

Icon representing the capability of Db2 Big SQL to access data where it resides

Access data where it resides

Where all data cannot be moved into your Hadoop system, Db2 Big SQL has unique capabilities to federate the data assets across the enterprise.

Icon representing the capability of Db2 Big SQL to improve query performance

Improve query performance

Run all 99 TPC-DS queries up to 100 TB with numerous concurrent users. Db2 Big SQL supports multiple workers per node for efficient CPU and memory utilization.

Product images

Next Steps