Feeds

Dataupia: a utopian vision for databases?

MPP offering could give vendors no place to hide

5 things you didn’t know about cloud backup

Over the course of the last few months I have written a couple of times speculating on the development of appliances that might be more generally deployed than the very specific products we have seen to date.

In particular, in my last article on this subject I discussed the scope for improving the performance of merchant databases by replacing their horizontal approach to data management with a more vertical MPP (massively parallel processing) based solution that could be packaged as an appliance. Just such an offering has now been released by Dataupia.

As far as the technology is concerned, this is based on Dual Opteron based Blades, each of which has 2Tb capacity on eight attached RAID drives. Additional units, of the same capacity, can be added on demand and as required.

On the software side, Dataupia runs on Linux (which you don't touch) and plugs into the top layer of the Oracle (or DB2 or SQL Server) execution engine and then Dataupia takes over execution of database primitives (parse, joins and so forth) and storage management (which you will no longer need to administer) from the database.

There is a utility provided to extract or replicate data from existing storage media and there is a fast indexing facility that runs in the background even while you are loading or working on the data. As one might expect from an appliance, high availability is built-in, together with back-up and restore capabilities.

Perhaps the most important additional point to note is that the implementation of Dataupia has no impact (except to make them run much faster) on your existing applications. That is, your applications do not need to be changed in any way, they simply run against the Oracle, SQL Server, or DB2 database as they always have.

In theory, Dataupia could be used to improve the performance of any type of database installation using one of the merchant databases mentioned. However, in practice, most OLTP systems are not large enough to warrant the uses of such a solution - here, clustering or grid technology is probably more appropriate to speed up the environment.

At the other extreme, Dataupia is not aimed at the very high performance of the data warehouse appliance vendors such as Netezza and DATAllegro. In practice, therefore, Dataupia is targeting the enterprise data warehouse (EDW) market, especially where you need or would like to keep large amounts of historic data on line so that you can do things such as better account management, and more accurate forecasting.

In practice, the sheer volume of data required to have a longer-term perspective has meant that it has been cost prohibitive for many organisations, but Dataupia makes this much more affordable, delivering multi-terabyte solutions without any application porting costs, and at a fraction of the cost of traditional approaches.

The advent of Dataupia is likely to make as much of a disturbance within the market as Netezza did when it first appeared. In particular, it will strengthen the positions of the merchant databases against any rivals that do not integrate with Dataupia such as Teradata and Sybase, as well as newcomers like HP. It will also inevitably impact on the success of vendors as they seek to add EDW capabilities to their existing offerings, as well as to new entrants into the market such as Vertica.

Of course, utopia literally means "no place": if Dataupia is the success that it promises to be then any vendor that does not either partner with it or develop comparable technology of its own, will be likely to find itself with no place to hide.

Copyright © 2007, IT-Analysis.com

Build a business case: developing custom apps

More from The Register

next story
Microsoft: Azure isn't ready for biz-critical apps … yet
Microsoft will move its own IT to the cloud to avoid $200m server bill
Shoot-em-up: Sony Online Entertainment hit by 'large scale DDoS attack'
Games disrupted as firm struggles to control network
Silicon Valley jolted by magnitude 6.1 quake – its biggest in 25 years
Did the earth move for you at VMworld – oh, OK. It just did. A lot
VMware's high-wire balancing act: EVO might drag us ALL down
Get it right, EMC, or there'll be STORAGE CIVIL WAR. Mark my words
Forrester says it's time to give up on physical storage arrays
The physical/virtual storage tipping point may just have arrived
Better be Nimble, tech giants, or mutant upstarts will make off with your sales
Usual suspects struggling to create competing products
VMware vaporises vCHS hybrid cloud service
AnD yEt mOre cRazy cAps to dEal wIth
prev story

Whitepapers

A new approach to endpoint data protection
What is the best way to ensure comprehensive visibility, management, and control of information on both company-owned and employee-owned devices?
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.
Maximize storage efficiency across the enterprise
The HP StoreOnce backup solution offers highly flexible, centrally managed, and highly efficient data protection for any enterprise.
How modern custom applications can spur business growth
Learn how to create, deploy and manage custom applications without consuming or expanding the need for scarce, expensive IT resources.
Next gen security for virtualised datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.