Review of Major Commercial DBMSs - Database Design and Development: An Essential Guide for IT Professionals - page 695

Personal Edition. Full-featured version of the database for individuals who need
full compatibility with the entire Oracle database family.

Highlights of Certain Significant Features

Row Level Locking Ability to lock at the level of individual rows instead of the
entire table, thereby allowing many concurrent users to access data from the same
table in a multiuser environment.

Materialized Views Precomputing and storing of aggregated data to improve
data access performance for common queries, thereby eliminating the need to
recompute the results.

Data Partitioning Flexible partitioning of data to improve performance, avail-
ability, and manageability.

Query Optimization Proven query optimizer to determine the best data
access strategy for each query, especially for the ones with complex SQL

statements.

Database Clusters Clustered database with provision to scale your application
on any platform with data protection comprising of fast hot failovers.

Data Protection Features Oracle Data Guard providing complete data protec-
tion scheme for all types of failures.

Single Sign-On Provision of single sign-on using interoperable certificates for
authentication over Secure Sockets Layer (SSL), the Internet authentication
standard.

Data Encryption Ability for selective encryption based on industry-standard

DES.

Self-managing and Tuning Enhanced database management tools to automate
routine DBA tasks including space, memory, and resource management as well as
ongoing monitoring.

Data Replication Oracle Advanced Replication designed to support a variety of

applications.

Database Clusters Clustered database with provision to scale your
application on any platform with data protection comprising of fast hot
failovers.

Connectivity Options Two connectivity solutions—generic connectivity
and transparent gateways—providing seamless access to non-Oracle data
sources.