Solutions for Highly Scalable Database Applications: An analysis of architectures and technologies

Published: May 30, 2006

Download

OracleRAC.pdf

644 KB
Portable Document file

Get Adobe Reader

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 Oracle RAC
•	Oracle 10g RAC benefits
•	Analysis of Oracle 10g RAC
•	RAC is Very Complex to Manage
•	RAC requires Application and Schema Design Changes
•	RAC requires special storage solutions
•	Patching RAC is difficult
•	Tuning RAC is Complex

•

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 - Scalability Comparison
•	Scalability beyond a single SMP Server
•	Oracle 10g RAC and SQL Server 2005 - Availability Comparison
•	Protection from Server Failure
•	Protection from Storage Failure

•

Oracle 10g RAC and SQL Server 2005 - Cost Comparison

•

Oracle 10g RAC and SQL Server 2005 - Comparison Summary

•	"Scaling-Out" with SQL Server 2005

•

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

출처 : http://www.microsoft.com/korea/sql/prodinfo/compare/oracle/default.mspx