Wednesday 25 November 2015

AcidSQL Application Avaiable on Google Play Store

What is ACID ?

Database ACID (Atomicity, Consistency, Isolation, Durability) Properties


There are a set of properties that guarantee that database transactions are processed reliably, referred to as ACID (Atomicity, Consistency, Isolation, Durability).

Atomicity

Atomicity refers to the ability of a database to guarantee that either all of the tasks are performed or none of them are. Database modifications must follow an all or nothing rule. Each transaction is said to be atomic if when one part of the transaction fails, the entire transaction fails.

Consistency

The consistency property ensures that the database remains in a consistent state before the start of the transaction and after the transaction is over.

A distributed data system is either strongly consistent or has some form of weak consistency

Weak consistency is sometimes referred to as eventual consistency, the database eventually reaches a consistent state. Weak consistency systems are usually ones where data is replicated; the latest version is sitting somewhere in the cluster, older versions are still out there. Eventually all nodes will see the latest version.

Isolation

Isolation refers to the requirement that other operations cannot access or see the data in an intermediate state during a transaction. This constraint is required to maintain the performance as well as the consistency between transactions in a database.

Durability

Durability refers to the guarantee that once the user has been notified of success, the transaction will persist, and not be undone. This means it will survive system failure, and that the database system has checked the integrity constraints and won't need to abort the transaction.

Durability does not imply a permanent state of the database. Another transaction may overwrite any changes made by the current transaction without hindering durability.


With the AcidSQL App you can can connect to databases, make queries, execute SQL commands
view results grpahically, show tables. edit registers, delete registers and tables, view database, specifications


AcidSQL is compatible with Microsoft SQL Server, MySQL and PostgreSQL databases.

Click on the link to download now on your Android device.

Get it on Google Play

No comments:

Post a Comment