Feeds

Dataupia: a utopian vision for databases?

MPP offering could give vendors no place to hide

Beginner's guide to SSL certificates

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

Beginner's guide to SSL certificates

More from The Register

next story
Azure TITSUP caused by INFINITE LOOP
Fat fingered geo-block kept Aussies in the dark
NASA launches new climate model at SC14
75 days of supercomputing later ...
Yahoo! blames! MONSTER! email! OUTAGE! on! CUT! CABLE! bungle!
Weekend woe for BT as telco struggles to restore service
You think the CLOUD's insecure? It's BETTER than UK.GOV's DATA CENTRES
We don't even know where some of them ARE – Maude
DEATH by COMMENTS: WordPress XSS vuln is BIGGEST for YEARS
Trio of XSS turns attackers into admins
Cloud unicorns are extinct so DiData cloud mess was YOUR fault
Applications need to be built to handle TITSUP incidents
BOFH: WHERE did this 'fax-enabled' printer UPGRADE come from?
Don't worry about that cable, it's part of the config
Astro-boffins start opening universe simulation data
Got a supercomputer? Want to simulate a universe? Here you go
prev story

Whitepapers

Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
Getting started with customer-focused identity management
Learn why identity is a fundamental requirement to digital growth, and how without it there is no way to identify and engage customers in a meaningful way.
How to determine if cloud backup is right for your servers
Two key factors, technical feasibility and TCO economics, that backup and IT operations managers should consider when assessing cloud backup.
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?
Internet Security Threat Report 2014
An overview and analysis of the year in global threat activity: identify, analyze, and provide commentary on emerging trends in the dynamic threat landscape.