What are the database types?

Database types include: 1. Relational databases, including [MySQL, MariaDB]; 2. Non-relational databases, [Cassandra, MongoDB]; 3. Key-value databases, including [Dynamo, LevelDB].

#The operating environment of this article: Windows 7 system, Dell G3 computer.

Database types are:

1. Relational database

MySQL, MariaDB (a substitute for MySQL, English Wikipedia Switching from MySQL to MariaDB), Percona Server (MySQL replacement·), PostgreSQL, Microsoft Access, Microsoft SQL Server, Google Fusion Tables, FileMaker, Oracle database, Sybase, dBASE, Clipper, FoxPro, foshub.

Almost all database management systems are equipped with an Open Database Connectivity (ODBC) driver, which allows various databases to integrate with each other.

2. Non-relational database (NoSQL)

BigTable (Google), Cassandra, MongoDB, CouchDB.

3. Key-value database

Apache Cassandra (used by Facebook): highly scalable, Dynamo, LevelDB (Google).

Extended information:

Database model: object model, hierarchical model (lightweight data access protocol), network model (large data storage), relational model, object-oriented model, semi-structure model, flat model (tabular model, generally in the form of a two-dimensional array. Such as tabular model data Excel).

The architecture of the database can be roughly divided into three general levels: inner layer, conceptual layer and outer layer.

Related free learning recommendations: php programming (video)

The above is the detailed content of What are the database types?. For more information, please follow other related articles on the PHP Chinese website!