JPH09282210A - Method and system for monitoring data base - Google Patents

Abstract

PROBLEM TO BE SOLVED: To detect the change of data without applying any load to a data base by monitoring the change of data while referring to the history of access to the data base. SOLUTION: When a data monitor request is received from a client computer system 202, a monitor request interpretetion part 22 of a server computer system 101 prepares data monitor rules and report rules. When the update of data is requested from a data base access request part 13 of the client computer system 202 to a data base 16, while receiving the request, a data base control part 18 updates the data base and acquires the access history such as access time, updated table name, update conditions and update contents. On the other hand, an event detection part 17 executed through a process different from the data base 16 periodically refers to the access history and when the change of monitor data is detected, while referring to a report rule file, the change of data is reported to the client computer system 202 according to the designated rules.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a system composed of a plurality of clients accessing a database at the same time, and more particularly to a database monitoring for notifying a specific user when a specific change is made to specific data in the database. A method and its system.

[0002]

2. Description of the Related Art In the case where a plurality of users update data in a database, it is sometimes desired to monitor specific data and notify when specific changes are made. For example, there is a table that manages the inventory quantity of products, and the inventory quantity is reduced every time a plurality of sales staff sell the product. However, when inventory reaches a certain quantity,
The ordering person must place an order at the factory.

In such a case, as a first conventional technique,
According to the "Oracle Mobile Agents Application Development Guide" by ORACLE, there is a method of creating an SQL for data monitoring, executing the SQL at regular intervals, and notifying by email when a condition is hit. In this method, in order to detect the change of data, it is necessary to search the database at regular intervals, and if it is attempted to detect the change of data earlier, the SQL execution interval can be narrowed. , The number of times the database is searched increases, and the database is overloaded.

As a second conventional technique, when the database body has a trigger function like ORACLE,
Update (INSERT, UPDATE, DELETE) to the monitored table
There is a way to detect data changes by executing the associated stored procedure when the instruction is issued. In this method, the stored procedure is executed every time the table being monitored is updated, and the update process becomes heavy.

[0005]

In the first prior art described above, in order to detect a change in data, it is necessary to search the database at regular intervals, and it is possible to detect that the data has been changed more quickly. If it is attempted to detect it, the SQL execution interval will be narrowed, and if this happens, the number of times the database is searched increases and there is the problem that the database is loaded.

The second conventional technique has a problem that the stored procedure is executed every time the table being monitored is updated, and the update process becomes heavy.

It is an object of the present invention to provide a database monitoring method and system for detecting a change in monitored data without imposing a load on the database.

[0008]

In order to achieve the above object, in the database monitoring system of the present invention, when data monitoring is requested in the first client computer system, a data monitoring rule is set in the server computer system. Create notification rules and save each in a data monitoring rule file and a notification rule file. On the other hand, when the second client computer system requests an update to the database of the server computer, the server computer system updates the database and saves the update request in the access history file.
On the other hand, in the server computer system, when a data change is detected by periodically referring to the data monitoring rule file and the access history file in a process different from this,
Refer to the notification rule file and use the specified rule
Notifies the client computer system of the change of data.

Further, in order to achieve the above object, in the database monitoring system of the present invention, when the change of the second database affecting the first database occurs, the second server computer system executes the first database change. When the first server computer system receives the data change notification from the second server computer system, the first server computer system refers to the data monitoring rule file and the change of the monitoring data is detected. Then, it refers to the notification rule file and notifies the client computer system of the data change according to the specified rule.

Further, in order to achieve the above object, in the database monitoring system of the present invention, the database server computer, the database centralized monitoring server computer and the result distribution server computer are divided into different processors.

[0011]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described below in detail with reference to the drawings.

First Embodiment FIG. 1, FIG. 6, FIG. 9, FIG.
0, FIG. 11, FIG. 12, FIG. 16, FIG. 17, and FIG.

In FIG. 1, 101 is a server computer system, 201, 202 and 203 are client computer systems, respectively, which are the communication control unit 1.
1 connected to the network. The database 16 in the server computer system 101 is realized by a relational database, a structural database, an object-oriented database, or the like. The processing will be described below with reference to FIG.

