KR100931310B1 - Integrated continuous query processing device and user method using user-defined shared extended trigger - Google Patents

Abstract

The present invention relates to an integrated continuous query processing apparatus and method using a user-defined shared extended trigger, and to a user-defined shared used in each integrated continuous query when processing multiple integrated continuous queries on stored data using a user-defined shared trigger. By registering a query for the trigger result as a user-defined shared extension trigger, instead of searching the entire user-defined shared trigger result, the user can search the user-defined shared extended trigger result and process the integrated continuous query, thereby reducing the time required to process the query. To improve processing performance, an integrated continuous query processing apparatus using a user-defined shared extended trigger and a method thereof are provided.

To this end, the present invention provides an integrated continuous query processing apparatus comprising: data stream management means for managing a data stream; Integrated continuous query management means for analyzing the integrated continuous query statement and informing the trigger management means according to the query for the result of the user-defined shared trigger; The trigger management means for setting (registering) a user-defined shared extended trigger for the integrated continuous query statement according to the notification information from the integrated continuous query management means; Trigger result management means for managing the result of the user-defined shared extended trigger set by the trigger management means as a set (trigger result set); And integrated continuous query execution means for processing the integrated continuous query using the data stream from the data stream management means and the trigger result set from the trigger result management means.

Description

Apparatus and method for processing integrated continuous query using user-defined shared extension trigger}

The present invention relates to an integrated continuous query processing apparatus and method using a user-defined shared extended trigger, and more particularly, to use in each integrated continuous query when processing multiple integrated continuous queries on stored data using a user-defined shared trigger. Time required to process a query by registering a query for the result of the user-defined shared trigger as a user-defined shared extension trigger and processing the integrated continuous query by searching the user-defined shared trigger result without searching the entire user-defined shared trigger result. The present invention relates to an integrated continuous query processing apparatus using a user-defined shared extended trigger and to a method for improving query processing performance.

The present invention is derived from the research conducted as part of the IT new growth engine core technology development project of the Ministry of Information and Communication and the Ministry of Information and Communication Research and Development. [Task Management Number: 2005-S-405-02, Title: Development of Next Generation Internet Server Technology] .

In the ubiquitous computing environment, continuous query processing technology for real-time processing of data continuously generated from radio frequency identification, global positioning system, various sensors (e.g. temperature sensor, humidity sensor) and various applications is provided. It is required.

Taking a sensor network as an example, the sensor network, where lightweight sensor nodes are connected by wireless communication, can be used to monitor environmental conditions in areas where humans cannot monitor, automation and security of homes and offices, health monitoring, tracking of moving objects, and networks. Various application services for various ubiquitous environments such as monitoring, logistics / distribution, web logs, etc. can be provided.

In this case, the data processed for the various application services as described above is continuously generated, and since the amount of the generated data is changed at any time, there is a characteristic to be processed in real time.

In addition, in a ubiquitous computing environment, a continuous query including a data stream as well as stored data such as related information or history information in a continuous query processing device that processes a continuous query registered by a user or an application for real time situation recognition. There is an increasing demand for query processing.

However, analysis and analysis of data streams input in real time under ubiquitous computing environments may lead to inaccurate understanding and judgment of the current situation. In other words, integrated analysis based on past history or related information should be performed to obtain more accurate and high value-added information.

Accordingly, the continuous query processing unit integrates historical data or related data in a certain repository as well as data streams input in real time to provide high value information to users and applications through continuous queries (integrated continuous queries). Is supported.

However, until now, most research and development have adopted a push-based approach to continuously input data streams and a pull-based approach to stored data in a database. Combined, the integrated query was processed.

Accordingly, in the data stream management system that needs to deliver the result of the integrated query in real time, the query processing time for the stored data of the database is longer than the query processing time for the data stream. There was this.

That is, the continuous query processing apparatus according to the prior art takes a pull-based approach to perform a query after each connection with a database without knowing whether or not the stored data of the database has changed, thereby storing the stored data of the database. Due to the long time required for query processing, there is a problem of degrading the overall query performance.

Hereinafter, a conventional technique for improving query performance of stored data will be described.

The first conventional technique is to modify an initial query using a query for some data that will track the change in the initial query result to support a change in the query result, and then newly transform it with the rest of the initial query result not related to change tracking. The latest query result obtained by processing a query is combined to generate the latest result of the initial query reflecting the data change. In other words, instead of retrieving all the initial query results, only the latest changes of some specified results are reflected to provide the latest results of the initial query.

