Shulou(Shulou.com)05/31 Report--

This article focuses on "what are the top ten SQL and NoSQL databases". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn what are the top 10 SQL and NoSQL databases.

The indisputable Top 3

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

1. Oracle 11g

First issue: 1980

Licensing mechanism: Proprietary

Whether SQL: yes

Oracle is the first choice for important business projects, and it is also the oldest mainstream database product on the market. Oracle is available in four different versions: Enterprise, Standard, Standard Edition One and Express compared to Microsoft's similar products, Oracle has more advantages in operating system flexibility. When it comes to supported operating systems, Oracle has the broadest flexibility features: Virtual Private Database, Data Guard, Automatic Storage Management and Undo Management.

2. MySQL

First issue: 1995

Licensing mechanism: open source

Whether SQL: yes

Enterprises can start with the community open source version, and then upgrade to the commercial version that can run on Linux, Windows, OSX, FreeBSD, Solaris to provide an intuitive graphical interface for user design databases. In view of its open source community, MySQL has a large number of materials and tutorials that allow you to start and deal with problems to support Partitioning, replication, Xpath, Stored Procedures, Triggers, Views.

3. Microsoft SQL Server

First issue: 1989

Licensing mechanism: Proprietary

Whether SQL: yes

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

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

4. PostgreSQL

First issue: 1989

Licensing mechanism: open source

Whether SQL: yes

The unique extensible object relational database can run on Linux, Windows, OSX, etc., supporting Tablespaces, Stored Procedures, Joins, Views, Triggers, etc.

5. MongoDB

First issue: 2009

Licensing mechanism: open source

Whether SQL: no

The most popular NoSQL database, but retains some SQL attributes, such as query and index big data set showing high performance is very good for dynamic query and index definition to support Linux, OSX and Windows, but the database size on 32-bit systems is limited to 2.5GB

6. DB2

First issue: 1983

Licensing mechanism: Proprietary

Whether or not SQL: both

Oracle 11g competitive products released by IBM can run on Linux, UNIX, Windows and mainframe designs based on IBM host environment support both SQL and NoSQL models

7. Microsoft Access

First issue: 1992

Licensing mechanism: Proprietary

Whether SQL: yes

Just an installation (database and tools in one) is similar to Microsoft SQL Server. Smart running on Windows is originally designed for traffic analysis, but its performance is not designed for supporting languages for medium to large projects: C, C #, C++, Java, VBA and Visual Basic.NET

8. SQLite

First issue: 2000

Licensing mechanism: open source

Whether SQL: yes

Independent serverless database engine without any external dependencies, used as an embedded database on iPhone, Firefox browsers and Skype, widely used in devices like iPhone, and deployed in desktop software such as Skype and Firefox without the need to configure and manage the entire database is saved on a disk file, growing to the widest range of languages supported by 7TB in Top 10

9. Cassandra

First issue: 2008

Licensing mechanism: open source

Whether SQL: no

The highly available NoSQL has a user-friendly interface, which is suitable for storing large data sets and is widely used in banking, finance, etc., as well as by Facebook and Twitter. Support Windows, Linux, OSX, and support multiple languages. Map/Reduce is also supported when used with Hadoop

10. Sybase ASE

First issue: 1987

Licensing mechanism: Proprietary

Whether SQL: yes

SAP's enterprise products run on Linux and Unix and Windows, but OSX does not support C, C++, Cobol, Java, Perl, PHP and Python programming languages.

Besides 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, the competition will become more and more fierce.

At this point, I believe you have a deeper understanding of "what are the top ten SQL and NoSQL databases?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.