JP2009169801A - Schedule retrieval system and retrieval method for data - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To perform data retrieval based on a retrieval condition independent on a retrieval period. <P>SOLUTION: A data retrieval unit C retrieves data meeting the specified retrieval condition from data collected/stored in a data storage unit B at a specified execution period as scheduled. In this data retrieval, a data segmentation section management unit 2 manages even a data segmentation period including the retrieval period during execution of a schedule retrieval unit 1, a section segmentation processing unit 3 saves section start detection information without carrying out segmentation when section segmentation in the retrieval period does not reach the end of the retrieval period, and a retrieval period extension unit 4 outputs even section data having been started before the start of the retrieval period as a retrieval period. A setting unit 5 for a maximum holding period and the number of parallel sections sets the maximum storage period and the maximum number of parallel sections in an external definition file for the section management independent on the retrieval period. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to a data collection / storage / retrieval system, and more particularly to a schedule retrieval method and method for collected / accumulated data.

  The data collection / storage / retrieval system, as shown in FIG. 5, has a “data collection unit” A that collects data from various devices / equipment # 1 to #n, and accumulates the collected data in a database. The “data storage unit” B and the “data search unit” C that searches for data that matches the search conditions from the stored data and that is used for data analysis, etc., are largely divided in functions, and each has a function for managing data. However, data transmission is possible using a system-dedicated LAN or an existing LAN.

  The main functions of the data collection unit A include (a1) a data collection function with a predetermined period from a data source (digital I / O, sequencer, unique data communication), and (a2) collected data to the data storage unit. There is a transfer function.

  The main functions of the data storage unit B include (b1) a function for receiving collected data from the data storage unit and (b2) a function for storing collected data in the database.

  The main functions of the data search unit C installed as an application in a client PC or the like include (c1) a data extraction function based on specified search conditions for the collected data stored in the database, and (c2) a function for extracting data. There is a schedule search function that periodically executes.

Here, the data search by the data search unit C is usually realized by designating “search conditions”, “execution cycle”, and “output format”. For example,
“Search condition”: Specifies that the section condition is data A = 10 to 20, parameters 10 to 10, and the search period is 1 hour to 20 minutes ago.

  “Execution period”: Specify a period of 30 minutes.

  “Output format”: Designated as a CSV format file.

The search schedule information specified in such a format is stored in a database, and by specifying a search target period, the schedule information for the period is searched from the database, and there is also a search that uses a schedule according to this information (for example, , See Patent Document 1).
JP 2000-67126 A

  An example of the schedule search operation of the “data search unit” C is shown in FIG. In the figure, the search period is a period during which the search is executed. The section is a data section within the search period specified by the search condition. The start of this section is indicated by a circle and the end is indicated by a ■ mark. Also, ■ / ○ indicates the start and end of the deemed section.

  As shown in (a) of FIG. 6, in the schedule search, basically, the boundary positions of a plurality of search periods are the end positions of only the data sections and the assumed section start positions. However, it is determined whether or not the boundary position is the last data connection section performed last time, and only when it is determined that the boundary section is a connection section, the acquisition target data is obtained.

  Further, as shown in FIG. 6B, when no data section exists in the search period, it is determined whether or not the entire search period data is to be acquired depending on whether it is a continuous section from the previous search period. To do. Therefore, when the continuation period remains, all data within the search period to be executed is an acquisition target. Conversely, if it is not a continuation section, all data within the search period to be executed is subject to discarding.

  In the schedule search method in which the acquisition target data is determined as described above, the “section” based on the search condition is completed within the search period because of the relationship between the search condition and the search period. This has the following problems.

  (1) Since the “section” by the search condition is limited to the search period, the data output as the section information is not the entire original section information but becomes partial information in which the section is divided by the search period. End up.

  (2) When the search condition is not related to the time limit frame, it is inconvenient from the viewpoint of original data management to output a plurality of data. That is, it is necessary to combine the output results separately later.

  An object of the present invention is to provide a schedule search method and method capable of performing data search under a search condition independent of a search period.

  In order to solve the above-mentioned problems, the present invention enables data obtained by dividing a section by a search period as continuous data and as data under a target clipping condition. It is characterized by.

(1) In a data collection / accumulation / retrieval system having a data retrieval unit for performing a schedule retrieval using data that meets a designated retrieval condition and having a designated execution cycle from collected / accumulated data,
The data search unit
When performing the schedule search, a data extraction section management unit that can also manage a data extraction section across the search period;
In the section cutout process within the search period by the schedule search, if the section does not end within the search period, a section cutout processing unit that saves the section start detection information without cutting out,
A search period expansion unit that outputs as a search period for the section data started before the start of the search period, together with the section cut-out process by the section cut-out processing unit,
It is provided with.

  (2) When the section start condition is detected in the current search period and the section end condition is not detected, the data cut-out section management unit stores the section start detection status in a separate file and searches for the next period. If there is this stored information, data segmentation including the previous search period is performed.

  (3) In order to perform section management that does not depend on the search period, the maximum retention period and the maximum number of parallel sections can be set in an external definition file. And

