IBM Db2 Big SQL now available on IBM Cloud Pak® for Data

Overview

Benefits

Quickly query across platforms

Various shapes with interconnecting lines

Access and analyze data and perform queries on batch and real-time data across sources, like Hadoop, object stores and data warehouses.

Flexibly scale

Two three-dimensional shapes

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

Clock symbol

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

Triangle inscribed in a hexagon

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

Graph with exponential trend line

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.

Use cases

Better data-driven decisions

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

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.

Product images

Complex querying

Screenshot of Db2 Big SQL service landing page

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

Screenshot of Db2 Big SQL metrics dashboard

Monitoring capabilities

Monitor service metrics with intuitive dashboards help to identify the root causes of slowdowns, helping to maximize resources and performance.

Simplified deployment

Screenshot of service instance creation

Simplified deployment

Db2 Big SQL has a simplified deployment experience, helping to easily create service instances and allocate resources.

Dynamic scaling

Screenshot of instance configurator

Dynamic scaling

Based on workload needs, scale the instance up or down by allocating additional or fewer resources.

Resources

Using your Db2 skills with big data

Community

Documentation