Q

The benefits and drawbacks of analytical databases

Find out what the benefits and drawbacks of analytical databases are. See how an analytic database compares to an OLTP database and what each is best suited for.

What are analytical databases, and what are some of their benefits and drawbacks?

Operational databases support online transactional processing (OLTP). They’re great, as that term suggests, for processing transactions. Indeed, they’re highly optimized for exactly that.

Optimization for transactions tends to mean, in practice, de-optimization for analysis. So, when we need to analyze data, we often extract it from OLTP systems and restructure it for analytical purposes. In other words, we create an analytical database. These systems, in turn, are very bad at doing transactions (updating customer accounts) but very good at handling analytical queries (how much cat food have we sold, month by month for the past five years, in Kansas?).

This was last published in May 2011

Dig Deeper on Database management system (DBMS) software and technology

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

SearchSOA

SearchSQLServer

Close