I'm wondering why companies choose Teradata along with DB2. My company has a mainframe and good database maintenance on DB2, but some of our applications are using the Teradata database. I don't understand why the company is going for Teradata, while we have a very good database like DB2. Any idea why?
is a fabulous relational database engine that is optimized for transactional processing. So it is a great engine for running your operational databases.
Teradata is also a relational database engine
, but it is optimized for analytical queries, which is unusual for a relational database engine. So my guess is that your company is using DB2 to run its operational databases and, at regular intervals, is copying the data to the Teradata database for analysis.
Dig Deeper on IBM DB2 management
Here's a guide to primary, super, foreign and candidate keys, what they're used for in relational database management systems and the differences ...
The unstructured data types common in big data systems are often better managed by a NoSQL database than relational software, Mark Whitehorn says.
IT managers should ask cloud providers some pointed questions about the security of data stored in cloud databases, says expert Mark Whitehorn.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.