Gartner Research

Eventual Consistency and Its Implications: Can You Trust Your DBMS?

Published: 04 September 2015

ID: G00276734

Analyst(s): Rick Greenwald

Summary

Data consistency is the foundation of many business use cases; protecting that consistency is an essential responsibility of IT. Distributed DBMSs can allow data inconsistencies to appear. If a use case requires consistent data, you must understand the risks posed by eventual consistency approaches.

Table Of Contents

Comparison

Analysis

  • What Causes a Lack of Data Consistency?
  • How Do DBMSs Protect Data Consistency?
    • Consistency Issues
    • Consistency Tools
  • Why Is Data Consistency an Issue With Distributed DBMSs?
  • CAP Theorem
  • Consistency Versus Availability
  • Implications of Data Inconsistency
  • When Should You Consider Eventual Consistency?
  • Consistency in DBMSs
    • HBase
    • MapR
    • MongoDB
    • Cassandra
    • VoltDB
    • SQL Server
    • Oracle

Guidance

  • Choose the DBMS That Can Meet Your Consistency Requirements and Delivers the Greatest Benefits
  • Determine the Consistency Requirements of Your Workloads, Now and in the Future
  • Match Consistency Requirements to Potential DBMS Offerings

Gartner Recommended Reading

©2020 Gartner, Inc. and/or its affiliates. All rights reserved. Gartner is a registered trademark of Gartner, Inc. and its affiliates. This publication may not be reproduced or distributed in any form without Gartner’s prior written permission. It consists of the opinions of Gartner’s research organization, which should not be construed as statements of fact. While the information contained in this publication has been obtained from sources believed to be reliable, Gartner disclaims all warranties as to the accuracy, completeness or adequacy of such information. Although Gartner research may address legal and financial issues, Gartner does not provide legal or investment advice and its research should not be construed or used as such. Your access and use of this publication are governed by Gartner’s Usage Policy. Gartner prides itself on its reputation for independence and objectivity. Its research is produced independently by its research organization without input or influence from any third party. For further information, see Guiding Principles on Independence and Objectivity.

Already have a Gartner Account?

Become a client

Learn how to access this content as a Gartner client.