Question

Discuss at least two of the most popular commercial database systems. Compare and contrast the specific strengths, weaknesses, and features of each database system, as well as the operating systems that each database system will run on?

In response to your peers, discuss the details shared about each system and compare it to your findings. Try to find a classmate who wrote about at least one of your systems and one that chose a different system.

Finally, how do you think the skills you have learned will help you in your future courses at Post University? What courses will you be taking next term? Have you already registered for next term? If you have not already registered, why not?

Answer 1

Oracle 12c

The newest version of Oracle, 12c, is designed for the cloud and can be hosted on a single server or multiple servers, and it enables the management of databases holding billions of records. Some of the features of the latest version of Oracle include a grid framework and the use of both physical and logical structures.

This means that physical data management has no effect on access to logical structures. Additionally, security in this release is excellent because each transaction is isolated from others.

Pros

• You'll find the latest innovations and features coming from their products since Oracle tends to set the bar for other database management tools.
• Oracle database management tools are also incredibly robust, and you can find one that can do just about anything you can possibly think of.

Cons

• The cost of Oracle can be prohibitive, especially for smaller organizations.
• The system can require significant resources once installed, so hardware upgrades may be required to even implement Oracle.

Ideal for: Large organizations that handle enormous databases and need a variety of features.

Oracle 12c runs only in Oracle Linux.

MySQL

MySQL is one of the most popular databases for web-based applications. It's freeware, but it is frequently updated with features and security improvements. There are also a variety of paid editions designed for commercial use. With the freeware version, there is a greater focus on speed and reliability instead of including a vast array of features, which can be good or bad depending on what you're attempting to do.

This database engine allows you to select from a variety of storage engines that enable you to change the functionality of the tool and handle data from different table types. It also has an easy to use interface, and batch commands let you process enormous amounts of data. The system is also incredibly reliable and doesn't tend to hog resources.

Pros

• It's available for free.
• It offers a lot of functionality even for a free database engine.
• There are a variety of user interfaces that can be implemented.
• It can be made to work with other databases, including DB2 and Oracle.

Cons

• You may spend a lot of time and effort to get MySQL to do things that other systems do automatically, like create incremental backups.
• There is no built-in support for XML or OLAP.
• Support is available for the free version, but you'll need to pay for it.

Ideal for: Organizations that need a robust database management tool but are on a budget.

My sql runs in Linux, Solaris, macOS, Windows and FreeBSD