Differences in basic architecture and management between Oracle and DB2

[IT168 technical documentation]

1. Introduction

Today's IT environment is experiencing dramatic changes, and companies that rely on a single relational database management system (RDBMS) to manage data are gradually decreasing. Analysts report that more than 90% of companies today have more than one RDBMS. In the current tense economic situation, the actual needs are challenging the limits of IT staff. It is increasingly rare for a company to assign different DBAs to manage each RDBMS. Today, DBAs must manage different RDBMS across platforms, which is very common.

"58% of DBAs are required to manage more than one database platform ." -- From: SearchDatabase.com

Generally, a DBA not only has basic relational theory knowledge, but also has a special RDBMS experience. The basic principles of database design and management are the same among all RDBMS. To become a successful cross-platform DBA, the key is to grasp the true understanding of the terms and the nuances of different RDBMS. This article will discuss the differences in the basic architecture and management between multi-platform Oracle and DB2 UDB.

2. Basic Components

Most of the object types and functions on different platforms are very similar. Some important differences are the usage of stored procedures and log generation methods. This article will discuss these topics in detail.

Table 1: Differences in common terms in basic database Components

　　

 

3. Product Options

Select a version when installing any database. To meet your IT needs and make the right decisions, IT is important to understand the differences between different database versions.

Oracle 10g:

Enterprise Edition;

Standard Edition;

Express Edition.

Enterprise Edition is the most widely used version. If you want to use an OEM additional package, this version can meet your needs.

DB2 UDB for Linux/Unix/Windows (LUW) V 9.1:

Data Warehouse version;

Enterprise Server Edition (ESE );

Work Group edition;

Simplified version;

Personal Edition;

General development edition;

Personal Development edition.

Before DB2 udb v 8.1, you have two options for the company environment: Enterprise Edition-EE and Extended Enterprise Edition-EEE ). They are generally called Double E and Triple E respectively. EEE is an environment of a concurrent server type. It is similar to RAC in Oracle. It is usually applied to the installation of a giant data warehouse. IBM integrates the underlying code with V8.1, this is what we know now: Enterprise Server Edition (ESE ). The Data Partition component (DPF) is an additional component that can be used by database partitions. This makes it easy for the system to migrate from an EE-type environment to an EEE environment.

4. Data Types

Even the data formats stored in databases of different brands are different, which is a headache for DBAs and developers who are allocated to an unfamiliar database.

The following table describes the different data types between databases:

　　

 

5. Data Dictionary/Cataloguing

The two RDBMS databases store database-related metadata in a group of related tables. These tables are called data dictionaries in ORACLE and known as System Catalog for DB2 in DB2 ).

ORACLE has a set of basic data dictionary tables in SYS mode. These basic tables define a set of views of storage system information and object information. A group of views, namely the V $ view, can access dynamic performance information. The static information of the object can be obtained from the View starting with ALL _, DBA _, and USER.

In DB2, each database contains a group of basic tables called system Cataloguing in the SYSIBM mode. In SYSCAT mode, object information is usually obtained in a group of views defined on these tables. In addition, DB2 provides updatable and a set of views mainly used to operate access paths in the recover at Mode.

6. Access the database

Each database vendor provides a unique set of tools to access and manage their own databases.

6.1 Oracle Enterprise Manager (OEM)

OEM provides some basic database management functions. To use more advanced functions, you must purchase additional packages:

-Change Management Package.

-Diagnostic package.

-Adjust the package.

-Restore the management package.

-SQLPLUS: Basic command line interface.

6.2. IBM control center (CC)

The control Center specifies basic database management features, such as creating/deleting objects, generating tools/commands, and some interfaces: Command Center, Script Center, and Visual Explain.

6.3. IBM health center (HC)

Since DB2 LUW V8.1, IBM has introduced the idea of autonomous computing, a concept in a "self-repair" database. The concept of autonomous computing is still in its early stages of development, and the health center allows you to define thresholds for different performance metric values in the database. If the threshold is exceeded, an alarm is automatically triggered.

• 5 pages in total:
• Previous Page
• 1
• 2
• 3
• 4
• 5
• Next Page