Access, query & analyze data across data warehouse & Hadoop
IBM Db2® Big SQL is a high performance SQL on Hadoop engine that runs complex queries at scale with high concurrency. Being a ANSI SQL compliant engine it provides enterprise querying capabilities to Hadoop and also enables data analytics across disparate data sources, such as HDFS, RDBMS, NoSQL databases, object stores and WebHDFS, with a single connection or query. With its ability to understand and process SQL dialects from Db2, Oracle, and Netezza, port applications easily as and when data is offloaded to Hadoop. With Db2 Big SQL, empower your SQL developers/applications to operationalize the ML models effortlessly.
Access data from disparate sources
Provides federation and integration capabilities, enabling you to virtualize and join disparate data sources in a single query.
Leverage SQL knowledge
Not only allows you to run SQL on Hadoop, but understands SQL dialects from Db2, Netezza, Oracle SQL and PL/SQL to enable unchanged porting of applications.
Improve query performance
Can run all 99 TPC-DS queries up to 100TB with numerous concurrent users. Supports multiple workers per node for efficient CPU and memory utilization.
Gain secure access to data
Provides centralized security administration using role-based access control, row-based dynamic filtering, column-based dynamic masking and ranger integration.
Explore key features
- Standards-compliant ODBC and JDBC
- Point queries
- Apache Spark integration
- Federation capabilities
- Compatibility with multiple SQL dialects
- Available on IBM Power
- Hybrid Flex
Product images
