CTO Blog
« Delivering differentiation – with your sanity intact! | Main | Oracle OpenWorld: innovation. 2009 style. »
Business Intelligence with 1.3 Terabytes of in-memory Database
I recently blogged about changes in the meaning of business intelligence and how we can better use it to support real-time decision making. This raised a lot of great comments. Larry Ellison made his own impact on this topic with a webcast to introduce the second generation Oracle/Sun Exadata 2.0. This was an early indication of what Oracle hopes to achieve with the Sun acquisition. It raised all the usual comments on this unhappy with the acquisition given the resulting monopoly it would give Oracle in databases, due to gaining control of OpenSQLtopic, even including whether the approval for completion of the deal will go through (The EU is apparently ).
What was announced was the first online transaction processing database using Sun FlashFire technology to provide in a single 1u rack tray as a single cohesive unit. It has eighty flash drives and four SAS disk connections – providing a massive (multi terabytes) memory – with a capacity of one million input/output operations per second. This raises a lot of questions as to what exactly this is and how it works. You can get answers at the official Oracle Exadata FAQs site.
But behind all of this is the point that this is the first move in a shift towards using flash memory and solid state drives to fundamentally change the accessibility of stored data. This is an entire data warehouse ‘as an appliance’ with operational speeds for any dimension increased by 50 to 200 percent and a claimed cost reduction (over conventional methods) of 50 percent. This is potentially a game-changing move for anything that uses data and by that I mean high-speed accessing of data.
The normal situation is that an SQL relational database provides rapid transactional processing but for capabilities such as traditional business intelligence reporting, a cube structure is required. If you want to get into this side of matters in detail an interesting article was recently published on database journal about cubes and storage.
Now: back to business intelligence in the front office. This will mean analysing a lot of data, but it will almost certainly be unstructured. Traditionally that’s a ‘no no’. You need to structure the data and design a cube or similar approach to optimise the search. Put another way, you need to decide on the answer you are looking for before you can ask the question!
We are not yet at the point of having true ‘flat’ data, which would involve the capture of all unstructured information about market, enterprise, events - and offer the ability to find unforeseen relationships. But there is a strong move in that direction and we now need to get our thinking caps on, to see how we can use it to make a real difference with internal business intelligence.
As a pure personal issue - though it has got a bigger message - I would like to make mention of the rebranding of one of the oldest computing professional bodies in the world. The British Computer Society, BCS, was founded in 1957 and has always been the professional body for UK computing people. But the world is changing and with it the definition of those ‘people’ and so in recognition of this it becomes; ‘The Chartered Institute for IT – enabling the information society’. Its role is now described as:
‘BCS, The Chartered Institute for IT, promotes wider social and economic progress through the advancement of information technology science and practice’.
A sign of the times and it’s good to see one of the longest established professional bodies in the computing world moving decisively with the times to stay relevant to a new world of users.
TrackBacks
TrackBack URL for this entry: http://www.capgemini.com/cgi-bin/blog/mt-tb.cgi/1077
Post a comment
Subscribe
Recent Posts
- You are what you eat – or your enterprise is what it communicates
- Not another word on iPad or eBooks! But what about using it for Capgemini Debate TV?
- Why are clouds so hard to understand?
- Microsoft + HP; Oracle + Sun and IBM + IBM
- What do we want from business intelligence?
- Business and IT alignment is getting worse and data/information is the reason
- Jugaad v Lean – doing more with less
- CIOs have their say; the funding model is at the heart of it
- Unstructured Events Call for Unstructured Data (But in Context)
- Clouds – is this a critical insight into the mixed messages?


Comments
# on October 25, 2009 9:13 AM, Roberto Galoppini said:
Andy, actually I'm not unhappy with the Oracle-Sun merge. What concerns me most about the acquisition is the future ahead of vendor-controlled open source projects. In this respect MySQL is not a major concern, given - just to name the most visible - Monty Videnius's cleandar interest into giving MySQL a shining future.
So said, OpenOffice.org's future or Glassfish maybe more at risk, even if for different reasons. But this is not, or at least it shouldn't be, food for Mrs Kroes free software zealots. We live in the real world, open source as everything else has to find its own way.
Community-led projects and foundation-incubated projects are the way to go, I wish OOo and MySQL will get there, someday.
# on October 26, 2009 1:40 PM, andy mulholland said:
I think we are at a crossroads - the public or private debate is starting on multiple fronts as we add how to provision with clouds to the already runing positioning on open source or licensed models.
There are no 'free lunches' ie taking a vertical optimisation can work very well as Oracle is demonstrating but at a price to ...?
well thats the question isnt it?
If i may return to an earlier post on 'make, buy, open source, or share' http://www.capgemini.com/ctoblog/2009/08/build_buy_open_source_or_servi.php we need to not see everything in the same way anymore and that includes who sponsers Open Source which might well move towards being sponsered by vertical sector associations for business services at least. the real challenge is what happens to fundemental technology open source and who would sponser this?