MySQL vs MongoDB, a NoSQL Database and Coding Essay

MySQL vs MongoDB, a NoSQL Database and Coding Essay

Length: 996 words (2.8 double-spaced pages)

Rating: Good Essays

Open Document

Essay Preview

Introduction.

The introduction of the computer has significantly changed our lives in a very short period of time.

Originally the computers were designed to help a person calculate numbers and nowadays a computer allows huge amounts of information to be stored in a small place, calculate mathematical problems easily and communicate with other people via the social networks.

Between the 1960’s and the 1970’s emerged different types of databases in order to satisfy the need of storing and retrieving data in an organised and consistent manner.

The growing needs in industry and he huge amount of data collected by software nowadays is becoming a real problem to business/organizations due that the storage technologies are not advancing and performing as expected.

There is a huge amount of data which require be organising, analysing and storing in databases to be accessed by multiple users/applications at the same time. Also databases are prepared to conserve all the data stored in case of failure or disaster.

The aim of this report is to compare two different databases, one relational database such as MySQL, considered as a well-defined concept and based on a solid and mature theory, with MongoDB the most popular NoSQL database defined as a new concept of database used for complicated queries(ability to handle very fast unrelated and unstructured
data).

This report will include:

• Overview of Transaction Management theory
• Brief Introduction to both databases.
• Analysis of recovery and concurrency
• Advantages and disadvantages
• Brief conclusion.



Definitions, Acronyms, and Abbreviations

Database
Relational Database
Oracle
SQL
MySQL
MomgoDB
RDMS
DML and DDL
ACID - Atomicity, Consistency, Isolation and Durability






...


... middle of paper ...


...mmits the current transaction and starts a new transaction.
Here is a simple test code on the default transaction:

Output:

Observe that:
• How InnoDB is specified as the storage engine for the table.
• How to turn off the auto-commit flag.
• How uncommitted changes can be rolled back.
• Uncommitted changes are rolled back at the end of the session.

Here is another simple test code on non-default transactions:

Output:


Observe that:
• "jack" is in the table because the previous commit statement ends the non-default transaction. The insert statement on "jack" is automatically committed.
• "user1" and "user2" are in the table because transactions cannot be nested. A "start transaction" statement commits the changes and ends the current transaction.
• "user4" is in the table because the previous rollback statement ends the non-default transaction.

Need Writing Help?

Get feedback on grammar, clarity, concision and logic instantly.

Check your paper »

Database Management System : Mysql Server Essays

- Chapter three: Case Study In the previous chapter we generally mentioned Graph databases together with other types of NoSQL database; however, since one of the main goals of this thesis is giving a simple analysis for two systems, it is necessary to understand what main features and what these systems have. Consequently, in this chapter we will find what are the most Databases that have the best availability and scalability. First of all, we will choose a simplest type of the relational database and describe it which is MySQL....   [tags: SQL, Database, MySQL, Databases]

Good Essays
3366 words (9.6 pages)

Mysql And Open Source Essay

- Open innovation is the use of purposive inflow and outflow of knowledge to accelerate internal innovation as well as to expand the markets for external use of innovation. The central idea behind open innovation is that in a world of widely distributed knowledge, companies cannot afford to rely entirely on their own research, but should instead use a mix of internal as well as external ideas. In addition, internal inventions not being used in a firm's business should be taken outside the company (e.g., through licensing, joint ventures, spin-offs)....   [tags: Database Mysql Business Analysis]

Good Essays
839 words (2.4 pages)

Advantages of MySQL over Oracle Essay

- ... These prevent a user updating or modifying the database while it’s being read or written too. (Moodle.Ncirl.ie/Advanced_Databases.2014)   Concurrency Control Concurrency Control locking Strategies: There are two types of locking strategies that apply to a database management system, these are known as ‘Pessimistic Locking’ and ‘Optimistic Locking’. These are two different methods to control data within a database to prevent any lock problems. Pessimistic Locking: This lock strategy prevents concurrency by keeping an entity in the database locked whole it’s in the database’s memory....   [tags: database, website, security]

