KR101439346B1 - Complex Event Processing Apparatus for referring tables from an external Database - Google Patents

Abstract

As a preferred embodiment of the present invention, an event processing apparatus for referring to a table in an external database as an external reference object includes a query analyzing unit for analyzing an input CQL query statement and generating a parse tree; Wherein the object processing unit manages the objects available for use in the event processing apparatus as meta information by dividing the objects into an inner object and an outer reference object and manages the inner object and the outer reference object using the meta information among the data source objects included in the generated parse tree A meta information management unit for separating the meta information; A query generator for generating an external database query using the separated external reference object; A query term storing unit for storing the external database query term, and an external interface unit for executing the retrieved query term.

Description

[0001] The present invention relates to an event processing apparatus for referring to a table in an external database as an external reference object,

The present invention relates to an event processing apparatus, and more particularly, to a method of using a table in an external database in an event processing apparatus.

In order to perform various analysis and detection on successive events in the event processing device, the static data of the database should be continuously referred to. However, when the tables in the database are continuously referenced or changed through IPC (Inter-processes Communication) such as TCP / IP, there is a problem that the performance is degraded.

In order to solve the problem of performance degradation caused by IPC, there is a method of embedding a database in an event processing device. However, in the case of such an in-process method, there is a problem that a database can not support a plurality of clients.

KR 2011-0097550

In an exemplary embodiment of the present invention, a stream that is an internal object of the event processing apparatus and a table of an external database, which is an external reference object, are used in combination.

According to a preferred embodiment of the present invention, there is provided an event processing apparatus for referring to a table in an external database as an external reference object, the event processing apparatus comprising a continuous query language (CQL) query input to the event processing apparatus A query term analysis unit for generating a parse tree after analysis; Wherein the object processing unit manages the objects available for use in the event processing apparatus as meta information by dividing the objects into an inner object and an outer reference object and manages the inner object and the outer reference object using the meta information among the data source objects included in the generated parse tree A meta information management unit for separating the meta information; A query generator for generating an external database query using the separated external reference object; A query term storage unit for storing the input CQL query and the external database query term using the input CQL query as a key and using the generated external database query as a value, And an external interface unit for executing the fetched query word when fetched.

Preferably, the query analyzing unit determines whether the input CQL query is the same as one of the CQL query statements previously stored in the query storage unit, and if it is determined to be the same, retrieves the external database query stored in the query storage unit ), And then executes the extracted external database query through the external interface unit.

Preferably, the query term storage unit is implemented to perform a cache function. In this case, the key of the cache includes a CQL query.

Preferably, the value of the cache is an external database query generated by the query generator 130.

As a preferred embodiment of the present invention, the event processing apparatus combines a stream, which is an internal object of the event processing apparatus, with a table of an external database, which is an external reference object, in an input CQL query statement of the event processing apparatus, It has the effect of accessing the table inside the database and referencing or changing the data.

1 is a block diagram showing an internal configuration of an event processing apparatus according to a preferred embodiment of the present invention.
FIG. 2 shows an example of converting into a parse tree when receiving a CQL query syntax according to a preferred embodiment of the present invention.
FIG. 3 illustrates an example of managing an external database table as an external reference object in the metadata unit according to a preferred embodiment of the present invention.

Embodiments of the present invention will now be described with reference to the accompanying drawings. The following description and accompanying drawings are for understanding the operation according to the present invention, and parts that can be easily implemented by those skilled in the art can be omitted.

Furthermore, the specification and drawings are not intended to limit the present invention, and the scope of the present invention should be determined by the claims. The terms used in the present specification should be construed to mean the meanings and concepts consistent with the technical idea of the present invention in order to best express the present invention.

A preferred embodiment of the present invention discloses a method for referring to a table in an external database as an external reference object in an event processing apparatus.

