Home
Topics
Database management systems (DBMS)
Database management system (DBMS) software and technology
The benefits and drawbacks of analytical databases

Answer

The benefits and drawbacks of analytical databases

Mark Whitehorn, Co-Founder, PenguinSoft Consulting Ltd.

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

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

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?).

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary

This was first published in May 2011

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Business Analytics
Data Management UK
Content Management
Oracle
SAP
SOA
SQL Server

Business Analytics
- No more shortcuts: Sound data quality strategy a must for BI success
  
  In the past, companies might have gotten away with not building data quality efforts into business intelligence programs. That's less likely now.
- Member Exclusive Downloads
  
  Member Exclusive Downloads from SearchBusinessAnalytics
- In-memory applications take on big data analytics challenge
  
  In-memory tools and big data can be a potent analytics mix. But before you put them together, read advice from experienced users and consultants.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Content Management
- Cloud collaboration software connects at networking company Enterasys
  
  Enterasys Networks ended up with more users than expected when it deployed a cloud-based collaboration system. But that turned out to be a good thing.
- Data value chain puts the focus on what matters most to a business
  
  In his career running data management systems for consumer goods companies, Richard Beaver has found a formula for success: the data value chain.
- Quiz: Implementing digital asset management systems
  
  Take this quiz to test your knowledge of digital asset management (DAM) technologies and processes.
Oracle
- The future of Dell Toad: Oracle DBAs can use BI, Exadata features
  
  Dell Toad is pushing itself into business intelligence and now has an edition to support Oracle's big Exadata appliance.
- Unlock the potential of the Oracle Exadata architecture
  
  Despite being almost five years old now, many implementations haven't realized all of the Oracle Exadata architecture benefits.
- The state of Dell Toad: Oracle DBAs and how they can still benefit
  
  Since Dell acquired Quest Software, maker of the Toad tool for Oracle databases and applications, some questions have arisen about what would happen.
SAP
- Food bank network delivers with SAP mobility
  
  The nation's largest network of food banks is cutting out labor-intensive paper-bound processes with the help of SAP mobile technology.
- SAP adds hybris to its SAP CRM tool set: More choices, or confusion?
  
  One expert calls SAP's purchase of hybris long overdue. Another wonders if SAP is confusing its own SAP CRM customers.
- Limit returns, SAP procurement expenses with a stability study
  
  Stability studies, which measure how different materials respond to various conditions, can save companies huge amounts of money, writes Jawad Akhtar.
SOA
- Top four trends with intelligent integrated enterprises
  
  From the cloud to big data, there are major trends architects need to be aware of.
- XML appliances' evolving role in messaging protocol
  
  XML appliances have evolved. Jason Bloomberg, president of ZapThink, a Dovel Technologies company, gives an overview of the technology in this Q&A.
- API management, servers enable mobile, Web gift services strategy
  
  By exposing a network through application programming interfaces, Blackhawk Network is making the change from physical to digital cards.
SQL Server
- SQL Server 2014 'keeps up with the Joneses,' says analyst
  
  Ovum analyst Tony Baer says that most database platforms are moving toward in-memory features, and SQL Server 2014 is no different.
- SQL Server high availability: Natural enemy of virtualization?
  
  Do SQL Server high availability and virtualization go together or not? Find out if virtualization is a good option for you in this tip by Bob Sheldon.
- SQL Server 2014 due out in late 2013, in-memory OLTP a big feature
  
  Microsoft announced that the next version of its database, SQL Server 2014, will have in-memory features and be generally available in late 2013.

All Rights Reserved,Copyright 2005 - 2013, TechTarget