The first conventional technology has a problem in that the application of the technology is limited by designating data to be changed later by a user or an application program.

The second conventional technique is a technique for enhancing a keyword search capability generated from one or more data stores, and extracts a file argument and a type (type) from an initial query result to generate a second search result. Classify the results as additional retrieval, actions, and information that augment the results.

The second conventional technique is a technique of generating a second search query result that reinforces the initial query from the initial query result, and has a limitation that data to be queried should not be changed.

In the third conventional technique, when a trigger detects a change in a database to optimize a query processing repeatedly performed in a relational database, the data processing engine re-executes the query for the relational database and the result of the query is limited to executing the same query. By reusing it, you can optimize queries that are executed repeatedly in a relational database. At this time, the trigger only plays a role of detecting change of the database.

This third conventional technique has a problem that the time for processing a query is not shortened when data is changed because the trigger only plays a role of detecting a change of the database.

The fourth prior art is a paper on a data stream management system for performing an integrated query on a data stream and stored data, and the integrated continuous query processing performance by reducing the I / O cost for the stored data through sampling of the stored data. To improve.

This fourth conventional technique has a problem of reducing the actual query subject itself by performing sampling to improve query processing performance for stored data.

As a result, since the above conventional technology performs only a predetermined user-defined shared trigger for each database when data is changed on the database, the entire user-defined shared trigger result set must be retrieved when a query for the result of the user-defined shared trigger is requested. There is a problem that can not provide a variety of request information in a short time, and setting a user-defined shared extended trigger to provide a large amount of user request details in a short time is a problem that takes a lot of time And, to solve this problem is a problem of the present invention.

The present invention, when processing a multi-integrated continuous query for the stored data using a user-defined shared trigger, by registering a query for a user-defined shared trigger result used in each integrated continuous query as a user-defined shared extended trigger user-defined shared trigger Integrated continuous query processing using user-defined shared extended triggers to improve query processing performance by reducing the time required for query processing by retrieving user-defined shared extended trigger results without processing the entire result. It is an object of the present invention to provide an apparatus and a method thereof.

The objects of the present invention are not limited to the above-mentioned objects, and other objects and advantages of the present invention which are not mentioned above can be understood by the following description, and will be more clearly understood by the embodiments of the present invention. Also, it will be readily appreciated that the objects and advantages of the present invention may be realized by the means and combinations thereof indicated in the claims.

An apparatus of the present invention for achieving the above object comprises: an integrated continuous query processing apparatus, comprising: data stream management means for managing a data stream; Integrated continuous query management means for analyzing the integrated continuous query statement and informing the trigger management means according to the query for the result of the user-defined shared trigger; The trigger management means for setting (registering) a user-defined shared extended trigger for the integrated continuous query statement according to the notification information from the integrated continuous query management means; Trigger result management means for managing the result of the user-defined shared extended trigger set by the trigger management means as a set (trigger result set); And integrated continuous query execution means for processing the integrated continuous query using the data stream from the data stream management means and the trigger result set from the trigger result management means.

In addition, the method of the present invention for achieving the above object, the integrated continuous query processing method, comprising: receiving a data stream; A verification step of analyzing an integrated continuous query received from an external application and including a query for a result of a user-defined shared trigger; A registration step of setting (registering) a user-defined shared extended trigger for the integrated continuous query statement according to a query for a result of a user-defined shared trigger; And processing an integrated continuous query using the data stream and the corresponding user-defined shared extended trigger result.

In addition, the present invention provides a user-defined sharing in order to improve the query processing performance for the user-defined shared trigger results in the integrated continuous query processing system for processing the user-defined shared trigger for processing the data stream and the data stored in the database continuously input Register and process a query for a trigger as an extended trigger.

In addition, the present invention, when performing the integrated continuous query registered in the integrated continuous query processing system of the data stream and the stored data using the user-defined shared trigger, it is defined in the integrated continuous query syntax without searching the entire result of the user-defined shared trigger The query is processed using the customized shared extension trigger result.

In addition, the present invention, when the integrated continuous query processing using the user-defined shared extended trigger for the data stream continuously input and the stored data managed in the main memory database, the time required for processing the query for the user-defined shared trigger result Decrease.

