Databases – What is ACID?

What does ACID mean in database technologies? Concerning databases, the acronym ACID means: Atomicity, Consistency, Isolation, and Durability. Why is ACID important? Atomicity, Consistency, Isolation, and Durability (ACID) are import to database, because ACID is a set of properties that guarantee that database transactions are processed reliably. Where is the ACID Concept described? Originally described … Continue reading Databases – What is ACID?

What is DCL?

What is DCL (Data Control Language)? Data control language (DCL) is anything that is used for administrating access (permissions/security) to database content.  The main DCL commands are: Grant Revoke Related References Database Table Field Ordering Effective Practices Structured Query Language (SQL) Tuning What is DDL? What is DML?