About MySQL Database

1. What isDatabase

Database ( Database) is a warehouse that organizes, stores, and manages data according to

each database has one or more different The API is used to create, access, manage, search, and replicate saved data.

We can also store the data in a file, but it is relatively slow to read and write data in the file.

So now we're using the relational database management system ( RDBMS) to store and manage large amounts of data.

the so-called relational database, is based on the relational model of the database , the use of set algebra and other mathematical concepts and methods to process the data in the database.

The RDBMS is the feature of the relational database management system (Relational Management systems) :

1. the data appears in tabular form

2. various record names for each behavior

3. data fields corresponding to record names for each column

4. a number of rows and columns form a single sheet

5. a number of forms form database

2. MySQLOverview

Mysqlis a small relational database management system, the developer of SwedenMySQL ABCompany. In the -years1Month -number wasSunCompany acquisitions. and theyears, SUNis alsoOracleAcquisitions.currentlyMySQLis widely used inInterneton the small and medium Web site.

because of its small size, fast speed, low total cost of ownership, especially the open source, many small and medium-sized websites in order to reduce the total cost of ownership of the site has chosen MySQL as a Web site database.

Http://www.runoob.com/mysql/mysql-tutorial.html

3. MySQLfeatures

1)UseCand theC + +written and tested using a variety of compilers to ensure the portability of the source code2)SupportAIX,FreeBSD,HP-UX,Linux,Mac OS,Novell Netware,OpenBSD,OS/2 Wrap,Solaris,Windowsand many other operating systems

3)provides a variety of programming languagesAPI. These programming languages includeC,C + +,Python,Java,Perl,PHP,Eiffel,Rubyand theTCLand so on.

4) support multi-threading, make full use of CPU Resources

5) optimized SQL query algorithm to improve query speed effectively

6) can be used as a separate application in the Client server network environment, but also as a library embedded in other software to provide multi-language support, common encoding such as Chinese GB 2312,BIG5 , Japanese shift_jis and so on can be used as data table name and data column name

7) provides a variety of database connectivity pathways such as TCP/IP,ODBC , and JDBC

8) provides management tools for managing, inspecting, and optimizing database operations

9) can handle large databases with thousands records

4. Relationship TypeDatabase FeaturesSummary

# A relational database is actually a two-dimensional table when storing data (almost the same as word,Excel table)

# The larger market share is MySQL and Oracle Database, and the Internet scene is most commonly used in MySQL database.

# It accesses and manages the data of the relational database through the SQL Structured query language .

# relational databases are strong in maintaining data security and data consistency, following the ACID theory .

5. Non-relationshipDatabase Knowledge Summary

# NOSQL Database is not a negative relational database, but an important supplement to relational database.

# NoSQL Database for flexibility and performance, high concurrency, ignoring the impact of high performance, high concurrency features.

# in the NOSQL database World, today's most typical product is Redis( persistent cache), mongodb,memcached (pure memory ) and so on .

# NoSQL Databases do not have a standard query language (SQL), usually using A RESTful data interface or query API

About MySQL Database