Contents

Title and Copyright Information

Preface

• Audience
• Related Documents
• Conventions
• Syntax Diagrams

What's New in This Guide

1 Introduction to Data Cartridges

• 1.1 Oracle CQL Data Cartridge Framework
• 1.2 Names
• 1.3 Application Context

2 Configure Oracle JDBC and Oracle Spatial Data Cartridges

• 2.1 How to Configure Oracle Spatial Application Context
• 2.2 How to Configure Oracle JDBC Data Cartridge Application Context

3 Oracle JDBC Data Cartridge

• 3.1 Understanding the Oracle Event Processing JDBC Data Cartridge
  • 3.1.1 Data Cartridge Name
  • 3.1.2 Scope
  • 3.1.3 Parameter Specification
  • 3.1.4 Oracle Event Processing JDBC Data Cartridge Application Context
    • 3.1.4.1 Declare a JDBC Cartridge Context in the EPN File
    • 3.1.4.2 Configure the JDBC Cartridge Context in the Application Configuration File
• 3.2 Using the Oracle Event Processing JDBC Data Cartridge
  • 3.2.1 Defining SQL Statements: function Element
    • 3.2.1.1 function Element Attributes
    • 3.2.1.2 function Element Child Elements
      • 3.2.1.2.1 param
      • 3.2.1.2.2 return-component-type
      • 3.2.1.2.3 sql
    • 3.2.1.3 function Element Usage
      • 3.2.1.3.1 Multiple Parameter JDBC Cartridge Context Functions
      • 3.2.1.3.2 Invoking PL/SQL Functions
      • 3.2.1.3.3 Complex JDBC Cartridge Context Functions
      • 3.2.1.3.4 Overloading JDBC Cartridge Context Functions
  • 3.2.2 Defining Oracle CQL Queries With the Oracle Event Processing JDBC Data Cartridge
    • 3.2.2.1 Using SELECT List Aliases
    • 3.2.2.2 Using the TABLE Clause
    • 3.2.2.3 Using a Native CQL Type as a return-component-type

4 Oracle Spatial Data Cartridge

• 4.1 Understanding Oracle Spatial
  • 4.1.1 Data Cartridge Name
  • 4.1.2 Scope
    • 4.1.2.1 Geometry Types
    • 4.1.2.2 Element Info Array
    • 4.1.2.3 Ordinates and Coordinate Systems and the SDO_SRID
    • 4.1.2.4 Geometric Index
    • 4.1.2.5 Geometric Relation Operators
    • 4.1.2.6 Geometric Filter Operators
    • 4.1.2.7 Geometric Aggregations
    • 4.1.2.8 Geometry API
      • 4.1.2.8.1 com.oracle.cep.cartridge.spatial.Geometry Methods
      • 4.1.2.8.2 oracle.spatial.geometry.JGeometry Methods
  • 4.1.3 Datatype Mapping
  • 4.1.4 Oracle Spatial Application Context
• 4.2 Using Oracle Spatial
  • 4.2.1 How to Access Oracle Spatial Java API Geometry Types
  • 4.2.2 How to Create a Geometry
  • 4.2.3 How to Access Geometry Type Public Methods and Fields
  • 4.2.4 How to Use Geometry Relation Operators
  • 4.2.5 How to Use Geometry Filter Operators
  • 4.2.6 How to Use Geometry Aggregate Operators
  • 4.2.7 How to Use the Default Geodetic Coordinates
  • 4.2.8 How to Use Other Geodetic Coordinates

5 Oracle Big Data Cartridges

• 5.1 Hadoop Data Cartridge
  • 5.1.1 Understanding the Oracle Event Processing Hadoop Data Cartridge
    • 5.1.1.1 Usage Scenario: Using Purchase Data to Develop Buying Incentives
    • 5.1.1.2 Data Cartridge Name
  • 5.1.2 Using Hadoop Data Sources in Oracle CQL
    • 5.1.2.1 Configuring Integration of Oracle Event Processing and Hadoop
    • 5.1.2.2 Integrating a File from a Hadoop System Into an EPN
    • 5.1.2.3 Using Hadoop Data in Oracle CQL
• 5.2 NoSQL Data Cartridge
  • 5.2.1 Oracle CQL Processor Queries
  • 5.2.2 Data Cartridge Name
  • 5.2.3 Using a NoSQL Database in Oracle CQL
    • 5.2.3.1 Integrating a NoSQL Database Into an EPN
    • 5.2.3.2 Using NoSQL Data in Oracle CQL
      • 5.2.3.2.1 Formatting the Key Used to Obtain Entries from the NoSQL Store

6 Oracle Java Data Cartridge

• 6.1 Understanding the Oracle Java Data Cartridge
  • 6.1.1 Data Cartridge Name
  • 6.1.2 Class Loading
    • 6.1.2.1 Application Class Space Policy
    • 6.1.2.2 No Automatic Import Class Space Policy
    • 6.1.2.3 Server Class Space Policy
    • 6.1.2.4 Class Loading Example
  • 6.1.3 Method Resolution
  • 6.1.4 Datatype Mapping
    • 6.1.4.1 Java Data Type String and Oracle CQL Data Type CHAR
    • 6.1.4.2 Literals
    • 6.1.4.3 Arrays
    • 6.1.4.4 Collections
  • 6.1.5 Oracle CQL Query Support for the Oracle Java Data Cartridge
• 6.2 Using the Oracle Java Data Cartridge
  • 6.2.1 How to Query Using the Java API
  • 6.2.2 How to Query Using Exported Java Classes
  • 6.2.3 Java Cast Function

7 Data Cartridge Framework

• 7.1 About the SPI
• 7.2 Interfaces
  • 7.2.1 Interface Descriptions
  • 7.2.2 Exceptions
• 7.3 Cartridge Examples
  • 7.3.1 Arithmetic Cartridge
  • 7.3.2 Data Source Cartridge
• 7.4 Source Code
  • 7.4.1 Arithmetic Cartridge
  • 7.4.2 Data Source Cartridge

A Oracle Spatial Command and API Reference

• A.1 ANYINTERACT
• A.2 buffer
• A.3 bufferPolygon
• A.4 CONTAIN
• A.5 convertTo2D
• A.6 convertTo3D
• A.7 createCircle
• A.8 createElemInfo
• A.9 createGeometry
• A.10 createLinearLineString
• A.11 createLinearMultiLineString
• A.12 createLinearPolygon
• A.13 createMultiPoint
• A.14 createPoint
• A.15 createRectangle
• A.16 distance
• A.17 einfogenerator
• A.18 FILTER
• A.19 get2dMbr
• A.20 INSIDE
• A.21 INSIDE3D
• A.22 NN
• A.23 ordsgenerator
• A.24 to_Geometry
• A.25 to_J3D_Geometry
• A.26 to_JGeometry
• A.27 WITHINDISTANCE