Extensibility platform using data cartridges

• US 8,447,744 B2
• Filed: 11/30/2010
• Issued: 05/21/2013
• Est. Priority Date: 12/28/2009
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: de Castro Alves, Alexandre, Srinivasan, Anand, Park, Hoyong, Mishra, Shailendra
• Primary Examiner(s): BURKE, JEFF A
• Application Number:
  US12/957,194
• Publication Number:
  US 20110161321A1
• Time in Patent Office: 903 Days
• Field of Search: 707/702, 707/769, 719/328
• US Class Current: 707/702
• CPC Class Codes: G06F 16/24568 Data stream processing; Continuous queries
• CPC Class Codes: G06F 16/25 Integrating or interfacing systems involving database management systems

Abstract

A framework for extending the capabilities of an event processing system using one or more plug-in components referred to herein as data cartridges. Generally speaking, a data cartridge is a self-contained unit of data that can be registered with an event processing system and can store information pertaining to one or more objects (referred to herein as extensible objects) that are not natively supported by the system. Examples of such extensible objects can include data types, functions, indexes, data sources, and others. By interacting with a data cartridge, an event processing system can compile and execute queries that reference extensible objects defined in the data cartridge, thereby extending the system beyond its native capabilities.

Claims

1. A method comprising:

receiving, by a computer system, a first query configured for processing events received via one or more event streams; and

compiling, by the computer system, the first query by retrieving metadata pertaining to an extensible object from information stored by a data cartridge for the extensible object, and generating, based on the metadata, executable instructions for executing the first query, the executable instructions including a call-out instruction to a function whose implementation is included in the information stored by the data cartridge for the extensible object;

wherein the first query includes a particular link definition identifying the extensible object and a source of metadata for the extensible object;

wherein compiling the first query further comprises determining that the first query includes the particular link definition;

wherein compiling the first query further comprises identifying the data cartridge based upon the particular link definition in response to determining that the first query includes the particular link definition;

receiving a second query;

determining that the second query excludes link definitions;

in response to determining that the second query excludes link definitions, determining that a complex type specified in the second query is a native data type that is not defined in the data cartridge; and

compiling the second query based on the native data type.

2. The method of claim 1 wherein the first query is a Continuous Query Language (CQL) query.

3. The method of claim 1 wherein the data cartridge is registered with the computer system in a registry, and wherein identifying the data cartridge based upon the link definition comprises searching the registry.

4. The method of claim 1 further comprising executing the first query using the executable instructions to process the events received via the one or more event streams.

5. The method of claim 4 wherein executing the first query comprises:

invoking the call-out instruction to the function; and

executing the implementation of the function included in the information stored by the data cartridge for the extensible object.

6. The method of claim 5 wherein executing the implementation of the function comprises:

accessing application context information stored by the data cartridge; and

executing the implementation of the function based on the application context information.

7. The method of claim 1 wherein the extensible object is selected from a group consisting of:

a data type, a function, an index, and a data source.

8. The method of claim 1 wherein compiling the first query further comprises performing semantic analysis of the first query using the metadata.

9. The method of claim 1 wherein the computer system cannot natively compile queries referencing the extensible object without accessing the data cartridge.

10. A non-transitory computer-readable storage medium having stored thereon instructions executable by a processor, the instructions comprising:

instructions that cause the processor to receive a first query configured for processing events received via one or more event streams; and

instructions that cause the processor to compile the first query by retrieving metadata pertaining to an extensible object from information stored by a data cartridge for the extensible object, and generating, based on the metadata, executable instructions for executing the first query, the executable instructions including a call-out instruction to a function whose implementation is included in the information stored by the data cartridge for the extensible object;

wherein the first query includes a particular link definition identifying the extensible object and a source of metadata for the extensible object;

wherein compiling the first query further comprises determining that the first query includes the particular link definition;

wherein compiling the first query further comprises identifying the data cartridge based upon the particular link definition in response to determining that the first query includes the particular link definition;

instructions that cause the processor to receive a second query;

instructions that cause the processor to determine that the second query excludes link definitions;

instructions that cause the processor to determine, in response to determining that the second query excludes link definitions, that a complex type specified in the second query is a native data type that is not defined in the data cartridge; and

instructions that cause the processor to compile the second query based on the native data type.

11. The non-transitory computer-readable storage medium of claim 10 wherein the first query is a Continuous Query Language (CQL) query.

12. The non-transitory computer-readable storage medium of claim 10 wherein the instructions further comprise instructions that cause the processor to execute the first query using the executable instructions to process the events received via the one or more event streams.

13. The non-transitory computer-readable storage medium of claim 12 wherein the instructions that cause the processor to execute the first query comprise:

instructions that cause the processor to invoke the call-out instruction to the function; and

instructions that cause the processor to execute the implementation of the function included in the information stored by the data cartridge for the extensible object.

14. A system comprising:

one or more central processing units; and

a computer-readable storage memory storing particular instructions comprising;

instructions that cause the processor to receive a first query configured for processing events received via one or more event streams; and

instructions that cause the processor to compile the first query by retrieving metadata pertaining to an extensible object from information stored by a data cartridge for the extensible object, and generating, based on the metadata, executable instructions for executing the first query, the executable instructions including a call-out instruction to a function whose implementation is included in the information stored by the data cartridge for the extensible object;

wherein the first query includes a particular link definition identifying the extensible object and a source of metadata for the extensible object;

wherein compiling the first query further comprises determining that the first query includes the particular link definition;

wherein compiling the first query further comprises identifying the data cartridge based upon the particular link definition in response to determining that the first query includes the particular link definition;

instructions that cause the processor to receive a second query;

instructions that cause the processor to determine that the second query excludes link definitions;

instructions that cause the processor to determine, in response to determining that the second query excludes link definitions, that a complex type specified in the second query is a native data type that is not defined in the data cartridge; and

instructions that cause the processor to compile the second query based on the native data type.