Technical Comparison of Oracle9i Real Application Clusters vs. IBM DB2 UDB EEE v7.2 Page 6
• How will the application architecture (OLTP, DSS) affect the database
performance?
• How much re-training will administrators need to support operations?
With only two real parallel database choices to pick from, Oracle9i Real
Application Clusters and IBM’s DB2 Universal Database EEE V7.2, the choice
should be easy.
INTRODUCTION
The focus of this paper is to compare the deployment of a real world
application in a cluster environment of Oracle9i Real Application Clusters ( RAC
) and IBM’s DB2 Universal Database EEE V7.2 ( DB2 EEE ) parallel database.
The reason for this focus is two fold. First, both databases have many features
so we need to limit the scope of this paper to where both products compete.
And secondly, if you are addressing the needs of today’s IT environments,
reliability, availability and scalability through modular growth, then clustering is
the only solution that will provide a cost effective solution.
We will first look at the hardware and software platforms to see how they
measure up, and what, if any, special requirements are needed, as well as the
costs that are associated with them. Next, we will look at the deployment of
the application and what it takes to roll out a production system. Once the
application is up and running, performance becomes the top priority of the data
center. We will break this down into three environments, OLTP, DSS and
packaged application because they have different requirements and
characteristics that need to be addressed.
We can first note that the hardware and software requirements are similar. The
abstraction to the application is also the same with both solutions - it gives an
illusion of a single database and there is no need to modify the SQL code. The
differences are in ease of deployment, performance and manageability.
First, let’s clarify some definitions and terminology that we will use.
In DB2 terminology, the term partition is used to refer to a logical node and the
data that is owned by the logical node. This usage is different from the RAC
usage where a partition refers to a part of a table or index. In this document, we
use the word partition to mean a logical node (i.e, the DB2 usage). Each
partition has its own buffer pool, package cache etc. It may be convenient to
think of a partition as equivalent to an Oracle instance except that it can access
only a subset of the data directly.
HARDWARE REQUIREMENTS
Both databases have similar cluster hardware requirements. A cluster is a group
of independent servers that collaborate as a single system. The primary cluster
components are processor nodes, a cluster interconnect (private network), and
剩余32页未读，继续阅读
Jerry_kuang
- 粉丝: 1
- 资源: 13
我的内容管理
展开
最新资源
- 构建Cadence PSpice仿真模型库教程
- VMware 10.0安装指南：步骤详解与网络、文件共享解决方案
- 中国互联网20周年必读：影响行业的100本经典书籍
- SQL Server 2000 Analysis Services的经典MDX查询示例
- VC6.0 MFC操作Excel教程：亲测Win7下的应用与保存技巧
- 使用Python NetworkX处理网络图
- 科技驱动：计算机控制技术的革新与应用
- MF-1型机器人硬件与robobasic编程详解
- ADC性能指标解析：超越位数、SNR和谐波
- 通用示波器改造为逻辑分析仪：0-1字符显示与电路设计
- C++实现TCP控制台客户端
- SOA架构下ESB在卷烟厂的信息整合与决策支持
- 三维人脸识别：技术进展与应用解析
- 单张人脸图像的眼镜边框自动去除方法
- C语言绘制图形：余弦曲线与正弦函数示例
- Matlab 文件操作入门：fopen、fclose、fprintf、fscanf 等函数使用详解
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
