Oracle9i OLAP Services Concepts and Administration Guide for Windows
Release 1 (9.0.1) for Windows

Part Number A90371-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go the next page

Learning the Basics, 5 of 5


Managing OLAP Services

Definition: OLAP Services

In its broadest definition, OLAP Services consists of the following components: the Oracle Java OLAP API, one or more OLAP services that run as child processes of a database instance, a metadata repository in each database instance, and tools within Oracle Enterprise Manager for creating OLAP metadata and managing OLAP services. However, OLAP Services is frequently used in this guide to refer to one or more components (such as an OLAP service child process) where distinctions among software components are not necessary.

Integrated tools

All of the tools that you use to manage OLAP services are integrated into Oracle Enterprise Manager. You do not need to use a separate set of tools.

Instance management

OLAP Services Instance Manager is the primary tool for managing OLAP services. You can use Instance Manager to do these system administration tasks:

For information about managing OLAP services, read "Introducing OLAP Services Instance Manager".

Metadata definition

The OLAP component of Oracle Enterprise Manager generates metadata for use by applications. This metadata is used to identify the facts available for analysis, and to create and populate multidimensional objects. These objects are needed to process analytical queries using data stored permanently in an Oracle data warehouse.

For information about configuring your data warehouse for use with OLAP Services, read "Using Oracle Enterprise Manager".

OLAP metadata

Metadata is typically defined as "data about data." OLAP applications can query the metadata repository to find out what data is available for them to analyze and display. While the data is stored in tables in an Oracle data warehouse, the metadata identifies the data in terms of the multidimensional objects they will become in OLAP Services: dimensions, measures, and attributes. Moreover, the metadata defines the dimension hierarchies required to aggregate the data into meaningful levels of detail.

For more information about creating metadata, read "Creating Metadata".

Language support

Globalization Technology provides the Oracle standard for internationalizing and localizing Oracle products. Its use throughout Oracle9i allows text data in native languages to be passed between the RDBMS and OLAP Services without data loss or performance degradation.

Additional information about Globalization Technology is provided in "About Oracle Globalization Technology".

Security methods

The metadata maps OLAP Services security directly to the security of the RDBMS. Users can access through OLAP Services only the data that they are authorized to access in the database.

Users can provide proof of identity in the following ways:

For more information about these security methods, refer to your Oracle9i networking and security documentation. For information about defining users, refer to "Granting Access Rights to Users".


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback