Wait a second!
More handpicked essays just for you.
More handpicked essays just for you.
What is the advantage of MySQL over oracle
Don’t take our word for it - see why 10 million students trust us with their essay needs.
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.
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
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.
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.
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
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...
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"
(Mullins 1995) Currently, the more sought after relational database products are incorporating more and more complex features and components to simplify procedural logic. Due to the complexity of todays relational database, corporations are changing the established way of dealing with database management personnel. Traditionally, as new features were added to the database, more and more responsibility fell on the DBA. With the emergence of the relational database management system (RDBMS), we are now beginning to see a change in the database administrator's role.(Mullins 1995)
...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.
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.
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).
In this report I will discuss briefly how transaction management can be used within the database I will also discuss how concurrency and recovery can be used within databases I intend to use the database platforms provided by Microsoft and Oracle.
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.
The relational database model is based upon tables or relations. In this model, the physical implementation of the database is abstracted away from the user. Users query the database using a high-level query language, such as SQL. The relations are made up of columns, which have headings indicating the attribute represented by that column. Tables have key fields, which can be used to identify unique records. Keys relate tables to each other. The rows of the relation are also called tuples, and there is one tuple component for each attribute – or column – in that relation. A relation or table name, along with those relation’s attributes, make up the relational schema. Relational Database models are server-centric.
...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.
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 ...