Advantages of MySQL over Oracle:MySQL is a fast, reliable, robust, open source database system that also offers a large number of features. Administration and security are effective and easy to set up. MySQL would be recommended for medium sized companies where the data processing to and from the database was not so huge, it is more suitable and aimed at websites. MySQL lacks some features offered by Oracle but the development team seems to be added new features for MySQL on a regular basis. MySQL is best suited for a website or smaller business that doesn't require large amounts of database usage. Advantages of Oracle over MySQL: Oracle is a much larger database software, can handle many more database requests and handle more transactions than MySQL. MySQL takes resources from the system to process requests which can overload the system. However Oracle has a built-in memory management feature that spreads the load across multiple threads making it much faster and less impactful on the system running it. Oracle is mostly used by larger companies, this is due to licensing costs or the amount of data they are processing. MySQL uses system memory for processing, so you will see a decrease in the system over time or after a couple of thousand rows of data, Oracle is less effective on the system and is mainly used by companies that process large amounts of data data such as a data warehouse. Oracle's backup functionality is much faster and better than MySQL. Saves a backup in seconds/minutes while MySQL can take forever.Cleverlogic.net. 2014. MySQL vs. Oracle SecurityConcurrencyConcurrency is a feature that allows multiple users of a database to read, modify, or update...... middle of the sheet ......contains information about all database updates. A log file usually contains transaction reports and checkpoint records. Write-Ahead Logging: This occurs when the transaction is entered into the system log before it is even written to the database. Steal/Don't Steal: If a cached page is updated by a transaction it cannot be written to disk before the transaction commits, it is known as No-Steal approach. If you write before the transaction commits, it is known as the steal approach. Force/No-Force: If all updates made by a transaction are immediately written to the database via a commit, it is known as "Force". If it is not written immediately it is a 'no-force'. Checkpoint: A checkpoint is a synchronization between the database and the system log file. A checkpoint record is recorded at intervals as the system writes to disk all buffers that have changed.