IBM Db2 Big SQL

Feature spotlights

Standards-compliant ODBC and JDBC

Provides usage patterns, enabling developers to access databases using products or tooling that require ODBC or JDBC.

Point queries

Enables short, rapid queries that search by key word or key ranges. Uses HBase for point queries and rapid insert, and to update and delete workloads.

Apache Spark integration

Integrates with Spark for easier data delivery and faster processing. Provides an ANSI-compliant SQL parser that can run 99 TPC-DS queries and structured streaming with new APIs.

Federation capabilities

Uses a single database connection, enabling you to access big data across Hadoop and relational databases, whether they are on the cloud, on premises or both. Includes Fluid Query capabilities to enhance virtualization with data warehouses. You can also federate with object store and WebHDFS.

Compatibility with multiple SQL dialects

Understands SQL dialects from offerings such as IBM Db2 and Oracle databases. This helps support RDBMS offloading, and ensures fast and easy consolidation. Big data can be offloaded from existing enterprise data warehouses or data marts to free up capacity, while preserving most of the familiar SQL code.

Available on IBM Power

Supports IBM Open Power servers, enabling clients to run SQL and Spark on a family of advanced Linux servers.

FlexPoints Licensing

Take advantage of an entire suite of capabilities within the Hybrid Data Management Platform offering with the ability to scale when you want, as well as optimize your investments as your data architecture evolves. With this offering, you can now buy entitlement to the various capabilities included based on FlexPoints. FlexPoints do not expire and can be allocated to any capability within the offering, providing the flexibility to change the deployment mix.

View the resource

View moreView less