Introduction of MySQL
Previous Home Next

It Stands for My-SQL ,SQL acronym is Structured Query Language. MySQL was initially developed in Oracle Corporataion by Michael Widenius and David Axmark begining in 1994. But,the first internal version release in the 23 May 1995.

It is an open soucre available software and became the second most widely used RDBMS(Relational Database Management System).

There are atleast a dozen different versions of MySQL Server is introduced. The last updated version of MySQL is 5.7.5 is released in 25 september 2014

Advantages of Mysql

  1. Cross-Platform Support
  2. Store Procedure available
  3. Triggers, Cursors and Updateable view available
  4. Embedded Database Library
  5. It is Customizable

It ensures that transactions follow by the ACID Model, which is define below

ACID Model

Means atomicity, consistency, isolation and durability.

Atomicity: Each transaction is said to be “atomic". Means if any part of transaction fail then whole transaction failed. In a word say "ALL OR NOTHING". The failure of transaction commonly depend on Hard disk fail, System crash.

Consistency: Consistency means only valid data will be written to the database. If any transaction violate any consistency rule of database the whole transaction is Rollback, means it starts again from beginning. Each state in transaction must be consistent for database.

Isolation: If two transactions occurs at a time then both are not impact to each other, separate completion of each transaction. The isolation property does not ensure which transaction will execute first, merely that they will not interfere with each other. If second transaction depend on first then it will done, and data update after completion of traction.

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.

Previous Home Next