In addition, the present invention is generally defined by sharing a user-defined shared trigger result of multiple integrated continuous queries, but the stored data required for each integrated continuous query is only a part, By registering the query as a user-defined shared extension trigger, the query processing time for the stored data can be shortened to improve the integrated query processing performance.

In addition, the present invention registers a query for a user-defined shared trigger result used in each integrated continuous query as a user-defined shared extended trigger when processing multiple unified continuous queries on stored data using a user-defined shared trigger in real time. Improve query processing performance by not searching the entire user-defined shared trigger result.

In the present invention as described above, when processing a multi-integrated continuous query for the stored data using a user-defined shared trigger, by registering a query for a user-defined shared trigger result used in each integrated continuous query as a user-defined shared extended trigger user By retrieving the user-defined shared extended trigger result without processing the entire definition shared trigger result and processing the integrated continuous query, the query processing performance can be improved by reducing the time required for query processing.

In addition, the present invention, in the continuous query processing system using a user-defined shared trigger for the data stream, advance query results for the user-defined shared trigger results in the integrated continuous query processing for the stored data of the data stream and the main memory database It is possible to improve the overall integrated query processing performance by calculating and sharing it among multiple integrated continuous queries.

In addition, the present invention, when a change to the result of the user-defined shared trigger in the main memory database occurs, the trigger statement of the user-defined shared extended trigger in real time to calculate the result set in advance to the user-defined shared in the integrated continuous query By directly accessing some designated result data without searching the entire trigger result and sharing it among several integrated continuous queries, the overall query performance can be improved by reducing the integrated continuous query processing time.

The above objects, features, and advantages will become more apparent from the detailed description given hereinafter with reference to the accompanying drawings, and accordingly, those skilled in the art to which the present invention pertains may share the technical idea of the present invention. It will be easy to implement. In addition, in describing the present invention, when it is determined that the detailed description of the known technology related to the present invention may unnecessarily obscure the subject matter of the present invention, the detailed description thereof will be omitted. Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings.

In the following detailed description, an XML data stream and an XML database will be described by taking into consideration that data transmitted between the Internet and an application conforms to the XML (eXtensible Markup Language, XML) format. .

1 is a block diagram of an integrated continuous query processing apparatus using a user-defined shared extended trigger according to the present invention.
Before looking at the configuration diagram of FIG. 1, the user-defined sharing trigger and the user-defined sharing extended trigger will be described. A user-defined shared trigger is a trigger that executes a user-defined query (search) whenever a change such as inserting, updating, or deleting data stored in a database occurs. In addition, the user-defined shared extended trigger is a trigger that detects a change in the search result generated from the user-defined shared trigger and automatically performs a search query for some data of the user-defined shared trigger result.

As illustrated in FIG. 1, an integrated continuous query processing apparatus using a user-defined shared extended trigger according to the present invention includes a data stream manager 11 for managing an XML data stream continuously input from various external XML data stream sources. ), An integrated continuous query manager 12 for managing an integrated continuous query statement from an external application, and notifying the trigger manager 13 according to its analysis result including a query for the result of a user-defined shared trigger. Trigger manager 13 for setting (registering) a user-defined shared extended trigger for the integrated continuous query statement according to the notification information from the query manager 12, and the result of the user-defined extended trigger set by the trigger manager 13 A trigger result manager 14 for managing the data as a set (trigger result set), and the data An integrated continuous query executor for processing the integrated continuous query using the XML data stream from the stream manager 11 and the trigger result set from the trigger result manager 14 and then passing the result to an external application. 15).

Here, the integrated continuous query manager 12 is a component that provides a function of registering and deleting an integrated continuous query. When the integrated continuous query is registered, the integrated continuous query manager 12 performs parsing and validity checking of the integrated continuous query and integrates it in the validity checking process. When the query for the result of the user-defined shared trigger is included in the continuous query, the trigger manager 13 checks whether it is registered as the user-defined shared extended trigger and requests registration to the trigger manager 13 if it is not registered. . In addition, when deleting the integrated continuous query, the trigger is registered and its operation is performed.

In addition, the trigger manager 13 is a component that provides a trigger registration and deletion function, performs parsing and validity check when registering a user-defined shared extended trigger, and performs an operation according to generation of a trigger to integrate a continuous query. Build an environment for the executor 15. In addition, when the user-defined shared extended trigger is deleted, the existence of an integrated continuous query using the user-defined shared extended trigger is checked and the corresponding operation is performed.

