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

    Requires Free Membership to View

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 first published in May 2011

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: