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.