JP2010079692A - Database management system and record update method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To perform exclusive control of only a record to be updated without imposing any loads to operator's operation when updating records by the operation of a record information display section. <P>SOLUTION: A record to be updated is selected from a record information display section where record search results is displayed (201). By searching the selected record to be updated again (205), it can be checked whether the re-searched record agrees with a previously searched record (206). When the re-searched record agrees with the previously searched record (Y), only the selected record to be updated is subjected to exclusive control (207), an update button is pressed at the record information display section (208), and the exclusive control of the record to be updated is canceled (210) after the completion of the update processing (209). <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to a database management technique, and more particularly, to a database management system that operates a record information display unit to update a record of a database by operating a record information display unit.

  With the development of the information society, database management methods using DBMS have become widespread. However, it is difficult for an operator who is not familiar with the SQL language to directly operate the DBMS, in which case access via a GUI (Graphical User Interface) is indispensable.

  Recently, a database maintenance system by operating a record information display unit that accesses a database by operating a record information display unit such as a web browser and searches, updates, adds, and deletes records is becoming widespread.

  FIG. 1 is a functional block diagram showing an overview of a database maintenance system by operation of a record information display unit. The database maintenance system A has, for example, a client terminal 100, an application server 102 connected thereto via a network (NT or LAN), and a database 104 managed by the application server 102 and storing various information. is doing. The client terminal 100 includes a record information display unit 101a that inputs search conditions and record update information and displays the result, and a control unit 101b that includes this function and controls the entire client terminal. The application server 102 includes a database access control unit 102a. The database access control unit 102a converts the operation instruction content from the record information display unit 101a into an SQL sentence, sends it to the database 104, receives the result, and creates screen information.

  In order to update a record in such a database maintenance system by operating the record information display unit 101a, it is necessary to first search for the record and display it on the record information display unit 101a. For this purpose, the record access condition input by the operator from the record information display unit 101 a is received by the database access control unit 102 a, converted into SQL, and transmitted to the database 104. On the other hand, the database 104 returns the search result to the database access control unit 102a, and the database access control unit 102a processes the received search result into screen information and returns it to the record information display unit 101a.

  In order to update the record following the record search, the record update information is selected from the record information display unit 101a on which the record search result is displayed, and the record update information is input. Thereafter, the record update can be performed on the database 104 via the database access control unit 102a.

  The following patent document 1 is mentioned as a well-known technical document relevant to this invention.

