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, e ...

, Oracle Advanced Queuing (AQ) is a sort of

message-oriented middleware Message-oriented middleware (MOM) is software or hardware infrastructure supporting sending and receiving messages between distributed systems. MOM allows application modules to be distributed over heterogeneous platforms and reduces the complex ...

developed by

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 ...

and integrated into its

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 ...

. AQ uses database structures as a repository for

asynchronous Asynchrony is the state of not being in synchronization. Asynchrony or asynchronous may refer to: Electronics and computing * Asynchrony (computer programming), the occurrence of events independent of the main program flow, and ways to deal with ...

queuing Queue areas are places in which people queue (first-come, first-served) for goods or services. Such a group of people is known as a ''queue'' (British usage) or ''line'' (American usage), and the people are said to be waiting or standing ''in ...

as an element in various Oracle-oriented and heterogeneous operations. Oracle features utilising Advanced Queuing include: *

Oracle Data Guard The software which Oracle Corporation markets as Oracle Data Guard forms an extension to the Oracle relational database management system (RDBMS). It aids in establishing and maintaining secondary standby databases as alternative/supplementary rep ...

Oracle Streams In computing, the Oracle Streams product from Oracle Corporation encourages users of Oracle databases to propagate information within and between databases. It provides tools to capture, process ('stage') and manage database events via Advanced ...

primary databases the queue monitor process (often running as ''qmn0'') interacts with AQ. As of Oracle release 9.2, AQ comes bundled with Standard Edition and Enterprise Edition at no extra cost. As of Oracle release 10.1, AQ is integrated into

, and is called "Oracle Streams AQ". As of Oracle release 12.1, Oracle Streams is deprecated and AQ is again named just "Oracle AQ". Oracle AQ is used as the internal

Java Message Service The Jakarta Messaging API (formerly Java Message Service or JMS API) is a Java application programming interface (API) for message-oriented middleware. It provides generic messaging models, able to handle the producer–consumer problem, that can ...

provider in the

Oracle Enterprise Service Bus Oracle Enterprise Service Bus (Oracle ESB), a fundamental component of Oracle's Services-Oriented Architecture suite of products, provides integration of data and enterprise applications within an organisation and their connected ( "extended" or ...

. In addition to asynchronous message exchanges (point-to-point and publish–subscribe), Oracle AQ can also perform message transformation via SQL functions. Oracle AQ is available in all editions of Oracle database, including XE.

References

External links

Oracle 11g Streams Advanced Queuing User's Guide (11.2)

* * ttp://www.stanford.edu/dept/itss/docs/oracle/9i/appdev.920/a96587/toc.htm Oracle9i Advanced Queuing manual
Oracle Database 10g Product Family
Message-oriented middleware Oracle software {{database-software-stub