the development stage of database management technology
1, the artificial management stage
data can not be long-term preservation, the program itself management data, data can not be shared, data is not independent.
2, File system stage
data can be long-term preservation, data file system management, data redundancy, poor sharing, access efficiency is low.
3, the database system stage
data realization structure, the data realizes the sharing, the access efficiency is high
Database System Related Concepts
- Databases (database. DB) is a collection of data that can be shared by a variety of users or applications by means of a set of rules that are stored on a computer's storage device for a long time.
- Database Management System,dbms is a frustration and management database software for resumes, use and maintenance of databases, unified management and control of data to ensure the security and integrity of the database. The user accesses the data in the database through the database management system. Currently the most popular database management systems are Oracle, DB2, MySQL, SQL Server, Dynamo, MongoDB, and so on.
Classification of database technology
Relational databases use foreign key associations to establish the relationship between tables. Oracle, DB2, MySQL, SQL Server, and more.
A non-relational database usually means that the data is stored in the database as an object's running script, and the relationships between objects are determined by the properties of each object itself. BigTable, Dynamo, MongoDB, Redis, etc.
functions provided by the database management system
- Database management provides a number of features that enable you to define and manipulate data through the SQL language, maintain database integrity and security, and manage various databases. SQL language supported by the database management system:
- DDL language (data definition Language): Define databases, tables, views, indexes, stored procedures. Create, DROP, alter ...
- DML language (Database manipulation language): Inserting data Insert, deleting data Delete, updating data update, querying data Select
- DCL Language (Database Control language): For example, to control access rights for a user grant, REVOKE
MySQL Data management system
- MySQL was a relational database system developed by 3 Swedes David Axmark, Allan Larsson and Michael Widenius in the 1990s.
- MySQL is an open-source, small and medium-sized database management system that is continuously enhanced both in functionality and performance.
- MySQL was acquired by Sun in 2008, and Sun was acquired by Oracle Company in 2009.
- Due to the advantages of small size, fast speed and open source, MySQL has become the preferred database system for Internet companies.
How much MySQL database is used
- More than 15 million servers running MySQL services worldwide
- 2013 New database rankings ranked second
- Nine of the world's top ten web site clocks use MySQL
- Eight of the world's top ten ISVs use MySQL
- The largest cloud database
- 80% of the Hadoop Big Data platform integrates with MySQL
MySQL Note series: Database overview
