In
computing, the Oracle Streams product from
Oracle Corporation
Oracle Corporation is an American multinational computer technology corporation headquartered in Austin, Texas. In 2020, Oracle was the third-largest software company in the world by revenue and market capitalization. The company sells da ...
encourages users of
Oracle database
Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.
It is a database commonly used for running online t ...
s to propagate information within and between
databases. It provides tools to capture, process ('stage') and manage database events via
Advanced Queuing queues.
Oracle Streams is the flow of information either within a single database or from one database to another. Oracle Streams can be set up in homogeneous (all Oracle databases) or heterogeneous (non-Oracle and Oracle databases) environments. The Streams setup uses a set of processes and database objects to share data and messages. The database changes (
DDL and
DML) are captured at the source; those are then staged and propagated to one or more destination databases to be applied there. Message propagation uses Advanced Queuing mechanism within the Oracle databases.
Applications for the Oracle Streams tool-set include
data distribution,
data warehousing and
data replication.
History
As of Oracle version 9.2 (2002), Oracle Corporation made Oracle Streams available on Oracle Enterprise Edition systems only. This happened in the wake of previous replication products: Oracle Replication (introduced with Oracle 8
in 1997) and Oracle Advanced Replication
Database Replication with Oracle 11G Streams
[
]
(introduced with Oracle 9i in 2000).
In July 2009, Oracle acquired
GoldenGate, a company with a heterogeneous replication solution. Oracle Corporation encourages customers with new applications to use Oracle GoldenGate rather than Streams.
Footnotes
Oracle software
{{Database-software-stub