标准版和企业版ORACLE区别(中文版)

1、bookmarkgo to endoracle9i 功能和高可用性选项the oracle9i database is available as oracle9i standard edition, oracle9i enterprise edition, and oracle9i personal edition. not all features and options are available with all editions of the oracle9i database.oracle9i personal edition is available on windows nt a

2、nd windows98 and includes, at no extra cost, all features and options that are available with oracle9i enterprise edition, such as oracle高级安全性、oracle分区技术, and so forth. due to limitations of the windows98 operating system, not all features are available on the windows98 version of the oracle9i datab

3、ase server.this section contains the following topics: options features optionsthe following table lists the options available with this release. options which are new, or whose factoring status has changed, are noted in bold italic print.oracle9i release 9.0.1 optionsoption oracle9i standard editio

4、noracle9i enterprise editionoracle9i personal editionnotesoracle advanced securitynyyoracle高级安全性提供有关网络加密，sso服务，智能卡，象征性和生命期的用户身份验证的统一集成。oracle change management pack nyyoracle change management pack(变更管理包)消除在应用更新后导致数据库升级的情况下的数据错误和丢失。该管理包分析应用变更对自动执行数据库升级造成的依赖复杂程度。oracle data miningnyyoracle data minin

5、g包含了为做分类、预测和联合等数据挖掘功能。所有的内建模型和scoring功能均通过统一的java-based api接口进行访问。oracle diagnostics packnyyoracle diagnostics pack是一套用于监控数据库状态、系统精细化、分析、以及修复数据库漏洞的高级工具。oracle label securitynyyoracle标签安全特性是一种先进的行一级安全out-of-the-box解决方案，它允许用户定义和加强对于oracle数据库的表级访问控制策略。oracle management pack for oracle applicationsnynex

6、tends oracle enterprise manager to enable the monitoring, diagnosis, capacity planning, and tuning of the oracle applications environment.oracle management pack for sap r/3nynoffers real time monitoring for sap r/3, systems, capacity planning for historical analysis and future planning purposes, eve

7、nt integration, and a single point of administration of the host, database, and application.oracle olapnyyoracle olap provides the oracle olap api, which provides support for complex, multidimensional queries.oracle partitioningnyyoracle partitioning allows large tables to be broken into smaller pie

8、ces that improve manageability, availability, and scalability. oracle programmeryyyoracle programmer is a family of products consisting of three sql-style interfaces: precompilers, sql*module, and sqlj; four call level interfaces: oracle call interface (oci), oracle c+ call interface (occi), odbc, a

9、nd jdbc; oracle objects for ole; and object type translator and jpub.oracle real application clustersnynoracle real application clusters allows database workload to be distributed across a cluster, resulting in high scalability. high availability is assured, because even if one node fails, the remai

10、ning nodes still can access the database.oracle spatialnyyoracle spatial is an integrated set of functions and procedures that enables spatial data to be stored, accessed, and analyzed quickly and efficiently in an oracle database. oracle tuning pack nyyoracle tuning pack provides database administr

11、ators with expert performance management for the oracle environment, including sql tuning and storage optimization.featuresthe following table lists the major features available with release 9.0.1. features which were new to oracle9i, or whose factoring status changed in oracle9i, are noted in bold

12、italic print. areafeature oracle9i standard editionoracle9i enterprise editionoracle9i personal editionnotescontent managementdynamic servicesyyyprovides web service aggregation and transformation, administration, definition and registration, and delivery. ice 1.0 support.content managementoracle da

13、tabase workspace manageryyycreates heretical workspaces and uses metadata and views to version enabled tables in a long transaction framework.content managementparallel text index creationnyyenables parallel text index creation on non-partitioned as well as partitioned tablescontent managementultra

14、searchyyyprovides unified searching across the oracle database, the web (html), and external data sources.data warehousing and vldbanalytic functionsyyybuilt-in sql functions to provide a variety of sophisticated analytical computations. these include rank, moving average, and ratio-to-report, and m