In addition, the trigger manager 13 registers an XML trigger that conforms to an XQuery syntax structure in the XML main memory database, so that the trigger result manager 14 automatically generates an XML data according to addition, change, and deletion. Receives the result of registered XML trigger execution.

In addition, the trigger result manager 14 retrieves the corresponding trigger result (user-defined shared trigger or user-defined shared extended trigger) according to a request from the trigger manager 13 and delivers the result to the integrated continuous query executor 15.

In addition, the trigger result manager 14 receives an XML trigger execution result for each stored data in real time from one or more XML main memory databases linked to the integrated continuous query processing system. To this end, the trigger manager 13 registers a user-defined shared trigger and a user-defined shared extended trigger as an XML trigger in the corresponding XML main memory database so that the registered XML trigger is automatically generated whenever a change occurs in the internal data of the XML database. To be performed. The execution result is transmitted to the trigger result manager 14 in real time, so that the integrated query can refer to the result of the query processing already completed.

In addition, the integrated continuous query executor 15 receives the XML data stream from the data stream manager 11, receives a trigger result set for the stored data from the trigger result manager 14, and refers to the XML data stream with reference thereto. And after processing the integrated continuous query for the stored data, and passes the result to the external application.

The present invention continuously receives XML data streams from XML data stream sources such as various sensors and applications including an external RFID sensor, and works with one or more XML databases supporting XML triggers to store data. Accessible.

In addition, the present invention performs integrated continuous query processing on the received XML data stream and the stored data of the XML database 108, and delivers the results generated therein to other applications in real time.

Hereinafter, an integrated continuous query statement set as a user-defined shared extended trigger will be described with reference to [Table 1].

Integrated continuous query statements can construct a "FLWOR" clause based on an Ex Query, while a "USING" clause is based on a document while a typical Ex Query is based on a document. To expand. Each data source can be identified by its name, and the name indicates whether it is a data stream source or a stored data source in an XML database.

Looking at the contents of the integrated query statement, the value of "/ Building / Room / Temperature" from the data stream input from "DataStreamSource" is the value of "/ Buildging / lobby / avgTemperature" in the result of the user-defined sharing trigger T1, that is, until recently If the building's lobby average temperature value is stored in the XML database, the room number and current temperature will be created by passing an element called "<REPORT>".

In this case, the user-defined shared trigger is registered by receiving the trigger name and the trigger statement. After that, the trigger name is referred to in the uc: trigger () function so that it can be shared and used in multiple continuous queries.

At this time, the namespace prefix uc in the uc: trigger () function is bound to the namespace URI 'http://ubicore.etri.re.kr/xquery-functions', and the present invention uses the W3C through the namespace. Defines and provides unique XQuery functions which are not defined in XQuery.

2 is a flowchart illustrating an integrated continuous query processing method using a user-defined sharing trigger according to the present invention.

First, an XML data stream is input from various external XML data stream sources (201).

Thereafter, the integrated continuous query received from an external application is analyzed to determine whether the query includes the query for the result of the user-defined shared trigger (202).

Thereafter, the user-defined shared extended trigger for the integrated continuous query statement is set (registered) as including the query for the result of the user-defined shared trigger (203). At this time, if the query for the result of the user-defined shared trigger is not included, the user-defined shared extended trigger is not generated. In addition, even if a user-defined shared extension trigger for the integrated continuous query already exists, it is not generated. However, the number of users is increased by one.

Thereafter, the integrated continuous query is processed using the XML data stream and the corresponding trigger result (204).

Thereafter, the processed result is transmitted to an external application (205).

3 is a detailed flowchart illustrating an integrated continuous query registration process in the integrated continuous query manager according to the present invention.

First, the integrated continuous query received is analyzed (301).

Thereafter, a validity check is performed on the analyzed integrated continuous query (302).

Then, it is determined whether or not the legitimacy (303). In this case, the validity check checks whether the data stream source to be queried through the syntax check exists, whether the argument of the trigger result reference function is a registered user-defined shared trigger name, whether the specification for the data is valid, etc. Check it.

