JPH03276238A - Record control system - Google Patents

Abstract

PURPOSE:To change the record constitution without interrupting the data base service to the users by converting the data records read in the retrieving and updating states into the record constitution of the latest generation. CONSTITUTION:A record defining means 3 performs the definition and the change of the record constitution to the record constitution information on a directory 1. At the same time, a data processing means 4 processes the requests for retrieval, addition and updating of the data records and also produces a data record of the constitution of he latest generation at addition. Then a data conversion means 5 converts the data records read in the retrieving and updating states into the record constitution of the latest constitution. A data reading means 6 reads the data records out of a data base 2, and a data writing means 7 writes the data records into the base 2. Thus the record constitution is changed without interrupting the data base service to the users.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a record management method in a database management system for an electronic computer.

[Conventional technology]

In a database system, a database is constructed by storing a large number of data records based on a predetermined record structure, but it may be necessary to change the record structure for various reasons.

In response to such changes in the record structure, conventional database management systems temporarily suspend the database service and simultaneously restructure the database, that is, convert all data records in the old generation record structure to the latest generation records. The process was to convert the configuration data records.

[Problem to be solved by the invention]

As mentioned above, in conventional database management systems, database services are interrupted and databases are reconfigured all at once, so the database is unavailable during that period, resulting in a significant drop in service to users. There were drawbacks. This problem is particularly important when the record structure is frequently changed to accommodate the expansion of the field of use of the database.

The present invention has been proposed in view of the above points, and its purpose is to provide a record management method that allows changes to the record structure without interrupting database services to users. be.

[Means to solve the problem]

To achieve the above object, the present invention provides a database management system that searches for, adds, and updates data records stored in a database according to record configuration information stored in a directory. A record definition means that performs definition and modification, a data processing means that processes requests for searching, adding, and updating data records, and creates data records with the latest generation record configuration when adding records; The system includes a data conversion means for converting data records into the latest generation record structure, a data reading means for reading data records from a database, and a data writing means for writing data records into the database.

[Effect]

In the record management system of the present invention, the record definition means defines and changes the record structure in the record structure information of the directory, and the data processing means processes requests for searching, adding, and updating data records, as well as adding Sometimes a data record is created with the latest generation record configuration, the data conversion means converts the data record read at the time of search and update to the latest generation record configuration, the data reading means reads the data record from the database, and the data writing means writes data records to the database.

C Example] Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of a database management system to which the record management method of the present invention is applied. 1st
In the figure, this embodiment includes a directory 1 that stores record configuration information, a database 2 that stores data records, and a record definition that defines and changes the record configuration in the record configuration information of directory 1 based on user instructions. means 3, a data processing means 4 that processes requests for searching, adding, and updating data records given by users, and creates data records with the latest generation record configuration when adding; and a database 2 when searching and updating. The data converting means 5 converts the data records read from the database into the latest generation record structure, the data reading means 6 reads the data records from the database 2, and the data writing means 7 writes the data records to the database 2. .

FIG. 2 shows the structure of the directory 1, which is composed of a plurality of record structure information 11.

FIG. 3 shows the structure of the record structure information 11, which is composed of a generation number 12 indicating a generation, and a record structure information section 13 containing the contents of the record structure information for that generation.

FIG. 4 shows the structure of the database 2, which is composed of a plurality of data records 21. As shown in FIG.

FIG. 5 shows the structure of the data record 21, which is composed of a generation number 22 indicating the generation and a data section 23 containing the contents of the data record.

FIG. 6 shows the configuration of the data conversion means 5,
A generation determination means 51 that determines the generation from the generation number 22 of the data record 21, and a plurality of generation data conversion means 52 that converts the data record 21 to the latest generation record configuration when the data record 21 has an old generation record configuration. It is configured. Note that the generation determining means 51 and the generation data converting means 52 perform determination and conversion according to the record configuration information 11 of the directory 1.

Hereinafter, the operation of the above embodiment will be explained for each case.

(1) Change of record configuration When the record configuration needs to be changed, the record definition means 3 is activated.

The record definition means 3 allows the user to delete and delete data items.
When an addition/change request is received, record configuration information 11 is read as a sample from directory l, a record configuration information section 13 is created according to the specified record configuration, and 1 is added to the latest value of generation number 12 at that time. As a result, new record configuration information 11 is created, it is added to directory 1, and the process ends.

