Oracle Streams
Encyclopedia
In computing
, the Oracle Streams product from Oracle Corporation
encourages users of Oracle database
s to propagate information within and between database
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 toolset include data distribution, data warehousing
and data replication.
As of Oracle version 9.2, Oracle Corporation makes Oracle Streams available on Oracle Enterprise Edition systems only.
In July 2009, Oracle acquired GoldenGate
, a company with a heterogeneous replication solution. Oracle Corporation is now encouraging customers with new applications to use GoldenGate rather than Streams.
Computing
Computing is usually defined as the activity of using and improving computer hardware and software. It is the computer-specific part of information technology...
, the Oracle Streams product from Oracle Corporation
Oracle Corporation
Oracle Corporation is an American multinational computer technology corporation that specializes in developing and marketing hardware systems and enterprise software products – particularly database management systems...
encourages users of Oracle database
Oracle database
The Oracle Database is an object-relational database management system produced and marketed by Oracle Corporation....
s to propagate information within and between database
Database
A database is an organized collection of data for one or more purposes, usually in digital form. The data are typically organized to model relevant aspects of reality , in a way that supports processes requiring this information...
s. It provides tools to capture, process ('stage') and manage database events via Advanced Queuing
Oracle Advanced Queuing
In computing, Oracle Advanced Queuing is a sort of Message Oriented Middleware developed by Oracle Corporation and integrated into its Oracle database....
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
Data Definition Language
A data definition language or data description language is a syntax similar to a computer programming language for defining data structures, especially database schemas.-History:...
and DML
Data Manipulation Language
A data manipulation language is a family of syntax elements similar to a computer programming language used for inserting, deleting and updating data in a database...
) 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 toolset include data distribution, data warehousing
Data warehouse
In computing, a data warehouse is a database used for reporting and analysis. The data stored in the warehouse is uploaded from the operational systems. The data may pass through an operational data store for additional operations before it is used in the DW for reporting.A data warehouse...
and data replication.
As of Oracle version 9.2, Oracle Corporation makes Oracle Streams available on Oracle Enterprise Edition systems only.
In July 2009, Oracle acquired GoldenGate
Goldengate
The name Goldengate or GoldenGate may reference:* Goldengate, an integrated software suite developed by Cullinet ca. 1980* GoldenGate, replication and data-integration software developed by GoldenGate Software; since 2009 marketed by Oracle Corporation...
, a company with a heterogeneous replication solution. Oracle Corporation is now encouraging customers with new applications to use GoldenGate rather than Streams.