OLAP Server 发表评论(0) 编辑词条

Features
Industrial-strength, multidimensional database
Designed to handle large volumes of business intelligence data.
Supports multidimensional (MOLAP) and hybrid (HOLAP) data stores.
Routines enable SAS procedures to query the SAS OLAP Server by using SQL Pass-Through with reach-through from multidimensional data to the underlying detailed data.
Native support for open industry standards:
OLE DB for OLAP.
Fully compliant implementation of MDX query language for communication with third-party clients.

Fast processing of queries.
Multithreaded query engine.
Data can be spread across multiple disk systems, providing parallel read access for query threads.

Easy-to-use GUIs for building and maintaining OLAP cubes.
Included with SAS OLAP Server, SAS OLAP Cube Studio makes it easy to define data dimensions and aggregations.
SAS OLAP Cube Studio is integrated with SAS Data Integration Studio so you can build cubes from cleansed data sources and load them for later use and updating.
New Java-based wizard facilitates designing, creating, updating and tuning OLAP cubes.

Optimization of summarized data to conserve system resources.
Seldom accessed data can be stored in a compressed format.
Frequently queried data can be cached in memory for faster access.



Centralized metadata.
All metadata is stored in a single, open location - the SAS Metadata Server. SAS OLAP Server is fully integrated into the open security model maintained in SAS Metadata Server that is used across all SAS products and solutions.
Powerful interfaces for OLAP server monitoring.
Define OLAP data servers and their configuration parameters, including performance logging options.
Application Response Management (ARM) classes used to monitor all server activities. Result sets can be transferred to SAS or third-party clients, such as HP-UX Workload Manager, in order to monitor activity and performance.
功能
为处理大量的经济职能数据而设计
支持多维和混合数据存储。
例程将使SAS程序，查询使用SQL传递的SAS OLAP服务器，通过与范围，从多方面的数据基础，通过详细的数据。
本机支持开放的行业标准：
OLE DB提供OLAP的。
完全符合执行MDX查询语言与第三方客户端通信。

快速处理的查询。
多线程查询引擎。
数据可以分布在多个磁盘系统，提供查询的并行读线程访问。

易于使用的建设和维护OLAP多维数据集图形用户界面。
与SAS OLAP服务器，工作室的SAS OLAP多维数据集包含可以方便地定义数据尺寸和聚合。
工作室的SAS OLAP多维数据集相结合的SAS数据整合工作室，您可以构建多维数据集数据源净化和负载以后使用和更新。
新的基于Java的向导方便设计，创建，更新和调整OLAP多维数据集。

汇总数据的优化，以节省系统资源。
很少访问的数据可以存储在压缩格式。
经常查询的数据可以缓存在内存以便快速访问。