The top 10 SQL and NoSQL databases in the latest statistics, and nosql databases in the latest statistics

The top 10 SQL and NoSQL databases in the latest statistics, and nosql databases in the latest statistics

This ranking is based on the ranking of DB Engines, which analyzes the popularity of 200 different databases on the market. The Top 10 databases are listed here.

Undisputed Top 3

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

1. Oracle 11g

Initial Release: March 1980

License Mechanism: Proprietary

SQL?: Yes

Oracle is the first choice for important commercial projects and the oldest mainstream database product in the market. Oracle has four different versions available: compared with Microsoft products of the same type, Enterprise, Standard, Standard Edition One and Express have more advantages in operating system flexibility. When talking about supported operating systems, Oracle has the widest range of flexibility features: virtual Private Database, Data Guard, Automatic Storage Management, and Undo Management.

2. MySQL

Initial Release1995

License Mechanism: Open Source

SQL?: Yes

Enterprises can use the open-source community version at the beginning, and then upgrade to the commercial version to run on Linux, Windows, OSX, FreeBSD, and Solaris to provide users with an intuitive graphic interface for designing databases. In view of its open-source community, mySQL has a lot of materials and tutorials for you to start and handle problems, including Partitioning, replication, Xpath, Stored Procedures, Triggers, and Views.

3. Microsoft SQL Server

Initial Release1989

License Mechanism: Proprietary

SQL?: Yes

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

Although the above three databases have been firmly in the top 3, the growth of emerging databases has been very stable, such as MongoDB, Cassandra, and HBase, on the trend chart depicted by DB Engines.

4. PostgreSQL

Initial Release1989

License Mechanism: Open Source

SQL?: Yes

Unique and scalable object relational databases can run on Linux, Windows, OSX, and other systems that support Tablespaces, Stored Procedures, Joins, Views, and Triggers.

5. MongoDB

Initial Release2009

License Mechanism: Open Source

SQL?: No

The most popular NoSQL database, but it retains some SQL attributes. For example, the query and index of a large data set shows high performance, which is very helpful for dynamic query and index definition. It supports Linux, OSX, and Windows, however, the size of the database on 32-bit systems is limited to 2.5 GB.

6. DB2

Initial Release1983

License Mechanism: Proprietary

SQL?: Both

The Oracle 11g competing product released by IBM runs on Linux, UNIX, Windows, and large hosts. It is designed based on the IBM host environment and supports both SQL and NoSQL models.

7. Microsoft Access

Initial Release1992

License Mechanism: Proprietary

SQL?: Yes

Only one installation (database and tool Integration) is similar to Microsoft SQL Server. The original intention of Smart running on Windows is traffic analysis. However, its performance is not designed for medium to large project support languages: c, C #, C ++, Java, VBA, and Visual Basic. NET

8. SQLite

Initial Release2000

License Mechanism: Open Source

SQL?: Yes

The independent serverless database engine does not have any external dependencies. It is used as an embedded database on the iPhone, Firefox browser, and Skype. It is widely used in devices such as iPhone, desktop software such as Skype and Firefox can also be deployed without the need to configure and manage the entire database to be saved on a disk file, which can grow to 7 TB and support the widest range of languages in Top 10

9. Cassandra

Initial Release2008

License Mechanism: Open Source

SQL?: No

Highly available NoSQL has a user-friendly interface, which is suitable for storing large datasets and is widely used in banking, finance, and other industries. It is also used by Facebook and Twitter. Supports Windows, Linux, and OSX, and supports multiple languages. Map/Reduce is also supported when used with Hadoop.

10. Sybase ASE

Initial Release1987

License Mechanism: Proprietary

SQL?: Yes

Enterprise-level products produced by SAP run on Linux, Unix, and Windows, but OSX does not support C, C ++, Cobol, Java, Perl, PHP, Python, and other programming languages.

In addition to the Top 10, there are many well-known databases, such as CouchDB (21), Neo4j (22), and Riak (30. At the same time, we also believe that with the emergence of a variety of new databases, the competition will become increasingly fierce.

Top 10 students with SQL statement query scores

Selet top 10 * from student table order by score desc

Nosql Database

NoSQL does not have the same standards as traditional relational databases, nor is it universal. Therefore, select the appropriate NoSQL Based on the application and data access features.
If you have never been familiar with NoSQL before, MongoDB is a good choice. It supports the most powerful NoSQL in terms of query capability. The disadvantage is the indexing cost and document size limitation.
If you use Hadoop big data analysis, there are basically no changes to the data, just insert and query, and you need to cooperate with Hadoop's MR task, HBase will be a good choice.
Casaandra is a good choice if it requires strong scalability and high concurrency read/write and easy maintenance.
Of course, apart from the three popular NoSQL databases above, there are also many excellent NoSQL databases, and they all have their respective fields of expertise, therefore, you need to understand the characteristics of your products and then analyze which one is the most suitable. Generally, in a large system, it is not a single database, but a combination of multiple databases.