What is a database? Deposit is a computer data warehouse, the warehouse is according to certain data structure, data structure refers to the organization form of the link between or data) to the data organization and storage, we can through the database to provide a variety of methods to manage the data,
Simple database software species are divided into: a relational database and relational database

RDBMS refers to the Relational Database Management System, the full name of Relational Database Management System

relationship database: access, sqlite, DB2, Sybase, mysql, MSSQL, oracle, SQL Server, InforMix, PostgreSQL, FileMaker, dBASE, Clipper, FoxPro, foshub (relational database model is the complex data structure comes down to a simple binary relation (that is, two-dimensional tabular form), in a relational database, almost entirely to the operation of the data based on one or more of the relationship between form, through the classification of the associated form, merger, connection or select operation to realize the database management, such as)

Relational database knowledge and characteristics of summary:

1) when the data is stored in relational database actually is to use a two-dimensional table (and almost the same as in the Word and excell form),

2) the larger the market share is MySQL and oracle database, and MySQL database is the most commonly used Internet scene,

3) it through structured query language (SQL access, data management of relational database,

4) relational database in terms of data security and data consistency is very strong, follow theory of ACID

No non-relational database summary:

1) no database is not no relational database, but as an important supplement of the relational database,

2) no (database for flexible and high performance, high concurrency, ignore the impact of high performance, high concurrency features,

3) in the field of no (database, today the most typical products for Redis (persistent cache), directing, Memcached (pure memory),

4) no (no standard database query language (SQL), usually use restful data interface or query API,

non-relational database: redis, Memchache, directing, no, BigTable (Google), Cassandra, CouchDB, Apache Cassandra, chateau marmont, LevelDB (Google), (non-relational database consists of: (1) key value store database (key, value) (2) the Column (the Column - oriented) storage database (4) s (3) the graphics database Document (the Document - oriented) oriented database)


Almost all of the database management system is equipped with an open database connectivity (ODBC) driver, to each other between each database integration,


-- -- -- -- -- -- -- -- -- -- - there are five common relational database:
ACCESS, MySQL, SQL Server, DB2 and Oracle

Where ACCESS
Is the Microsoft company launched in 1994 computer database management system, is typical of a new generation of desktop database management system.
The main features are:
(1) perfect the management of a variety of database objects, is a powerful data organization, user management, the function such as security checks,
(2) the powerful data processing capabilities, in the level of a working group of network environment, the use of Access the multi-user database management system with traditional XBASE (generally referred to as DBASE, FoxBASE) database system cannot be achieved by the client/Server (Cient/Server) structure and the corresponding database security mechanism, Access have many advanced large database management systems have characteristics, such as transaction processing error/rollback capability,
3 can easily generate a variety of data objects, forms and reports, was established based on the data stored good visibility,
(4) as part of the Microsoft Office suite, can be integrated with the Office, realize the seamless connection,
(5) be able to use the Web to retrieve and publish data, with the Internet connection, Acess is mainly suitable for small and medium-sized application system, or the client as a client/server system database,
Early application fields: small program system asp + access system, message board, chinaren,

is released, the full name is: Microsoft SQL Server,
Main application range: some enterprises electric commercial shopping (CCTV), using the Windows server platform,

is the IBM developed a set of relational database management system, its main operating environment for UNIX (including their IBM AIX), Linux, IBM I (old name OS/400), z/OS, and Windows server version,

Oracle corporation is the world's largest provider of information management software and services, founded in 1977, the headquarters is located in California Redwood shore, Oracle has strong ability of e-commerce solutions, provide enterprises with efficient means of the expansion of the market, and improve the work efficiency and attract more customers, Oracle officially entered the Chinese market in 1989, was the first company to the world of Chinese software giant, in July 1991 in Beijing set up wholly owned company, at present in domestic is equipped with Beijing, Shanghai, guangzhou and chengdu four offices,
Main application: traditional big business, big companies, government, finance, securities, etc.,
Version update: Oracle8i, Oracle9i, Oracle1Og, Oracle11g, Oracle12c,

MySQL founder Michael Widenius (English: Michael Widenius) leading development, his earlier for the price of $1 billion, will create the MySQL AB company sold to the SUN, and since then, as the SUN acquired by Oracle, MySQL ownership also fall into the hands of the Oracle, developed by Swedish MySQL AB, now belongs to Oracle's product,
MySQL database main application areas: Internet, big small and medium-sized websites, games, and so on electric business platform,


-- -- -- -- -- -- -- -- -- -- - there are four common non-relational database:
Memcached (key - value), redis (key - value, directing (Document - oriented),

Memcached is an open source, high-performance, distributed memory object caching system, through which can reduce the database load, speed up dynamic Web applications, the first version by LiveJoumal Brad Fitzpatrick development completed in 2003, the world there are so many users are using it to build their own big load in website or improve your visit the Web site response speed, high note: Memcache is the name of the project, the main program and Memcached is the server name,

redis :
(1) support the memory cache, this function is equivalent to the memcached,
(2) support the persistent storage, this function is equivalent to memcachedb ttserver,
(3) data type is richer, stronger than other key - value library functions,
(4) support the master-slave cluster, distributed,
5) support queue special features, such as

mongo is a between relational databases and the relational database products, is the most abundant function of relational database, the most like a relational database, he supports data structure is very loose, bjson formats like json, so can store more complex data types, directing the biggest characteristic is his support query language is a very powerful and its syntax is a bit similar to the object-oriented query language, can achieve almost similar to relational database for the most part of single table query function, but also support for data indexing, its characteristic is high performance, easy to deploy, easy to use, it is very convenient to store data,

Apache Cassandra is a set of open source distributed Key - Value storage system, it was originally developed by Facebook, used to store huge data, Facebook is now in the use of this system,
Main features:
1) distributed
(2) based on the column of structured
(3) high stretch


-- -- -- -- -- -- -- -- -- -- - said the biggest difference between them:

The ACCESS of the less powerful, main is often used in stand-alone software development;
SQL Server is more extensive and widespread application, a database is a milestone in the development of database,
Oracle's function is relatively strong, generally used for the establishment of a large management system software, the application scope of now has more extensive, and the DB2 other

-- -- -- -- -- -- -- -- -- -- -- -- -- the domestic some database:

(1) of the dream database - a traditional database

(2) GBase ntu general - traditional database

(3) avatar database - a traditional database

(4) Jin Cang database, traditional database

(5) EsgynDB - new database

6 SequoiaDB giant sequoias database - new database

All landowners Oceanbase - new database

Today K - DB database - a traditional database

Pet-name ruby OpenBASE?

Attending hua yi Huayisoft DB database Server

? HUABASE - hua ding database

? Shenzhou OSCAR (Beijing shenzhou aerospace software technology co., LTD.)

? TiDB (domestic PingCAP team to develop a distributed SQL database) - the new database