Solutions for Highly Scalable Database Applications: An analysis of architectures and technologies
|
Understanding the nuanced differences between two Relational Database Management Systems (RDBMS) products like Oracle 10g and SQL Server 2005 can be difficult for even the most seasoned database professional. In this paper, Performance Tuning Corporation compares and provides an analysis of the differences of these two RDBMS products in their ability to "scale-out" and "scale-up". From the paper, you will see how SQL Server 2005 supports both "scale-out" and "scale-up" while Oracle 10g offers "scale-out" only technologies. The paper says that Microsoft's approach asserting no single technology can fit all situations is a more cost effective option for today's large-scale business applications.
Included in this document:
| • | Business Requirements
| ||||||||||||||||
| • | Overview of SQL Server 2005 | ||||||||||||||||
| • | SQL Server 2005 Database Mirroring | ||||||||||||||||
| • | Comparison of SQL Server 2005 and Oracle RAC
| ||||||||||||||||
| • | Oracle 10g RAC and SQL Server 2005 - Cost Comparison | ||||||||||||||||
| • | Oracle 10g RAC and SQL Server 2005 - Comparison Summary
| ||||||||||||||||
| • | Service Oriented Database Architecture (SODA) | ||||||||||||||||
| • | SQL Server 2005 SODA Features | ||||||||||||||||
| • | Peer-to-Peer Transactional Replication | ||||||||||||||||
| • | Scalable Shared Database (SSD) | ||||||||||||||||
| • | Data Dependent Routing (DDR) | ||||||||||||||||
| • | Scaling-out with SQL Server 2005: Summary |
