MySQL General Information Comparison of Oracle, MySQL and PostgreSQL DBMS CONTENTS: 1. General consideration 2. Elementary features 3. Transactions 4. Programming in DB 5. Administration 6. Portability and Scalability 7. Performance and VLDB 8. Application development and interfaces 9. Reliability mercial issues 1. GENERAL CONSIDERATION: ---------------------------------------------------------------------------------------------------- Category Problem Importance MySQL Oracle PostgreSQL ---------------------------------------------------------------------------------------------------- Elementary features Basic data types C B C A SQL B B B B Declarative constraints B C A A Programming abstractions A C A C Transactions Transactions A D A A Locks A D A A Programming in DB Multiuser access A C A C Stored procedures and triggers B C A A Administration Access control B A A B Backup A C A C Data migration C A B A Portability and Portability B B A B Scalability Scalability A B A C Query optimization A B A B Structures supporting optimization B D A B Support for OLAP B D A D Performance and VLDB Allocation of the disk space A C A C (Very Large DB) Size limits A B A C VLDB implementation A D A B Access to multiple databases C C A C Special data types Large objects B B A C Post-relational extensions C D A B Support for special data types C D A C Application development Embedded SQL C D A B and interfaces Standard interfaces B B A B Additional interfaces A A A A Web technology A B A B XML B D A D CASE B D A D Reliability Recovery A C A C Commercial issues Prices C A D A Technical support A C B C Position in the market A C A C --------------------------------------------------------------------------------------------- Oracle8i and Oracle9i features are considered for the parisons, and MySQL versions base 4 and higher, PostgreSQL versions and higher. 2. ELEMENTARY FEATURES:
