JP2004348356A - Database search method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a database search method which reduces the amount of processing needed to end a database search and the time of processing by performing search processes in the order of processing that matches each search condition, in the database search where the order of inputting commands for the search conditions is designated. <P>SOLUTION: The database has a database processing table which holds the search items of database searches and data for designating the order of executing the searches, and a temporary buffer for temporarily storing the data extracted from the database. The data are extracted from the database starting with the search item which is higher in the order of priority for executing the searches, designated in the database processing table. The data extracted are stored on the database. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a data search method for a database such as a monitoring / control system such as a communication network, and more particularly to a data search method for a database in which an input order of command input of a search item as a database search condition is specified.
[0002]
[Prior art]
First, a system for monitoring, controlling, and managing an alarm event in a communication network or the like will be described. FIG. 5 is a block diagram of a conventional alarm event monitoring / control / management system.
The alarm event monitoring / control / management system is a monitoring / control system 10 for monitoring the network and taking countermeasures / control for the generated alarm event, a database 20 for holding alarm data and other data, and a communication network manager. It is composed of a client terminal 30. The event collection system 11 of the monitoring and control system 10 collects the history of the occurrence of the generated alarm event and the countermeasure for the alarm event, and stores the history in the alarm database 21 of the database 20. The system administrator accesses the alarm database from the client terminal 30, downloads the data in the alarm database of the communication network to the client terminal, checks the contents, and manages the communication network.
[0003]
The database 20 includes, for example, an alarm database 21 which is a search target DB table of A3 in FIG. The data items of the alarm event constituting the alarm database include a device type indicating which device of the communication device constituting the communication network has generated the alarm event, a unit type indicating which unit of the device has generated the alarm, and a target There are an alarm type indicating the type of alarm event, a sensing importance indicating the importance of the target alarm event, and a date and time when the alarm event occurred.
[0004]
A conventional alert database search procedure and editing method for an alert database will be described below.
1) FIG. 6 shows a conventional database search procedure.
As an example, a case where it is desired to display, as search conditions, five alarms whose sensing importance is “MAJOR” in chronological order of occurrence date and time will be described with reference to the example of FIG. 6.
(1) Download data from the alarm database 21 to the client terminal. A3 is a database to be searched, and this data is displayed on the client terminal.
(2) Input the following search condition commands in a predetermined order.
[0005]
I. Enter the period for which the occurrence date / time command is to be executed. FIG. 6 targets an alarm event that has occurred between December 16 and December 31, 2002.
B. In FIG. 6, the input is a blank of "blank", regardless of the command type of the device type.
[0006]
C. In FIG. 6, the input is a "blank" blank, assuming that the command importance of the command does not matter.
D. The device alarm is input for the device alarm as the command alarm type of the alarm type.
(3) The following search processing is performed in the client terminal. First, based on the sort condition at the date and time of occurrence in S20, a process of searching for all records in the database is performed and temporarily stored in the client terminal in ascending order. B3 is the content.
(4) Data is extracted from all the records B3 that are temporarily stored under the condition of the importance of sensing in S21. C3 is a result of extracting the sense importance “MAJOR” from B3, and is temporarily stored in the client terminal.
(5) The contents of C3 are extracted in the order of the date and time of occurrence in descending order of the occurrence date and time from the condition of the number of display cases in S22, and five events are displayed on the user interface screen.
[0007]
In the case of this example, two search processes are performed on all records under the conditions of S20 and S21. That is, search processing for all records in the database is required twice.
When the search result indicated by B3 is separately sorted by another search item, the contents of B3 are stored in the client terminal to reuse the database.
[0008]
Since it is important to reduce the database search time, the following technology has been disclosed as a method for reducing the search time.
2) In Patent Literature 1, priority processing is set in advance for search conditions, and search processing is performed based on the priority processing. When the database is created, the number of occurrences of the same key is stored in advance in association with the content of the key, the number of occurrences of the key is checked against the search condition, the search is performed in order from the key with the lowest number of occurrences, and A technique for shortening a search time by narrowing down is disclosed.
[0009]
[Patent Document 1] JP-A-7-105223 "Database search device"
[0010]
[Problems to be solved by the invention]
The number of alarm events in a monitoring / control system such as a communication network ranges from 300,000 to 500,000. Reducing the search time is an important issue. Shortening is also an important issue. The methods 1) and 2) described in [Prior Art] have the following problems. Explanation will be given for each item.
1) It is necessary to input a database search input command in a predetermined fixed order in advance, and as shown in the example of FIG. Date and time of alarm occurrence b. If the search is performed in the order of the sense importance “MAJOR”, it is necessary to search the entire database twice as described above. Further, when the database once searched is reused, it is necessary to save it in the client terminal. Since the total number of data in the original database is from 300,000 to 500,000, it is necessary to hold an enormous amount of data, which puts pressure on the memory of the client terminal or decreases the performance of the machine. In addition, there are physical limitations.
In the method of searching from a search key having a small number of appearances of the key described in 2) described in 2), the effect of reducing the search time cannot be obtained unless the number of searches is repeated to some extent.
[0011]
[Means for Solving the Problems]
The present invention that achieves the above object is as follows.
The database is provided with a database processing table for holding data for designating search items of the database search and their execution order, and a temporary buffer for temporarily storing data extracted from the database. A plurality of search items, which are search conditions, are input from the client terminal, the DB processing table is referred to for the search items, and the search items specified in the database processing table in the descending order of the priority of the execution order of the search items Then, data of the search item is extracted from the database. The extracted data displays the extraction result on the client terminal.
[0012]
Further, the extracted data is stored in a temporary buffer of a database, editing conditions are input from the client terminal, and the data stored in the temporary buffer is edited according to the editing conditions and displayed on the client terminal.
[0013]
BEST MODE FOR CARRYING OUT THE INVENTION
FIG. 1 is a configuration diagram of an alarm event monitoring / control / management system according to an embodiment of the present invention. This is basically the same as the conventional system configuration diagram of FIG. 5, and the same parts are denoted by the same reference numerals. The database 20 is provided with a temporary buffer 22 for storing data retrieved and extracted from the alarm database 21 and a priority processing matrix table 23 for designating the execution order of the retrieval items of the database retrieval.
[0014]
FIG. 2 is a priority processing matrix table according to an embodiment of the present invention. In the matrix table, search processing items are shown in the row direction, and the search processing priority is shown in the column direction. An example is shown below.
1) Items expressed in the row direction Indicates the date and time of occurrence of the alarm event, and is displayed in ascending or descending order according to the specification.
B. Indicates the name of the device that constitutes the device type control / monitoring system that caused the alarm event that occurred.
C. The unit type of the cause device of the generated alarm event represents each unit number constituting the alarm event cause device.
D. The alarm type of the alarm event that occurred is the alarm type, such as the failure of the power supply unit, the failure of the device such as a clock system failure, the location of the warning such as the abnormal connection of the abnormality with other devices, and the type of warning. Indicates if there is.
E. Sensing importance of alarm type Indicates the importance of alarm events to be detected by the system administrator, such as "CLEARED" indicating that the countermeasures have been taken from "MAJOR" which is detected as the most important obstacle by the countermeasures.
F. Displayed number Indicates the number of alarm events to be displayed.
2) Represents the order of priority from the first column of items in the column direction.
[0015]
In the case of FIG. 2, examples of the device type, the alarm type, the sensing importance, the unit type, the date and time of occurrence, and the number of displayed items are shown in descending order of priority.
FIG. 3 shows a search processing procedure according to an embodiment of the present invention (claim 1). The flow of the search processing when it is desired to display the five alarms with the sensing importance of “MAJOR” in the order of the date and time of occurrence described above in the conventional example is shown below. As the priorities of the search processing shown in FIG. 2, the processing items and priorities determined in the management of the system are registered in advance.
The portion that overlaps with the input procedure described in the conventional example also shows the procedure of the search processing.
(1) Access the alarm database (search target table A1) of the database from the client terminal.
(2) From the client terminal, commands of the following search conditions are input to the database via a UI (User Interface) in a predetermined order.
I. Enter the period for which the occurrence date / time command is to be executed. FIG. 3 is directed to an alarm event that occurred between December 16 and December 31, 2002.
B. In FIG. 3, the input is a blank of "blank", assuming that the command type of the device type does not matter.
C. In FIG. 3, the input is a "blank" blank, assuming that the command importance of the command does not matter.
D. The device alarm is targeted as the command alarm type of the alarm type.
(3) Based on the search processing matrix table shown in FIG. 2 and the input conditions of 1), three black-out items (second priority / item 5 (sensing importance) and priority 5) in the matrix table D1 shown in FIG. Rank / item 1 (date and time of occurrence), 6th priority / item 6 (number of displayed items)). Among the three items, the priority of the first priority is first sorted as the condition of S2.
(5) C1 is the result of sorting all records B1 by date as the next priority as the condition of S3.
(6) The extraction process is performed according to the condition for displaying five items in S4.
(7) The results of the sorting in S4 are displayed on the client terminal via the UI in the order of older occurrence date and time, with five alarm events of the sensing importance "MAJOR" on the client terminal.
[0016]
In step (7), if this data is to be reused separately, it is stored in a temporary buffer for storage. B1 and C1, which are the results of sorting in (5) and (6), are updated each time sorting is performed, and are deleted after a series of search processing is completed.
Next, a method for reusing the once searched database C1 will be described. FIG. 4 shows a search processing procedure according to an embodiment of the present invention (claim 2).
(8) Although not described in detail, B2, which is reuse data, is accessed based on the input search condition and the search parameter in S11. B2 is obtained by searching once stored in the temporary buffer 22 shown in FIG. 1 and narrowing down the original data of A2.
[0017]
(9) Edit the contents of B2 under the condition of S12 to sort in the specified column order. C2 is the result, showing an example in which the date and time of occurrence, the degree of importance of sensing, the unit number, the type of alarm, and the type of device are displayed in this order, and displayed on the client terminal via the UI.
【The invention's effect】
According to the present invention, in a database search in which a command input order of search conditions is specified, a search is performed based on the order of search items specified in a priority processing table, thereby reducing the amount of processing until the end of the search and shortening the processing time. Can be provided.
[Brief description of the drawings]
FIG. 1 is a configuration diagram of an alarm event monitoring / control / management system according to an embodiment of the present invention; FIG. 2 is a priority processing matrix table according to an embodiment of the present invention; Search processing procedure according to an embodiment [FIG. 4] Search processing procedure according to an embodiment of the present invention (claim 2) [FIG. 5] Conventional alarm event monitoring / control / management system configuration diagram [FIG. 6] Conventional database search procedure

Claims (2)

A database processing table that holds data specifying the search items of the database search and their execution order;
A data retrieval method for a database having a temporary buffer for temporarily storing data extracted from the database in the database,
A plurality of search items as search conditions are input from the client terminal, the database processing table is referred to for the search items, and the execution order of the search items specified in advance in the database processing table is in descending order of priority. And extracting data of a search item from a database and displaying a result of the data extraction on a client terminal. The database search method according to claim 1,
A database search method, wherein the extracted data is stored in a temporary buffer of a database, editing conditions are input from a client terminal, and the data stored in the temporary buffer is edited according to the editing conditions.

Images