In the determination result 303, if it is not a legitimate integrated continuous query, it terminates, and if it is a legitimate integrated continuous query, the query for the user-defined shared trigger result is included by using the user-defined shared trigger result reference function in the integrated continuous query. Check if it is (304).

If the check result 304 includes a query for a user-defined shared trigger result, the trigger manager 13 notifies the query result and stores metadata information related to the integrated continuous query (305 and 306). In this case, the information to be stored includes integrated continuous query, user-defined shared trigger and user-defined shared extended trigger information.

If the check result 305 does not include a query for a user-defined shared trigger result, metadata information related to the integrated continuous query is immediately stored (306). In this case, the information to be stored includes the integrated continuous query and the user-defined shared trigger information.

The integrated continuous query registered through the above process is repeatedly performed on the data stream. On the other hand, the processing for the stored data is processed by referring to the trigger result managed by the trigger result manager 14 according to the execution of the user-defined shared trigger and the user-defined shared extended trigger.

The user-defined shared extended trigger generated through the above process is the same as the user-defined shared trigger, when the result of the user-defined shared trigger is changed according to the change of the XML database separately from the integrated continuous query processing operation of the integrated continuous query processing system. Each time, a user-defined shared extension trigger is automatically executed to update the result. Thus, querying the stored data is completed by referring to the user-defined shared extended trigger result without retrieving all the user-defined shared trigger results.

In addition, since the registered user-defined extended trigger can refer to a plurality of integrated continuous queries, the entire query processing performance can be improved by sharing the trigger result when performing multiple integrated continuous queries.

4 is a detailed flowchart illustrating an integrated continuous query deleting process in the integrated continuous query manager according to the present invention.

First, it is checked whether the integrated continuous query to be deleted is registered (401).

The check result 401, if there is no integration continuation query is terminated, and if the integration continuation query exists, it is determined whether to refer to the result of the user-defined shared extension trigger (402).

Referring to the determination result 402, the user-defined shared extended trigger result, the integrated continuous query deletion is notified to the trigger manager 13, and then the integrated continuous query is deleted (403, 404).

If the determination result 402 does not refer to the user-defined shared extended trigger result, the corresponding integrated continuous query related information is immediately deleted (404).

5 is a flowchart illustrating an embodiment of a process for generating and deleting a user-defined shared extended trigger in the trigger manager according to the present invention.

First, a type (creation / deletion) of a request function for a user-defined shared extension trigger is determined (501).

When the request function type determination result 501 is requested to generate the user-defined shared extended trigger, the user-defined shared extended trigger is searched for to be generated (502) and the existence thereof is determined (503).

As a result of determining whether the trigger exists (503), if the corresponding user-defined extended trigger does not exist, create and register a user-defined shared extended trigger for the related user-defined shared trigger result in the corresponding XML database (505), and trigger After configuring the trigger result that occurs with the generation of a (a trigger result set configuration) to be accessible in the integrated query processing (506), and returns the name of the user-defined shared extended trigger (507). At this time, the number of users is set to 1 after configuring the trigger result set. Here, "the user exists" means "the trigger has been created."

On the other hand, if the result of determining whether the trigger exists (503), if the corresponding user-defined extended trigger already exists, the total number of users (exactly, the number of combined queries) of the result set of the trigger is increased by one (504), Return the name of the corresponding custom shared extension trigger (507).

On the other hand, if the request function type determination result 501, when requested to delete the user-defined shared extended trigger is retrieved (508) corresponding to the user-defined shared extended trigger (508), the total number of users using the user-defined shared extended trigger ( The total number of users in the trigger result set) (509).

If the total number of users is not greater than 1, the verification result 509 deletes the user-defined shared extension trigger and the result set registered in the corresponding XML database (510).

If the total number of users is greater than 1, the verification result 509 reduces the total number of users in the trigger result set by one (511). And exit.

Here, the result set of the user-defined shared extension trigger can be shared by multiple integration queries. That is, in the case of a trigger that already exists when a request for creating a user-defined shared extension trigger is generated, the name of the user-defined user-defined extended trigger previously created to use the created result set is returned.

Similarly, when the user of the result set delete request does not exist other than the object requested for deletion, the trigger and the trigger result set are deleted. The sharing of these user-defined shared extension triggers and the user-defined shared extension trigger result set provides an optimization effect on the use of system resources.

Hereinafter, the user-defined shared extension trigger statement for registering the user-defined shared extension trigger will be described with reference to Table 2 below.

