13/13
Index
A C D E F H I J K M N O P Q R S T
A
- access layer, 2.1
-
- customizing, 3.1
- Oracle Utilities Data Model, 2.1
- aggregate tables
-
- in Oracle Utilities Data Model, 3.3
- As Is reports, 5.6.1
- As Was reports, 5.6.1
C
- compression
-
- in Oracle Utilities Data Model, 2.4.2, 2.4.2.1, 2.4.2.1.1
- materialized views, 3.5.4
- configuring Oracle Utilities Data Model warehouse, A.2
- conventions
-
- when customizing physical model, 2.2.2
- cubes
-
- adding materialized view capabilities to, 3.4.3.2
- changing the dimensions of, 3.4.6
- changing the measures of, 3.4.6
- customizing, 3.4.4
- data maintenance methods, 3.4.9
- forecast, 3.4.7
- in Oracle Utilities Data Model, 3.4.4, 3.4.5
- partitioning, 3.4.8
- customizing
-
- cubes, 3.4.4
- Oracle Utilities Data Model, 1.2
- physical data model, 2
D
- dashboards, Oracle Utilities Data Model, 5.2, 5.7
- data governance committee, responsibilities of, 1.3.2
- data mining models
-
- customizing, 3.2.2
- derived tables
-
- in Oracle Utilities Data Model, 3.2
- dimensional components, Oracle Utilities Data Model, 3.4
E
- ETL for Oracle Utilities Data Model, 4.1
F
- fit-gap analysis for Oracle Utilities Data Model, 1.4
- forecast cube in Oracle Utilities Data Model, 3.4.7
- foundation layer
-
- defined, 2.1
- Oracle Utilities Data Model, 2.1
- foundation layer of Oracle Utilities Data Model
-
- common change scenarios, 2.3.1
H
- hybrid columnar compression
-
- and Oracle Utilities Data Model, 2.4.2.1.3
I
- implementers of Oracle Utilities Data Model
-
- prerequisite knowledge, 1.3.1
- implementing
-
- Oracle Utilities Data Model, 1.2
- indexes
-
- in Oracle Utilities Data Model, 2.4.6
- materialized views, 3.5.2
- partitioning, 2.4.6
- integrity constraints
-
- in Oracle Utilities Data Model, 2.4.5
- intra-ETL
-
- Oracle Utilities Data Model, 4.1
J
- join performance, improving, 2.4.7.3
K
- keys, surrogate
-
- in Oracle Utilities Data Model, 2.4.4
M
- materialized views
-
- compressing, 3.5.4
- in Oracle Utilities Data Model, 3.5
- indexing, 3.5.2
- partition change tracking, 3.5.3
- partitioning, 3.5.3
- refresh options, 3.5.1
- metadata management
-
- repository, 6.1.2, 6.2
- with Oracle Utilities Data Model, 6.1
- metadata repository, 6.1.2
-
- browsing, 6.2
- with Oracle Utilities Data Model, 6.2
N
- naming conventions
-
- for physical model of Oracle Utilities Data Model, 2.2.2
O
- Oracle Utilities Data Model
-
- access layer, 2.1
- components of, 1.1.1
- customizing, 1.2
- customizing physical model, 2.1, 2.2, 2.2.1, 2.2.2, 2.4
- dashboards, 5.2
- data governance, 1.3.2
- dimensional components, 3.4
- ETL, 4.1
- fit-gap analysis, 1.4
- foundation layer, 2.1
- implementing, 1.2
- intra-ETL, 4.1
- metadata management, 6.1
- metadata repository, 6.1.2, 6.2
- Oracle products used by, 1.1.2
- physical layers of, 2.1
- pre-implementation tasks, 1.3
- querying, 5.3
- reporting, 5.1, 5.3
- sample reports, 5.2
- source-ETL, 4.1, 4.2, 4.2.1.2, 4.2.1.3, 4.2.1.4, 4.2.1.5
- staging layer, 2.1
- tablespaces, design recommendations, 2.4.1
- Oracle Utilities Data Model implementers
-
- prerequisite knowledge for, 1.3.1
- Oracle Utilities Data Model warehouse
-
- configuring, A.2
- sizing, A.1
P
- parallel execution
-
- enabling for a session, 2.4.8.1
- enabling for DML operations, 2.4.8.2
- in Oracle Utilities Data Model, 2.4.8
- partition change tracking, 3.5.3
- partition exchange load, 4.2.1.7.5
- partitioned indexes in Oracle Utilities Data Model, 2.4.6
- partitioning
-
- cubes, 3.4.8
- for easier data access, 2.4.7.2
- for join performance, 2.4.7.3
- for manageability, 2.4.7.1
- for source-ETL, 4.2.1.7.5
- indexes, 2.4.6
- materialized views, 3.5.3
- tables, 2.4.7
- partitions, changing, 2.4.1
- physical model of Oracle Utilities Data Model
-
- characteristics of, 2.1, 2.2, 2.2.1
- customizing, 2.2.2
- general recommendations for, 2.4
Q
- querying Oracle Utilities Data Model, 5.3
R
- refreshing
-
- materialized views, 3.5.1
- reporting
-
- Oracle Utilities Data Model, 5.1, 5.3
- reports
-
- approaches to, 5.1
- As Is, 5.6.1
- As Was, 5.6.1
- troubleshooting performance, 5.5
- reports, Oracle Utilities Data Model
-
- creating new, 5.8
S
- sample reports
-
- customizing, 5.2
- sizing
-
- Oracle Utilities Data Model warehouse, A.1
- source-ETL
-
- exception handling, 4.2.1.6
- jobs control, 4.2.1.5
- loading considerations, 4.2.1.7
- Oracle Utilities Data Model, 4.1, 4.2, 4.2.1.2, 4.2.1.3, 4.2.1.4, 4.2.1.5, 4.2.1.7
- parallel direct path load, 4.2.1.7.4
- partitioning for, 4.2.1.7.5
- workflow, 4.2.1.5
- staging layer, 2.1
-
- Oracle Utilities Data Model, 2.1
- star queries, optimizing, 5.4
- subtypes
-
- defining tables for, 2.4.3
- physical implementation of, 2.4.3
- supertypes
-
- defining tables for, 2.4.3
- physical implementation of, 2.4.3
- surrogate keys
-
- in Oracle Utilities Data Model, 2.4.4
T
- tables
-
- aggregate, 3.3
- compressing, 2.4.2, 2.4.2.1, 2.4.2.1.1
- derived, 3.2
- partitioning, 2.4.7
- tablespace in Oracle Utilities Data Model, 2.4.1