Questions tagged [consistency]

In database systems, a consistent transaction is one that does not violate any integrity constraints during its execution. If a transaction leaves the database in an illegal state, it is aborted and an error is reported.

Consistency is one of the ACID properties that ensures that any changes to values in an instance are consistent with changes to other values in the same instance. A consistency constraint is a predicate on data which serves as a precondition, post-condition, and transformation condition on any transaction.

518 questions
8
votes
2 answers

C++ ensuring a float size of 4 bytes

I need a cross-architecture way to ensure that a float will be 4 bytes (as is on 32-bit windows). For instance, in the structs I'm creating, I'm using __int32 instead of int to ensure an integer value that is 4 bytes long. How could I do this with a…
7
votes
1 answer

What is the difference between Sequential Consistency and Eventual Consistency?

There are two definitions I found on the Internet: Sequential consistency -- the result of any execution is the same as if the operations of all the processors were executed in some sequential order, and the operations of each individual processor…
7
votes
1 answer

Hazelcast: Questions regarding multi-node consistency

(I could not find a good source explaining this, so if it is available elsewhere, you could just point me to it) Hazelcast replicates data across all nodes in clusters. So, if data is changed in one of the nodes, does the node update its own copy…
gammay
  • 5,957
  • 7
  • 32
  • 51
7
votes
1 answer

Is it possible to run a Neo4j cluster with strong consistency?

The docs of Neo4j state that when running in HA mode, you get eventual consistency. This is a quote from that page: All updates will however propagate from the master to other slaves eventually so a write from one slave may not be immediately…
falconizer
  • 408
  • 5
  • 11
7
votes
2 answers

How can MySQL Cluster 7.3 achieve 99,999% Availability? Antithesis to CAP Theorem

According to the "Guide to Scaling Web Databases with MySQL Cluster", MySQL Cluster 7.3 can acchieve 99,999% availability while using synchronous update replication. This would be a antithesis to the CAP Theorem since it states that perfect…
NorRen
  • 711
  • 2
  • 9
  • 22
7
votes
3 answers

Combining Neo4J and MongoDB : Consistency

I am experimenting a lot these days, and one of the things I wanted to do is combine two popular NoSQL databases, namely Neo4j and MongoDB. Simply because I feel they complement eachother perfectly. The first class citizens in Neo4j, the relations,…
Pieter-Jan
  • 1,675
  • 2
  • 19
  • 25
6
votes
3 answers

Google Cloud Storage not strongly consistent, returning 404 until 500ms after a resumable upload completes

I am making a file uploader using Cloud Storage which is experiencing non-consistent behaviour which seems contrary to the documentation. When you upload an object to Cloud Storage, and you receive a success response, the object is immediately…
scipilot
  • 6,681
  • 1
  • 46
  • 65
6
votes
4 answers

Can pseudo "lock" objects be used in the Amazon S3 API?

I'm thinking about using "lock" S3 objects in order to prevent simultaneous identical operations on a given S3 object. But I have great doubts about the validity of this technical solution. More precisely, at the beginning of an operation on an…
Azzip
  • 122
  • 10
6
votes
3 answers

Choosing a NoSQL database for storing events in a CQRS designed application

I am looking for a good, up to date and "decision helping" explanation on how to choose a NoSQL database engine for storing all the events in a CQRS designed application. I am currently a newcomer to all things around NoSQL (but learning): please be…
Yonn Trimoreau
  • 539
  • 7
  • 23
6
votes
1 answer

"Official" docker backup strategy - what about consistency?

The suggested strategy to manage and backup data in docker looks something like this: docker run --name mysqldata -v /var/lib/mysql busybox true docker run --name mysql --volumes-from mysqldata mysql docker run --volumes-from mysqldata -v…
S1lentSt0rm
  • 1,989
  • 2
  • 17
  • 28
6
votes
2 answers

Controling eventual AppEngine datastory consistency during testing

I have an AppEngine app written in Go, and I'm trying to improve my tests. Part of the tests that I need to run are a series of create, update, delete queries on the same object. However given that the datastore is eventually consistent (these…
JohnGB
  • 1,906
  • 2
  • 20
  • 31
6
votes
1 answer

One table DAO vs multiple table DAO

I am designing some "blocks" of data in JSF and I am getting my data from a Java bean per block. My problem is that my blocks get their data from more than one table. For example: A block that describes personal data of a customer consists…
Stefanos Kargas
  • 10,547
  • 22
  • 76
  • 101
5
votes
1 answer

Transaction with Cassandra data model

According to the CAP theory, Cassandra can only have eventually consistency. To make things worse, if we have multiple reads and writes during one request without proper handling, we may even lose the logical consistency. In other words, if we do…
aXqd
  • 733
  • 5
  • 17
5
votes
1 answer

Are dynamodb update expressions strongly consistent?

Suppose that a given table already contains the following key value pair: { "id": "one", "num": 5000 } If I write an update expression such as "ADD num :val" to add values as necessary can I expect this to be consistent in case of parallel…
codejammer
  • 1,636
  • 1
  • 14
  • 27
5
votes
2 answers

What exactly is the difference between REQUEST_PLUS and STATEMENT_PLUS ScanConsistency in Couchbase?

I couldn't understand the different between a request and a statement and how consistency is related to each of them.
N A
  • 831
  • 2
  • 8
  • 28
1 2
3
34 35