MySQL


The key role of a data base management system is information management. A database server is the key to solving the problems of information management. In general, a server must reliable manage a large amount of data in a multi-user environment so that many users can concurrently access the same data. A data base server must also prevent unauthorized access and provide efficient solutions for failure recovery.

Some of the key features of MySQL are:

  1. Speed. If the server hardware is optimal, MySQL runs very fast. It support clustered servers for demanding applications.
  2. Ease of use. MySQL is a high-performance, relatively simple database system. From the beginning, MySQL has typically been configured, monitored, and managed from the command line. However, several MySQL graphical interfaces are also available.
  3. Cost. MySQL is available free of cost. MySQL is a "Open Source" database. MySQL is part of LAMP (Linux, Apache, MySQL, PHP/Perl/Python) environment, a fast growing open source enterprise software stack.
  4. Query Language Support. MySQL understand standard based SQL ( Structured Query Language).
  5. Portability. MySQL provides Portability as it has been tested With a broad Range of different compilers and can work on many different platforms. it is fully multi-threaded using kernel threads. It can easily use multiple CPUs if they are available.
  6. Data Types. MySQL provides many data types to support different types of data. It also support fixed-length and variable-length records.
  7. Security. MySQL offers a privilege and password system data is very flexible and secure, and that a loss host-based verification. passwords are secure because all password traffic is encrypted when you connect to a server.
  8. Scalability and Limits. MySQL can handle large databases some real life MySQL databases contain 50million records, some have up to 60,000 tables and about 5,000,000,000 rows.
  9. Connectivity. Clients can connect to MySQL Server using several protocols:
  10. localization.  The server can provide error messages to clients in many languages.
  11. Clients and Tools. MySQL provides several clients and utility programs. These include both command-line programs such as mysqldump and mysqladmin, and graphical programs such as MySQL Administrator and MySQL Query Browser.  

MySQL and SQL


In order to access data within the MySQL  database, all programs and users must use, Structured Query Language (SQL). SQL is the set of commands that is recognised by nearly all RDBMSs. 
The Structured Query Language  (SQL) is a language that enables you to create and operate on relation databases, which are sets of related information stored in tables. 
The SQL(Structured Query Language ) has proved to be a standard language as it a loss users to learn one set of commands and use it too create, retrieve, alter, and transfer information regardless whether they are working on a PC, a workstation, a mini, or a mainframe.

SQL has clearly Stablished itself as the standard relational database language. we present a briefed survey of SQL.  

Processing Capabilities of SQL

The SQL(Structured Query Language ) has proved to be a standard language that can be used by both casual users as well as skilled programmers. The various processing capabilities of SQL are:

  1.  Data Definition Language (DDL):  The SQL(Structured Query Language ) DDL provides commands for defining relation schemas, deleting relations, creating indexes, and modifying relations schemas.
  2. Interactive Data Manipulation Language (DML):  The SQL(Structured Query Language ) DML includes a Query language based on both the relational algebra and the tuple relational calculus. It includes also commands to insert, delete, and modify tuples in the database.
  3. Embedded Data Manipulation language: The embedded form of SQL is designed for use within general-purpose programming languages such us PL/1,COBOL, FORTRAN, Pascal, and C, C++ etc.
  4. View Definition:  The SQL(Structured Query Language ) DDL  also include commands for defining views.
  5. Authorization:  The SQL(Structured Query Language ) DDL includes commands for specifying access rights to relations and views.
  6. Integrity: The SQL provides (limited) forms of integrity checking. Future products and standards of SQL are likely to include enhanced futures for integrity checking.
  7. Transaction Control: SQL includes commands for specifying the beginning and ending of transactions along with commands to have a control over transaction processing.