Feeds

Mainframe now obsolete for data warehousing

Let Intel inherit the earth?

High performance access to file storage

Reg Reader Workshop Many would have argued in the past that a data warehouse was not a "real" data warehouse unless it existed the in big iron mainframe number crunching environment.

A bit of a generalisation maybe, but when you look at where many of the big banks, insurance companies, retailers and telcos stick their transaction data for analysis even today, it is clear that mainframe class equipment has traditionally been a key part of the overall data warehousing landscape since most people can remember.

Recently though, someone trying to sell me on the merits of using scaled-out Intel based architectures running Windows or Linux made the claim that the mainframe was now pretty much obsolete for things like data warehousing.

I could see his point given the way so called commodity hardware platforms and the database management systems that run on them such as SQL Server, Oracle and MySQL have evolved. The argument is that the cost of these is a fraction of the premium you would pay for the mainframe equivalent, and that things like performance, scalability, manageability, and security are now generally on a par.

Shortly afterwards, however, I happened to be on the receiving end of an IBM mainframe data warehousing pitch, which I have to say was pretty convincing. With the introduction of an offload engine called the Integrated Information Processor (zIIP), which allows certain business intelligence type queries to be routed and executed separately and optimally from the main processor, IBM appeared to be fighting back hard - especially when you add some of the commercial elements into the mix.

In terms of business case, for example, you're unlikely to go out and buy a Series z box for data warehousing purposes if you don't already have one, so the real comparison is the incremental investment of implementing a new warehousing solution on an existing mainframe versus the typical situation of buying, installing, and optimising all of the platform components you need for an new Intel based solution. When you look at it this way and try to ignore all of the fudge factors advocates of one approach or the other try to throw into the mix, the numbers seem pretty close.

Before all you fans of other platforms reach for flamethrowers, yes, of course it's not just about mainframe versus Intel. This raises a question, however. How you go about selecting a platform (or platforms) for a data warehousing project given that requirements range from the big to the small to the distributed/federated, and there are so many options available?

If you have been through this process recently, or just have some thoughts on the matter, we'd love to hear from you in the discussion below. ®

High performance access to file storage

More from The Register

next story
Audio fans, prepare yourself for the Second Coming ... of Blu-ray
High Fidelity Pure Audio – is this what your ears have been waiting for?
Dropbox defends fantastically badly timed Condoleezza Rice appointment
'Nothing is going to change with Dr. Rice's appointment,' file sharer promises
Zucker punched: Google gobbles Facebook-wooed Titan Aerospace
Up, up and away in my beautiful balloon flying broadband-bot
Nokia offers 'voluntary retirement' to 6,000+ Indian employees
India's 'predictability and stability' cited as mobe-maker's tax payment deadline nears
Apple DOMINATES the Valley, rakes in more profit than Google, HP, Intel, Cisco COMBINED
Cook & Co. also pay more taxes than those four worthies PLUS eBay and Oracle
MtGox chief Karpelès refuses to come to US for g-men's grilling
Bitcoin baron says he needs another lawyer for FinCEN chat
It may be ILLEGAL to run Heartbleed health checks – IT lawyer
Do the right thing, earn up to 10 years in clink
France bans managers from contacting workers outside business hours
«Email? Mais non ... il est plus tard que six heures du soir!»
Adrian Mole author Sue Townsend dies at 68
RIP Blighty's best-selling author of the 1980s
prev story

Whitepapers

Mainstay ROI - Does application security pay?
In this whitepaper learn how you and your enterprise might benefit from better software security.
Five 3D headsets to be won!
We were so impressed by the Durovis Dive headset we’ve asked the company to give some away to Reg readers.
3 Big data security analytics techniques
Applying these Big Data security analytics techniques can help you make your business safer by detecting attacks early, before significant damage is done.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Mobile application security study
Download this report to see the alarming realities regarding the sheer number of applications vulnerable to attack, as well as the most common and easily addressable vulnerability errors.