Question

Please list two popular DBMS software. Discuss the advantages and disadvantages of them.

Answer 1

SQL is an acronym for Structured Query Language. It is used to access, manipulate and retrieve information from a database.

MySQL is an open source Relational Database Management System (RDBMS) based on Structured Query Language (SQL). It runs on platforms like Linux, UNIX and Windows.

SQL Server is owned and developed by Microsoft Corporation. The primary function of SQL Server is the storage and access of data as it is required by other applications, whether they are running on other computers that are connected to a network, or the computer on which the server is stored.

MS SQL Server	MySQL
Developed by Microsoft.	Developed by Oracle.
It supports programming languages like C++, JAVA, Ruby, Visual Basic, Delphi, R etc.	MySQL offers extended running support for languages like Perl, Tcl, Haskey etc.
Expects a large amount of operational storage space.	Expects less amount of operational storage space.
It enables for stopping query execution.	It doesn’t allow query cancellation mid-way in the process.
Doesn’t block the database while backing up the data.	Blocks the database while backing up the data.
It is not free.	It is open source. It is freely available.
It is a highly secured and doesn’t allow any kind of database file manipulation while running.	It allows database file manipulation while running.
It is available in multiple editions, such as Enterprise, Standard, Web, Workgroup, or Express.	It is available in MySQL Standard Edition, MySQL Enterprise Edition, and MySQL Cluster Grade Edition.

MySQL is the database management system. It is also referred to as an Open-source relational database management system (RDBMS). It supports all platforms like Windows, Mac OS, Solaris, Free BSD, Linux, etc. It was mainly written in C and C++. Its type is RDBMS and available in the English language only. SQL Server is defined as a relational database management system (RDBMS). It supports the platforms that are Linux, Microsoft Windows, and Windows server. SQL Server provides the language drivers to connect easily with any code.

MySQL

• MySQL was created by a Swedish company MySQL AB. The features are like support to cross-platform, stored procedures, triggers, cursors, data definition language, ACID compliance, SSL support, views updatable, partitioning, Indexing, select, commit grouping, Unicode support and many more.
• There are certain limitations in My SQL. In MySQL, Triggers are limited to only one action per timing. It means only one trigger can be executed on the table if any event happens on the table. Triggers cannot be defined on views as well. The other limitation is MySQL does not follow the full SQL standards.
• MySQL uses the ‘mysqldump’ backup tool, which supports backing up of data from all the storage engines. The other MySQL back up software program is ‘XtraBackup’, which is open-source. MySQL can be run on Cloud as well as Amazon and Microsoft Azure. MySQL can be used as a service

SQL Server

• SQL Server also referred to as MSSQL means Microsoft SQL Server. It was developed by Microsoft. It was initially released in the year 1989. It was written in C and C++. It is available in multi-languages like English, Japanese, French, Spanish, Chinese, etc.
• SQL Server has many editions like Enterprise edition, basic or Standard edition, Web edition, BI, workgroup, and Express edition. SQL Server has many features like the same database can be used by multiple developers. The database table model is used for storing records or information. The syntax is very simple for writing the basic queries like for Insert, create, update and delete, which is also referred to as CRUD statements
• SQL Server provides high scalability as it can be used for small projects as well as large applications. It helps in taking care of millions of transactions per day. It gives better performance and high speed while retrieving the data for the application. SQL Server also used as a service like SSAS, SSRS, SSIS, SSNS. SQL Server has a feature to integrate with a Visual studio for data programming.

Key differences between MySQL vs SQL Server

Both MySQL vs SQL Server are popular choices in the market; let us discuss some of the major Difference Between MySQL and SQL Server:

• MySQL is mainly used for the PHP projects or applications. SQL server is mainly used for the.Net applications or Windows projects.
• In MySQL, there are multiple storage engines which give developers more flexibility to use the engine for the tables based on the performance. One of the popular storage engines is InnoDB. SQL server can use only one or having a single storage engine.
• In MySQL, once the query has been executed, it cannot be canceled in mid-way. In SQL server, the query can be canceled in mid-way after the execution.
• MySQL does not have any tool which provides security. SQL Server has a security tool which ensures the data security etc. that is MS baseline security analyzer tool.
• MySQL is free of cost and free to use. SQL server is licensed and need to purchase licenses to use and run multiple databases. It is really costly to buy multiple licenses.
• For MySQL, it is required to pay for getting support or assistance. SQL server has wider community support or online forums. Microsoft support is also paid for providing support to the bSQL server.
• If MySQL used with.Net, then third party tools are required to download for getting started. If the SQL server is used with.Net, inbuilt framework classes provide the compatibility and can be started with LINQ queries as well.
• MySQL uses the Enterprise manager as IDE tool. SQL server uses the management studio as IDE for developing the queries.

MySQL vs SQL server both is used as a relational database management system. Both MySQL vs SQL server databases provide immediate consistency. Both MySQL vs SQL server are using the ACID transaction types. They also provide support for typing, data scheme, XML support, triggers and secondary indexes.

MySQL is more popular as it is open source, free of cost and compatible with many platforms as compared to SQL server. The SQL server high cost paid license makes the developers uncomfortable to work with the platforms like Linux. If Linux is the platform, mainly MySQL is being used. Only Windows-based application Developers go with SQL server for integrating the languages like.Net etc.