Questions tagged [serialization]

The tag has no usage guidance.

7 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4
votes
1answer
311 views

What is the meaning of Order preserving Conflict Serializable schedules?

I was going through the concept of order preservation in Conflict Serializable class and I came across Order preserving conflict serializable (OCSR in short). The following is the definition of OCSR ...
1
vote
1answer
27 views

SELECT FOR UPDATE (NOWAIT) on auxilliary table for serializing updates?

Background: I have an inventory tracking application which needs to avoid the following sort of situation where the same inventory might be used twice due to lack of serialization. The constraint is ...
1
vote
0answers
60 views

View serializable schedule

Any view serializable schedule that is not conflict serializable must contain a blind write. (Source: Wikipedia) Why is this statement true? I referred some links like this but am still not able to ...
1
vote
0answers
16 views

Do start and end points change conflict serialisability?

If we have two transactions, and the following schedule: S1 R1(X) S2 R2(X) R2(Y) E1 W2(X) W2(Y) E2 where Si and Ei indicate the start and end of the ith transaction respectively. Does this change ...
1
vote
0answers
168 views

Turn off serialization failure logging

Is it possible to turn off serialization failure logging? If so, how? For example, my log is filled with this example: ERROR: could not serialize access due to read/write dependencies among ...
0
votes
0answers
23 views

How to store very very big Array in MySQL (separator / json_encode / serialize)?

I have project with saving timestamps from SCADA system to localhost MySQL-DB. All works fine but thinking about storing datas (read many threads and array storing isnt most efficiency method). Every ...
0
votes
0answers
282 views

PostgreSQL Race condition and Serializable

Hello I try to debug a tricky race condition in my app (golang, pq, sqlx, postgresql Debian 10.6-1.pgdg90+1). I have a table CREATE TABLE j ( id BIGSERIAL PRIMARY KEY NOT NULL, ...