Oracle 9i数据库的新特征(3) (Writed By F_Q_Y)
Business Intelligence
商务智能
Oracle9i continues to provide the best platform support for business intelligence in medium to large-scale enterprises, focusing especially on challenges raised by the large volume of data and the need for near real-time complex analysis in an e-business environment.
Oracle9i 继续为中到大型的企业提供最好的商务智能平台支持,这种支持尤其集中于来自大规模数据的挑战和在电子商务环境近于实时复杂分析的需求。
Oracle9i exceeds the requirements of a relational database for data warehousing。
Oracle9i 超越了关系数据库的要求成为一个数据仓库。
Performance, Scalability, and Manageability
性能,可扩展性和可管理性
Oracle9i offers considerable new enhancements in each of these areas. For example, partitioning capabilities have been expanded to support list partitioning, which allows explicit control over how rows map to partitions. A list of discrete values can be specified for the partitioning column in the description for each partition.
在这些领域中的每一个领域,Oracle9i 都提供了相当新的增强。例如,分区能力被扩展以便支持列表分区,允许显式的控制如何将记录行映射到分区。在描述每一个分区时,可以为分区列指定一系列的离散值。
Data Warehouse Manageability
数据仓库的可管理性
Oracle9i addresses growing workloads of established data warehouses through enhanced capabilities for managing larger numbers of users。and ensuring that:
? An appropriate amount of resources is allocated to each query
? The throughput of the entire warehouse platform is maximized
? The warehouse administrator and users can view the status of ongoing jobs
? The database can automatically abort or queue queries, based upon conditions pre-specified by the database administrator, in order to maintain optimal system load
通过增强管理非常多的用户的能力,Oracle9i致力于增加工作量建立数据仓库。并确保:
为每个查询分配适当数量的资源;
最大化整个数据仓库平台的吞吐量;
数据仓库管理员和用户可以察看正在进行任务的状态;
为了维持最佳的系统负载,数据库可以根据数据库管理员预先指定的条件,自动放弃或是排队查询,
Integrated Analysis and Personalization Capabilities
集成分析和个人化能力
Oracle9i provides ground-breaking new functionality in three areas:
? online analytical processing (OLAP)
? Extraction, transformation and loading (ETL)
? Data mining
Oracle9i 提供在三个领域提供(ground-breaking)新功能:
在线分析过程(OLAP);
抽取、转换和加在(ETL);
数据挖掘(DataMine)
Other Oracle9i New Features
Oracle9i 其他的新特征
Heterogeneous Services 比较特殊的服务
Oracle Net Services Oracle Net服务
Oracle Net supports the Virtual Interface (VI) protocol :Oracle Net 支持虚拟界面协议
Replication 复制
Oracle Spatial 空间数据库
20[/SIZE] 255[/COLOR]