Defining your database layout

Oracle information is stored within a schema. The schema is the objects (tables, views, sequences, and so on) owned within the database. In a business intelligence and data warehouse solution, there are normally multiple schemas that encompass the solution.

Getting ready

Understand the proposed technology for the project and pre-read the installation requirements to get an understanding of the schema requirements.

How to do it...

Creating schemas within the database allows you to segregate and separate objects. This makes it easier to manage the objects with greater flexibility.

Separate your schemas into two categories:

  1. Application Owners: These are the required schemas to house the information for the solution:
    • a.

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.