A custom shared extension trigger statement means retrieving the value of "Building / lobby / avgTemperature" from the result data source of the "UserDefinedTriggerResult" custom shared trigger and returning that value. Received as a trigger and set (registered) in the database.

Thereafter, the trigger result manager 14 receives the result of the user-defined shared extended trigger to construct an initial result set.

After the user-defined shared extended trigger is created, the user-defined shared extended trigger statement is executed whenever the stored data source "UserDefinedTriggerResult" is added, deleted, or changed in the XML database. Is returned and the trigger result is updated.

These user-defined shared extended triggers do not retrieve the entire user-defined shared trigger result set when performing a query on the user-defined shared trigger result set in a continuous query. Instead, the user-defined shared extended trigger result set is automatically built into the latest result set. By referring to, it provides the effect of optimization in terms of performance of continuous query processing.

6 is a diagram illustrating an embodiment of data configuration for managing results of a user-defined sharing extension trigger according to the present invention.

As shown in FIG. 6, the result set list 601 of the user-defined shared extended trigger includes all the result sets of all the user-defined shared extended triggers generated by the integrated continuous query processing apparatus. The result set of a specific user-defined extended trigger is accessible via the name of the trigger, and the trigger's name is automatically assigned to be unique within the integrated continuous query processing unit.

In addition, the result set of a particular user-defined shared extended trigger includes information related to the result of performing the particular trigger statement 602, the total number of users 603, and the lock 604 required to reference / change the result set.

Here, the total number of users refers to the total number of integrated continuous queries that access and use the result set of the user-defined shared extended trigger. The first time a user-defined shared extended trigger is created to form a result set, the number of users is 1, and the number of users is increased by 1 according to the registration request of the integrated continuous query referencing the trigger later. On the contrary, the number of users is reduced by 1 according to the deletion request of the integrated continuous query referring to the trigger, and the secondary trigger is automatically deleted when the number of users becomes 0 at last.

In this case, the result set of the user-defined shared extended trigger is used to process the integrated continuous query in the integrated continuous query processing apparatus. That is, when processing the integrated continuous query, the result set of the user-defined shared extended trigger is referred to, and the change to the result set of the user-defined shared extended trigger is made in the XML database.

Therefore, the lock 604 management technique is used to perform an operation on the result set of the user-defined shared extended trigger so that the read is performed when the result set is changed or the change is not performed when the read is performed. In other words, a lock must be acquired in order to read or change, and after the read / change operation is completed, the lock is released to prevent the read and change operations from being performed together. Since the operations such as query execution in XML database and integrated continuous query processing device are performed separately, the above lock management technique is possible because of less overhead.

In addition, the result set according to the execution of the user-defined shared extended trigger statement may include the result of the node tree type 605 or the result of basic type such as an integer 606 and a string 607. have.

On the other hand, the method of the present invention as described above can be written in a computer program. And the code and code segments constituting the program can be easily inferred by a computer programmer in the art. In addition, the written program is stored in a computer-readable recording medium (information storage medium), and read and executed by a computer to implement the method of the present invention. The recording medium may include any type of computer readable recording medium.

The present invention described above is capable of various substitutions, modifications, and changes without departing from the technical spirit of the present invention for those skilled in the art to which the present invention pertains. It is not limited by the drawings.

The present invention can be used for integrated continuous query processing and the like.

1 is a configuration diagram of an integrated continuous query processing apparatus using a user-defined shared extended trigger according to the present invention;

2 is a flowchart illustrating an integrated continuous query processing method using a user-defined shared trigger according to the present invention;

3 is a detailed flowchart illustrating an embodiment of an integrated continuous query registration process in an integrated continuous query manager according to the present invention;

4 is a detailed flowchart illustrating an embodiment of a process for deleting an integrated continuous query in the integrated continuous query manager according to the present invention;

5 is a flowchart illustrating an embodiment of a process for generating and deleting a user-defined shared extended trigger in the trigger manager according to the present invention;

6 is a diagram illustrating an embodiment of data configuration for managing results of a user-defined sharing extension trigger according to the present invention.

* Explanation of symbols for the main parts of the drawings

10: integrated continuous query processing device 11: data stream manager

12: integrated continuous query manager 13: trigger manager

14: trigger result manager 15: integrated continuous query executor