First client computer system 201
9, the data monitoring request screen shown in FIG. 9 is used, and, for example, the stock quantity of the stock table showing the stock status of the product is 1
If less than 00, T. Request SUZUKI to monitor the data such as notifying the product code of the product (process 601). The monitoring request interpretation unit 22 of the server computer system 101 receives the data monitoring request (process 60).
2), the agent ID for identifying the request is output together with the confirmation message for accepting the data monitoring shown in FIG. 10 (process 603). In addition, based on the contents received,
5, an agent ID, a table name and a column name to be monitored, a monitoring condition, a data monitoring rule 151 including a monitoring instructor, and an agent ID, a mail notification destination, notification data, and the like shown in FIG. The notification rule 161 is created (processes 604, 605).

On the other hand, using the database access request screen shown in FIG. 11 from the database access request unit 13 of the second client computer system 202 to the database 16, the product code of the inventory table is S001.
If an update requesting that the stock quantity of the client computer be set to 70 is made (process 606), in the server computer system 101, the database computer 18 causes the client computer system
In response to the request from 2, the database is updated (process 60
8) Further, the access history 171 including the access time, the update table name, the update condition, and the update content shown in FIG. 17 is acquired (process 609).

On the other hand, the event detection unit 17 of the server computer system 101, which is executed in a process different from the database 16, periodically refers to the data monitoring rule shown in FIG. 15 and the access history shown in FIG. Monitor the data.

In the case of this embodiment, when the access history 171 hits the data monitoring rule 151 and it is detected that the inventory quantity of the monitoring data is less than 100 (steps 610 and 611), the hit data monitoring rule is detected. 151
16 is searched for the notification rule shown in FIG. 16, and the change notification is sent by e-mail according to the notification rule 161.
It is sent to T.SUZUKI (process 612). In the change notification acquisition unit 14 of the third client computer system 203 used by T.SUZUKI, the change notification mail shown in FIG. 12 can be acquired (process 613), and it can be confirmed that the inventory quantity is less than 100.

In the present embodiment, when monitoring a database change, it is possible to detect a data change by directly referring to the database and referring to the access history of the database in a process different from the database. , It is possible to notify the change of monitoring data without overloading the database. Further, by narrowing the reference interval of the access history file, the monitoring data can be notified more quickly, and in this case also, the database is not overloaded.

Next, a second embodiment will be described with reference to FIGS. 4, 7, and 18.
This will be described with reference to FIG. A second server computer system 401 having a database 42 different from the server computer system 101 is connected to the communication control unit 11 via a network. For example, when the database 16 is used as a data warehouse, the database 16 is a replica of the database 42, and when the database 42 is updated (process 701), the database 16 is also updated by the data interlocking unit 41. It is not updated from the computer system. At this time, in the server computer system 101, in the event detection unit 17 executing in a process different from the database 16, the database shown in FIG. 18 including the update table name, update condition, update content, etc. from the data interlocking unit 41. The update notification 181 is received (process 702, process 703) and it is verified whether the data monitoring rule is hit (process 704).

When it is detected that the stock quantity, which is the monitoring data, falls below 100, the change notification section 21 transmits a change notification according to the notification rule as in the first embodiment (process 705). In the present embodiment, when monitoring a change in the data of the first database that is linked with another second database, the second database updates the first database without directly referring to the first database. Since the notification of the change is received and the change of the monitor data is checked at that time, the change of the monitor data can be detected more quickly without imposing a load on the database.

Further, a third embodiment will be described with reference to FIGS. 5, 8, 13, 14, 15, 16, and 17.

FIG. 5 shows the first server computer system 10.
This shows that a third server computer system 501, which is different from the first and second server computer systems 401, and client computer systems 201, 202, and 204 are connected by a communication control unit 11 via a network.

For example, the second server computer system is
It is installed in a bookstore of a bookstore and has a book database 42 to be sold in the bookstore. The first server computer system 101 is installed in a branch, and is connected by an in-house private line during this period. The first server computer system 101 has a book database 16 composed of information linked to the book database of the head office and book information sold only at the branch office. Further, the third server computer system 501 and the client computer system 204 are connected to each other via the Internet, and the third server computer system 501 becomes a WWW server open to the public for customers and stores the new news 53, and the client The computer system 204 may have a WWW browser 54 that acquires the newly published news.

