SAS OLAP CUBE STUDIO统计软件闻其普 发表评论(0) 编辑词条

SAS OLAP CUBE STUDIO
20071042228闻其普

SAS OLAP CUBE STUDIO的特征是有高工业强度的多维数据库,它能设计的商务智能处理大量数据,能够支持多维（的MOLAP）和混合（HOLAP）数据存储。
这个软件是使SAS程序，查询利用SQL传递的SAS OLAP服务器，从数据的范围中选择，根据多方面的数据基础，得出详细的数据。
开放的行业的范围:OLE DB提供OLAP的；符合MDX查询语言的与第三方客户端通信。
快速查询程序：多个线程查询引擎；数据可以分布在多个磁盘系统，提供查询的线程访问；容易使用的建设和维护OLAP多维数据集 图形用户界面：
1、与SAS 可以方便地定义数据尺寸和聚合。
2、新的基于Java的向导方便设计，创建，更新和调整OLAP多维数据集。
优化汇总数据，节省系统内存。
1、很少访问的数据可以以压缩的格式来存储。
2、可以快速访问经常查询的数据，因为它们是可以缓存在内存中的。
程序可以用于OLAP服务器监控功能强大的接口。
1、定义OLAP数据服务器及其配置参数，包括性能日志记录选项。
应用响应管理（ARM）用来监控所有服务器活动课。结果集可以转移到SAS或者第三方客户端，如HP - UX的工作负载管理器，以监测活动和业绩
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.