Feeds

Mainframe now obsolete for data warehousing

Let Intel inherit the earth?

The essential guide to IT transformation

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. ®

5 things you didn’t know about cloud backup

More from The Register

next story
Microsoft exits climate denier lobby group
ALEC will have to do without Redmond, it seems
Caught red-handed: UK cops, PCSOs, specials behaving badly… on social media
No Mr Fuzz, don't ask a crime victim to be your pal on Facebook
Barnes & Noble: Swallow a Samsung Nook tablet, please ... pretty please
Novelslab finally on sale with ($199 - $20) price tag
Ballmer leaves Microsoft board to spend more time with his b-balls
From Clippy to Clippers: Hi, I see you're running an NBA team now ...
Kate Bush: Don't make me HAVE CONTACT with your iPHONE
Can't face sea of wobbling fondle implements. What happened to lighters, eh?
Video of US journalist 'beheading' pulled from social media
Yanked footage featured British-accented attacker and US journo James Foley
Amazon takes swipe at PayPal, Square with card reader for mobes
Etailer plans to undercut rivals with low transaction fee offer
Assange™: Hey world, I'M STILL HERE, ignore that Snowden guy
Press conference: ME ME ME ME ME ME ME (cont'd pg 94)
Call of Duty daddy considers launching own movie studio
Activision Blizzard might like quality control of a CoD film
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
7 Elements of Radically Simple OS Migration
Avoid the typical headaches of OS migration during your next project by learning about 7 elements of radically simple OS migration.
BYOD's dark side: Data protection
An endpoint data protection solution that adds value to the user and the organization so it can protect itself from data loss as well as leverage corporate data.
Consolidation: The Foundation for IT Business Transformation
In this whitepaper learn how effective consolidation of IT and business resources can enable multiple, meaningful business benefits.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?