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

, the Oracle Streams was a product from

Oracle Corporation Oracle Corporation is an American Multinational corporation, multinational computer technology company headquartered in Austin, Texas. Co-founded in 1977 in Santa Clara, California, by Larry Ellison, who remains executive chairman, Oracle was ...

that encouraged users of

Oracle database Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a proprietary multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for ru ...

s to propagate information within and between

database In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and a ...

s. It provided tools to capture, process ('stage') and manage database events via Advanced Queuing queues. Oracle Streams was 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 used a set of processes and database objects to share data and messages. The database changes ( DDL and DML) were captured at the source; those are then staged and propagated to one or more destination databases to be applied there. Message propagation used Advanced Queuing mechanism within the Oracle databases. Applications for the Oracle Streams tool-set included data distribution,

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

and

data replication Replication in computing refers to maintaining multiple copies of data, processes, or resources to ensure consistency across redundant components. This fundamental technique spans databases, file systems, and distributed systems, serving to impro ...

. This product was later replaced with Oracle Goldengate.

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. Oracle Streams was deprecated since Oracle Database version 12c, and desupported since Oracle Database version 19c.

Footnotes

Oracle software {{Database-software-stub