Oracle9i database configurations, Environment descriptions, General purpose – Oracle Audio Technologies ORACLE9I B10508-01 User Manual

Page 20: Online transaction processing, Oracle9, Oracle9 i database configurations

Advertising
background image

Oracle9i Database Configurations

1-4

Oracle9i Installation Guide Release 2 (9.2.0.2) for HP Alpha OpenVMS

Oracle9i Database Configurations

When you install the Oracle9i database product, you are prompted to select a
database configuration that is suited to your needs

.

Select from one of five Oracle9i

database configurations:

1.

General Purpose

2.

Online Transaction Processing

3.

Data Warehouse

4.

Customized

5.

Software Only

Options one through three are preconfigured databases that you can use for your
Oracle9i database

.

Each preconfigured database is designed to provide optimal

support for particular database needs

.

Options four and five are configurations for

special needs

.

The following section describes some of these configurations.

Environment Descriptions

General Purpose

Users of this database type perform a variety of database tasks, ranging from simple
transactions to complex queries

.

Select this database environment for general

purpose use.

Online Transaction Processing

Users of this database type perform large numbers of concurrent transactions, in
which each transaction is a relatively simple operation that is processing a small
amount of data

.

Transactions consist of reading, writing, and deleting data in

database tables.

Billing databases, such as those commonly found on Internet commerce sites, are
the most common example of this database configuration

.

These databases are also

known as Online Transaction Processing (OLTP) databases.

Advertising