15、any others.data warehousing and vldbautomated parallel query degreenyyautomated parallel query optimization based on system utilization.data warehousing and vldbbitmapped indexes and bitmapped joined indexesnyyindex type commonly used in a data warehouse for columns with small number of distinct val

16、ues, such as y or n, resulting in dramatic performance gains in a data warehouse application. bitmapped joined indexes improve join performance and makes it possible to create an index on one table based on a set of columns from another table.data warehousing and vldbdescending indexesyyyprovides be

17、tter performance when indexed data needs to sorted in descending order.data warehousing and vldbdirect path load apiyyyallows complete access to all load functionality via oci api for creation of high performance load programs.data warehousing and vldbexport transportable tablespacesnyyquickly moves

18、 or creates a copy of tablespace data. a transportable tablespace can be plugged in to all editions of the database.data warehousing and vldbimport transportable tablespacesyyyquickly plugs in a transportable tablespace.data warehousing and vldbexternal tablesyyyenables accessibility within the data

19、base to external data sources (such as flat files) as read-only tables.data warehousing and vldbfunction-based indexesfrom 9.2yyallows indexes to be created on expressions or functions.data warehousing and vldblong operations monitoryyyprogress of long running database and application operations can

20、 be monitored and information can be displayed, such as percent complete.data warehousing and vldbmaterialized viewsyyyincludes summary management functionality, join indexes, multi-tier materialized views, and summary advisor. automatically redirects queries to stored summary tables, improving quer

21、y performance dramatically.data warehousing and vldbmergeyyyan incremental refresh of a table requires two tasks: new records are inserted and existing records are updated. merge allows both tasks to be performed simultaneously in a single sql statement.data warehousing and vldboptimizer statistics

22、managementyyyschema object statistics, used by the cost based optimizer, can be copied and moved to another database.data warehousing and vldbparallel analyzenyythe analyze statement, used to gather statistics on tables, can be run using parallel processing. this feature requires the partitioning op

23、tion.data warehousing and vldbparallel bitmap star query optimizationnyythis algorithm utilizes single-table bitmap indexes and an advanced star query join method, resulting in excellent performance while efficiently utilizing space.data warehousing and vldbparallel dml (insert/update/ delete)nyydiv

24、ides dml operations transparently across multiple processes. this feature requires the partitioning option.data warehousing and vldbparallel index buildnyycreates indexes using parallel processes, significantly improving performance of the operation.data warehousing and vldbparallel index scansnyyqu

25、eries that use an index can scan the index in parallel with multiple processes. this requires the partitioning optiondata warehousing and vldbparallel loadyyyloads of data quickly with multiple, parallel processes.data warehousing and vldbparallel querynyytransparently distributes query execution ac

26、ross multiple processes, resulting in outstanding performance.data warehousing and vldbpipelined table functionsyyyallows result sets to be pipelined back to calling statement, dramatically improving performance.data warehousing and vldbsample scanyyyscans of a sampling of data to determine approxim

27、ate averages or other data analysis quickly even in extremely large tables.data warehousing and vldbstar query optimizationyyythis algorithm utilizes b-tree indexes (not bitmap indexes)data warehousing and vldbsynchronous change data capturenyycaptures, publishes, and allows applications to subscrib

28、e to change data in a controlled fashion.database featuresadvanced queuingyyyprovides direct support in the database for high performance queuing and messaging operations, integrated with ldap.database featuresdatabase event triggersyyyfires off database triggers, such as database startup or shutdow

29、n triggers, ddl statement triggers, and logon/logoff triggers, when the event occurs.database featuresdbms_repair packageyyydetects and corrects software and hardware corruption early.database featuresdrop columnyyyremoves an unwanted column from a table.database featureflashback queryyyyallows data

30、 to be queried from a point in the past.database featuresglobalization supportyyyprovides native language support with enhanced unicode capabilities.database featuresindex coalescenyydefragments free space in index leaf blocks while a table is online.database featuresindex-organized tablesyyystores data in a table in a b*-tree index structure for better performance and reduced storage.database featuresinstead-of triggersyyyexecutes triggers instead of the dml that caused the trigger to fire.database featureslob (large object) su