IBM has its own massively parallel processing (MPP) database. How does it fare against Teradata's? Wouldn't it be prudent to go with that option for DB2 (relational) users?

    Requires Free Membership to View

Yes, DB2 is indeed available in  massively parallel processing (MPP) form and MPP is Teradata's natural operating mode. I wouldn't choose between them on the basis of manufacturer; I'd make the choice based on the requirements, because the two systems are designed to do different jobs.

DB2 is essentially designed to be a transactional database and comes in standard and MPP versions. Teradata is designed as a data warehousing system.

Unlike other warehouse systems, Teradata is based on the relational model and the use of MPP technology gives Teradata a huge edge in the real-time world.

With virtually every other warehouse system you load data into it by batch processing extract, transform and load (ETL) routines — typically overnight — and then there is a pause, often of several hours, while the data is indexed, aggregated and generally readied for querying. With Teradata's Enterprise Data Warehouse (EDW) you can load in data much more frequently and it is available for querying immediately.

So, if your goal is data warehousing with real-time analytics, check out Teradata. If you need a fast, MPP transactional database, check out DB2.

 

This was first published in June 2009

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: