Q
Problem solve Get help with specific problems with your technologies, process and projects.

Are there benefits to using both Teradata and a DB2 database?

Many companies use DB2 to run an operational database and use Teradata for analysis. Find out why this is an effective approach and why it makes sense to use both Teradata and DB2 databases in this expert Q/A with Mark Whitehorn.

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?
DB2 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.
This was last published in April 2009

Dig Deeper on IBM DB2 management

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSQLServer

Close