DBM/460 Week One - Capabilities Comparison

DBM/460 Week One - Capabilities Comparison

For this assignment, you will choose from the following options:

·         Option 1: Write a 1- to 2-page paper.

·         Option 2: Create a 3- to 5-slide presentation including speaker notes.

Compare the distributed database management system capabilities of Oracle^® and Microsoft^® SQL Server^®.

Develop a list of database management system capabilities to compare these systems.

Develop your criterion and definitions in a table that lists the criteria, your definition, and your rankings.

Consider some of the following capabilities:

·         Distributed data dictionary

·         Distributed data location transparent to developers and users

·         Security

·         Concurrency

·         Deadlock control

·         Global query optimization

·         Automatic failure recording and recovery

·         Data consistency among distributed copies of data

·         Single logical database view for distributed data

·         Scalability

·         Replication of data and stored procedures across distributed data

·         Cost

·         Support

·         Training and skill requirements

·         Database partitioning

·         Application clustering

Middleware integration and support