Scalablity and Availability in Oracle7 7.3.
Dieter Gawlick:
Scalablity and Availability in Oracle7 7.3.
VLDB 1996: 584@inproceedings{DBLP:conf/vldb/Gawlick96,
author = {Dieter Gawlick},
editor = {T. M. Vijayaraman and
Alejandro P. Buchmann and
C. Mohan and
Nandlal L. Sarda},
title = {Scalablity and Availability in Oracle7 7.3},
booktitle = {VLDB'96, Proceedings of 22th International Conference on Very
Large Data Bases, September 3-6, 1996, Mumbai (Bombay), India},
publisher = {Morgan Kaufmann},
year = {1996},
isbn = {1-55860-382-4},
pages = {584},
ee = {db/conf/vldb/Gawlick96.html},
crossref = {DBLP:conf/vldb/96},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
Abstract
The Oracle7 7.3 Server (Oracle Universal Server)
provides efficient, scalable, reliable and secure
management for applications ranging from high
volume online transaction systems to query
intensive data warehouse applications. The
Oracle Server is designed to support the
following environments efficiently:
- Enterprise class OLTP
- Enterprise class Data Warehousing
- Enterprise wide distribution
- Enterprise wide System Management
- Internet and Intranet
- Special support for Audio, Video, Text and Spatial Data
Oracle 7.3 is available on a wide range of
hardware platforms including almost all UNIX
variants, MVS and NT across SMP, Clusters and
MPP configurations with a single code base.
Scalability
Oracle 7.3 has demonstrated scalability on large
SMP, cluster and MPP platforms. On an 8 CPU
Digital AlphaServer, Oracle 7.3 has been
benchmarked at 11,456.13 TPC-C transactions
per minute at $286 per transaction. On a 32
CPUs 4-Node Cluster Digital AlphaServer,
Oracle 7.3 achieved the highest ever TPC-C
benchmark with 30,390 TPC transactions per
minute at $305 per transaction. Some
installations of Oracle 7.3 have data base sizes in
excess of a Tera Byte.
Key features include: Row level locking,
transaction isolation via Consistent Read (CR)
and discrete transactions. With the CR
mechanism no read locks are acquired, enabling
readers to neither block nor be blocked by
writers. A consistent version of the database is
created by applying undo to roll the required
blocks back to the time of the query. Discrete
transactions do not generate undo information,
and hence, provide very high performance for
short-duration transactions which are typical in
OLTP environments. To address data warehouse
application requirements, Oracle 7.3 offers a rich
variety of query processing techniques,
sophisticated query optimizations to choose most
efficient data access path, and a scalable
architecture that takes full advantage of all
parallel hardware configurations. Oracle7.3
provides fully integrated bitmapped indexes and
hash joins facilities. Oracle7.3's parallel query
increases the performance of database operations
by dynamically subdividing these operations into
distinct tasks, and distributing the workload
across all multiple processors. Oracle 7.3
parallelizes more operations than any other
database product. A partial list includes table
scans, sorts, data loading, aggregation, index
creation, table and table space creation, as well
as, recovery.
Availability
Oracle7.3 provides facilities for high-availability
operations and applications without
compromising scalability. The Oracle7.3 Parallel
Server (OPS) ensures data accessibility in the
event of a node failure, when operating in a
clustered computer environment. If any node in
the system should fail, affected users can resume
processing on another operating node. The
Oracle7.3 Online Backup Facility supports
backup activities while the database is running,
and without interrupting transaction processing,
even during periods of heavy OLTP usage. The
Oracle 7.3 standby database feature provides
reliable and supported mechanism for
implementing standby database system to
facilitate rapid disaster recovery. In the event of a
primary system failure, the standby database can
be activated with minimal recovery, providing
immediate system availability. Using Oracle7.3
Symmetric Replication, data can be replicated
from a primary system to one or more alternative
sites. Each alternative site and can be used for
queries and modification and remains operational
in case of problems in other sites.
Further Information
For more information:
http://www.oracle.com/products/oracle7/oracle7.3/html/oracle7.3_ds.html
This file also contains the relevant trade mark information
Copyright © 1996 by the VLDB Endowment.
Permission to copy without fee all or part of this material is granted provided that the copies are not made or
distributed for direct commercial advantage, the VLDB
copyright notice and the title of the publication and
its date appear, and notice is given that copying
is by the permission of the Very Large Data Base
Endowment. To copy otherwise, or to republish, requires
a fee and/or special permission from the Endowment.
Online Paper
CDROM Version: Load the CDROM "Volume 1 Issue 5, VLDB '89-'97" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
BibTeX
Printed Edition
T. M. Vijayaraman, Alejandro P. Buchmann, C. Mohan, Nandlal L. Sarda (Eds.):
VLDB'96, Proceedings of 22th International Conference on Very Large Data Bases, September 3-6, 1996, Mumbai (Bombay), India.
Morgan Kaufmann 1996, ISBN 1-55860-382-4
Contents BibTeX
Other Formats
BibTeX
ACM SIGMOD Anthology - DBLP:
[Home | Search: Author, Title | Conferences | Journals]
VLDB Proceedings: Copyright © by VLDB Endowment,
ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:46:13 2009