(2) Search for data records When a user requests a search for data records, the data processing means 4 is activated.

The data processing means 4 determines the position of the designated data record on the database 2 by a well-known method, and activates the data reading means 6.

The data reading means 6 reads the data record 21 from the specified position on the database 2, passes the data record 21 to the data processing means 4, and ends the process.

The data processing means 4 activates the data conversion means 5 and passes the data record 21 to it.

The data converting means 5 determines the generation from the generation number 22 of the data record 21 by the generation determining means 51, and if it is the latest generation, returns the data record 21 as it is to the data processing means 4, ends the process, and processes the data. The means 4 outputs the two data records as they are to the user, and ends the process.

Further, when the generation of the read data record 21 is the old generation, the data conversion means 5 converts the data record 2 from the old generation record configuration to the latest generation record configuration by the corresponding generation data conversion means 52. , returns the converted data record 21 to the data processing means 4, and ends the process.

Then, the data processing means 4 converts the converted data record 2
1 is output to the user and the process ends.

(3) Addition of data records When a user requests the addition of data records, the data processing means 4 is activated.

The data processing means 4 creates a data record 21 to be added based on the record structure information 11 of the directory 1 and the record structure of the latest generation, determines the position on the database 2 where it should be written, and the data writing means 7
is started, the data record 21 is passed, and the process ends.

The data writing means 7 writes the given data record 2
1 is written to the specified position on database 2, and the process ends.

(4) Update of data record When a user requests update of a data record, the data processing means 4 is activated.

The data processing means 4 determines the position of the designated data record on the database 2 by a well-known method, and activates the data reading means 6.

- The data reading means 6 reads the data record 21 from the specified position on the database 2, passes the data record 21 to the data processing means 4, and ends the process.

Next, the data processing means 4 activates the data conversion means 5 and passes the data record 21 to it.

The data conversion means 5 uses the generation determination means 51 to determine the generation from the generation number 22 of the data record 21, and if it is the latest generation, returns the data record 21 as it is to the data processing means 4 and ends the process. Further, when the generation of the read data record 21 is the old generation, the data conversion means 5 converts the data record 21 from the old generation record configuration to the latest generation record configuration by the corresponding generation data conversion means 52, Data record 2 after conversion
1 is returned to the data processing means 4, and the process ends.

Next, the data processing means 4 updates the data record 21 as it is because it is the latest generation, or the data record 21 having the record configuration of the latest generation after conversion,
The position on the database 2 where the data record 21 has been read is specified, the data writing means 7 is activated, and the process is completed.

The data writing means 7 writes the data record 21 to the specified position in the database 2, and ends the process.

〔Effect of the invention〕

As explained above, in the record management method of the present invention, when searching for a data record, the latest generation record configuration is passed to the user, and when a new data record is added or updated, the latest generation record configuration is passed to the user. In some cases, the latest generation record structure is stored in the database, so
This has the advantage that the reconfiguration is performed during the normal use of the database and does not affect the database service. This is particularly effective when the record structure is frequently changed.

[Brief explanation of drawings]

Figure 1 is a configuration diagram showing an embodiment of a database management system to which the record management method of the present invention is applied; Figure 2 is a configuration diagram of a directory; Figure 3 is a configuration diagram of record configuration information; Figure 4 is a database Figure 5 is a diagram showing the configuration of the data record and the 6th rj! J
FIG. 2 is a configuration diagram of data conversion means. In the figure, 1... Directory 11... Record configuration information 12... Generation number 13... Record configuration information section 2... Database 21... Data record 22... Generation number 23...Data section 3...Record definition means 4...Data processing means 5...Data conversion means 51...Generation determination means 52...Generation Data conversion means 6...Data reading means 7...Data writing means

Claims (2)

[Claims] (1) Searching for data records stored in the database according to the record configuration information stored in the directory;
In a database management system that performs additions and updates, there is a record definition means that defines and changes the record structure in the record structure information of the directory, and a record definition means that processes requests for searching, adding, and updating data records. a data processing means for creating data records in a configuration; a data conversion means for converting data records read during searches and updates into the latest generation record structure; a data reading means for reading data records from a database; A record management method comprising: a data writing means for writing data. (2) A generation number and a record structure information section are provided in the record structure information of the directory, a generation number and a data section are provided in the data record of the database, and a generation determination means and a generation data conversion means are provided in the data conversion means. The record management system according to claim 1, characterized in that: