Oracle 10g vs PostgreSQL 8 vs MySQL 5（外围特性评比）

This is my comparison of installing and getting started with Oracle 10g, PostgreSQL 8 and MySQL 5. This is what I consider the comparison of state of the art for three categories of DB: Commercial vs. Academe vs. Internet Model. This is a comparison from the view of a new user wanting to install a database to learn. I'm trying to keep the viewpoint of a home or small business user.
Full Disclosure: I am strongly biased towards Oracle and fully expected no real competition.

License: I will not get into a debate over open source and closed source. Oracle is a commercial database and requires licensing to use. MySQL and PostgreSQL are both open source projects. Oracle provides a free developers license for you to "test out" and create prototypes.

Configuration: I am installing on an older machine with 256 Megs of Ram and a 40 Gig hard drive. The CPU is a 633 Mhz Celeron. The OS is Windows 2000 Professional. I want to install at the low end of the spectrum to gauge the ability for home user-type installations.

OS: I chose to perform this comparison under Windows, as I believe that that is still the most common platform that new people to the world of databases will use. By that, I mean people installing at home. For new corporate users, the odds are good that they will not have a choice of either OS or database so a comparison is pointless.

Versions:

PostgreSQL 8.0 - PostgreSQL 8.0 is a very new product. I chose 8.0 as it is the latest version and it natively supports Windows. This is the first version that actually does support Windows without an emulator or third-party recompilation.

MySQL - MySQL 5.0 is also a very new product. As a matter of a fact, the version I used, v5.0.4, is actually a beta version. I argued with myself about whether I should use the stable v4 or the beta v5. I chose v5 because v4 does not compete with PostgreSQL or Oracle. V4 does not have stored procedures, triggers, views, etc. Without those features, I would not consider it as a contender. The upside to that is that v5 does support those features.

Oracle 10g – This is the latest version of Oracle and was released last year. In my opinion, Oracle 10g is the gold standard of databases. Nevertheless, I also recognize that it is very expensive and requires quite a bit of knowledge to support in a production environment.

Ranking Factors:

Documentation and Getting Started Support
Ease of installation
Ease of Verifying Successful Installation
Creation of Non-Admin User
Time to Run First Query
Resource Requirements
Ranking Values: I rank each factor a score of 1 through 10, with 10 being the best or highest.

Documentation and Getting Started Support

PostgreSQL - I found a lot of support for previous versions (under Linux, Cygwin, etc.), but almost nothing for 8.0 under Windows. The PostgreSQL documentation website, http://www.postgresql.org/docs/ , provides very good, very complete documentation. In my opinion, one of PostgreSQL's strengths in the past has been the documentation.

That web site includes a very good installation document. However, post installation and getting started documentation is very limited. I hope that that will change in time.

I googled "PostgreSQL getting started" and got thousands, mostly version 7, of hits. PostgreSQL has some Usenet newsgroup support, but I noticed they were not very active.

PostgreSQL Documentation Ranking: 5

MySQL – Because v5 is so new, there is not very much documentation yet. There is a world of documentation for MySQL v3 and v4. Check Amazon or BN.com. MySQL seems to be the choice for a lot of smaller Internet and java-oriented companies.

Because v5 is beta, I will not rank this factor according to the documentation available for that release. V4 has amazing documentation and I fully expect v5 to have the same by the time the software is released to production. I will rank according to v4 documentation.

I googled "MySQL getting started" and got millions, mostly version 4, of hits. I could find no MYSQL-specific Usenet newsgroup support, but I noticed some postings for MySQL support on the comp.databases group.

MySQL Documentation Ranking: 8

Oracle – Oracle, as a commercial product, has a large staff of full-time technical writers. Every feature is spelled out and many features receive their own books. The installation documentation provided by Oracle is superior and, where that is lacking, it is made up by third party sites dedicated to Oracle. The documentation, as well as the documentation portal, is very mature.

In addition to installation guides for just about every OS, Oracle provides a "2 day DBA" guide. This document is indispensable for new users.

I googled "Oracle getting started", and received millions of hits. Oracle also has robust Usenet newsgroup support.

Oracle Documentation Ranking: 10

Ease of Installation

 如果您对本文有任何疑问或者建议，请到讨论区发表您的意见: >> 论坛入口 <<