computing Computing is any goal-oriented activity requiring, benefiting from, or creating computing machinery. It includes the study and experimentation of algorithmic processes, and development of both hardware and software. Computing has scientific, ...

, the Oracle Streams product from Oracle Corporation encourages users of Oracle databases to propagate information within and between

database In computing, a database is an organized collection of data stored and accessed electronically. Small databases can be stored on a file system, while large databases are hosted on computer clusters or cloud storage. The design of databases s ...

s. 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 To disseminate (from lat. ''disseminare'' "scattering seeds"), in the field of communication, is to broadcast a message to the public without direct feedback from the audience. Meaning Dissemination takes on the theory of the traditional view ...

data warehousing In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis and is considered a core component of business intelligence. DWs are central repositories of integr ...

and

data replication Replication in computing involves sharing information so as to ensure consistency between redundant resources, such as software or hardware components, to improve reliability, fault-tolerance, or accessibility. Terminology Replication in comp ...

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