Skip to main content

DBMS ACID Properties

 1. Atomicity states that database modifications must follow an all or nothing rule


2. Consistency states that only valid data will be written to the database. If, for some reason, a transaction is executed that violates the database's consistency rules, the entire transaction will be rolled back and the database will be restored to a state consistent with those rules. 


3. Isolation requires that multiple transactions occurring at the same time not impact each other's execution. For example, if Joe issues a transaction against a database at the same time that Mary issues a different transaction, both transactions should operate on the database in an isolated manner. The database should either perform Joe's entire transaction before executing Mary's or vice-versa.


4. Durability ensures that any transaction committed to the database will not be lost. Durability is ensured through the use of database backups and transaction logs that facilitate the restoration of committed transactions in spite of any subsequent software or hardware failures.

                                                        ------------------------

Concurrency Database concurrency controls ensure that transactions occur in an ordered fashion. The main job of these controls is to protect transactions issued by different users/applications from the effects of each other. They must preserve the four characteristics of database transactions: atomicity, isolation, consistency and durability.

Comments

Post a Comment

Popular posts from this blog

how to solve: nginx Permission denied problem

  *71 connect() to unix:/run/php/php7.4-fpm.sock failed (13: Permission denied) while connecting to upstream, client: <ip here>, server:  <ip here>, request: "GET /iomad/ HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.4-fpm.sock:", host: "<ip here>" just give permission  to  php7.4-fpm.sock i solved it by giving sudo chmod -R 0777     php7.4-fpm.sock Also i tried to open the file but there was again permission denied issue  i visited my website and it was working
Post a Comment
Read more

Indian HAL Tejas | Touch The Sky With Glory | ShotOnNikonD3500

Indian HAL Tejas | Touch The Sky With Glory | ShotOnNikonD3500
Post a Comment
Read more

installing Laravel v8.0.1 in Windows 10 Pro x64bit

 Using WAMP for  php - 7.4.10 maraiadb - 10 apache - 2.4 php -i | grep -i ssl  to check registration stream socket transports grep -R "search your word" use this cmd to search in linux directory composer diagnose to see the status of composer check with this link also:  https://github.com/composer/composer/issues/4388 Failed to download tijsverkoyen/css-to-inline-styles from dist: The "https://api.github.com/repos/tijsverkoyen/CssToInlineStyles/zipball/b43b05cf43c1b6d849478965062b6ef73e223bb5" file could not be downloaded: php_network_getaddresses: getaddrinfo failed: No such host is known.     failed to open stream: php_network_getaddresses: getaddrinfo  failed: No such host is known.  Now trying to download from source https://github.com/tijsverkoyen/CssToInlineStyles   install the  composer require tijsverkoyen/css-to-inline-styles ======================================================================= These are final steps: ...
Post a Comment
Read more