The external database 200 stores tables in the shared memory 300 and stores the tables stored in the shared memory 300 of the external database 200 in the event processing apparatus 100. [ Reference to an external reference object is possible within the context.

The complex event processing apparatus 100 is characterized in that it extracts meaningful data in real time on events occurring in various event sources and performs a corresponding action. Examples of event data include real-time data, data continuously input in a large amount, and time-sequential data.

As one preferred embodiment of the present invention, the external database 200 is an apparatus for processing or storing static data, and means an apparatus for managing data on a table basis.

1, the event processing apparatus 100 includes a query language analysis unit 110, a meta information management unit 120, a query language generation unit 130, a query language storage unit 140, and an external interface unit 150 .

The query analyzer 110 analyzes a Continuous Query Language (CQL) query sent to the event processing device 100 and generates a parse tree as shown in FIG. 2 shows an example of conversion into a parse tree when the following CQL query syntax S100 is received by the query language analysis unit 110. [

"SELECT * FROM STREAM1 AS S, TABLE1 AS T WHERE S.ID = T.ID;" (S100)

The above CQL query syntax S100 shows an example of performing a JOIN operation on Table1 310, which is a table in the external database 200, and Stream Stream1, which is an internal object.

Thereafter, the event processing apparatus 100 separates the inner object and the outer reference object among the data source objects included in the generated parse tree by referring to the meta information management unit 120. An example of an internal object is a stream object. The external reference object information includes a table name of an external database, column information required for the table, and the like.

The query term generation unit 130 generates an external database query term based on the separated table object information. The query generation unit 130 generates the following external database query for the received CQL query S100: SELECT * FROM STREAM1 AS S, TABLE1 AS T WHERE S.ID = T.ID;

"SELECT * FROM TABLE1 WHERE TABLE1.ID =?;"

The query storage unit 140 stores a CQL query and an external database query as a key and generates an external database query as a value. As a preferred embodiment of the present invention, the external database query term generated by the query language generation unit 130 is generated for an external database table, and is highly likely to be reused.

In an exemplary embodiment of the present invention, an external database query term is stored in the query term storage unit 140 in the event processing apparatus 100 so that an external database query term is generated for the same input CQL query in the query language generation unit 130 There is an advantage that it is performed only once without repeating the process of repeating the process.

In a preferred embodiment of the present invention, the query term storage unit 140 may perform a function of a cache. In this case, the key of the cache includes a received CQL query as a basis. The value (Value) of the cache is an external database query term generated by the query language generation unit 130.

In an exemplary embodiment of the present invention, the external database query term stored in the query term storage unit 140 is fetched and managed in the shared memory 300 of the external database 200 when the query is performed through the external interface unit 150 Lt; RTI ID = 0.0 > 310 < / RTI >

The query analyzer 110 determines whether the input CQL query is identical to one of the stored CQL query statements stored in the query storage unit 140.

The query analyzer 110 retires the external database query term stored in the query term storage unit 140 and then executes the retrieved external database query term via the external interface unit 150. [

As shown in FIG. 3, the meta information management unit 120 manages internal objects and external reference objects. Management information of the external reference objects includes table information of external databases, table information of external databases, tables of external databases The information of the column to be analyzed.

3, the meta information management unit 120 determines that the TABLE_ID 320 of the TABLES_INFO 311 is a primary key and the TABLE_ID 340 of the COLUMN_INFO 330 is a foreign key It concludes.

In a preferred embodiment of the present invention, in order to use a table of an external database in the event processing apparatus 100 as an external reference object, the external reference object information must be registered in the meta information management unit 120 in advance. In addition, the meta information management unit 120 verifies and updates the information of the external reference object at the time of initializing the event processing apparatus 100 or a run-time error of the event processing apparatus 100. [

As a preferred embodiment of the present invention, the meta information management unit 120 is configured to verify the external database table information at the time of initializing the event processing apparatus 100.

The meta information management unit 120 reads the external database table and column information managed by the external reference object at the time of initializing the event processing apparatus 100. Then, it is confirmed whether the information managed by the external reference object of the event processing apparatus 100 coincides with the read external database table and column information.

If they match, the initialization of the event processing apparatus 100 is completed. If they do not match, the external reference object is updated with the external database table and column information read by the meta information management unit 120. Thus, the event processing apparatus 100 can maintain the table information of the latest external database as an external chamber object in the initialization step.

In another preferred embodiment of the present invention, the meta information management unit 120 is configured to verify and update information managed by an external reference object when a run-time error occurs in the event processing apparatus 100.

When the table of the external database 200 is changed, the table information managed by the meta information management unit 120 is different from the table information of the external database. As a result, when the event processing apparatus 100 executes a command on an external database based on existing external reference object information, an error message such as "the corresponding table does not exist "," Is returned.

When the runtime error is detected, the meta information management unit 120 updates the information managed by the external reference object.

The present invention can be embodied as a code that can be read by a processor in a processor-readable recording medium provided in a portable terminal. The processor-readable recording medium includes all kinds of recording apparatuses in which data that can be read by the processor is stored. Examples of the recording medium on which the processor can read are ROM, RAM, CD-ROM, magnetic tape, floppy disk, optical data storage, and the like. In addition, the processor readable recording medium may be distributed over networked computer systems so that code readable by the processor in a distributed manner can be stored and executed.

While the present invention has been particularly shown and described with reference to exemplary embodiments thereof, it is to be understood that the invention is not limited to the disclosed exemplary embodiments, but, on the contrary, It should be understood that various modifications may be made by those skilled in the art without departing from the spirit and scope of the present invention.

Claims (8)

An event processing apparatus for referring to a table in an external database as an external reference object,
A query analyzer for analyzing a continuous query language (CQL) query sent to the event processing device and generating a parse tree;
Wherein the metadata processing unit manages the objects available in the event processing apparatus as meta information by dividing the objects usable in the event processing apparatus into an inner object and an outer reference object and manages the data source objects included in the generated parse tree using the meta information, A meta information management unit for dividing the meta information into objects;
A query generator for generating an external database query using the separated external reference object;
A query term storage unit storing the input CQL query and the external database query word as a key and using the generated external database query as a value;
And an external interface unit for executing the retrieved query if the stored external database query term is retrieved. The apparatus of claim 1, wherein the query analyzing unit
Determines whether the input CQL query is identical to one of the CQL query statements previously stored in the query storage unit, retreivates the database query stored in the query storage unit if it is determined to be the same, And a database query term is performed through the external interface unit. The apparatus of claim 1, wherein the query term storage unit
Wherein the cache is implemented to perform a function of a cache, wherein the key of the cache includes the CQL query. The method of claim 3,
Wherein the value of the cache is an external database query generated by the query generator. The method according to claim 1,
Wherein the external database stores the table data in a shared memory. 6. The apparatus of claim 5, wherein the external interface unit
And the table data of the shared memory can be directly accessed. The apparatus of claim 1, wherein the meta information management unit
And reads the external database table and column information managed by the external reference object at the time of initializing the event processing device. A method for referring to a table in an external database as an external reference object in an event processing apparatus,
Analyzing a continuous query language (CQL) query sent to the event processing device by the query language analyzing unit and generating a parse tree;
The meta information management unit manages the objects available in the event processing apparatus as meta information by dividing them into an internal object and an external reference object, and manages the meta information from among the data source objects included in the generated parse tree, And an external reference object;
Generating an external database query term in a query term generation unit using the separated external reference object;
Storing the CQL query and the external database query word as a key in the query term storage unit as a key and using the external database query as a value;
And executing the query term retrieved through the external interface unit when the stored external database query term is retrieved.

Images