Top 10 SQL and NoSQL Databases

This ranking is based on the DB Engines ranking, which analyzes 200 different databases on the market in terms of popularity. Here is a list of the Top 10.

　The undisputed Top 3

　Oracle, MySQL and Microsoft SQL Server have always occupied the top three in the rankings with absolute advantages, and have the largest number of users in the market with their unique advantages.

　1. Oracle 11g

First released: 1980

Licensing mechanism: Proprietary

Is SQL: Yes

Oracle is the first choice for important commercial projects and the oldest mainstream database product on the market

Oracle has 4 Different editions are available: Enterprise, Standard, Standard Edition One and Express

Compared to Microsoft's similar products, Oracle has the advantage in operating system flexibility

When it comes to supported operating systems, Oracle has the widest flexibility Features: Virtual Private Database, Data Guard, Automatic Storage Management and Undo Management.

　　2. MySQL

　First release: 1995

　Licensing mechanism: Open source

　Is SQL: Yes

Enterprises can start with the community open source version and then upgrade to the commercial version

Can run on Linux, Windows, OSX, FreeBSD, Solaris

Provides an intuitive graphical interface for users to design databases

Given its open source community, MySQL has a large amount of information and tutorials to let you get started and deal with problems

Supports Partitioning, replication, Xpath, Stored Procedures, Triggers, Views

　 3. Microsoft SQL Server

First released: 1989

Licensing mechanism: Proprietary

Whether SQL: It is

the most used commercial database

Limited to Windows, but if the organization is heavily controlled by Microsoft products, the same is true It is an advantage

Other emerging databases

Although the above three databases have always firmly dominated the top 3 of the rankings, on the trend chart drawn by DB Engines, the growth of emerging databases has been very stable, such as MongoDB, Cassandra, HBase, etc.

　　　4. PostgreSQL

　First release: 1989

　Licensing mechanism: Open source

　Is SQL: It is

a unique extensible object-relational database

can run on Linux, Windows, OSX, etc.

Supports Tablespaces, Stored Procedures, Joins, Views, Triggers

　5. MongoDB

First released: 2009

Licensing mechanism: Open source

Whether SQL: No

The most popular NoSQL database, but retains some attributes of SQL , such as query and index

Exhibit high performance on large data sets

Very conducive to dynamic query and index definition

Supports Linux, OSX and Windows, but the database size is limited to 2.5GB on 32-bit systems

　6. DB2

Initial release: 1983

Licensing mechanism: Proprietary

Whether SQL: Both

Oracle 11g competitive product released by IBM

Can run on Linux, UNIX, Windows and mainframes

Designed based on IBM host environment

Supports both SQL and NoSQL models

　7. Microsoft Access

First released: 1992

Licensing mechanism: Proprietary

Is SQL: Yes

Only one installation required (database and tool in one)

Similar to Microsoft SQL Server , runs intelligently on Windows

The original intention is traffic analysis, but its performance is not designed for medium to large projects

Supported languages: C, C#, C++, Java, VBA and Visual Basic.NET

　8. SQLite

Initial release: 2000

Licensing mechanism: Open source

Whether SQL: It is

an independent serverless mode database engine, without any external dependencies, used on iPhone, Firefox browser and Skype

as an embedded database , it is widely used in devices like iPhone and deployed in desktop software like Skype and Firefox

No configuration and management required

The entire database is saved on a disk file that can grow to 7TB

In The most widely supported languages ​​in the Top 10

　9. Cassandra

First released: 2008

Licensing mechanism: Open source

Whether SQL: No

Highly available NoSQL

has a user-friendly interface and is suitable for storing large data Set

is widely used in banking, finance, etc., and is also used by Facebook and Twitter.

Supports Windows, Linux, OSX, and multiple languages.

It also supports Map/Reduce when used with Hadoop

　10. Sybase ASE

First released: 1987

Licensing mechanism: Proprietary

Whether SQL: It is an enterprise-level product produced by

SAP

Running on Linux, Unix and Windows, but does not support OSX

Supports programming languages ​​such as C, C++, Cobol, Java, Perl, PHP and Python

　There are many well-known databases besides the Top 10, such as CouchDB (21), Neo4j (22) , Riak (30) et al. At the same time, we also believe that with the birth of various new databases, competition will become increasingly fierce.