Advantages And Differences Between Oracle And Mysql

732 Words2 Pages
bulb-icon

Recommended: What is the advantage of MySQL over oracle

- Kellie Hughes (x12388761) - HCC2 - Advanced Databases CA1 -
Research Report

Table Of Contents:

1. Overview of Transaction Management Theory
2. Introduction to the Chosen Databases
2.1 Introduction to MySQL
2.2 Introduction to Oracle
3. How Concurrency and Recovery Are Implemented
3.1 The Implementation of Concurrency
3.1.1 MySQL
3.1.2 Oracle
3.2 The Implementation of Recovery
3.2.1 MySQL
3.2.2 Oracle
4. Advantages and Disadvantages
4.1 Advantages
4.2 Disadvantages
5. Conclusion
6. Bibliography

1. Overview of Transaction Management Theory

In this assignment I will discuss transaction management and be carrying out research on two types of relational databases. The two databases that I have chosen to look into and compare are Oracle and MySQL. Both of these databases are regularly used today in the modern day between lots of different companies from all around the world.
But what is a relational database? A relational database is a database management system (or DBMS for short hand) in which all bits of the information and the database is put into groups of relations. 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) that the user does which when done correctly reads and or updates the contents of the database that they would like to change. The main purpose of any transactions is to: provide working units that can recover in the chance of a failure in the system and still manages to have a consistancy within the database. to provide proper isolation between programs accessing the database.

With a transaction you have this all or nothing feel, you either get it completely correct and everything goe...

... middle of paper ...

...d profiles like Wikipedia, Facebook and Google.

2.2 Introduction to Oracle

Oracle is another database management system and it is one of the best. Oracle database management system was set up by the “Oracle Corporation”. Oracle Corporation is an American based computer technology corportation. In 1977, Software Development Laboratories (SDL) was set up by Larry Ellison, Bob Miner and Ed Oates. This consultancy then developed the original version of the Oracle software. “Oracle” comes from the code name of a project that Ellison had worked on a few years previous. The Oracle Relational Database Management system or Oracle RDBMS for short has had some clients find it difficult to install on Linux systems. Unlike MySQL, Oracle is not open source and can become quite pricey when dealing with a lot of database materials. Oracle would not be my first choice of RDBMS.

