Preliminary comparison of mysql5, postgresql8, and Oracle10g [posting]

Preliminary comparison of mysql5, postgresql8, and Oracle10g

Http://www.51cto.com techtarget

This is a comparison I made when installing and starting to use Oracle 10g, postgresql8, and MySQL 5. I will compare three types of databases from the following three artistic forms: Business vs. Academic vs. Internet model. This is a comparison from the perspective of a beginner who wants to install and learn the database. I try to explain it from the perspective of a family or a small business user. Completely unveiled: I am very inclined to Oracle, and really hope that no other product can really compete with it. License fee: I don't want to get involved in open source and resource confidentiality disputes. Oracle is a commercial database. to use it, you must pay the license fee. MySQL and PostgreSQL are open-source projects. Oracle provides you with a free development license to test and create a prototype. Configuration: I am using an old machine with a memory of 256 MB, a hard disk of 40 GB, and a CPU of 633 MHz. The operating system is Windows2000 Professional Edition. I want to install it on low-end configurations to measure the installation performance of the home user type. Operating System: I chose to compare it in windows, because I believe this is still the most common platform for people who recently use databases. I mean people install it at home. For new company users, they do not need to choose the operating system or database. Of course, this comparison is meaningless. Version: PostgreSQL 8.0 -- PostgreSQL 8.0 is a very new product. I chose 8.0 because it is the latest version, and it originally supports windows. This is the first version that truly supports windows without the need for simulators or third-party recompilation. MySQL -- MySQL 5.0 is also a very new product. In fact, the version I use v5.0.4 is a beta version. I hesitated for a while for the stable V4 or beta version. Finally, I chose V5 because V4 cannot compete with PostgreSQL or Oracle. V4 does not have stored procedures, triggers, views, and so on. Without the above features, I think it is not qualified as a competitor, while V5 supports the above features. Oracle 10 GB-this is the latest version of Oracle, which was released last year. In my opinion, Oracle 10 Gb is the gold standard for database duplication. However, I still think it is too expensive and requires considerable knowledge in the product environment to maintain it. Score indicators: Documentation and entry-level support Easy to install It is easy to check whether the installation is successful Non-administrator user Creation Time when the first query was run Resource requirements Score: I give each indicator a score from 1 to 10. 10 indicates the best or the highest. Documentation and entry-level support Postgresql-I found its support for many previous versions (in Linux, cygwin, and other environments), but its support for Windows is only 8.0. PostgreSQL File Management Website: http://www.postgresql.org/docs. I think one of postgresql's strengths in the past is its documentation. This website contains excellent installation documents. However, the documentation and entry-level documentation after installation are very limited. I hope they can change this situation in time. I found "PostgreSQL getting started" on Google and got thousands of clicks, but almost all of them are version 7. PostgreSQL supports some Usenet newsgroups, but I found that they are not very active. PostgreSQL score: 5 Mysql-because v5 is so new that there are not many documents yet. All over the world are MySQL V3 and V4 documents. Looking at Amazon or bn.com, MySQL seems to be quite a small choice of Internet and Java-oriented companies. Because v5 is a beta version, I will not rate this indicator, because the document will give it at the time of release. V4 has amazing documents, and I very much expect V5 to have the same number of documents when releasing products. I give a score based on the V4 document. I searched "MySQL getting started" on Google and got millions of clicks, almost all of which were V4. I did not find the USENET newsgroup support for MySQL, but I found that some MySQL support is provided in the comp. Databases group. MySQL document score: 8 Oracle, as a commercial product, has a large number of full-time technical editors. Each feature is described, and many features have their own manuals. The installation documentation provided by Oracle is very good, but its disadvantage is that it is composed of a third-party website dedicated to Oracle. Documentation, just like the documentation portal, is very mature. In addition to the installation documents for each operating system, Oracle also provides a 2-day Database Administrator guide. This document is indispensable for new users. I searched for "Oracle getting started" on Google and found millions of clicks. Oracle also has robust USENET newsgroup support. Oracle document score: 10 Easy to install PostgreSQL I have never used PostgreSQL on cygwin (a Windows Unix environment. I am very surprised that the installation has arrived. It runs very naturally without any leaks. The installation process is also very fast. PostgreSQL is the fastest installation. According to the description, you can install the SDK without administrative permissions. This is the first PostgreSQL version that supports windows (without cygwin). I want to test the service support. PostgreSQL is installed as a service and can be started after the machine is restarted. PostgreSQL installation score: 10 MySQL I used to build a website for my own entertainment and use MySQL as a database. The technology I use is Java/Apache/MySQL. Based on past experiences, I expect MySQL to win in installation. However, MySQL is the only one that fails to be installed. I cleared and re-run the installer. Failed again. I cleaned up again, restarted my computer, and re-ran the installation program. This installation is successful. I'm not sure what caused the error. It is hidden deeply, but it causes several failures. However, I can force it to pass. Remember, this is only a beta version. MySQL can also be installed as a Service. After the machine is restarted, no error starts. When it runs correctly, the installation is fast. MySQL installation score: 5 Oracle Oracle once again proved that it is a very mature product. Among the three, Oracle is the only one that can be installed without administrator permissions. This option is very good. In addition, it is indeed very easy to install. I have not encountered any errors. Oracle is the only one that prompts me to press the next button at the end of the installation. This method is very useful for new users and requires almost no effort. All databases should provide such support. In fact, Oracle is criticized for its installation time. This is indeed a problem for home users. Several times I suspect that my machine has crashed, because I have not received any feedback for a long time. Oracle Installation score: 7 It is easy to check whether the installation is successful It is difficult to verify whether the installation is successful, but the above three databases provide data access tools. According to the instructions in the documentation, I can access the server in all three environments. Verification scores of the above three databases: 10 Non-administrator user creation: PostgreSQL: PostgreSQL uses the standard create user syntax. You can easily execute this task. This document guides you through this task (for security purposes ). PostgreSQL User Creation score: 10 MySQL: The create user syntax can also be used in V5. Earlier versions are not supported. Therefore, the document is incomplete; it cannot be clearly seen whether the create user can be used. This is confusing for new users. MySQL user creation score: 7 ORACLE: Oracle uses the standard create user syntax and I can easily execute this task. This document guides you through this task. Oracle user creation score: 10 Time when the first query was run The preceding three database document sets provide guidelines for connecting to and running the first query. The first query score of the above three databases: 10 Resource requirements: Postgresql-I am very surprised by PostgreSQL's minimum resource requirements. I did some tests, such as opening a Web browser and MS-word during remote connection. We can see that my test machine has not received any influence. I did not find the minimum hardware requirement, but the 256 MB memory on the old machine looks enough. PostgreSQL resource score: 10 It is well known that the resource requirements of MySQL-MySQL are very small. This is one of its biggest selling points. I did the same test on PostgreSQL, and MySQL was executed as well as PostgreSQL. It is very strange that I did not find the minimum hardware requirement for MySQL, but the 256 MB memory on the old machine seems to be enough. MySQL resource score: 10 Oracle -- Oracle uses most of the memory, and 10 Gb of Oracle uses more than previous versions. In fact, it is best to run on a machine with 512 MB of memory. I recommend 1 GB of memory. On the testing machine, it took a long time to start Oracle alone. When I open the word, the memory starts to constantly switch and stagnate. After multiple remote connections are enabled, the database stops. Oracle can be installed and run on a machine with 256 MB of memory, but I do not recommend it. Oracle resource score: 3 So what is the overall evaluation? The final score is as follows: PostgreSQL: 55 MySQL: 50 ORACLE: 50 This is the installation and first use score. This is not what I expected at all. I think the scores of the three are very high. I did not expect this result, or Oracle and MySQL won't fight. I did not expect PostgreSQL to become the first place. However, installation is only a small part of the database. There are also language support, management, additional available features, security measures, and third-party support. In the near future, I will write a comparison of these parts.     Oracle 10g For MySQL 5.0 PostgreSQL 8.0 Documentation and learning support 10 8 5 Ease of Installation 7 5 10 Easy to verify successful installation 10 10 10 Create a non-admin user 10 7 10 Time when the first query is executed 10 10 10 Resource usage 3 10 10 Although PostgreSQL documents only scored 5 points, I think the official PostgreSQL documentation is also very comprehensive, but it is not widely used, so there is very little experience to talk about, I believe there will be more in the future.