Selection of Oracle, SqlServer, Mysql, and PostgreSQL databases
Selection of Oracle, SqlServer, Mysql, and PostgreSQL databases
All DB-Engines Ranking ranks list can be found here
The DB-Engines Ranking ranks database management systems according to their popularity. The ranking is updated monthly
Several relational databases currently on the market are: Oracle, Mysql, SqlServer, PostgreSQL, etc.;,
(1) Oracle is a large database, Oracle has a market share of 40%, oracle can run on all mainstream platforms, oracle has high security, and has obtained the highest certification level ISO standard certification, Oracle has high performance, and the price of Oracle is also very high. The space used for Oracle installation is also very large. Oracle has about 3G, which has high hardware requirements, and Oracle uses a large amount of memory space and other machine performance when used.
(2) SQL Server is a database launched by Microsoft. SQL Server can only be run on Windows. It is the most convenient to use, the most convenient to develop, and the most convenient to operate and maintain, but there is no slight openness. The stability of the operating system is very important to the database. , Not open source, and the security factor is not as high as Oracle, SQL server has not obtained any security certificate, the charge is slightly lower than oracle
(3) MySQL is a free and open-source database, Mysql is a small and medium-sized database,
The software is small in size, easy to install and use, and easy to maintain, with low installation and maintenance costs, and only 152M after installation.
Excellent performance, stable service, and few abnormal downtimes;
MySQL has a long history, the community and users are very active, you can ask for help when you encounter problems; and MySQL has open-source code and no copyright restrictions, autonomy and low cost of use;
(4) PostgreSQL advertises itself as the most advanced open-source database in the world. Some fans of PostgreSQL say that it is comparable to Oracle, and it does not have such an expensive price and arrogant customer service. It was originally developed at the University of California, Berkeley in 1985 as a successor to the Ingres database. PostgreSQL is an open source project driven entirely by the community. It provides a single full-featured version, instead of providing multiple different communities, business, and enterprise versions like MySQL. PostgreSQL is based on a free BSD/MIT license, and organizations can use, copy, modify, and redistribute code, just providing a copyright notice.
There are a lot of open-source software that PostgreSQL cooperates with, there are many distributed cluster software, such as pgpool, pgcluster, slony, plploxy, etc., it is easy to do read and write separation, load balancing, data level splitting, and other solutions;
PostgreSQL is not only a relational database, in addition to storing normal data types, it also supports storage:
array , whether it is an array or mostly array
json(hStore) and jsonb are much more efficient than text storage
Summary :
Oracle is a commercial database, not open, high performance and high security, the same price is expensive
SqlServer is also a commercial database, but it can only run on the Windows operating system, the security is not as high as Oracle, but the price is relatively low
Both Mysql and PostgreSQL are free, open-source databases, and the MySQL database is open source, but now with Sun being acquired by Oracle, it is now basically controlled by Oracle. In fact, before SUN was acquired, the most important InnoDB in MySQL The engine is also controlled by Oracle, and many important data in MySQL are placed in the InnoDB engine, so if the market scope of MySQL conflicts with the market scope of the Oracle database, Oracle will definitely sacrifice MySQL, which is nothing. No doubt, but the same MySQL is even more powerful under Oracle.
PostgreSQL is completely free, and it is a BSD protocol. If you change PostgreSQL and then sell it, no one will control you. This is very important, which shows that the PostgreSQL database will not be controlled by other companies and will not fall into. Vendors’ cages; PostgreSQL recently added JSON support. Compared with traditional relational databases, it provides greater data storage flexibility. Therefore, PostgreSQL excels MySQL in this respect.
Considering the cost of the project, non-open source databases are temporarily not considered,
Comparison of Mysql and PostgreSQL
PostgreSQL and MySQL are two kinds of databases that are different from the bottom design principles. When the amount of data is small, the database tends to be more lightweight, and MySQL will be more suitable. But once the amount of data rises slightly and the amount of calculation rises, PostgreSQL will be a better choice.
Compared with PostgreSQL and MySQL, PostgreSQL is more suitable for strict enterprise application scenarios (such as finance, telecommunications, ERP, CRM), while MySQL is more suitable for relatively simple business logic and low-reliability requirements for Internet scenarios (such as google, Facebook, Alibaba).
Thanks
Pankaj K.(pankajconnect.com).