Questions tagged [data-consistency]
126 questions
0
votes
1 answer
User table in database is changed, how to update session?
Currently when the user logs in my site, a (PHP) session is started and his database row is saved in his $_session. I do so because the size of user's data is small for now, and this way I do not have to ask the database for user's data every time I…
Marco Sulla
- 15,299
- 14
- 65
- 100
0
votes
1 answer
"Maximum allowed trigger depth" in SQL Server?
I know about "Allow Triggers to Fire Others" server setting that allows the action taken by a trigger to fire another trigger (or not), and as I understand it, my only options are True (allow trigger to fire other triggers, which may lead to…
SqlRyan
- 33,116
- 33
- 114
- 199
0
votes
1 answer
How to validate NOT NULLABLE attributes from a POJO vs list of required attributes?
My issue is that I need to persist in my database two kind of status "VALID" and "INVALID" according to data validation, it means, in my database all attributes are NULLABLE but another process will put status "VALID" if all required values are…
Osy
- 1,613
- 5
- 21
- 35
0
votes
1 answer
Implementing data mathematical consistency among table rows
I have 3 tables: Persons, Variables, Person_Data.
Person_Data table has numerical data on various variables for different persons. Columns are: variable_value, person_id (foreign key to Persons) and variable_id (fk to Variables).
Some of the…
0
votes
1 answer
Serialization of Application Object
At first I have strong Java knowledege, but however just started with Android.
My Android app is downloading some fairly complex data (texts, dates, images) which I am saving in a custom object. The data need to be refresh from time to time. However…
Pierre-Antoine
- 7,939
- 6
- 28
- 36
0
votes
1 answer
solution to synch back cache value to database?
below is the scenario:
here is a access statistic system, just like Blogger's overviewstats function.
Statistic data is stored persistent in database(like MySQL), while using a key-value cache(now is memcache) to cache the access counts, each…
situch
- 103
- 1
- 4