Reference no: EM131136431

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.