Features of the IBM Db2 Big SQL solution include:
This SQL workload management system was designed with an advanced SQL compiler and cost-based optimizer so that it maintains high performance, concurrency, and scalability for analytical and complex SQL workloads. A SQL parser compliant with ANSI is provided so that TPC-DS queries can be run 99 times and structured streaming can be done with new APIs.
Integration with Apache Spark
Integrating Db2 Big SQL with Spark facilitates insight delivery and improves processing speeds. In addition to providing machine learning models with fresh data, this integration will enable them to be operationalized with data not only from Hadoop but also from other sources.
Db2 Big SQL can access data from Hadoop and relational databases, whether they are on-premise or in the cloud, through a single database connection. It can also enhance the virtualization process for different data warehouses by using Fluid Query. In addition, WebHDFS (technical preview only) and S3 Object Storage can also be federated.
Compatibility with multiple SQL dialects
The platform’s support for SQL dialects of a variety of RDBMS (including Db2, Netezza, and Oracle) makes it an ideal platform for offloading and easy consolidation of RDBMS data. By offloading data from existing enterprise data warehouses or data marts, capacity can be freed up while keeping most of the familiar SQL.
Integration with BLU Acceleration
Db2 Big SQL integrates BLU Acceleration, which includes columns-organized tables, actionable compression, data skipping, and scan-friendly memory caching as a technical preview.
Integration with YARN through Slider
By using Apache Slider, we improved integration with YARN, enabling the deployment of non-YARN services on YARN and better control over YARN resource allocation.
Db2 Big SQL is the only SQL engine that can successfully run all 99 TPCDS queries up to 100TB with multiple concurrent users. In addition, it is capable of running multiple workers on a single node to maximize CPU and memory utilization.
Db2 Big SQL includes robust role-based access control (RBAC), row-based dynamic filtering, column-based dynamic masking, and Apache Ranger integration for centralized data lake security administration and auditing.
Standards-compliant Open Database Connectivity and Java Database Connectivity
The usage pattern allows developers to access the database with specific tools or products that only allow Open Database Connectivity (ODBC) or JavaTM Database Connectivity (JDBC).
Point querying capabilities
Db2 Big SQL allows the use of short and rapid queries that search by keywords or combinations of keywords. It uses HBase when allowing random access to your data in real-time.
All Blue Solutions can provide IBM Db2 Big SQL managed service at any time, no matter where you are in the world.
Get in touch with one of our IBM Db2 Big SQL experts today.