This case will be described with reference to the flow chart of FIG. First client computer system 20
In the data monitoring request unit 12 of No. 1, when the book information is added to the database 16 of the branch using the data monitoring request screen shown in FIG. 13, for example, the book name and amount from the book table, and the book from the book catalog. Request the data monitoring of the contents such as extracting the outline and the product photograph to create a new news and storing it in the WWW server (Process 8).
01). The monitoring request interpreting unit 22 of the first server computer system 101 receives the data monitoring request (process 80).
2) A confirmation message that the data monitoring is accepted is output (process 803). Further, based on the received contents, the agent ID (agent 002) shown in FIG. 15, the table name to be monitored (book table) and the monitoring condition (new addition),
Data monitoring rule 15 consisting of monitoring instructor (N.TANAKA)
2 and the agent ID (agent 002) shown in FIG.
Storage destination (WWW server 100) Notification data (product name and price of book table, book outline and product photo of book catalog) Document format name (newly published news.html) Notification rule 162 is created (process 804, process 8).
05), and also saves the HTML document, which is the document format, in the document format file 52 (process 80).
6).

On the other hand, when a new publication is registered in the book database 42 of the second server computer system 401 in the head office, it is also registered in the book database 16 of the first server computer system 101 in the branch. At this time,
Event detection unit 1 of the first server computer system 101
In FIG. 7, the second server computer system 401 shown in FIG.
Receives a new addition change notification 182 from (step 808),
It is verified whether the data monitoring rule 19 is hit (process 8).
09). When the data monitoring rule 19 is hit, the extracted data creating unit 51 hits the data monitoring rule 15
Search the notification rule 20 from the agent ID of 2,
The database 16 is searched according to the notification rule 162 (process 811), the book name and price are extracted from the book table, the book outline and the product photograph are extracted from the book catalog, converted into the specified document format (process 812), and specified. The converted extracted data file is stored in the storage destination WWW server 100 (third server computer system 501) (process 813).

On the other hand, in the fourth client computer system 204, the WWW browser 54 is used to connect to the WWW server 100 which is the third server computer system 501 (process 814), and the new news as shown in FIG. Is acquired (process 815). Further, the database access request unit 13 of the client computer system 202 may also request a new addition of a book. Also in this case, similarly to the above, the data change is detected, and the newly published news is stored in a predetermined format. In the present embodiment, when a certain user makes a certain change to the monitoring data by updating another user or another linked database, the data is acquired in a specific format and stored in a specific location. By requesting this, it is possible to monitor the data without imposing a load on the database for the data update due to the update of another user or another linked database.

Further, when a change in the monitoring data is detected, the necessary data is automatically extracted, converted into a specific format, and stored in a specific location.
The user can automatically send the information only by first requesting.

Further, a fourth embodiment will be described with reference to FIG. In FIG. 20, reference numerals 102 and 105 denote database server computer systems, and 103 denotes a central database monitoring server computer system.
Reference numeral 4 denotes a result distribution server computer system, 201,
Reference numerals 202, 203 and 204 denote client computer systems, respectively, which are connected to the network by the communication control unit 11.

Database server computer system 105
The internal database 16 and the database 23 of the database server computer system 102 are realized by a relational database, a structural database, an object-oriented database, or the like. In the client computer system 201, the monitoring request interpretation unit 22 of the database centralized monitoring server computer system 103 receives the data monitoring request, and creates the data monitoring rule 19 and the notification rule 20 based on the received contents.

On the other hand, when the database access request unit 13 of the client computer system 202 requests the database 16 to update using the database access request unit 13, in the database server computer system 105, the database control unit 18 causes Upon receiving a request from the client computer system 202, the database is updated and the access history is acquired in the database access history 15 of the database centralized monitoring server computer system 103. Database access history 15
Is implemented as a file or database. Also,
Similarly, the database 2 of the database server computer system 102 in the client computer system 204
The history of updating to 3 is also acquired in the database access history 15.

On the other hand, the event detection unit 17 of the database centralized monitoring server computer system 103 periodically refers to the data monitoring rule 19 and the database access history 15 to monitor the data. When a change in the monitoring data is detected, the change notification unit 21 of the result distribution server computer system 104 is notified of the change in accordance with the notification rule 20. Change notification acquisition unit 14 of client computer system 203
Then, you can get the change notification mail from the change notification section 21,
You can confirm the change of monitoring data.

In the present embodiment, when monitoring changes in a plurality of databases, a processor other than the databases collects access histories of the databases in a centralized manner,
Since it is possible to detect the change of data by referencing,
Effective load balancing is possible, and the change of monitoring data can be notified without imposing a load on the database. Also,
By narrowing the access history file reference interval, the monitoring data can be notified more quickly, and in this case also the database is not overloaded.

