Oracle Advanced Queuing Features Overview Database Integrated Message

Oracle Advanced Queuing Features Overview

Database Integrated Message Queuing Ÿ Inherits reliability, integrity, security of database Ÿ Provides loose application coupling Ÿ Provides unique message management Ÿ Has additional features for e-businesses such as Internet access Application Rules & Transformation Advanced Queues Application

Message Queuing Ÿ Enables communication via store and forward model Ÿ Provides loose coupling of applications – – Asynchronous application integration Heterogeneous data integration Application location transparency Business process integration

Asynchronous Application Integration Ÿ Time specification Application FIFO and priority-based Ÿ Listen Ÿ Asynchronous notifications EN Q Blocking/non-blocking Rules & Transformation Q DE Ÿ Dequeue – Q – EN Ÿ Ordering and priority Application Q – Delay Expiration DE – Advanced Queues Application

Extensible Integration Architecture Ÿ Multiple modes of addressing – – Publish/subscribe Point-to-multipoint Ÿ Dynamic addition of subscribers – – Multi-consumer queues More applications can be added later Ÿ Subscriptions – – Subject-based Content-based

Heterogeneous Data Integration Ÿ Extensive type support for message structure – – – Scalar types such as number, date, varchar, raw Oracle object types Large objects such as CLOB and BLOB Ÿ Dynamic message structure with XML – XDK for operations on XML data Ÿ Transformation plug-ins – – Define transformation mappings in PL/SQL Use mappings during AQ operations

Application Location Transparency Ÿ Automatic message propagation – – – Guaranteed Fail-safe Tunable Ÿ Oracle Internet Directory integrated – – Global Queues Global Events Ÿ Transport independence – TCP/IP, IPX, HTTP(s), Email

Unique Benefits Ÿ Transaction protection with high reliability – Messaging operation done in a transaction Ÿ Querying/SQL access – SQL access to the message and its history Ÿ Retention – Automatic auditing, tracking, and business intelligence Ÿ Integrated application model – security, transactions, tables and queues

Unique Features for E-Business Ÿ Internet access to Advanced Queuing Ÿ Transformation plug-ins – User-defined PL/SQL functions can be called at Advanced Queuing operations Ÿ Messaging Gateway – – Tibco Rendezvous IBM MQSeries

Business Process Integration • Manage business processes spanning applications and partners with Oracle Workflow’s Business Event System (BES) • • Incoming message can initiate workflow • BES permits registering events and subscriptions on events Workflow activities can generate outbound message

Features Overview Ÿ Time-based specification for consumption Ÿ Ordering and priority Ÿ Multiple ways of enqueue, dequeue, and propagation Ÿ Asynchronous notifications Ÿ Multiple addressing modes – publish/subscribe – point-to-point Ÿ Subscriptions – subject-based – content-based Ÿ Extensive type support – XML for dynamic data Ÿ Transformation plug-ins Ÿ OID integration – global events – global queues Ÿ Transport independence – internet support Ÿ SQL access Ÿ Messaging gateway to Tibco and MQSeries

Oracle 9 i AQ Overview Inter net A Internet User OCI, PL/SQL, Java Notificatons ccess Rules & Transform ation Email Notificatons gation Propa t e n r e Int Rules & & Rules Transformation Advanced Queues Exchange or Business Partner OCI, PL/SQL, Java client Advanced Queues Firewall MQ Series Tibco* Int Pro ranet pag ati on Native XML-based Internet Transport Internet Security Rules & Tranformation Advanced Queues, Events, Agents

Oracle 8 i and 9 i AQ features and Oracle 10 g Streams AQ features What's New in Oracle Streams Advanced Queuing?

Application Programming Interface ŸC – – OCI Pro*C Ÿ Java – JMS Ÿ PL/SQL Ÿ Internet Data Access Presentation (IDAP) – – http email

AQ Management with OEM Ÿ DBA studio provides two main sections for managing AQ: – – – AQ Administration AQ Objects All AQ objects are managed under their respective Queue. Tables Ÿ The Diagnostics and Tuning Pack supports alerts and monitoring for AQ queues. E. g. Alert when propagation stops working.

Q& A Q U E S T I O N S A N S W E R S