AcomparisonofMySqlAndOracleppt.pptVIP

A comparison of MySQL And Oracle Jeremy Haubrich Importance of choosing the right database High cost for an enterprise system Databases can hold the “keys to the castle” Databases can give companies a competitive advantage Direct comparison isn’t fair Oracle and MySQL are built for different markets Oracle is designed for the enterprise customer with a big enough budget and more complex business needs MySQL is a lower cost database that is most commonly used for database driven web sites and non mission critical applications Features that look identical in a brochure may be implemented very differently (ex. row level locking) Cost Oracle $36,000 per processor for Enterprise Edition + optional $8,000 for support and software updates $5,000 per processor for Standard Edition + optional $1,100 for support and software updates Oracle Features Oracle Management Server Central administration, monitoring, and tuning of multiple databases Schedule and share database tasks with other admins Oracle Change Manager Allows you to create a change plan and see the effects of your changes before actually implementing them Also shows any changes that cannot be applied Administrative Alerts Oracle will contact the admin by email or pager when an error condition occurs Can be scheduled to reduce false positives More Oracle Features Capacity Planning Tracks usage patterns to help admins plan for upgrades Feedback on CPU, disk and query performance Query Optimizer Oracle chooses the most efficient way to execute a SQL statement Analyzes tables and indexes to minimize the cost of the transaction MySQL Features Easy to get started with Many free GUI management tools like PHPMyAdmin Speed is emphasized over lesser used features Uses very little overhead MySQL uses just under 1MB of RAM on my laptop My Oracle 9i installation uses 128MB while idle More MySQL Features Beginning to support advanced features Stored Procedures, Triggers, Views in the next version (5) Select statements with sub