IBM Db2 Big SQL

A hybrid SQL-on-Hadoop engine delivering advanced, security-rich data query across enterprise big data sources, including Hadoop, object storage and data warehouses

Person studying information on laptop

Overview

Work across all your sources

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.

IBM Db2 Big SQL now available on IBM Cloud Pak® for Data
Try watsonx.data

Features

Unlock value from your data

Break down data silos

Access and analyze data across sources, including Hadoop, object stores, data warehouses, and relational data. Db2 Big SQL executes complex queries across enterprise data through a single engine and database connection.

Product screen Complex querying Db2 Big SQL charts and statistics

Keep workloads running efficiently

Monitor service metrics with intuitive dashboards to identify the root causes of slowdowns and maximize resources and performance. Support numerous concurrent users and efficient resource utilization through multiple workers per node.

Product screen Monitoring capabilites Db2 Big SQL

Reduce setup complexity

Create service instances and allocate resources with a simplified deployment experience, helping teams get started quickly and manage environments more efficiently.

Product screen Simplified deployment Db2 Big SQL

Adapt resources to changing demand

Scale instances up or down based on workload needs and shift workloads across public cloud, private cloud, and on-premises environments to meet changing requirements.

Product screen Dynamic scaling Db2 Big SQL

Get insights when they matter most

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.

Woman looking at multiple screens with data analytics in real time

Extend your analytics ecosystem

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®.

Woman working looking at screens with data

Use cases

Modernize and scale your data

Better data-driven decisions

Integrate new forms of semi and unstructured data (social media, sentiment, streaming audio/video, log and more) with your traditional structured data using advanced querying capabilities.

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

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

Use virtualization and federation to unify data access across the logical enterprise data warehouse, cloud and Hadoop for more accurate data-driven decisions.

Resources

Discover expert resources

Read blogs from IBM subject matter experts, learn from the experiences of fellow Db2 users, and take the opportunity to share your own best practices.

Take the next step

Get started with IBM Db2 Big SQL.

  1. Try the free edition