Feeds

DB2 'Stinger' to pack powerful punch

Float like a butterfly...

  • alert
  • submit to reddit

Top 5 reasons to deploy VMware with Tegile

I have no idea of whether IBM had Cassius Clay (or even Mohammed Ali) in mind when it nicknamed the forthcoming release of DB2 UDB "Stinger", but the product certainly looks likely to pack a punch when it is released later this year.

Given that this is will be the first major release of DB2 UDB for 18 months, it is hardly surprising that there is a lot to it. It is equally unremarkable that I do not have enough space to cover all of its new features. For example, there is a lot of stuff to support .Net and Java Eclipse environments, as well as a number of other enhancements that developers will like. And, of course, there are performance and scalability improvements, and new security features, and so on and so forth.

However, what really stands out for me is the extended DBA (database administrator) capability. In particular, there are two features that are especially impressive: the Design Advisor and the product's Autonomic Management features.

Of course, the Design Advisor is not new. It is in the current product and it is used to advise the DBA on indexes he or she might build. However, it is now much more extensive and encompasses materialised query tables, indexes on those tables, multi-dimensional clusters, and partitioning. Moreover, it doesn't just provide you with suggestions but actually generates executable recommendations, which you can either run directly, or you can customise, or you can save them and reuse them, or whatever.

What is really neat about the new Design Advisor is not only that it takes away some of the repetitive (and boring) stuff that DBAs have to do, leaving them free for the more interesting parts of their job, but it also directly impacts on performance. This is because the Design Advisor is probably better than most of us humans at getting the right combination of performance enhancing functions. In tests, IBM is reporting a 6.5 times performance improvement from before and after using the Design Advisor.

While DB2's Autonomic Management features cover a range of different areas (which, again, I don't have space to cover) the most interesting is based on IBM's Learning Optimiser (LEO) project (which is ongoing). This provides continuous statistics monitoring and updating for the DB2 optimiser, rather than relying on the DBA to "Runstats" as and when he or she thought fit, which used to be the case.

Now, the obvious advantage of autonomic statistics updating is not only that you take another tedious task away from the DBA but also that the system can learn faster and better about itself and therefore update the optimiser more efficiently. However, there is a potential downside, which is the impact on run-time performance. In order to minimise this, IBM uses a form of query sampling named after one of the Bernouilli family (I don't know which one - there were lots of them in the 17th and 18th centuries - to the extent that they have been described as being to mathematics what the Bach family was to music), which is based on cardinality. What is particularly nice is that query sampling is not only used in gathering statistics, but IBM is also surfacing it as an extension to SQL so that you can use it as a pre-cursor to making more detailed queries for predictive analytics, say.

So, as I said, there is far too much in Stinger to cover in one article. I will be writing a full review of the product in due course.

© IT-Analysis.com

Related stories

IBM gets hot and spicy
IBM puts new DB2 up for inspection
End of the road for EAI?

Internet Security Threat Report 2014

More from The Register

next story
Microsoft to bake Skype into IE, without plugins
Redmond thinks the Object Real-Time Communications API for WebRTC is ready to roll
Microsoft promises Windows 10 will mean two-factor auth for all
Sneak peek at security features Redmond's baking into new OS
Mozilla: Spidermonkey ATE Apple's JavaScriptCore, THRASHED Google V8
Moz man claims the win on rivals' own benchmarks
FTDI yanks chip-bricking driver from Windows Update, vows to fight on
Next driver to battle fake chips with 'non-invasive' methods
PEAK APPLE: iOS 8 is least popular Cupertino mobile OS in all of HUMAN HISTORY
'Nerd release' finally staggers past 50 per cent adoption
DEATH by PowerPoint: Microsoft warns of 0-day attack hidden in slides
Might put out patch in update, might chuck it out sooner
Ubuntu 14.10 tries pulling a Steve Ballmer on cloudy offerings
Oi, Windows, centOS and openSUSE – behave, we're all friends here
Was ist das? Eine neue Suse Linux Enterprise? Ausgezeichnet!
Version 12 first major-number Suse release since 2009
prev story

Whitepapers

Why cloud backup?
Combining the latest advancements in disk-based backup with secure, integrated, cloud technologies offer organizations fast and assured recovery of their critical enterprise data.
A strategic approach to identity relationship management
ForgeRock commissioned Forrester to evaluate companies’ IAM practices and requirements when it comes to customer-facing scenarios versus employee-facing ones.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Top 5 reasons to deploy VMware with Tegile
Data demand and the rise of virtualization is challenging IT teams to deliver storage performance, scalability and capacity that can keep up, while maximizing efficiency.
Mitigating web security risk with SSL certificates
Web-based systems are essential tools for running business processes and delivering services to customers.