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:
- 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 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.