- Kellie Hughes (x12388761) - HCC2 - CA1 Advanced Databases - Research Report Summary:1. Overview of transaction management theory2. Introduction to Selected Databases2.1 Introduction to MySQL2.2 Introduction to Oracle3. How Concurrency and Recovery are Implemented3.1 The Concurrency Implementation3.1.1 MySQL3.1.2 Oracle3.2 The Recovery Implementation3.2.1 MySQL3.2.2 Oracle4. Advantages and disadvantages4.1 Advantages4.2 Disadvantages5. Conclusion6. Bibliography1. Overview of Transaction Management Theory In this assignment I will discuss transaction management and research two types of relational databases. The two databases I chose to examine and compare are Oracle and MySQL. Both of these databases are regularly used today by many different companies around the world. But what is a relational database? A relational database is a database management system (or DBMS for short) where all the bits of information and database are placed into groups of relationships. Many popular databases to date, including Oracle and MySQL, all use the relational database system. What is a transaction? A transaction is an action(s) performed by the user that, if executed correctly, reads and/or updates the contents of the database that they wish to modify. The main purpose of any transaction is: to provide units of work that can recover in the event of a failure in the system and still manage to have consistency within the database. to provide adequate isolation between programs accessing the database. With a transaction you have this "all or nothing" feeling, or you get everything right and everything goes... middle of paper... d profiles like Wikipedia, Facebook and Google.2.2 Introduction to OracleOracle is another system of database management and is one of the best. Oracle Database Management System was created by “Oracle Corporation”. Oracle Corporation is an American information technology company. In 1977, Larry Ellison, Bob Miner, and Ed Oates founded Software Development Laboratories (SDL). This consulting firm then developed the original version of Oracle software. "Oracle" comes from the code name of a project Ellison had worked on a few years earlier. The Oracle Relational Database Management System or Oracle RDBMS for short has had difficulty with some clients installing on Linux systems. Unlike MySQL, Oracle is not open source and can get quite expensive when dealing with a lot of database stuff. Oracle would not be my first choice of RDBMS.