Skip Headers
Oracle® Healthcare Operating Room Analytics User and Administrator Guide
Release 1.0.1

E16680-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

4 Maintaining the Repository and Warehouse

This chapter contains the following topics:

4.1 Maintaining the Oracle Healthcare Operating Room Analytics Repository

You can modify the ORA-delivered repository file (RPD) for any one of the following reasons:

Caution:

Exercise caution when you modify the RPD. Please conform with the following recommendations.

The following rules apply when you modify the RPD:

See Also:

4.2 Maintaining the Oracle Healthcare Operating Room Analytics Warehouse

For better performance of the dashboards and analyses, you should partition the following tables:

Table 4-1 Tables for Partitioning

Table Partition Type Columns Involved

W_EHA_CASE_F

PARTITION BY RANGE

CASE_DT_WID

W_EHA_OR_UTILIZATION_F

PARTITION BY RANGE

UTILIZATION_DT_WID

W_EHA_PROCEDURE_F

PARTITION BY RANGE

PROCEDURE_DT_WID

W_EHA_SCHD_PROCEDURE_F

PARTITION BY RANGE

SCHD_PROCEDURE_CREATION_DT_WID

W_EHA_SCHEDULED_CASE_F

PARTITION BY RANGE

SCHEDULED_CASE_CREATION_DT_WID


You should make partitions such that one partition holds data for one calendar month for a fact. For example, if the warehouse table has data for one year, there should be 12 partitions created based on the values of the partitioned column.

Also, the create script for bitmap indexes on partitioned tables should be changed. For example:

CREATE BITMAP INDEX IDX1 ON TAB1 (COL) local;