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?).
Dig Deeper on Database management system (DBMS) software and technology
Related Q&A from Mark Whitehorn
Here's a guide to primary, super, foreign and candidate keys, what they're used for in relational database management systems and the differences ... Continue Reading
The unstructured data types common in big data systems are often better managed by a NoSQL database than relational software, Mark Whitehorn says. Continue Reading
IT managers should ask cloud providers some pointed questions about the security of data stored in cloud databases, says expert Mark Whitehorn. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.