Further, in the first, second, third and fourth embodiments, when the database access history 15 is stored in the database, if the event detecting section 17 is installed as a trigger function of this database, the database access history 15 can be accessed. The event can be detected at the timing when the history 15 is updated, and the event can be detected at a more accurate timing.

[0034]

According to the present invention, when monitoring a change in data in a database, the database is not directly referenced,
Since a process different from the database is used to refer to the history of accessing the database and monitor the data change, it is possible to notify the change of the monitoring data without imposing a load on the database.

Further, by narrowing the reference interval of the access history file, the monitoring data can be notified more quickly, and in this case also, there is an effect that the database is not loaded.

Further, by obtaining the data access history in another database and detecting the event by the trigger of this database, there is an effect that the monitoring data can be notified at the timing when the database is updated.

Further, according to the present invention, when monitoring a change in the data of the first database that is linked with another second database, the second database is not directly referenced but the second database is Since the notification for updating the first database is received and the change of the monitoring data is checked at that time, the first database is not loaded, and
There is an effect that a change in the monitoring data can be detected earlier.

Further, according to the present invention, when a certain user makes a certain change to the monitoring data by updating another user or another linked database, the data is acquired in a certain format. By requesting that the data be stored in a specific location, it is possible to monitor the data for other users and updates of other linked databases without overloading the database. There is an effect. Also, when a change in monitoring data is detected, the necessary data is automatically extracted, converted into a specific format, and stored in a specific location, so the user only needs to request it first. The effect is that information can be automatically transmitted.

Further, according to the present invention, when monitoring changes in a plurality of databases, a processor different from the databases intensively collects and refers to access histories of the databases to detect data changes. Therefore, it is possible to effectively distribute the load and to notify the change of the monitoring data without imposing a load on the database.

[Brief description of drawings]

FIG. 1 is a configuration diagram showing a basic system of the present invention.

FIG. 2 is a configuration diagram of hardware to which the present invention is applied.

FIG. 3 is a configuration diagram showing a first conventional system.

FIG. 4 is a configuration diagram showing a system of a second exemplary embodiment of the present invention.

FIG. 5 is a configuration diagram showing a system of a third exemplary embodiment of the present invention.

FIG. 6 is a flowchart showing a process of the present invention.

FIG. 7 is a flowchart showing a process of the second exemplary embodiment of the present invention.

FIG. 8 is a flow chart showing the processing of the third exemplary embodiment of the present invention.

FIG. 9 is a diagram showing a data monitoring request screen input example (1).

FIG. 10 is a diagram showing an example of a data monitoring request confirmation screen output.

FIG. 11 is a diagram showing an example of inputting a database access request screen.

FIG. 12 is a diagram showing an output example of a change notification acquisition screen.

FIG. 13 is a diagram showing a data monitoring request screen input example (2).

FIG. 14 is a diagram showing an example of an extracted data screen output.

FIG. 15 is a diagram illustrating an example of a data monitoring rule.

FIG. 16 is a diagram illustrating an example of a notification rule.

FIG. 17 is a diagram for explaining an example of a database access history.

FIG. 18 is a diagram illustrating an example of a database update notification.

FIG. 19 is a diagram showing a system configuration of a second conventional method.

FIG. 20 is a configuration diagram showing a system of a fourth exemplary embodiment of the present invention.

[Explanation of symbols]

 101 First Server Computer System 102 Database Server Computer System 103 Database Centralized Monitoring Server Computer System 104 Result Distribution Server Computer System 105 Database Server Computer System 401 Second Server Computer System 201 First Client Computer System 202 Second Client Computer System 203 Third client computer system 204 Fourth client computer system 11 Communication control unit 16 Database 23 Database 42 Database

─────────────────────────────────────────────────── ─── Continuation of the front page (51) Int.Cl. ⁶ Identification code Internal reference number FI Technical display location G06F 13/00 357 G06F 13/00 357Z

Claims (4)

