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.