How to select an MPP database: DB2 vs. Teradata
Should you run a massively parallel processing (MPP) database with DB2 or Teradata? Find out how to compare DB2 vs. Teradata and how to choose a database system and with advice from a data warehouse expert.
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?
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.
Dig Deeper on Database management
Related Q&A from Mark Whitehorn
DBMS keys: 8 types of keys defined
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
Do predictive analytics projects require data scientists?
Expert Mark Whitehorn explains what skills are required for predictive modeling -- and whether business users can do the work of data scientists. Continue Reading
Key issues to consider when building a data warehouse
There are numerous issues, both technical and cultural, that organizations need to consider before building a data warehouse. Learn what they are ... Continue Reading