[Claims] 1. A server client system in which a server computer system having a database and a plurality of client computer systems having a display and an input device are connected by a network, and a plurality of the client computer systems are provided in the server computer system. A means for communicating and a request from the client computer system to access the database, and at that time, means for storing the access history in an access history file, and interpreting a data monitoring request from the client computer system, Create a monitoring rule that monitors data changes and a notification rule when data change is detected, and save each in the data monitoring rule file and notification rule file, and periodically refer to the access history file and data monitoring rule file, Superintendent The server in the first client computer system has means for detecting a change in data in the target database and means for notifying a change in data by referring to the notification rule file after detecting the data change. A means for communicating with the computer system, a means for requesting data monitoring of a database of the server computer system, a means for communicating with the server computer system in the second client computer system, and the server computer system By having means for requesting access to the database included in the third client computer system and means for communicating with the server computer system and means for receiving a data change notification from the server computer system, Data monitoring in the first client computer system If you request in said server computer system, creates a data monitoring rules and notification rules, and stored respectively in the data monitoring rule file and notification rules file, while the second
In this client computer system, when an update is requested to the database, the server computer system updates the data and saves the update request in an access history file, while the server computer system periodically updates the data. When the change of the monitoring data is detected by referring to the monitoring rule file and the access history file, the notification rule file is referred to and the third client computer system is notified of the data change according to the specified rule. Database monitoring system to do. 2. The system according to claim 1, wherein the second server computer system is a system in which a server computer system having a second database different from the first server computer system is connected via a network. When a means for communicating with the first server computer system and the second database are changed, the data is reflected in the first database, and a data change notification is sent to the first database.
The first server computer system and means for receiving the data change notification from the second server computer system in the first server computer system, thereby affecting the first database. When a change of the second database occurs, the second server computer system notifies the first server computer of the data change, and the first server computer system notifies the second server computer of the change of data. When a data change notification from the system is received, the data monitoring rule file is referenced, and when a change in monitoring data is detected, the notification rule file is referenced and the client computer system changes the data according to the specified rule. Database monitoring system characterized by notifying. 3. A database centralized monitoring server computer system having a plurality of database server computer systems having a database, a plurality of client computer systems having a display and an input device, and a data access history file collected from the database server computer systems. And a result distribution server computer system having a function of distributing data monitoring results to a plurality of client computer systems, in a network system, wherein a plurality of the client computers are provided inside each of the database server computer systems. A means for communicating with the system and access to the database in response to a request from the client computer system, at which time access within the database central monitoring server computer system A means for storing an access history in a history file, means for communicating with the client computer system, the database server computer system, and the result distribution server computer system in the database centralized monitoring server computer system; and the client computer system. Means for interpreting data monitoring requests from the server, creating monitoring rules for monitoring data changes and notification rules when data changes are detected, and saving each in a data monitoring rule file and notification rule file, an access history file, and the data A means for periodically referring to the monitoring rule file to detect a change in the data in the database to be monitored, and after detecting the data change, referring to the notification rule file and changing the result to the distribution server computer system. With a means to notify In the distribution server computer system, means for communicating with the database central management server computer system and the client computer system, and data change to a plurality of designated client computer systems by notification from the database central monitoring server computer system And a database server computer system having means for communicating with the database centralized monitoring server computer system and means for communicating with the database centralized monitoring server computer system in the first client computer system. Having a means to request data monitoring of the database,
The second client computer system has means for communicating with the database server computer system and means for requesting access to the database of the database server computer system, and the result is provided in the third client computer system. By providing means for communicating with the distribution server computer system and means for receiving a data change notification from the result distribution server computer system, when the data monitoring is requested in the first client computer system, the database concentration In the monitoring server computer system, the data monitoring rule and the notification rule are created and stored in the data monitoring rule file and the notification rule file respectively, while the second
In this client computer system, when an update request is made to the database of the database server computer system, the database server computer system updates the data, and the update request is made to the access history file in the database centralized monitoring server computer system. On the other hand, the database centralized monitoring server computer system periodically refers to the data monitoring rule file and the access history file, and when a change in the monitoring data is detected, refers to the notification rule file, A database monitoring system characterized by notifying the result distribution server computer system according to a specified rule, while receiving a data change notice at a third client computer system. 4. When notifying a specific user that a specific change has been made to specific data in the database, the database is stored in a server computer system having the database in a process different from the database. It has a monitoring rule file that stores the monitoring rules to be monitored, a notification rule file that stores the notification rules that notify the detection results, and an access history file that saves the history of accessing the database. And the access history file, check whether there is any change in the data, and if a change is detected, notify the specific user according to the notification rule of the notification rule file. .