JPH04178847A - Data base management mechanism - Google Patents

Abstract

PURPOSE:To improve the responsiveness of the whole system for utilizing a data base by providing this data base management mechanism with a control part for executing exclusive control in each record or item in a file or table in the data base. CONSTITUTION:The data base management mechanism is provided with a control part 1, a data base record skimmer definition part 2 and a data base file 3. At the time of newly registering a record, the control part 1 automatically forms an exclusive control information area corresponding to each record or each item in a record. The exclusive control information is written and referred in/from the exclusive control information and the reception of a data updating request from another application program is controlled based upon the exclusive control information. Consequently, exclusive control can be executed in each record or in each item and the responsiveness of the whole system utilizing the data base can be improved.

Description

DETAILED DESCRIPTION OF THE INVENTION [Object of the Invention] (Field of Industrial Application) The present invention relates to a database management mechanism that manages a database.

(Prior Art) Generally, a database management mechanism has an exclusive control function to guarantee data consistency when data updates occur simultaneously.

In such an exclusive control function, the target of exclusive control has traditionally been a file unit or a table unit. In other words, the entire file or table is subject to exclusive control. For example, if an application program declares exclusive use for updating data in a database, the processing of that application program Until the process is completed, other application programs can refer to the file or table, but updates are prohibited and must wait.

(Problem to be solved by the invention) However, in most cases, the data handled by an application program is not the records of the entire file or table, but a part of it, such as a certain item, or a certain condition. Often limited to satisfying records or specific items within them.

Therefore, in conventional database management systems, the performance of the entire system that utilizes the database tends to deteriorate in terms of responsiveness.

The present invention has been made in response to such conventional circumstances, and can implement exclusive control on a record-by-record basis or item-by-item basis of files or tables within a database, and is capable of controlling the entire system that utilizes a database compared to the past. The present invention aims to provide a database management mechanism that can improve responsiveness.

[Structure of the Invention] (Means for Solving the Problem) That is, the present invention registers a new record of a file in a database based on the schema definition part of the record, and also registers a data update request from another application program. In the database management mechanism, the control unit is configured to automatically generate a corresponding exclusive control information area for each record or each item in the record when the record is newly registered. Then, writing and referencing information for exclusive control in the area of exclusive control information for each record or each item, and based on this information for exclusive control, data from the application program of the above type is written. It is characterized by controlling reception of update requests.

(Function) In the database management mechanism of the present invention having the above configuration, when a new record is registered, the control unit automatically generates a corresponding exclusive control information area for each record or each item within a record. Then, exclusive control information is written and referenced in this exclusive control information area, and acceptance of data update requests from other application programs is controlled based on this exclusive control information.

Therefore, exclusive control can be performed on a record-by-record or item-by-item basis, and the responsiveness of the entire system that utilizes a database can be improved compared to the past.

(Embodiment) Hereinafter, a database management mechanism according to an embodiment of the present invention will be described with reference to the drawings. Note that exclusive control can be performed on a record-by-record basis or on an item-by-item basis. In this embodiment, a case will be described in which exclusive control is performed on an item-by-item basis.

FIG. 1 shows the overall configuration of an embodiment of the present invention. In the figure, ] is the control unit of the database management mechanism,
2 is a schema definition part of a database record, and 3 is a database file.

The schema definition section 2 of the above record defines the structure of the record in the file 3, and the item definition section (item 1 definition section, item n
definition part). In this item definition section, information regarding the data type (one character string of integers, etc.), size, etc. of each item is defined.

Also, file 3 contains records (record 1,...
..., record m). Figure 2 shows the internal structure of a record (record j) in file 3, where record j is an item of record j (item 1 of record j, ..., item n of record j). and exclusive control information of the item of record J (exclusive control information of item 1 of record J, . . . , exclusive control information of item n of record j).

Then, the control unit 1 registers a new record in the file 3 based on the schema definition unit 2 of the record, and
It is configured to control reception of data update requests for the file 3 from other application programs.

In the database management mechanism with the above configuration, when registering a new record, the control unit 1 reads the schema definition part 2 of the record, decodes the contents, and registers a new record, for example, record J, in the file 3. .

At this time, the control unit 1 first selects the schema definition unit 2 of the record.
Item 1 of ``Record in File 3'' is generated from the definition section of Item 1 of .

Next, the control unit 1 generates item 2 of record J in file 3 from the definition section of item 2 of schema definition section 2 of the record.

In this way, the control unit generates item n of record j in file 3 from the definition section of item n of schema definition section 2 of the record.

After all items of record j have been generated, the control unit then generates exclusive control information for item 1 of record j in file 3 from the definition section of item 1 of schema definition section 2 of the record.

Next, the control unit 1 generates exclusive control information of item 2 of record j in file 3 from the definition part of item 2 of schema definition part 2 of the record, and sequentially generates exclusive control information of item n of record J. generate.

Second, the generation process of the control unit 1 from the exclusive control information of item 1 of record j to the exclusive control information of item n of record j is hidden from database users and application programs.

Next, the operation in the case of declaration of occupancy at the start of data update will be explained.

Occupancy declaration when updating data from an application program is given as a condition that the value of a certain item (multiple times) must satisfy (for example, the value of item 1 is between 55 and 99 and the value of item 2 is less than 1000, etc.) .

When receiving a declaration of occupancy at the start of data update from an application program, the control unit 1 immediately puts the entire corresponding file 3 in an exclusive state and suspends the declaration of occupancy at the start of data update from another application program. .

Next, the control unit 1 searches for all records that satisfy the conditions specified by the application program for the item.

If the corresponding item (for example, the item in record 2) matches item 2, the exclusive control information (for example, the process ID or user id, etc.), and makes it exclusive and exclusive, and releases the exclusive status of the entire file 3.

Therefore, in this case, only item 1 and item 2 of record 2 are occupied.

Please note that some items may already be connected to other applications.
When a program is occupied, the application program can specify whether to cancel, continue to run, or wait for a certain period of time.

In this way, the database management mechanism of this embodiment can process simultaneous updates to different items for the same record in the same file, and simultaneous updates to the same item for different records in the same file, making it possible to utilize the database. The performance of the entire system is improved.

[Effects of the Invention] As explained above, according to the database management mechanism of the present invention, exclusive control can be carried out on a record-by-record basis or on an item-by-item basis of files or tables in a database, making it possible to utilize the database more effectively than in the past. This can improve the responsiveness of the entire system.

[Brief explanation of drawings]

FIG. 1 is a diagram showing the configuration of a database management mechanism according to an embodiment of the present invention, and FIG. 2 is a diagram showing the configuration of records shown in diagram M1. 1...Control section 2...Record schema definition section 3...
・・・・・・File applicant Toshiba Corporation Representative Patent attorney Satoshi Suyama - Figure 1 Figure 2

Claims (1)

[Claims] (1) In a database management mechanism that includes a control unit that registers new records of files in the database based on the schema definition unit of the record, and controls the reception of data update requests from other application programs, When the record is newly registered, the control unit automatically generates a corresponding exclusive control information area for each record or each item in the record, and creates a corresponding exclusive control information area for each record or each item. A database management mechanism, characterized in that information for exclusive control is written and referenced in a database management mechanism, and based on this information for exclusive control, reception of data update requests from the other application programs is controlled.