Claims (12)

In the integrated continuous query processing apparatus, Data stream management means for managing the data stream; Integrated continuous query management means for analyzing the integrated continuous query statement and informing the trigger management means according to the query for the result of the user-defined shared trigger; The trigger management means for setting (registering) a user-defined shared extended trigger for the integrated continuous query statement according to the notification information from the integrated continuous query management means; Trigger result management means for managing the result of the user-defined shared extended trigger set by the trigger management means as a set (trigger result set); And Integrated continuous query execution means for processing an integrated continuous query using the data stream from the data stream management means and the trigger result set from the trigger result management means Integrated continuous query processing apparatus using a user-defined shared extended trigger including a. The method of claim 1, The integrated continuous query management means, It provides integrated continuous query registration and deletion function, performs parsing and validity checking of the integrated continuous query when registering the integrated continuous query, and includes the query for the result of the user-defined shared trigger in the integrated continuous query during the validity checking process. If it is, the integrated continuous query using the user-defined shared extended trigger characterized in that it is registered as a user-defined shared extended trigger through the trigger management means, and requests registration to the trigger management means if it is not registered. Processing unit. The method of claim 2, The integrated continuous query management means, As the validity check, whether the data stream source to be queried through parsing exists, whether the argument of the trigger result reference function is a registered user-defined shared trigger name, and whether the specification for the data is valid. Integrated continuous query processing apparatus using a user-defined shared extended trigger, characterized in that the inspection. The method according to any one of claims 1 to 3, The trigger management means, After generating and registering a user-defined shared extended trigger for the related user-defined shared trigger result in the corresponding XML database, the trigger result set is set in the trigger result management means so that the registered user-defined extended trigger result can be accessed during the integrated query processing. Integrated continuous query processing apparatus using a user-defined shared extended trigger, characterized in that the configuration. The method of claim 4, wherein The trigger management means, When you delete a custom shared extension trigger, Check the total number of users referencing the user-defined shared extension trigger, and if it does not exceed 1, delete the user-defined shared extension trigger as well as the corresponding result set, and if it exceeds 1, the user-defined shared extension trigger Integrated continuous query processing device using. The method of claim 4, wherein The trigger result management means, An integrated continuous query processing apparatus using a user-defined shared extended trigger, characterized in that for managing the result of the user-defined shared extended trigger as a set under the control of the trigger management means to be used in the integrated continuous query processing. The method of claim 6, The trigger result management means, An integrated continuous query processing apparatus using a user-defined shared extended trigger, characterized in that the result of performing a trigger statement of the user-defined shared extended trigger, the total number of users, and information related to the lock are managed as a result set. In the integrated continuous query processing method, Receiving a data stream; A verification step of analyzing an integrated continuous query received from an external application and including a query for a result of a user-defined shared trigger; A registration step of setting (registering) a user-defined shared extended trigger for the integrated continuous query statement according to a query for a result of a user-defined shared trigger; And Processing an integrated continuous query using the data stream and the corresponding user-defined shared extended trigger result Integrated continuous query processing method using a user-defined shared extended trigger comprising a. The method of claim 8, The checking step, Analyzing the received integrated continuous query; Performing a validity check on the analyzed integrated continuous query; A check step of checking whether the integrated continuous query includes a query for a user-defined shared trigger result using a user-defined shared trigger result reference function in the integrated continuous query statement; Integrated continuous query processing method using a user-defined shared extended trigger comprising a. The method of claim 9, The validity test process, The syntax check checks whether the data stream source to be queried exists, whether the argument of the trigger result reference function is a registered user-defined shared trigger name, and whether the specification for the data is valid. Integrated continuous query processing method using a user-defined shared extended trigger. The method of claim 8, The user-defined shared extended trigger registration step, Ascertaining whether the same trigger exists as including a query for the result of the user-defined shared trigger; If the user-defined shared extended trigger does not exist as a result of the checking, creating / registering in the corresponding database, and configuring the trigger result set to be accessible when the integrated query is processed; And If the user-defined shared extended trigger exists, increasing the total number of users in the trigger result set by 1 Integrated continuous query processing method using a user-defined shared extended trigger comprising a. The method of claim 11, wherein The user-defined shared expansion trigger result is, And a result of performing the trigger statement of the user-defined shared extended trigger, including a total number of users and information related to the lock as a result set.

Images