preview

DB2 Case Study

Satisfactory Essays
DB2
DB2 is a family of relational database merchandise produced via IBM. DB2 delivers an open database setting that runs on a varied selection of computing platforms.
The DB2 databases have great self-configuring features, it doesn’t need a database installation process as it already has IBM installed, since the database has unique Single Level Storage concept of the system, responsibilities such as observing and creating table spaces or complicated partitioning of data through disk subsystems is not needed. The software also offers automatic data spreading for the entire database objects.
Benefits of the DB2 databases are that it contains many self-healing features which minimalize the recovery period just in case a system failure occurs, also lets the system to automatically monitor the capacity of a database transaction log and automatically manages index rebalancing remake catalogue views.
The self-tuning features include the cost-based query optimizer which has advanced query rewrite methods. The optimizer can automatically discover differences made to the database, which allows it to recreate query plans minus user intervention to make the most of the newest alterations to the system to make best use of the database. It also include an Adaptive Query Processing function which can change the join sequence or utilize a new index, statistics which can determine the best way of retrieving the data and performance analysis components let you simply examine and develop your indexing plan. It also contains great security because of the object based security model.
MySQL
MySQL is an open source relational database management system. It is built on the structure query language (SQL), which is used for inputting, deleting, and adjus...

... middle of paper ...

...ystem. It is a full-featured database primarily designed to compete against competitors Oracle Database and MySQL.
Some benefits to using SQL server are the seamless navigation which gives enough support for users to know how to work the system without asking an expert for assistance, it includes a query editor which is a tool used for executing T-SQL quires, which comes with the three features which support the database; Estimated Execution plan, Actual execution plan and Client Statistics. The Object scripting allows you to script out an object from one server to any other server, Generate Script Wizard which allows users to move their databases quickly and efficiently. It also contains templates, dialog supports to help the user and Object Explorer Details which provides a tabular view of all the objects in the server and produces a user interface to manage them.
Get Access