(4) In a data collection / accumulation / retrieval system including a data retrieval unit that performs a schedule retrieval using a data extraction that meets a designated retrieval condition as a designated execution cycle from collected / accumulated data,
The data search unit
In performing the schedule search, a data extraction section management step capable of managing a data extraction section across a search period;
In the section cutout process within the search period by the schedule search, if the section does not end within the search period, the section cutout process step of saving the section start detection information without cutting out,
A search period expansion step for outputting as a search period for the section data started before the start of the search period, together with the section cutout process by the section cutout processing unit,
It is provided with.

  (5) In the data extraction section management step, when the section start condition is detected in the current search period and the section end condition is not detected, the section start detection status is separately saved in a file, and the next period is searched. If there is this stored information, data segmentation including the previous search period is performed.

  (6) In order to perform section management independent of the search period, the maximum retention period and the maximum number of parallel sections can be set in an external definition file. And

  As described above, according to the present invention, since the data whose section is divided by the search period can be searched as continuous data and data under the target clipping condition, the data under the search condition that does not depend on the search period. You can search.

  Accordingly, section data can be acquired as continuous data from the section start before the search period. Further, since the section is handled as continuous data, it is possible to reliably acquire the state variable of the extraction condition event. Furthermore, since section data can be acquired as continuous data, the acquired data can be used (data analysis) without being processed.

  FIG. 1 is a functional configuration diagram of a data search unit showing an embodiment of the present invention. The schedule search unit 1 of the computer resource and the software configuration using the computer resource searches the schedule of the data stored in the data storage unit B by specifying “search conditions”, “execution cycle”, “output format”, etc. Execute. In this schedule search, data based on the section / period management by the following sections 2 to 5 of the software configuration is used as continuous data and data under the target cut-out conditions by the search divided by the search period. Make it searchable.

  (A) The data cut-out section management unit 2 performs section management independent of the search period so that the data cut-out section across the search periods can be managed.

  In this management, if the section start condition is detected in the current search period and the section end condition is not detected, the section start detection status is saved in a separate file, and this saved information is available when searching for the next period. In this case, the management mechanism performs data segmentation including the previous search period.

  (B) In the section cutout process within the search period by the schedule search unit 1, the section cutout processing unit 3 does not cut out when the section does not end within the search period.

  This process only saves the section start detection information when the section end condition cannot be detected by the section management unit 2 described above. FIG. 2 shows an example of the section start detection information file (XML file format).

  (C) The search period expansion unit 4 outputs the section data started before the start of the search period as the search period together with the section cutout process by the section extraction processing unit 3.

  In this process, in addition to the search period start time, segment extraction is performed by the search period extended to the stored section start time by the contents of (a) data extraction section management and (b) section extraction processing.

  (D) Since the setting unit 5 for the maximum holding period and the number of parallel sections performs section management independent of the search period, the maximum holding period and the maximum number of parallel sections can be set in the external definition file.

  In this process, it is assumed that the section start condition is detected, but the section end condition cannot be detected due to some trouble. At that time, in order to avoid that the storage information of the section start condition remains permanently, a function that enables registration as a storage information deletion condition is implemented.

  FIG. 3 shows an example of an external definition file (XML file format), in which the maximum number of parallel sections and the maximum time of one section information are set.

  FIG. 4 shows an operation example in the schedule search in the present embodiment, and the sections A, B, and C are expanded without depending on the search period, and only the conventional section is not cut out.

  Therefore, according to this embodiment, section data can be acquired as continuous data from the start of the section before the search period. Further, since the section is handled as continuous data, it is possible to reliably acquire the state variable of the extraction condition event. Furthermore, since section data can be acquired as continuous data, the acquired data can be used (data analysis) without being processed.

The function block diagram of the data search part which shows embodiment of this invention. An example of a section start detection information file. Example of an external definition file. Example of schedule search operation. A general block diagram of a data collection / storage / retrieval system. Example of schedule search operation.

Explanation of symbols

A data collection part B data storage part C data search part 1 schedule search part 2 data extraction section management part 3 section extraction processing part 4 search period expansion part 5 maximum retention period and parallel section number setting part

Claims (6)

In a data collection / storage / retrieval system equipped with a data retrieval unit that performs a schedule retrieval with a designated execution cycle from data that has been collected / accumulated according to a designated search condition,
The data search unit
When performing the schedule search, a data extraction section management unit that can also manage a data extraction section across the search period;
In the section cutout process within the search period by the schedule search, if the section does not end within the search period, a section cutout processing unit that saves the section start detection information without cutting out,
A search period expansion unit that outputs as a search period for the section data started before the start of the search period, together with the section cut-out process by the section cut-out processing unit,
A data schedule search method characterized by comprising:   When the section start condition is detected in the current search period and the section end condition is not detected, the data extraction section management unit saves the section start detection status in a separate file and searches for the next period. 2. The data schedule search method according to claim 1, wherein, when there is stored information, the data segmentation including the previous search period is performed.   In order to perform section management independent of the search period, a maximum holding period and a maximum number of parallel sections can be set in an external definition file. Item 3. A schedule search method for data according to item 1 or 2. In a data collection / storage / retrieval system equipped with a data retrieval unit that performs a schedule retrieval with a designated execution cycle from data that has been collected / accumulated according to a designated search condition,
The data search unit
In performing the schedule search, a data extraction section management step capable of managing a data extraction section across a search period;
In the section cutout process within the search period by the schedule search, if the section does not end within the search period, the section cutout process step of saving the section start detection information without cutting out,
A search period expansion step for outputting as a search period for the section data started before the start of the search period, together with the section cutout process by the section cutout processing unit,
A schedule search method for data, comprising:   In the data extraction section management step, when the section start condition is detected in the current search period and the section end condition is not detected, the section start detection status is separately saved in a file, and this is used when searching for the next period. 5. The data schedule search method according to claim 4, wherein when there is stored information, the data section extraction including the previous search period is performed.   A step of setting the maximum holding period and the number of parallel sections that allow the maximum holding period and the maximum number of parallel sections to be set in an external definition file in order to perform section management independent of the search period. Item 6. The data schedule search method according to Item 4 or 5.

Images