Good Essays
1332 words (3.8 pages)

Essay on Database Model Of Column Family Database

- • Key-Value Stores Key-value stores are designed for storing data in flexible and schema-less way. In these databases, data is stored as a list of keys with their corresponding values. All keys are unique and data access is achieved by means of key-value association. In addition, all keys are stored in a hash table to provide quick access for them. Values may contain actual information (raw data), or they may contain another set of keys. Key-value stores provide high concurrency, fast lookups and massive storage....   [tags: Database, Relational model, Relational database]

Good Essays
707 words (2 pages)

Essay about Relational Database Industry For Many Years

- Since the SQL language appeared in mid 1970s, it has been leading the relational database industry for many years. With the modern era of databases not everyone sees the advantages of using relational databases. NoSQL, was first developed in the twenty first century (MongoDB, para 19) to address the issues that the SQL language could not handle. NoSQL cannot handle pure relational database models, it can use any of five different kinds of models, including relational to solve problems. With the variety of models, designers are wondering if there is a future for the strictly relational language SQL, and it’s other disadvantages compared to that of NoSQL....   [tags: Database, Relational model, SQL]

Good Essays
1017 words (2.9 pages)

Database Analysis : Database And Information Systems Essay

- Database & Information Systems is a database used in everyday life, it was used in the past, is used in the present, and will continue to be used in the future. There are single and multiuser databases, as well as N Tier an client servers. There are many types of Data models such as, relational and star schema. Databases and information systems are even used on the web, these types can include PHP scripts and CGI scripts. To understand how Database & Information Systems came about, one has to look at the history of data....   [tags: SQL, Database, Relational model, Computer]

Good Essays
836 words (2.4 pages)

Open Source Database Management Systems Essay

- A number of recent studies have revealed that most enterprise customers nowadays prefer open source databases over commercial databases. Based on their requirements, the enterprises also have option to choose from a number of open source relational database management systems (RDBMS) including MySQL, MangoDB, Cassandra, Redis and PostgreSQL. But the usage statistics posted on various websites indicate that MySQL is more popular than other open-source and proprietary relational database management systems....   [tags: SQL, Database, Database management system]

Good Essays
716 words (2 pages)

Essay on THE SYSTEM DESIGN TOOLS – PHP AND MySQL

- THE SYSTEM DESIGN TOOLS – PHP AND MySQL Technology that harnesses and perhaps brings out the best and redefines the very way working is done has got lot to be talked upon. Because what was thought just a gradual process of logics and application is today dominating the every sector of life no matter how diminutive it may be. Perhaps that’s the irony of present day, where there are numerous technologies that have actually redefined the very way of working and the way they are anticipated. For the current project pertaining to elite institution web site which pledges to bridge the communication gap between the students and teachers, there were many options which could provide a comfortable int...   [tags: Information Technology]

Good Essays
1810 words (5.2 pages)

Database Comparison of SQL Server 2000, Access, MySQL, DB2, and Oracle Essay

- Introduction This paper will compare and contrast five different database management systems on six criteria. The database management systems (DBMS) that will be discussed are SQL Server 2000, Access, MySQL, DB2, and Oracle. The criteria that will be compared are the systems’ functionality, the requirements that must be met to run the DBMS, the expansion capabilities – if it is able to expand to handle more data over time, the types of companies that typically use each one, the normal usage of the DBMS, and the costs associated with implementing the DBMS....   [tags: essays research papers]

Good Essays
1088 words (3.1 pages)

MySQL Partitioning Essay

- MySQL Partitioning Partitioning for MySQL is a support for: partitioned file systems and servers, and multiple systems and servers for a single database. MySQL partitioning is completed on the tables not the file systems or servers. Table partitioning allows a table to be stored over multiple storage areas. MySQL uses row partitioning known as “horizontal partitioning”. Of version 5.5, MySQL does not allow column partitioning known as “vertical partitioning”, and it is not in development to do so....   [tags: Information Technology]

Good Essays
1191 words (3.4 pages)