Inherent Differences

Table 191. Inherent Differences Between Aggregate Storage and Block Storage

Inherent Differences

Aggregate Storage

Block Storage

Storage kernel

Architecture that supports rapid aggregation, optimized to support high dimensionality and sparse data

Multiple blocks defined by dense and sparse dimensions and their members, optimized for financial applications

Physical storage definition

Through the Application Properties window, Tablespaces tab in Administration Services

Through the Database Properties window, Storage tab in Administration Services

Create database

Migrate a block storage outline or define after application creation

Note:

Do not use the file system to copy a block storage outline into an aggregate storage application. Use the migration wizard in Administration Services to migrate the outline.

Define after application creation

Copy database

Not supported

Supported

Databases supported per application

One

Several (one recommended)

Application and database names

See Naming Restrictions for Applications and Databases. Names reserved for tablespaces, cannot be used as application or database names:

  • default

  • log

  • metadata

  • temp

See Naming Restrictions for Applications and Databases.

Application and database information display

Displayed in the Application Properties window and the Database Properties window in Administration Services.

Information not supported by or relevant to aggregate storage applications is not shown. For a description of aggregate storage-specific information, see the Oracle Essbase Administration Services Online Help for the Application Properties window and Database Properties window.

Displayed in the Application Properties window and the Database Properties window in Administration Services

Configuration settings (essbase.cfg)

For a list of the settings that apply to aggregate storage databases, see the Oracle Essbase Technical Reference.

For a list of the settings that do not apply to block storage databases, see the Oracle Essbase Technical Reference.