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