The original connection www. csdn. netarticle2014-09-112821640-the-top-10-sql-and-nosql-databases ranking according to the ranking of DBEngines, the ranking from the popularity of the analysis of the market on the 200 different databases, here list top 10. Undisputed Top3Oracle, MySQL, and MicrosoftSQLServe
The original connection http://www.csdn.net/article/2014-09-11/2821640-the-top-10-sql-and-nosql-databases ranking according to the DB Engines ranking, the ranking from the popularity of the analysis of the market on the 200 different databases, here a list of Top 10. Undisputed Top 3 Oracle, MySQL, and Microsoft SQL Serve
Original Text connection
Http://www.csdn.net/article/2014-09-11/2821640-the-top-10-sql-and-nosql-databases
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: Enterprise, Standard, Standard Edition One, and Express
- Compared with Microsoft products of the same type, Oracle has more advantages in operating system flexibility.
- Oracle has the widest range of flexibility when talking about supported Operating Systems
- 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.
- It can run on Linux, Windows, OSX, FreeBSD, and Solaris.
- 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.
- Supports Partitioning, replication, Xpath, Stored Procedures, Triggers, and Views.
3. Microsoft SQL Server
Initial Release1989
License Mechanism: Proprietary
SQL?: Yes
- Most used commercial databases
- Limited by Windows, 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 Database Service
- It can run in Linux, Windows, OSX, etc.
- Supports 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, such as queries and indexes.
- High Performance in big data sets
- It is very helpful for dynamic queries and index definitions.
- Supports Linux, OSX, and Windows, but the database size on 32-bit systems is limited to 2.5 GB
6. DB2
Initial Release1983
License Mechanism: Proprietary
SQL?: Both
- Oracle 11g competitive product released by IBM
- It can run on Linux, UNIX, Windows, and large hosts.
- Design Based on IBM host environment
- Supports both SQL and NoSQL Models
7. Microsoft Access
Initial Release1992
License Mechanism: Proprietary
SQL?: Yes
- Only one installation is required (database and tool are integrated)
- Similar to Microsoft SQL Server, it runs intelligently on Windows
- The original design was traffic analysis, but its performance was not designed for medium to large projects.
- Supported languages: C, C #, C ++, Java, VBA, and Visual Basic. NET
8. SQLite
Initial Release2000
License Mechanism: Open Source
SQL?: Yes
- An independent serverless database engine that does not have any external dependencies. It is used on iPhone, Firefox, and Skype.
- As an embedded database, it is widely used in devices such as iPhone, and has been deployed in desktop software such as Skype and Firefox.
- No configuration or management required
- The entire database is saved on a disk file and can grow to 7 TB.
- The most widely supported languages in the Top 10
9. Cassandra
Initial Release2008
License Mechanism: Open Source
SQL?: No
- High-availability NoSQL
- Has a user-friendly interface for storing large datasets
- It 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
- Running in Linux, Unix and Windows, but does not support OSX
- Supports 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.
The top 10 SQL and NoSQL databases (compilation/ZhongHao review/Wei)
