in Education by
What are some strategies that people have had success with for maintaining a change history for data in a fairly complex database. One of the applications that I frequently use and develop for could really benefit from a more comprehensive way of tracking how records have changed over time. For instance, right now records can have a number of timestamp and modified user fields, but we currently don't have a scheme for logging multiple change, for instance if an operation is rolled back. In a perfect world, it would be possible to reconstruct the record as it was after each save, etc. Some info on the DB: Needs to have the capacity to grow by thousands of records per week 50-60 Tables Main revisioned tables may have several million records each Reasonable amount of foreign keys and indexes set Using PostgreSQL 8.x JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

1 Answer

0 votes
by
One strategy you could use is MVCC, Multi-Value Concurrency Control. In this scheme, you never do updates to any of your tables, you just do inserts, maintaining version numbers for each record. This has the advantage of providing an exact snapshot from any point in time, and it also completely sidesteps the update lock problems that plague many databases. But it makes for a huge database, and selects all require an extra clause to select the current version of a record.

Related questions

0 votes
    What are some strategies that people have had success with for maintaining a change history for data in a ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 25, 2022 in Education by JackTerrance
0 votes
    An audit trail ___________ (a) Is used to make backup copies (b) Is the recorded history of operations ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    What is an Audit trail in Salesforce?...
asked Nov 12, 2020 in Technology by JackTerrance
0 votes
    What is the attenuation in dB assuming I1 is the input current and I2 is the output current leaving the port? ( ... for GATE EC Exam, Network Theory MCQ (Multiple Choice Questions)...
asked Oct 12, 2021 in Education by JackTerrance
0 votes
    Features of an Effective Endpoint Security Strategy?...
asked Oct 24, 2020 in Technology by JackTerrance
0 votes
    How to View the change history of a file using Git versioning?...
asked Jan 8, 2021 in Technology by JackTerrance
0 votes
    Which of the following properties aim to generate a trail to identify the source and path of attack? A. Repudiation B. Resilience C. Traceability D. Accountability...
asked Feb 25, 2023 in Technology by JackTerrance
0 votes
    I have a DQN all set up and working, but I can't figure out how to display the loss without ... , JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Apr 9, 2022 in Education by JackTerrance
0 votes
    Firewall examines each ____________ that are entering or leaving the internal network. (a) emails users (b) updates (c ... questions and answers pdf, mcq on Cyber Security pdf,...
asked Nov 4, 2021 in Education by JackTerrance
0 votes
    Which of the following SSA audit types involves simulating real-life attacker in the unprivileged and privileged modes? ... Audits B. Process Maturity Review C. Technical Review...
asked Feb 25, 2023 in Technology by JackTerrance
0 votes
    What are Audit Fields in Salesforce?...
asked Nov 12, 2020 in Technology by JackTerrance
0 votes
    Lalit is going for an interview for the job of Software developer in Reputed company. what point he should ... an effective interview. Select the correct answer from above options...
asked Dec 26, 2021 in Education by JackTerrance
0 votes
    Lalit is going for an interview for the job of Software developer in Reputed company. what point he should ... an effective interview. Select the correct answer from above options...
asked Dec 25, 2021 in Education by JackTerrance
0 votes
    What is one characteristic of an Enterprise that has mastered strategy Agility?...
asked Nov 27, 2020 in Technology by JackTerrance
0 votes
    _____________ track the user's online activities like search queries, history pages & downloads, for selling ... Cyber Security:,Cyber Security-Jobs:,Cyber Security Applications...
asked Oct 31, 2021 in Education by JackTerrance
...