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?
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.
Dig Deeper on IBM DB2 management
Related Q&A from Mark Whitehorn
Here's a guide to primary, super, foreign and candidate keys, what they're used for in relational database management systems and the differences ... Continue Reading
The unstructured data types common in big data systems are often better managed by a NoSQL database than relational software, Mark Whitehorn says. Continue Reading
IT managers should ask cloud providers some pointed questions about the security of data stored in cloud databases, says expert Mark Whitehorn. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.