5 Things to Know about What's New in BLU
PhilipMonson 11000074CG Visits (9084)
This blog was written by Sam Lightstone, Distinguished Engineer & Chief Architect Data Warehousing IBM Information Management
DB2 10.5 “Cancun” with BLU Acceleration takes a leap forward in simplicity, performance, availability, function, and cloud services. Here are 5 things you need to know about the enhancements to BLU Acceleration:
1. Load-and-go simplicity. Miraculously, and still unique in the industry, BLU Acceleration adapts automatically to any server, from gigabytes to terabytes of RAM, from 2 cores to 128. Workload management is enabled right out of the box. Compression algorithms adapt to your data. Storage is auto-managed. Just wonderful out of the box performance, and a concomitant stop-watch-checking time to value.
2. Phenomenal Performance. Queries are now 35X-73X typical speedup over traditional row-organized tables with indexing. DB2 Cancun is now dramatically faster than the already amazing performance produced in BLU Acceleration in prior versions. We’ve measured average speed-up over the previous version of BLU Acceleration in DB2 10.5 FP1 of 1.7X across several customer workloads and industry standard benchmarks. The TPC-DS workload is notably more than 3X faster. Performance rates like this make it necessary for BLU Acceleration to break the memory barrier, and process data faster than RAM channel speeds. It’s not just about query speeds that have improved. Now ELT is also dramatically improved with point UPDATE / DELETE processing as much as 80X faster. And there are many other ELT enhancements, including INGEST utility speed-up by 3X.
3. Mixed OLTP & Reporting – We’ve introduced Shadow Tables, enabling mixed workloads, with real examples of 10X speed-up, and multiple early customer reference quotes. The DB2 Cancun technology is hands down best of class. For one thing, it does not require all of the user data to fit into memory. In fact, in most cases database memory for the column-organized data can be less than 5% the size of the original user data and run with in-memory optimized performance.
4. New function with Oracle compatibility and HADR. We’ve taken DB2’s SQL Compatibility mode (In my experience 98%-100% compatible with Oracle by line of code for most customer applications) and enabled it lock stock and barrel with BLU Acceleration. There some very compelling reasons to move applications to DB2 from Oracle. It’s lower cost, easier to manage, and did I mention the blazing speed thing? Got Oracle reporting or BI applications? They can now run easily with BLU Acceleration. Similarly, we’ve added HADR support. As reporting and business intelligence functions become increasingly mission critical, who can afford for systems to go offline? With DB2’s mature High Availability Disaster Recovery (HADR) we now have a tried-and-true environment to keep the benefits of BLU Acceleration available in the presence of system failure or geo-local disasters. Sensational.
5. ‘dashDB’ Brings BLU Acceleration to the cloud, along with Netezza analytic technology. We’ve delivered near simultaneous code to both our on-premises customers using DB2 Cancun as an installable software product as well as making the DB2 Cancun engine with BLU Acceleration available for customers in the cloud, as the “dashDB” on BlueMix. This is a key element of IBM’s cloud portfolio. Low cost, no IT infrastructure to procure or configure, no OS or database installation, and best of all it’s a fully managed service, not just “infrastructure as a service”. Some companies offer “cloud computing” that is really just a collection of servers on the Internet for you to manage, but we believe that cloud computing means simplicity – so IBM manages the entire system for you at no additional cost. dashDB is more than BLU, it extends the technology with Netezza originated algorithms for R and spatial analytics. It’s amazingly Agile, and we’ve been impressed by how quickly customers can start developing and running apps with it. (See more in my dashDB post here )