Top ten SQL and NoSQL databases

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

SQL: Yes

Oracle is the first choice for important business projects and is 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 products of the same type, Oracle has the advantage of 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

SQL: Yes

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 provides an intuitive graphical interface for user design databases given its open source community, MySQL has a lot of information and tutorials to get you started and handle problems support partitioning, replication, Xpath, Stored procedures, triggers, views

3. MicrosoftSQL Server

First release: 1989

Licensing mechanism: Proprietary

SQL: Yes

the most used commercial database is limited to Windows, but if the organization is Microsoft product Heavy control, this is also an advantage 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, etc.

4. PostgreSQL

First release: 1989

Licensing mechanism: Open source

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

SQL: No

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

6. DB2

First release: 1983

Licensing mechanism: Proprietary

SQL: both

IBM-issued Oracle 11g competition can be run on Linux, UNIX, Windows, and mainframe based on IBM host environment Design and support both SQL and NoSQL models

7. MicrosoftAccess

First release: 1992

Licensing mechanism: Proprietary

SQL: Yes

only need one installation (database and tools) 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

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

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

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), etc. At the same time, we also believe that with the birth of a variety of new databases, competition will become more intense.

Original link: The top SQL and NoSQL databases (compiled/Zhonghao revisers/wei)

Free Subscription "CSDN cloud Computing (left) and csdn large data (right)" micro-letter public number, real-time grasp of first-hand cloud news, to understand the latest big data progress!

CSDN publishes related cloud computing information, such as virtualization, Docker, OpenStack, Cloudstack, and data centers, sharing Hadoop, Spark, Nosql/newsql, HBase, Impala, memory calculations, stream computing, Machine learning and intelligent algorithms and other related large data views, providing cloud computing and large data technology, platform, practice and industry information services.