JP 2002-215443 A

  By the way, by operating the record information display unit 101a, there can be a plurality of operators that access the database 104. Therefore, there is a possibility that an update operation is performed on the same record during the same time period.

  For this reason, for example, another operator B completes the update process of the record after the operator A displays the record search result on the record information display unit 101a until the record is changed. It often happens. In this case, there is a problem that one operator A overwrites and changes the record without knowing that the other operator B has changed the record and without checking the latest record information. Yes.

  By performing exclusive control on all records that match the search conditions at the stage of the record search process performed before the record update, the update process of other operators can be prevented. However, if all records that meet the search conditions are exclusively controlled at the record search stage, even if the records are not actually updated, the records are exclusively controlled because they match the search conditions. In spite of the fact that the control is unnecessary, there arises a disadvantage that other operators cannot perform the record update process.

  In Patent Document 1, the key information and exclusion date and time of the exclusion target record are registered in the exclusion control monitoring table, and the exclusion range is minimized by checking the table when updating the record. In this case, it is necessary to register the update target record in the exclusive control monitoring table in advance when updating the record, and it is burdensome for the operator to consciously perform these operations from the record information display unit 101a.

  An object of the present invention is to exclusively control only a record to be updated without imposing an operation burden on an operator when a record is updated by operating a record information display unit.

  According to one aspect of the present invention, the record information display is connected to a client terminal including a database that stores various types of information and a record information display unit that inputs search conditions and record update information and displays search results. A database management system having an application server including a database access control unit that converts operation instruction contents from the unit into an SQL statement, sends the result to the database, receives the result, and creates screen information And the said database access control part is the update object which rewritten the display content based on the said 1st record information from the 1st record information which searched the said database beforehand, and the search result displayed on the said record information display part The second record information retrieved from the database again matches the record. When the second record information that has been searched again matches the first record information that has been searched in advance, exclusive control of the update target record is started, and after the update process is completed, the update target There is provided a database management system characterized by performing control for releasing exclusive control of a record.

  As a result, when the record is updated by operating the record information display unit, it is possible to exclusively control only the record to be updated without placing an operational burden on the operator.

  In addition, a database for storing various information, a client terminal having a record information display unit for inputting search conditions and record update information and displaying a search result, and a network connection with the client terminal, from the record information display unit Record update by a database management system having an application server including a database access control unit that converts the operation instruction contents of the database into an SQL statement, sends it to the database, receives the result, and creates screen information In the method, the first record information searched in advance is displayed on the record information display unit, and the display content of the first record information is rewritten from the search result displayed on the record information display unit. The record is determined to be an update target record, and the update target record Step of confirming that the second record information re-searched from the database matches the first record information pre-searched; and the second record information re-searched and the first record information pre-searched And starting the exclusive control of the update target record when the two match, and after the update operation is performed in the record information display unit and the update process is completed, the exclusive control of the update target record is released. A record update method is provided.

  The present invention may be a program for causing a computer to execute the above method, or a computer-readable recording medium for recording the program.

  According to the database management method of the present invention, when performing record update by operating the record information display unit, there is an advantage that only the record to be updated can be exclusively controlled without placing an operational burden on the operator. .

  Hereinafter, a database management technique according to an embodiment of the present invention will be described with reference to the drawings.

  FIG. 1 is a diagram showing a configuration example of a database management system according to an embodiment of the present invention as described above. The database management system A by operation of the record information display unit according to the present embodiment includes a database 104 for storing various information, and a record information display unit 101a for inputting search conditions and record update information and displaying the results. The client terminal (controlled by the control unit 101b) 100 and the client terminal 100 are connected to the network, and the operation instruction content from the record information display unit 101a is converted into an SQL sentence and sent to the database 104 and the result is received. And an application server 102 including a database access control unit 102a that creates screen information.

  FIG. 2 is a flowchart when the database access control unit 102a performs a process from record search to record update on the database 104.

  When the process of record search and record update is started, when the operator detects a pressing operation of the search button specifying the search condition from the record information display unit 101a (step 201), the database access control unit 102a Is pre-searched (step 202), screen information is created from the pre-search result, sent to the record information display unit 101a, and displayed (step 203).

  Next, referring to the search result displayed on the record information display unit 101a, when an operation of rewriting the display content of the record by the operator is detected (step 204), the database access control unit 102a determines that the record is an update target record. Only the relevant record is re-searched from the database 104 (step 205), and it is determined whether or not the record information pre-searched in step 202 matches the re-searched record information (step 206).

  If the pre-searched record and the re-searched record do not match (N), the record to be updated is re-searched from the database 104 and the latest record information is displayed on the record information display unit 101a (step 211). ), The process returns to step S204.

  Thus, for example, when another operator B has updated the record between the time when the operator A performs the search process and the time when the record change process is performed, the operator A overwrites the record. It is no longer updated, and the latest record information updated by the operator B can be confirmed immediately.

  If the pre-searched record matches the re-searched record (Y in Step 206), only the update target record is exclusively controlled (Step 207). Thereby, for example, other operators can update records other than the update target record selected by the operator A.

  Thereafter, when it is detected that the update button is pressed (Y in Step 208), the database access control unit 102a updates the update target record with the display content rewritten in the record information display unit 101a (Step 209). The exclusive control of the target record is released (step 210). Thereby, the process from the record search to the record update is completed.

  FIG. 3 is a screen configuration diagram showing a display example of the record information display unit 101a. As shown in FIG. 3, the record information display unit 101a displays a record that matches the search condition, receives a record update information input, a search result display unit 301, and an update button 303 that instructs execution of the update process. Is composed of.

  When the display content of the search result display unit 301 is changed by screen input, the record is determined to be an update target record, and the processing after step 204 in FIG. 2 is performed. For example, when the display content indicated by reference numeral 302 is changed from “0778-12-3456” to “0000-00-0000”, it is determined that the record specified by the name number = 00002 is the update target record. Therefore, the operator can consciously exclude the selection of the record identified by the name number = 010002 as the update target record, and can exclude the selection from the record information display unit 101a as the update target record. .

  As described above, when the record is updated by operating the record information display unit 101a according to the present embodiment, it is possible to exclusively control only the record to be updated without placing an operational burden on the operator. There is.

  The present invention can be used for database management.

1 is a system configuration diagram showing an example of a database management system by operation of a record information display unit, and is a diagram showing an example of a configuration of a database management system by operation of a record information display unit to which an embodiment of the present invention is applied. . It is a flowchart figure which shows the process of record update from the record search by operation of the record information display part by this Embodiment. It is a screen block diagram which shows an example of the record information display part which displays the record which matched search conditions, and receives the input of record update information.

Explanation of symbols

A ... database management system, 100 ... client terminal, 100 ... client terminal, 101a ... record information display unit, 101b ... control unit, 102 ... application server, 102a ... database access control unit, 104 ... database.

Claims (2)

It is connected to a client terminal equipped with a database that stores various types of information and a record information display unit that displays search results and record update information and displays search results. A database access control unit that includes a database access control unit that converts the data into the database and receives the result and creates screen information, and a database management system,
The database access control unit
The first record information obtained by searching the database in advance, and a second search result obtained by re-searching the database from the search result displayed on the record information display unit, wherein the update target record is rewritten based on the first record information. Confirm that the record information matches the
When the second record information that has been searched again matches the first record information that has been searched in advance, exclusive control of the update target record is started,
A database management system which performs control to release exclusive control of the update target record after update processing is completed. A database for storing various information, a client terminal having a record information display unit for inputting search conditions and record update information and displaying the search results, and a network connection with the client terminal, and operations from the record information display unit A database access control unit that converts an instruction content into an SQL sentence, sends the result to the database, receives the result, and creates screen information; There,
Displaying the pre-searched first record information on the record information display unit;
When the display content of the first record information is rewritten from the search result displayed on the record information display unit, the second record is determined as the update target record, and the update target record is re-searched from the database. Confirming that the record information matches the previously searched first record information;
When the re-searched second record information matches the pre-searched first record information, exclusive control of the update target record is started, an update operation is performed in the record information display unit, and update processing is performed. And a step of releasing exclusive control of the update target record after completion.

Images