Book Image

Getting Started with Oracle Event Processing 11g

Book Image

Getting Started with Oracle Event Processing 11g

Overview of this book

Events are everywhere, events which can have positive or negative impacts on our lives and important business decisions. These events can impact a company's success, failure, and profitability. Technology now allows people from all walks of life to create Event Driven applications that will immediately and completely respond to the events that affect you and your business. So you are much more responsive to your customers, and competitive threats, and can take advantage of transient time sensitive situations. "Getting Started with Oracle Event Processing" will let you benefit from the skills and years of experience from the original pioneers who were the driving force behind this immensely flexible, complete, and award winning Event Stream Processing technology. It provides all of the information needed to rapidly deliver and understand Event Driven Architecture (EDA) Applications. These can then be executed on the comprehensive and powerful integral Java Event Server platform which utilizes the hardware and operating system.After an introduction into the benefits and uses of Event Stream Processing, this book uses tutorials and practical examples to teach you how to create valuable and rewarding Event Driven foundational applications. First you will learn how to solve Event Stream Processing problems, followed by the fundamentals of building an Oracle Event processing application in a step by step fashion. Exciting and unique topics are then covered: application construction, the powerful capabilities of the Oracle Event Processing language, CQL, monitoring and managing these applications, and the fascinating domain of real-time Geospatial Movement Analysis. Getting Started with Oracle Event Processing will provide a unique perspective on product creation, evolution and a solid understanding on how to effectively use the product.
Table of Contents (19 chapters)
Getting Started with Oracle Event Processing 11g
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Retrieving external tables using SQL


As you have learned in Chapter 5, Coding with CQL, CQL supports the concepts of both streams and relations. Relations are an abstract definition that can represent a database table. So much so that in Chapter 7, Using Tables and Caches for Contextual Data, you learned how to populate a relation with data coming from either a RBMS table or a distributed cache. This is done by respectively specifying a table or a cache and linking them to a processor in the EPN.

However, there are cases where you may need additional flexibility when retrieving data from a RDBMS table to be used in CQL. For example, you may need to invoke some PL/SQL function, or you may want to aggregate the data in some particular way before getting the result into CQL for the processing of events.

This fine-grained control can be achieved by using the JDBC cartridge. The JDBC cartridge allows you to define CQL functions whose implementation are done in SQL, and return collections to be...