Show More
Related

  • Huffman Trucking

    1834 Words  | 4 Pages

    SQL Server 2000 vs Oracle 9i. Retrieved December 1, 2007, from MSSQLCity.Com Web site: http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm

    Read More

  • Financial Analysis of Oracle Corp

    2599 Words  | 6 Pages

    In 1977, Larry Ellison, Bob Miner, and Ed Oates founded System Development Laboratories. After being inspired by a research paper written in 1970 by an IBM researcher titled “A Relational Model of Data for Large Shared Data Banks” they decided to build a new type of database called a relational database system. The original project on the relational database system was for the government (Central Intelligence Agency) and was dubbed ‘Oracle.’ They thought this would be appropriate because the meaning of Oracle is source of wisdom.

    Read More

  • Larry Ellison's Impact On Childhood And Education

    710 Words  | 2 Pages

    The website HowItWorks.com explains the relationship between tables is established by field in each table that relates to each other. It was the winning bid of a contract for the CIA that Software Development Labs created the first commercial database software. The software would eventually change how businesses store and retrieve

    Read More

  • Database Performance Tuning

    1067 Words  | 3 Pages

    System performance is one of the most critical issues faced by companies dealing with vast amounts of data. Companies use database systems and their applications to store, retrieve and handle this data.

    Read More

  • Essay On Mysql Workbench

    938 Words  | 2 Pages

    SQL Server provides a wizard for setting up database maintenance plans such as scheduling database and log backups. Both log and data files are created by SQL Server. Three main recovery models are covered in SQL Server. In a simple recovery, neither logging is done nor log recorded applied to the process. This method is mostly used for databases that never change. A full recovery includes the database changes into...

    Read More

  • Essay On Career Options In Information System

    1001 Words  | 3 Pages

    DBA deals with all of this by finding user needs, set the database, and test the system. DBA should enable editing any system he or she created. At the same time DBA should ensure the security of the data and guarantee data integrity and backup. Moreover, DBAs should know the database management systems (DBMS) that include the knowledge of Oracle, IBM DB2, and Microsoft SQL server (“Database Administrator,” 2010). Oracle is one of the most important platforms that DBA must know and have experience with. According to Kanaracus “The database experience we look for most of the time is Oracle”, says Tom Hart, executive vice president of the operations and technology group at Veritude. “SQL Server is more of a nice-to-have"

    Read More

  • Disaster Recovery Planning

    1326 Words  | 3 Pages

    ...mpany up and running through any kind of interruptions such as power failures, IT system crashes, natural or man-made disasters, supply chain/vendor problems and more.

    Read More

  • Advantages of MySQL over Oracle

    1332 Words  | 3 Pages

    MySQL does lack some features that oracle offer but the development team seem to be added new features to MySQL on a regular bases. MySQL is more suited for a website or smaller companies that don’t require massive amounts of database usage.

    Read More

  • History of Database Technology Past and Present

    1389 Words  | 3 Pages

    In 1970, Edgar Codd wrote several papers outlining in theory a new approach to database construction that would use a table of records and a unique identifier called a ¡§key¡¨ to search for related records within the table. Codd demonstrated that such a system could provide sets of data in a single operation without the need for the end user navigation required by earlier flat file models. Codd¡¦s theory resulted in the introduction of relational database management systems. Relational databases organize information in multiple tables that are linked together and include built-in functions allowing them to retrieve, sort, and edit the data in numerous ways. Instead of duplicating records in each table, the data can be stored in one table and simply linked to other tables that might utilize it. In addition, data retrieval speed is increased by the ability of a relational system to access any of the linked tables with a single connection instead of requiring multiple tables to be opened for data extraction (Wise).

    Read More

  • Oracle Databases

    1555 Words  | 4 Pages

    Some faculties and departments are already using Oracle applications in their day-to-day operations. As time goes by, more and more information users will be working with an application based on Oracle database technology. If you get the opportunity to be a member of an application development team, you will become familiar with the workings of Oracle and relational databases. Other users may have to learn about this popular database management system through their own experience. This article is for our readers who, as of yet, have no access to Oracle databases but have a yearning for learning what they're all about.

    Read More

  • Differentiate between database management system and information retrieval system by focusing on their functionalities.

    612 Words  | 2 Pages

    It was introduced to alleviate the data-dependency problem and also to remove unnecessary burdens from the application programmer. Some DBMS examples include mysql, postgresql, Microsoft Access, SQL Server, filemaker, Oracle, RDBMS, dbase, Clipper, and foxpro. It is important for there to be a way for them to communicate with each other since there are so many database management systems available. In database management systems, data is available in three levels which is physical level, conceptual level, and user ...

    Read More

  • The Database Management System (DBMS)

    1438 Words  | 3 Pages

    The Database Management System (DBMS) is software that enables the users to define, create, maintain and control the access to the database. It is a software that interact with the user’s applications programs and it database. Meanwhile, information retrieval system is a system that involved the activity that the systems obtain the information. The obtaining information action need the information from it resources.

    Read More

  • database management system and information retrieval system

    1069 Words  | 3 Pages

    A database management system in the main software tool of the database management approach because it controls the creation, maintenance, and use of the database of an organization and its users. The three major functions of a database management system are first to create new database and database application. Second to maintain the quality of the data in an organized database. And last to use the database of an organization to provide the information that its end users need. An example of a database management approach in a banking information system. Note how the savings, checking and installment loan programs use a database management system to share a customer database. Note also that the database management system allows a user to make direct, ad hoc interrogations of the database without using application programs.

    Read More

  • The Importance Of Database Management Systems

    1411 Words  | 3 Pages

    In our world, people rely heavily on the power of technology every day. Kids are learning how to operate an iPad before they can even say their first word. School assignments have become virtual, making it possible to do anywhere in the world. We can receive information from across the world in less than a second with the touch of a button. Technology is a big part of our lives, and without it life just becomes a lot harder. Just like our phones have such an importance to us in our daily lives, database management systems are the same for businesses. Without this important software, it would be almost impossible for companies to complete simple daily tasks with such ease.

    Read More

  • Essay On Effect Of Corruption

    1239 Words  | 3 Pages

    ...ng an acceptable form of transaction.Governments need to be more transparent to the public.A lot of ‘under table’ transaction take place in the most basic everyday services(passport,license, tax).Such services has the capability to go online reducing the red tape as money is only used via online transaction.

    Read More

More about Advantages And Differences Between Oracle And Mysql

Open Document