Relational Database Design using Oracle Warehouse Builder

1
Relational Database Design using Oracle
Warehouse Builder
5

• Jan Cordtz
• Product Manager Business Intelligence
• Oracle Denmark

2
Agenda

• Introduction
• Business Intelligence
• Logical design and physical design
• Creating Dimensions and Facts
• Implementing this Data Model
• The ETL process
• Putting Data into the Data Model using a mapping
• Quering the Datamodel

3
ltInsert Picture Heregt
Implementing the data model
4
The Deployment process
Design Repository Logical Design
Runtime Repository Physical
Deployment
5
The deployment process

• Takes the logical design and puts it into the
  database (the physical design/storage)?
• Create the SQL necessary for creating the objects
• ... and runs those scripts against the database
• Only validated objects should be deployed.
• The deployment process uses SQL known as DDL
  statements.

6
Requirements

• Validate the objects in question
• Use the control center to do the deployment
• Register the location(database) before the first
  deployment.
• Deploy the objects in right order.

7
Things to observe

• OWB spilts the deployment of an object in to
  different parts
• Create the table and columns
• Create the primary key
• Create the foreign keys
• Create indexes
• What could then happen ?

8
The validate process - 1

• Found in the menu in the tree structure

9
The validate process - 2

• Found in the menu in the object editor

10
The validate process - 3

• The result of a validation

11
The Deployment process
Design Repository Logical Design
Runtime Repository Physical
Deployment
The Control Center
12
The Control Center

• Controls (!) the operation done towards the
  database(s)?
• Location used by a Control Center needs to be
  registered before being used the first time.

13
Calling the control center

• You must have opened a project before you can
  call the control center.

14
The Control Center
Locations
Objects in this location
Status for deployments
15
The Register Process - 1
16
The Register Process - 2
You cannot deploy any object before you have
registered it
17
Mark objects for deployment
Remember to use Replace when You want to
recreate an object
18
Deployment

• Multiple objects can be marked for deployment

19
Deployment to file
20
ltInsert Picture Heregt
Implementing the data model
End of section