Preview

Mssql vs Mysql

Powerful Essays
Open Document
Open Document
1764 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Mssql vs Mysql
l Introduction An important aspect of database development is how to access your data using standard protocols. Both MySql and MSSql Server do a good job of supporting all major protocols for accessing their respective databases. MYsql and MSsql are the two Sql Servers that are commonly used today by the programmers and other IT people. These two are the most popular choices when considering a utility for data management. Both are efficient at keeping the data organized and readily available through a user interface but they differ in many drastic areas. Both are freely accessible for running small or big databases. Even they do have the same functionality; the existence of differences of the two known Sql Servers will still be a question to the users and to the future users. The major differences of this two will include the licensing costs, performance, and security.
This research paper will answer some key questions in determining which data management tool is best suited for the needs of the user like the flexibility of the data you are creating; the security of the data; the need of support in utilizing the data management tools; and the standard language support.
In this way the users of these management tools will determine which of the two will efficiently works on the programs they will be creating. It will also include here some of the important factors to consider a perfect database to be used in terms of their functional attributes that they could give for the users.
Basically, the significance of this study is to come up with a comparison of each database servers and will enable to answer the questions that are popping in the minds of the future users and the importance of a right and appropriate tools to be used. It will also identify the complexity of between the when it comes to some features and functionality.
By going through the pages of this research you will be able to identify the answer/s on the questions that arisen in choosing

You May Also Find These Documents Helpful

  • Powerful Essays

    Dbm 380 Week 1

    • 1191 Words
    • 5 Pages

    Database environments are very important in today’s industries. In selecting an organization that will need a database, I choose Smith Consulting. Smith Consulting will need a database to track their consulting staff, each staff member’s skill sets, and what projects they will be working on. This document will provide information on the following area’s listed below:…

    • 1191 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    One benefit of a relational database management system is that it contains a built-in query language, which lets you obtain immediate answers to the questions you ask about your data. _________________________…

    • 585 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    A database language must enable the user to create database and table structures to perform basic data management chores.…

    • 1917 Words
    • 8 Pages
    Powerful Essays
  • Best Essays

    Rob, P., & Coronel, C. (2002). Database systems: design, implementation, and management (5th ed.). Boston, MA: Course Technology.…

    • 1383 Words
    • 5 Pages
    Best Essays
  • Powerful Essays

    References: Rob, Peter and Coronel, Carlos. (2005). Database Systems: Design, Implementation, and Management. United States: Thomson Course Technology.…

    • 2376 Words
    • 10 Pages
    Powerful Essays
  • Satisfactory Essays

    Unit 1 Lab 1

    • 422 Words
    • 3 Pages

    Unit 1 Lab 1.1 – Explore the AdventureWorks Database Using the SQL Server Management Studio…

    • 422 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Athabasca Assignment

    • 837 Words
    • 4 Pages

    Relational databases are not new technology. Commercially, they gained importance in the early 1980s with the introduction of Oracle’s relational database, and since then they have been an essential tool for most businesses. Databases are critical tools that help to support various business functions in an organization. These information systems help a business to build and maintain competitive advantage. Databases not only support the operational levels of business—they are also used to support the activities of managers.…

    • 837 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Graphical User Interface

    • 559 Words
    • 3 Pages

    The choice of MySQL as the database platform has many advantage, some of them are:…

    • 559 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Database Environment

    • 1121 Words
    • 5 Pages

    When building a system for information, you have to decide how much responsibility for data management your software will take. A database can be rather large or it can be small depending on the information that is being stored. Request for information from a database are made in the form of a query or a question asking the database for particular information. All database management systems are not the same from a technical standpoint. They differ mostly in the way they organize their information internally. The internal organization can then determine how quickly and supplely the information can be extracted (Jupitermedia, 2011) .…

    • 1121 Words
    • 5 Pages
    Powerful Essays
  • Good Essays

    This paper will discuss the different databases in my organization with regards to what the databases are being used for and any improvements that can be made. To understand how a database helps the day-to-day functions of a business one must first know what a database does and how it works. A database is a “systematized collection of data that can be accessed immediately and manipulated by a data-processing system for a specific purpose” (English Dictionary). So a database is an application or tool used for storing and arranging information efficiently. Databases are very important tools in the workplace, if a company’s data is stored on a typically spreadsheet problems would arise fairly quickly. A spreadsheet is very hard to retrieve data except basic queries, and there is no multiple user access, and perhaps the most troublesome issue is that there is no integrity and data validation. In databases the structure is based on tables which have columns and rows that will store specific data. A row “in a table is referred to as a record. Records are where the individual pieces of information are stored” (Microsoft). Columns will identify the data in the table with the rows showing the records. The main types of databases are; relational and flat-file databases. “A flat file database is a database designed around a single table. The flat file design puts all database information in one table, or list, with fields to represent all parameters. A flat file may contain many fields, often, with duplicate data that are prone to data corruption” (databasedev). Flat file databases are good for small amounts of data that store simple data such as list and data values. Relational databases deals with more than one database at a time. It forms a relationship between tables that are manipulated to suite the user needs. The two main databases that I use at my job would be Microsoft Access and Microsoft SQL Server.…

    • 752 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Week 2

    • 263 Words
    • 2 Pages

    What are two of the most popular database vendors in the marketplace? What are the pros and cons of each vendor? What are some issues you would consider in making the decision to select a database vendor for an organization you work…

    • 263 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Ibm Db2 vs Oracle

    • 1231 Words
    • 5 Pages

    A side by side analysis of the hardware and software requirements for both DBMS 's shows some remarkable similarities as well as some differences. Similarities in baseline processors across the various hardware platforms but different amounts of disk space and both applications desiring as much memory as possible to improve performance (Chigrik, 2003).…

    • 1231 Words
    • 5 Pages
    Good Essays
  • Good Essays

    What are some of the most popular database vendors in the marketplace? What are the pros and cons of each vendor? What are some of the issues you would consider in making the decision to select a database vendor for an organization you work for? In your responses, please make sure that you are making reference to either information found in the text or outside resources. This information is necessary to clearly indicate that you understand the concepts being presented.…

    • 394 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    There are three types of Database Administration Tools, Oracle Enterprise Manger, Microsoft SQL Server Enterprise Manager and Sybase Central. This paper will discuss each one.…

    • 568 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    The MySQL database would enable us to stores a collection of data e.g. usernames and passwords, products and orders by customers, and designed around 3 key concept stability, speed and ease of use, and is available under the open source licence.…

    • 819 Words
    • 4 Pages
    Good Essays