Hp ProLiant DL980 G7 Server Bedienungsanleitung PDF herunterladen (Seite 37)

Measure Group

A Measure Group (MeasureGroup object) is composed of basic information, measures, dimensions,

and partitions.

• Basic information includes the name of the measure group, the type of measures, the storage

mode, the processing mode, and others.

• Measures are the actual set of measures that compose the measure group. For each measure

there is a definition for the aggregate function, the formatting attribute, the data item source,

and others.

• Dimensions are a subset of cube dimensions used for creating the processed measure group.

• Partitions are the collection of physical splits of the processed measure group.

Partition

A partition is a container for a portion of the measure group data. Partitions are not seen from

MDX queries; all queries reflect the whole content of the measure group, regardless of how many

partitions are defined for the measure group. The data content of a partition is defined by the

query bindings of the partition and by the slicing expression.

Estimated Rows

The estimated number of rows in the partition.

Estimated Size

The estimated size of the partition in megabytes.

Proactive Caching

Proactive caching provides automatic MOLAP cache creation and management for OLAP objects.

The cubes immediately incorporate changes that are made to the data in the database, based

upon notifications received from the database. The goal of proactive caching is to provide the

performance of traditional MOLAP, while retaining the immediacy and ease of management offered

by ROLAP.

ESO database recommendation statements

Database File on System Drive

HP ESO recommends that you store the database file in a different location than the system or OS

drive. If a database file is found on the system drive, HP ESO's recommendation to relocate the

file displays on this page.

Multiple Database File on a Drive

HP ESO also recommends that the database files are located on a dedicated drive. If multiple

database files are found on a drive, HP ESO's recommendation for relocating them on separate

drives displays on this page.

Database page: Viewing high availability and disaster recovery configurations

HP ESO can provide information about availability and disaster recovery configurations for SQL

Server and Analysis Services databases.

Availability Group

An Availability Group, a feature introduced with SQL Server 2012, provides high availability for

application databases. Availability Groups support a failover environment for a discrete set of user

databases known as availability databases. An Availability Group provides all the benefits of

Database Mirroring but also comes with a powerful set of new options that increase application

Optimizations pages 37

1 2 ... 32 33 34 35 36 37 38 39 40 41 42 ... 56 57

Kommentare zu diesen Handbüchern

Keine Kommentare

Hp ProLiant DL980 G7 Server Bedienungsanleitung Seite 37

Kommentare zu diesen Handbüchern

Verwandte Produkte und Handbücher für Computerhardware Hp ProLiant DL980 G7 Server