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