Top ten List of SQL and NoSQL databases in the latest rankings _ database other

This ranking is based on the DB engines list, which analyses 200 different databases on the market, listing top 10.

Undisputed Top 3

Oracle, MySQL, and Microsoft SQL Server have been occupying the top three of the rankings with absolute advantage, carving out the largest number of users in the market with unique advantages.

1. Oracle 11g

First release : 1980

Licensing mechanism : proprietary

whether SQL: Yes

Oracle is the first choice for important business projects and is also the oldest major database product in the market, Oracle has 4 different versions available: Enterprise, Standard, Standard Edition one and express compared to Microsoft's same-type products, Oracle has more advantages in operating system flexibility when it comes to supporting operating systems, Oracle has the broadest range of flexibility features: Virtual Private Database, Data Guard, Automatic Storage management, and Undo Management.

2. MySQL

first release : 1995

Licensing mechanism : Open source

whether SQL: Yes

The enterprise can start with a community open source version, and then upgrade to a commercial version that runs on Linux, Windows, OS X, FreeBSD, and Solaris to provide an intuitive graphical interface for user design databases given its open source community, MySQL has a lot of information and tutorials that allow you to start and handle problems with support for partitioning, replication, Xpath, Stored procedures, triggers, views.

3. Microsoft SQL Server

first release : 1989

Licensing mechanism : proprietary

whether SQL: Yes

The most used commercial databases are limited to Windows, but this is also an advantage if the organization is heavily controlled by Microsoft products other emerging databases

Although the top 3 databases have consistently dominated the top 3 of the rankings, the growth of emerging databases has been very stable in the trend chart depicted by DB engines, such as MongoDB, Cassandra, HBase, and so on.

4. PostgreSQL

first release : 1989

Licensing mechanism : Open source

whether SQL: Yes

Unique extensible Object Relational database can be run in Linux, Windows, OS X, and other support tablespaces, Stored procedures, joins, views, triggers

5. MongoDB

first release : 2009

Licensing mechanism : Open source

whether SQL: no

The most popular NoSQL database, but retains some of the SQL attributes, such as high performance on query and index large datasets, which is good for dynamic queries and index definitions to support Linux, OS X, and Windows, but the size of the database is limited to 2.5GB on 32-bit systems

6. DB2

First release : 1983

Licensing mechanism : proprietary

whether SQL: both

IBM-issued Oracle 11G competitive products run on Linux, UNIX, Windows, and large hosts based on IBM host Environment design supports both SQL and NoSQL models

7. Microsoft Access

First release : 1992

Licensing mechanism : proprietary

whether SQL: Yes

Only one installation (database and tool integration) similar to Microsoft SQL Server, intelligent running is designed for traffic analysis on Windows, but its performance is not for medium to large project design support languages: C, C #, C + +, Java, VBA, and visual Basic.NET

8. SQLite

First release : 2000

Licensing mechanism : Open source

whether SQL: Yes

Standalone server-less database engine with no external dependencies, used as an embedded database on iphones, Firefox browsers and Skype, is widely used in devices like the iphone, It can also be deployed in desktop software such as Skype and Firefox. No configuration and management of the entire database is saved on a single disk file, growing to the widest range of languages supported by 7TB in Top 10

9  . Cassandra

First release : 2008

Licensing mechanism : Open source

whether SQL: no

The highly available NoSQL has a user-friendly interface for storing large datasets that are widely used in banks, finance, etc., and are also used by Facebook and Twitter. Supports Windows, Linux, OS X, and supports multiple languages. Map/reduce is also supported when used in conjunction with Hadoop

Sybase ASE

First release : 1987

Licensing mechanism : proprietary

whether SQL: Yes

SAP-produced enterprise-class products run on Linux, Unix and Windows, but do not support OS X support for C, C + +, Cobol, Java, Perl, PHP, and Python programming languages

Beyond Top 10 There are many well-known databases, such as COUCHDB (21), neo4j (22), Riak (30), and so on. At the same time, we also believe that with the birth of a variety of new databases, competition will become more intense.