Stack Overflow
Stack Overflow

Questions tagged [data-consistency]

126 questions
34
votes
7 answers

Data Consistency Across Microservices

While each microservice generally will have its own data - certain entities are required to be consistent across multiple services. For such data consistency requirement in a highly distributed landscape such as microservices architecture, what are…
Santanu Dey
  • 2,900
  • 3
  • 24
  • 38
31
votes
5 answers

Are there any difference between data integrity and data consistency?

I'm a little confused about data consistency and data integrity. From Oracle Database Concepts: data integrity -------------- Business rules that dictate the standards for acceptable data. These rules are applied to a database by using integrity…
Just a learner
  • 26,690
  • 50
  • 155
  • 234
30
votes
2 answers

Should a RESTful GET response return a resource's ID?

A number of the developers here are having a friendly (some would say religious) discussion about whether a GET request from a RESTful API should return the ID of the requested resource. Let's assume the following GET…
Armchair Bronco
  • 2,367
  • 4
  • 31
  • 44
28
votes
9 answers

How to generate a verification code/number?

I'm working on an application where users have to make a call and type a verification number with the keypad of their phone. I would like to be able to detect if the number they type is correct or not. The phone system does not have access to a list…
Costo
  • 5,940
  • 8
  • 33
  • 35
23
votes
5 answers

How reliable is the adler32 checksum?

I wonder how reliable the adler32 checksum is, compared to e.g. md5 checksums? It was told on wikipedia that adler32 is "much less reliable" than md5, so I wonder how much, and in which way? More specifically, I'm wondering if it is reliable enough…
Samuel Lampa
  • 4,336
  • 5
  • 42
  • 63
15
votes
2 answers

How to avoid inserting the wrong data type in SQLite tables?

SQLite has this "feature" whereas even when you create a column of type INTEGER or REAL, it allows you to insert a string into it, even a string without numbers in it, like "the quick fox jumped over the lazy dog". How do you prevent this kind of…
Tulains Córdova
  • 2,559
  • 2
  • 20
  • 33
12
votes
2 answers

How to ensure data consistency in Cassandra on different tables?

I'm new in Cassandra and I've read that Cassandra encourages denormalization and duplication of data. This leaves me a little confused. Let us imagine the following scenario: I have a keyspace with four tables: A,B,C and D. CREATE TABLE A ( …
Pedro Cunha
  • 401
  • 1
  • 6
  • 16
10
votes
2 answers

verifying data consistency between two postgresql databases

This is specifically about maintaining confidence in using various replication solutions that you'd be able to failover to the other server without data loss. Or in a master-master situation that you could know within a reasonable amount of time if…
David Ackerman
  • 472
  • 4
  • 11
9
votes
2 answers

How to find issues related to Data consistency in an Embedded C code base?

Let me explain what I mean by data consistency issue. Take following scenario for example uint16 x,y; x=0x01FF; y=x; Clearly, these variables are 16 bit but if an 8 bit CPU is used with this code, read or write operations would not be atomic.…
EnsieT
  • 91
  • 5
8
votes
3 answers

How to maintain data consistency across multiple tables in cassandra?

I'm having trouble figuring out how to maintain attribute updates across multiple tables to ensure data consistency. For example, suppose I have many-to-many relationship between actors and fans. A fan can support many actors, and an actor have many…
James Maa
  • 81
  • 4
8
votes
5 answers

What algorithm to use to calculate a check digit?

What algorithm to use to calculate a check digit for a list of digits? The length of the list is between 8 and 12 digits. see also: How to generate a verification code/number?
Piotr Dobrogost
  • 41,292
  • 40
  • 236
  • 366
6
votes
1 answer

InfluxDB : How to update duration of an existing database

I have a database created with default retention policy which is infinite. # SHOW RETENTION POLICIES ON "my_database" name duration shardGroupDuration replicaN default ---- -------- ------------------ -------- ------- autogen 0s 168h0m0s…
kmonsoor
  • 7,600
  • 7
  • 41
  • 55
6
votes
2 answers

How long does it take for AWS S3 to save and load an item?

S3 FAQ mentions that "Amazon S3 buckets in all Regions provide read-after-write consistency for PUTS of new objects and eventual consistency for overwrite PUTS and DELETES." However, I don't know how long it takes to get eventual consistency. I…
EV3
  • 95
  • 1
  • 1
  • 6
5
votes
9 answers

Should you check for wrong parameter values in the constructor?

Do you check for data validity in every constructor, or do you just assume the data is correct and throw exceptions in the specific function that has a problem with the parameter?
Yossale
  • 14,165
  • 22
  • 82
  • 109
5
votes
1 answer

How to achieve data consistency in a newly added microservice?

For example, we have microservices with event sourcing. To achieve data consistency we use the following approach: A microservice generates an event The event is stored in an event store The event is published to the subscribed microservices This…
Mike
  • 613
  • 1
  • 10
  • 20
1
2 3
…
8 9