Question

Case Study: Taking the Plunge/ CIW: Database Design Specialist

The management of Acme Widgets has agreed that a relational database management system should be implemented to track its customer and order information. Joe is now tasked with recommending a specific RDBMS.
Joe conducts several interviews with management in order to put together a requirements document. He is able to ascertain the following:

• The preliminary budget is minimal.

• The preliminary schedule is tight (management wants the system in place as soon as possible).

• Company sales have been increasing rapidly (approaching nearly 10,000 widgets sold per day), so the product must be scalable.

• The product must run on Windows, but may one day be ported to a different operating system.

• The system must provide enough basic security to protect confidential data.

After reviewing his requirements document and investigating several database management systems, Joe recommends MySQL 8.0 because it is open-source (which satisfies the budget constraint) and because it can import data from the spreadsheets in which it is currently stored. MySQL also offers sufficient scalability, portability, and security.

As a class, discuss Joe's recommendation of MySQL 8.0. What are the advantages of using an open-source product? What are the disadvantages? Based on the requirements document Joe has constructed, what other DBMS products (open-source or proprietary) might serve equally well for Acme Widgets Inc.?

Answer 1

Answer:-

     Joe's recommendation of MySQL 8.0 because it is an open source which can satisfy the budget also and easily available for the download.MySQL is a trust fully open source system(user can use without fear i.e they can trust on this software to store the data). In which the data can be stored are fully secure.

• Advantages of an using open source product

1. The cost of the hardware is less :- open source product can be easily compressed.

      2. The quality of the software is high:- The source code of the software is availabe and most of the open source software are well-designed open source software can also be easily used for coding.For this reasonthe open source software ar productis an ideal choice fororganisation.

     3. License mangement can be simple:- If the user can use open source product then they would no longer or more time for woy about the license.The open source product can be install for many timesand you can use from any place.

     4. Consolidating and Scaling:- It can be easily scaled with the help of varied option like clustring,load balancing,and some application also . Such as Database.the user can start our organization to archive higher growth in our business.

• Disadvantages of an using open source product

1. It is not ecofriendly in use (the user can not undestand in a single day).
2. The number of applications can be less in open source product.So ,in case many applications can not be used.
3. To understand any open source product you can hire a tutior ar a trainer of this product to makes thing understand easily and to used in a proper maner.

• Some other DBMS products (open-source or proprietary)

1. CUBRID
2. PostgreSQL
3. Firebird
4. cassandra
5. SQLite