|
|
|
|
| Feature
Summary |
Standard Edition
One |
Standard Edition
|
Enterprise or Personal |
| High Availability |
|
|
|
Fail Safe
Configure and verify Windows clusters and automatically fail
over Oracle databases and applications fast and accurately through
high availability software integrated with Microsoft Cluster
Server.
|
Y |
Y |
Y |
Flashback Query
Recover older versions of data without complex, time-consuming
operations.
|
Y |
Y |
Y |
Flashback Table, Database
and Transaction Query
Diagnose and undo errors including changes to a single row,
changes by a rogue transaction, all changes made to one or more
tables (including the dropping of a table), and all changes
made to an entire database.
|
|
|
Y |
Data Guard
Maintain multiple remote standby copies of production databases
automatically; fail over processing from production environment
to standby databases; greatly reduce downtime in a disaster
situation
|
|
|
Y |
| Scalability |
|
|
|
Real Application Clusters
Run any packaged or custom application unchanged across multiple
connected, or "clustered," servers. |
|
Y |
Option |
Integrated Clusterware
Create and operate database clusters with a set of common, built-in
clustering services.
|
|
Y |
Y |
Automatic Workload Management
Route service connection requests to appropriate server with
lowest load; on failure, automatically reallocate surviving
servers to services.
|
|
Y |
Y |
Java, PL/SQL Native
Compilation
Write stored procedures deployed in the database in both Java
and PL/SQL.
|
Y |
Y |
Y |
| Security |
|
|
|
Oracle Advanced Security
Address privacy and compliance requirements. Includes Transparent
Data Encryption, Network encryption and data integrity, and
strong authentication.
|
|
|
Option |
Oracle Label Security
Provides out-of-the-box row-level security. Compare user security
clearances with data classification labels attached to data
rows.
|
|
|
Option |
Secure Application Roles
Enable roles only after a user passes any number of security
checks.
|
|
|
Y |
Virtual Private Database
Enforce data security and privacy with customizable, policy-based
access control down to the row level.
|
|
|
Y |
Fine-Grained Auditing
Allows highly focused auditing with almost no 'background noise'.
|
|
|
Y |
Proxy Authentication
|
Y |
Y |
Y |
Data Encryption
Protect vital data, such as credit card numbers, even in the
event of media theft by providing an extra layer of protection
for data on storage media.
|
Y |
Y |
Y |
| Application Development |
|
|
|
Java Support
Execute Java applications faster, integrate existing software
assets, connect Java/J2EE applications to Grid-enabled database,
support non-connnected clients through Web Services, and federate
local data with remote and dynamic data.
|
Y |
Y |
Y |
HTML DB
Develop and deploy fast, secure applications with a rapid web
application development tool.
|
Y |
Y |
Y |
Comprehensive XML Support
Store and retrieve XML natively with support for the W3C XML
data model; use standard access methods for navigating and querying
XML.
|
Y |
Y |
Y |
PL/SQL and Java Server
Pages
Utilize a server-side Java and stored procedural language; secure,
portable and seamless with SQL.
|
Y |
Y |
Y |
COM Automation, Microsoft
Transaction Server/COM+ integration, ODBC and OLE DB
Support multiple Windows data access methods.
|
Y |
Y |
Y |
| Manageability |
|
|
|
Enterprise Manager
Manage and monitor all applications and systems based on the
Oracle stack via a single, integrated console.
|
Y |
Y |
Y |
Automatic Memory Management
Automate management of shared memory used by an Oracle Database
instance.
|
Y |
Y |
Y |
Automatic Storage Management
Distribute I/O load across all available resources and optimize
performance via a vertically integrated file system and volume
manager; eliminates manual I/O tuning.
|
Y |
Y |
Y |
Automatic Undo Management
Monitor configuration of all Oracle systems for parameter settings,
security set-up, storage and file space conditions.
|
Y |
Y |
Y |
Server Managed Backup
and Recovery
Simplify, automate, and improve backup and recovery performance
with Oracle Recovery Manager (RMAN).
|
Y |
Y |
Y |
| Data Warehousing |
|
|
|
Data Compression
Compress data stored in relational tables without impacting
query time; reduce disk system costs.
|
|
|
Y |
Oracle Analytic Functions
Use built-in analytical workspaces for Online Analytical Processing
(OLAP).
|
|
|
Y |
Transportable Tablespaces,
Including Cross-Platform
Transport a set of tablespaces from one database to another,
or from one database to itself.
|
|
|
Y |
Star Query Optimization
Join a fact table and a number of dimension tables.
|
Y |
Y |
Y |
Summary Management -
Materialized View Query Rewrite
Improve query performance by automatically recognizing when
a materialized view can be used to satisfy a request; transparently
rewrite the request to use the materialized view.
|
|
|
Y |
| Integration |
|
|
|
Oracle Streams
Propagate and manage data, transactions, and events in a data
stream either within a database, or from one database to another.
|
|
|
Y |
Advanced Queuing
Allow database queues to serve as durable message stores via
queue-based publish-subscribe.
|
Y |
Y |
Y |
Workflow
Support business process-based integration with a complete workflow
management system.
|
Y |
Y |
Y |
Distributed Queries/Transactions
Query or update data on two or more distinct nodes of a distributed
database.
|
Y |
Y |
Y |
| Content Management |
|
|
|
Ultra Search
Search and locate data across multiple repositories, including:
Oracle databases, ODBC compliant databases, IMAP mail servers,
HTML documents, files on disk, and more.
|
Y |
Y |
Y |
interMedia
Develop, deploy, and manage traditional, Web, and wireless applications
that include rich media in the most-popular formats.
|
Y |
Y |
Y |
Text
Build text query applications and document classification applications.
|
Y |
Y |
Y |
Locator
Manage geospatial data to leverage the business value of location.
You can also support the most sophisticated GIS deployments
with the Spatial option for Enterprise Edition.
|
Y |
Y |
Y |
|
