preview

An Open Source Relational Database Management System Essay

Better Essays

Assessment 1:
1) Investigate and compare the features of the below mentioned category of DBMS. [choose one]
a) Ms SQL2014 VS MySQL 5.5
b) Ms SQL2014 vs ORACAL 11.g
A) Identify the similarities and different.[Range: data access tools, recovery, audit, distributed data management, backup, transaction processing]
Answer: - SQL is known as structured query language to manipulating and accessing database. And it is designed to manage large amount of data of company. It’s manage and make us easy to find any information in less time. SQL was developed by IBM in 1970’s by Donald D. Chamberlin and Raymond F. Boyce. MySQL is an open source relational database management system it is developed under the General Public License (GPL) of SQL. MySQL is the famous choice for web applications. It is written in C and C++. Swedish company was created this MySQL. This server come under two different editions. The open source MySQL community server and the proprietary enterprise server are the 2 different types of MYSQL server. MySQL is the database management system like SQL server, oracle etc.
DATA ACESS TOOLS
Similarities based on data access tools:-
• Both has an integrated SQL debugger to help locate bugs in SQL language stored procedures
• Both are based on graphical user interface (GUI) tools for querying the databased.
• MySQL has only have few dialog boxes but SQL2014 has many dialog boxes which are known as graphical wizards.
Different based on data access tool:-
• We can measure and

Get Access