Data Integrity

There are a number of concepts and features to consider when adding, modifying, or deleting data to ensure that the integrity and consistency of the data is maintained. These include:

  • Using table DeleteAction elements.

  • Using the forUpdate keyword correctly in select statements.

  • Enabling transactions in your code.

  • Avoiding deadlocks.

  • Implementing Optimistic Concurrency Control (OCC).

Community Additions