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.