SQL processing features

Standards-compliant ODBC and JDBC

Any software that supports ODBC or JDBC can connect and use Db2 Big SQL.

Learn more: Db2 Big SQL connections

Compatibility with multiple SQL flavors

Db2 Big SQL works on generic ANSI SQL as well as SQL types specific to Db2 database, IBM Netezza data warehouse appliances, and Oracle database. This makes the platform well suited for fast and easy consolidation. You can offload Data with RDBMS from existing enterprise data warehouses or data marts to free up capacity while preserving most of the familiar SQL data. When you offload data from Oracle, Db2 or Netezza, you can easily port the applications with only minimal changes required. This simplifies the planning and execution of data warehouse offloading use cases as well as time and money spent on re-writing applications for Hadoop.

SQL compatibility and the ANSI SQL-compliant engine in Db2 Big SQL enables seamless transfer of applications and SQL skills to execute SQL statements and procedural language (SQL PL, NZPLSQL and PL/SQL). Db2 Big SQL is tightly integrated with the Hortonworks Data Platform (HDP) to provide a robust, reliable, and resilient environment to maximize existing business and identify new business opportunities.

Db2 Big SQL is a synergetic SQL engine that offers SQL compatibility, portability and collaborative ability to get composite analysis on data

Learn more: SQL compatibility, Db2 standards compliance

Point queries

Point queries are queries that look up information, usually from a single table. For applications that do point queries, we recommend creating Db2 Big SQL tables that are on top of HBase tables rather than using Hive tables. HBase is a key/value store and can quickly look up data in an HBase table by key or key range. Db2 Big SQL contains functionality that enables you to create short rapid queries that search by key or key ranges. It uses HBase for point queries and rapid insert, update and delete.

Complex queries

Db2 Big SQL adheres to standard SQL syntax, allowing it to handle large, complex queries and allowing you to use system-generated complex queries.

The 99 queries in the TPC-DS^® benchmark contain a wide variety of SQL syntax including INTERSECT, EXCEPT, and ROLLUP. The TPC-DS queries range in complexity from fairly simple to very complex. Db2 Big SQL is able to run all 99 queries as-is or with allowed minor query modifications.

Apache Spark integration

Db2 Big SQL applications can treat Spark as a powerful analytic co-processor that complements the rich SQL functionality available in Db2 Big SQL. Db2 Big SQL users, who already enjoy the best SQL performance, richest SQL language, and extensive enterprise capabilities, can also leverage Spark for its non-relational distributed processing capabilities and rich analytic libraries. The capabilities of both engines are seamlessly blended in a single SQL statement, with large volumes of data flowing efficiently between them.

Learn more: Apache Spark