Learn about 1.5x improved load time and other enhancements in Db2 11.5.8 cloud-first
Overview
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.
IBM Db2 Big SQL now available on IBM Cloud Pak® for Data
Use cases
Data warehouse modernization
Data warehouse modernization
Free up bandwidth and storage. Cloudera Enterprise Data Hub and Db2 Big SQL provide a superior platform for offloading historical or cold data in Oracle data marts and warehouses to Hadoop.
Real-time data queries
Real-time data queries
Equip your data users with the right tools including Db2 Big SQL integrated with Apache Spark so they can do ad hoc and real-time queries to meet the needs of the business.
Operational improvements
Operational improvements
Use virtualization and federation to unify data access across the logical enterprise data warehouse, cloud and Hadoop for more accurate data-driven decisions.
Demos and tutorials
Product images
Complex querying
Complex querying
Db2 Big SQL's robust engine executes complex queries for relational data and Hadoop data, making querying enterprise data from across the organization an easy and secure experience.
Monitoring capabilities
Monitoring capabilities
Monitor service metrics with intuitive dashboards help to identify the root causes of slowdowns, helping to maximize resources and performance.
Simplified deployment
Simplified deployment
Db2 Big SQL has a simplified deployment experience, helping to easily create service instances and allocate resources.
Dynamic scaling
Dynamic scaling
Based on workload needs, scale the instance up or down by allocating additional or fewer resources.