What is this type of principle of data integrity known as? In an - ProProfs Discuss
Advertisement

What is this type of principle of data integrity known as? In an online transaction processing system, data integrity is maintained by ensuring that a transaction is either completed in its entirety or not at all.

Asked by Hemangdoshi, Last updated: Apr 10, 2024

+ Answer
Request
Question menu
Vote up Vote down

1 Answer

hemangdoshi99

hemangdoshi

hemangdoshi99
Hemangdoshi

Answered Sep 04, 2019

C. atomicity.

The principle of atomicity requires that a transaction be completed in its entirety or not at all. If an error or interruption occurs, all changes made up to that point are backed out. Consistency ensures that all integrity conditions in the database be maintained with each transaction. Isolation ensures that each transaction is isolated from other transactions, and hence, each transaction only accesses data that are part of a consistent database state. Durability ensures that, when a transaction has been reported back to a user as complete, the resultant changes to the database will survive subsequent hardware or software failures.
upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

Email Sent
We have sent an email to your address "" with instructions to reset your password.