1. Index

Index

Numerics  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  Z  

Numerics

A

  • about
    • refresh statistics 9.1
  • accessing
    • real-time materialized views 6.7.1.2
  • ADO, and IM column store 2.5.3
  • aggregates 5.2.1, 12.9.5
  • aggregation
  • alter analytic views 24.8
  • altering dimensions 10.6
  • alternate keys
    • of an attribute dimension level 25.4
  • amortization
  • analytic functions 22.3.5
  • analytic processing
    • materialized views 6.2
  • analytic views
  • application containers, sharing analytic views with 24.7
  • applications
    • decision support systems (DSS) 4.1.2
  • APPROX_COUNT function 4.7
  • APPROX_RANK function 19.2.1.2
  • APPROX_SUM function 4.7
  • approximate aggregations 19.3.1
  • approximate query processing 4.6
  • approximate top-n query processing 4.7
  • approximate values
  • architecture
    • data warehouse 1.4
  • attribute-clustered tables 13.1
  • attribute clustering 13.1
  • attribute dimensions
  • attributes 2.2
    • attribute dimension 25.2
    • creating hierarchies using 26.5
  • automatic big table caching

B

  • base measures
  • bind variables
  • bitmap indexes 4.1.1
  • bitmap join indexes 4.1.5
  • B-tree indexes 4.1.6
    • bitmap indexes versus 4.1.3
  • build methods 5.3.5
  • business intelligence 1.1
    • queries 23
  • business rules

C

D

  • data
  • database
  • data compression 4.4.1
    • See data segment compression 5.3.4
  • data cubes
  • data densification 19.6
    • time series calculation 19.7
    • with sparse data 19.6.2
  • data error handling
  • data marts 1.4.3
  • data rules
  • data segment compression 3.2.1.2
  • data transformation
  • data warehouse 5.1
  • data warehouses
    • common tasks 1.3
    • key characteristics of 1.1.1
  • date folding
  • DBMS_ADVISOR
    • TUNE_MVIEW procedure 5.3.6
  • DBMS_ERROR package 18.4.2.3
  • DBMS_MVIEW package 7.1.7
    • EXPLAIN_MVIEW procedure 5.10.1
    • EXPLAIN_REWRITE procedure 12.8.2
  • DBMS_SYNC_REFRESH package 8
  • decision support systems (DSS)
  • degree of cardinality 4.1.3
  • DENSE_RANK function 19.2.1.1
  • densification
  • DESCRIPTION classification 24.6
  • design
  • DETERMINES
    • clause of an attribute dimension level 25.5
  • dimension levels
  • dimensions 3.2.6, 10.1, 10.4
  • dimension tables 5.1.6
  • displaying
    • real-time materialized views 6.7.7
  • drilling down 10.1
  • drop analytic views 24.8
  • DROP MATERIALIZED VIEW statement
    • prebuilt tables 5.7
  • dropping

E

F

G

H

I

  • IM column store, managing contents 2.5.3
  • indexes
  • initialization parameters
    • QUERY_REWRITE_ENABLED 11.2.1
  • In-Memory aggregation 20.8.6
  • In-Memory Column Store
  • in-memory expressions 2.5.1
  • in-memory virtual columns 2.5.2
  • integrity constraints 4.2
  • invalidating
    • materialized views 6.5
  • itemsets

J

K

L

M

N

O

P

Q

R

S

  • schemas
  • set operators
    • materialized views 6.2.5
  • simultaneous equations 22.5.4
  • skipping levels in a dimension 10.2
  • SKIP WHEN NULL clause 10.2
  • snowflake schemas 2.4.3
  • source systems 16.1
  • sparse data
  • SPLIT PARTITION operation 4.4.1
  • SQL modeling 22.1
  • staging
  • star queries
    • star transformation 4.5.2
  • star schemas
    • dimensional model 2.4.1
  • star transformations 4.5.2
  • statistics 12.9.9
  • storage
    • optimizing 4.4
  • summary management
  • synchronous refresh 8
  • sync refresh 8

T

U

V

  • validating dimensions 10.5
  • validating hierarchy data 24.5
  • VECTOR GROUP BY
  • VECTOR GROUP BY aggregation
    • optimizing star queries 4.5.4
  • view constraints 4.2.2.7, 12.3.6
  • VPD
    • and materialized views 6.4.1
    • restrictions with materialized views 6.4.1.2

W

Z