Choosing your database type

There are three broad categories for setting up a database when you install Oracle database using the installation wizard:

  • Transaction Processing: Online transaction processing is typically for applications with multiple users inserting and updating low volumes per transaction
  • General Purpose: A batch application that loads large volumes of data during specific windows
  • Data Warehouse: An application that can have multiple users (transactions) requesting large volumes of data for read-only

Getting ready

Identify the key stakeholders, business process owners, and system owners within the identified process flows.

How to do it...

To determine the initial configuration of the database, it is important to get an understanding ...

Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.