What databases does Linux support?

1, oracle database

Originally named SDL, it was founded by Larry Ellision and two other programmers in 1977. They developed their own fist products and sold them in large quantities in the market. From 65438 to 0979, oracle Company launched the first commercial SQL relational database management system. Oracle Company is one of the earliest manufacturers to develop relational databases, and its products support the most extensive operating system platforms. Objective oracle relational database product is one of that product with the highest market share.

2.MySQL database

MySQL database is a small and medium-sized relational database management system, and the software developer is Swedish MySQL AB company. In June 2008, 65438+ 10/6 was acquired by sun Company, and then sun Company was acquired by oracle Company. At present, MySQL is widely used in large, medium and small websites on the Internet. Because of its small size, high speed, low total cost of ownership, especially its open source, many large, medium and small websites choose MySQL as their own website database in order to reduce the total cost of ownership. Even Taobao, a well-known domestic website, chose to give up oracle and switch to a more open MySQL.

3.MariaDB database

MariaDB database management system is a branch of MySQL database, which is mainly maintained by the open source community. One of the possible reasons for developing the branch of MariaDB database is that there is a potential risk of closing MySQL after Oracle Bone Inscriptions buys MySQL, so MySQL open source community adopts branches to avoid this risk. The purpose of developing MariaDB database is to be fully compatible with MySQL database, including API and command line, so as to be replaced by MySQL. In the aspect of storage engine, XtraDB is used to replace MySQL's InnoDB.

4.SQL server database

SQL server is a large relational database system developed by Microsoft. 1987, Microsoft cooperated with IBM to develop OS/2, and IBM bundled OS/2DatabaseManager in its OS/2ExtendedEdition system, but Microsoft product line still lacked database products. Therefore, Microsoft turned its attention to Sybase and signed a cooperation agreement with Sybase to develop a relational database based on OS/2 platform by using Sybase technology. 1989, Microsoft released the 1.0 version of SQL Server. SQL server has comprehensive functions and high efficiency, and can be used as a database platform for medium-sized enterprises or units. SQL server can be closely integrated with Windows operating system, which can greatly improve the speed of application development and system transaction processing.

Nosql = not only sql.

1, memory cache

Memcached is an open source high performance caching system with distributed memory objects. It can reduce the database load and accelerate the dynamic Web application. The original version was developed by Brad Fitzpatrick of LiveJoumal in 2003. At present, many users around the world are using it to build their own high-load websites or improve the response speed of their high-access websites. Note: Memcache is the name of this project, and Memcached is the file name of the server-side main program.

2、Redis

Redis is a key value storage system. But Redis supports more storage value types, including string, list, set and zset. These data types all support push/pop, add/remove, intersection, union and difference sets and richer operations, and these operations are all atomic. On this basis, Redis supports sorting in various ways. Like Memcached, in order to ensure efficiency, Redis data is cached in memory. The difference is that Redis will periodically write updated data to disk or modify additional record files, on this basis, master-slave synchronization can be realized.

3、MongoDB

MongoDB is a product between relational database and non-relational database, which has the strongest functionality and is similar to relational database. The data structure it supports is very loose, similar to Json Bjson format, so it can store more complex data types. The biggest feature of MongoDB is that its query language is very powerful, and its syntax is somewhat similar to that of object-oriented query language, which can realize almost all functions similar to single table query of relational database, and also supports index data. Its characteristics are high performance, easy deployment, easy use and convenient data storage.