5-2 Final Project Milestone Three - DBMS Research and Recommendation.docx

This preview shows page 1 - 4 out of 8 pages.

DBMS Research and RecommendationIT 650 Final Project Milestone ThreeDBMS Research and Recommendation
DBMS Research and RecommendationDBMS: ResearchIn every organization, while designing a database it is very important to identify what DBMS software is to be used and how will that fit to their needs. If the right DBMS is not identified then it would cost the organization a huge amount of money and can also effect the security of the data. There are different software’s in the market that would fit the structure of the database. Following are the different DBMS software’s that would fit for the structure of Westlake Research Hospital:oMicrosoft SQL Server by Microsoft:Microsoft SQL Server designed by Microsoft follows the rules of Relational Database Management System. The query language that this software uses is Structured Query Language (SQL). The GUI provided with this is very easy to use and to manage the security can be easy. This DBMS can store as much as dataas possible. The software would range from $600 to $4000. oOracle by Oracle:This is also a Relational DBMS designed by Oracle. This server has got different tools that will help the engineers to do their tasks better. Oracle has released Oracle 18c as the latest software where c is for the cloud services. Oracle DBMS is very costly to purchase.oIBM DB2 by IBM:DB2 is also a Relational DBMS designed by IBM. This is one more DBMS released by IBM which will run across different operating systems (Windows, UNIX and Linux). This is little challenging to use the database server compared to the others. The server would be costly to purchase.oMySQL by Oracle:This is also a Relation DBMS by Oracle. It is the open source software that can beused by any user for free of cost. This is the DBMS which can used across all the operating systems. The GUI is not available for MySQL. DBMS: Analysis
DBMS Research and RecommendationWhen it comes to the Westlake Research Hospital, the main motto is to have the database security. To choose the best software for this project, the strengths and weaknesses of different software are being discussed below:DBMSStrengthsWeaknessesMicrosoft SQL Server This has got a GUI which can be easily used by the users to view the data or manipulate the data. Security of the data is maintained really well by restricting the users at the server level as well at the database level can help the Westlake Research Hospital database to be more secured.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture