JPH0342743A - Encoding data control system - Google Patents

Abstract

PURPOSE:To reduce a burden which is required for the control of a data base system by unifiedly controlling a code table in the operation of the data base system and history information of encoding data. CONSTITUTION:At the time of generating a storage record in a data base, the most fresh encoding data is taken out in encoding data 210 in a code table file 200 which has a code related on a storage record 110 in a code part 220. A storage record history information setting means 310 in a data base update means 400 sets a history number in history information, which is set to encoding data that a most fresh encoding data taking out means 410 takes out. Consequently, the code table 200 and history information of encoding data 210 can be controlled unifiedly. Thus, burden required for the control of the data base system can be reduced.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a coded data management system, and particularly to a coded data management system in a database system in the field of information processing systems.

[Conventional technology]

In a database system, the storage records that make up the database may store not the data itself but a code corresponding to the data.

In such cases, coded data that shows the correspondence between individual data and codes is required, and a table (code table) consisting of multiple pieces of coded data is set in the code table file to operate the database system. ing.

Since the data in the database is updated as the operating period of the database system passes, the above-mentioned coded data is also updated accordingly.

Here, although the latest coded data is required for daily operation of the database system, old coded data may be required due to requests for data analysis, etc.

Conventionally, in the coded data management method for managing such coded data, a code table consisting of the latest coded data is set in the code table file, and at the same time, information about the old coded data of the coded data is stored. Historical information was saved in coded data files, and old coded data was restored and used when analyzing data.

[Problem to be solved by the invention]

In the conventional coded data management method described above, in order to manage the operation of the database system, it is necessary to save both the code table file corresponding to the current database and the coded data file containing the history information of the coded data. A database system that has many types of coded data has the disadvantage that the burden required to manage the database system increases.

In view of the above-mentioned points, an object of the present invention is to unify the management of code tables and the management of history information of coded data in the operation of a database system, and to reduce the burden required for managing the database system. The purpose of the present invention is to provide a coated data management method that can be used.

[Means to solve the problem]

The coded data management method of the present invention includes a database having a storage record having a history number storage part as a field corresponding to the code storage part, and coded data having a history information part as a field corresponding to the code part and the data part. When updating the data section of coded data in this code table file, set the history information to the history information section of the old and new coded data to have the same code in the code section. A coded data history information setting means in a code table maintenance section that identifies old and new coded data based on history information and causes them to coexist in the code table file; and a code related to the storage record when generating the storage record in the database. a latest coded data extracting means in a database update section for extracting the latest coded data among the coded data in the code table file having in the code part; and coded data extracted by the latest coded data extracting means. and a stored record history information setting means in the database update section that sets the history number in the history information set in the stored record to the stored record.

[Effect]

In the coded data management method of the present invention, the database has a storage record having a history number storage section as a field corresponding to the code storage section, and the code table file has a history information section as a field corresponding to the code section and the data section. When the coded data history information setting means in the code table maintenance section updates the data part in the coded data in the code file file, the history information part in the old and new coded data is updated. The new and old coded data that have the same code in the code section are identified by the history information and coexisted in the code table file, and the latest coded data retrieval means in the Pigbase update section retrieves the stored records in the database. When generating the stored record, the latest coded data is extracted from among the coded data in the code table file that has the code related to the stored record in the code section, and the stored record history information setting means in the database update section selects the latest coded data. The history number in the history information set in the coded data extracted by the extraction means is set in the storage record.

〔Example〕

Next, the present invention will be explained with reference to the drawings.

FIG. 1 is a block diagram showing the configuration of an embodiment of the coded data management system of the present invention. The coded data management system of this embodiment includes a database 100 having a plurality of stored records 110, a code table file 200 having a plurality of coded data 210, a code table maintenance section 300, and a database update section 400. It consists of

The storage record 110 in the data mousse 100 includes a code storage section 120 and a history number storage section 130 as fields.

Coded data 210 in code table file 200
has a code section 220, a data section 230, and a history information section 240 as fields.

The history information section 240 in the coded data 210 includes a history number section 241 in which a history number that is counted and amplified every time the coded data 210 is updated, and the expiration date of the coded data 210 are set. It has history information consisting of an expiration date section 242 (see Fig. 2).
.

In addition, in the code table file 200, the new and old coated data 2 having the same code in the coat part 220 are stored.
10 coexists, and the expiration date section 242 of the history information section 240 in the latest coded data 210 contains r99999.
9J is set, and other old coded data 210
The expiration date section 242 of the history information section 240 in
23J) is set.

The coat table maintenance department 300 stores coating data 210
The coded data history information setting means 310 updates (sets) the history information section 240 of the coded data history information setting means 310.

The database update unit 400 extracts the latest coded data 210 (coded data 210 having the same code in the code unit 220) from the code table file 200 in order to store (generate) data (storage record) '110) in the database 100. The latest encoded data retrieval means 410 retrieves the latest coded data retrieval means 410, and the history stored in the history number section 241 of the history information section 240 in the encoded data 210 retrieved by the latest encoded data retrieval means 410. The storage record history information setting means 420 incorporates the number into the history number storage section 130 in the storage record 110.

Referring to FIG. 3, the processing of the coded data history information setting means 310 in the code table maintenance unit 300 includes a coded data five person step 30, a valid restriction part determination step 31, and a valid restriction part update step 32. , encoded data recording step 33, encoded data write back step 34, encoded data data section update step 35, history number section count up step 36, expiration date section r999999'' setting step 37, encoding and a data write back step 38.

Referring to FIG. 4, the processing of the database update unit 400 includes a coded data input step 40, an expiration date determination step 41, and a storage record code setting step 42.
, a storage record history number setting step 43 , and a storage record storage step 44 .

Next, the operation of the coded data management system of this embodiment configured as described above will be explained.

Coded data 21 in code table file 200
When the data (content) in the data section 230 is changed in 0, the coded data history information setting means 310 in the code table maintenance section 300 performs the following processing (see FIG. 3).

First, one of the coded data 210 whose code section 220 has a code corresponding to the data section 230 whose contents have been changed.
1 from the code table file 200 (step 30).

Next, whether or not the coded data 210 is the latest among the coded data 210 having the code in the code section 220 (the expiration date field 242 of the history information section 240 in the coded data 210 It is determined whether "999999" is set (step 31).

If it is determined that the encoded data 210 is not the latest, the processing and determination of steps 30 and 31 are repeated until the latest encoded data 210 is input.

If the coded data 210 is the latest as determined in step 31, the expiration date section 242 of the history information section 240 in the coded data 210 is updated with the current date (step 32); The data 210 is recorded in a memory (not shown) (step 33), and the coded data 210 is written back to the code table file 200 (step 34). In order to create coded data 210), the data in the data section 230 of the coded data recorded in the memory in step 33 is updated (step 35), and the data is stored in the history number section 241 in the history information section 240. In step 36), count up the history number by 1 and write r999999 in the expiration date section 242 of the history information section 240.
J is set (step 37).

Finally, the coated data 210 created as described above
is written back to the code table file 200 as the latest coded data 210 (step 38).

New data (stored record 11) is added to the database 100.
0), the database update unit 400 performs the following processing to generate the storage record 110 (see FIG. 4).

First, using the latest coded data extraction means 410,
One of the coded data 210 (coded data 210 having the code in the code section 220) corresponding to the code of the storage record 110 to be generated is input from the code table file 200 (step 40).

Next, using the latest encoded data extraction means 410,
The coded data 210 converts the code into the code section 22.
The history information part 24 in the coded data 210 is checked to determine whether it is the latest among the coded data 210 held in the coded data 210.
0 is set in the expiration date field 242 (step 41).

If this determination shows that the coded data 210 is not the latest, the processing and determination of steps 40 and 41 are repeated until the latest coded data 210 is produced by two people.

If the coded data 210 is the latest as determined in step 41, the stored record history information setting means 420 is used to set the coded data 210 to the code storage section 120 of the stored record 110 to be generated. The code of the code section 220 is set (step 42).

Furthermore, using the stored record history information setting means 420, the history information section 2 in the coded data 210 is set as the history number corresponding to the code (code storage section 120).
The value (history number) of the history number section 241 of No. 40 is set in the history number storage section 130 in the storage record 110 to be generated (step 43).

Finally, the storage record 110 completed (generated) as described above is stored in the database 100 (step 44).

〔Effect of the invention〕

As explained above, the present invention includes a history number storage section in a stored record, a history information section in coded data, a coded data history information setting means, a latest coded data retrieval means, and a stored record history information setting means. This allows old and new coded data with the same code to coexist and be managed in the code table file, and centralizes code table management and history information management of coded data in database system operation. This has the effect of reducing the burden required for database system management.

[Brief explanation of drawings]

FIG. 1 is a professional diagram showing the configuration of an embodiment of the present invention, FIG. 2 is a diagram showing the configuration of the history information section in the coded data in FIG. 1, and FIG. 3 is the same as in FIG. 1. FIG. 4 is a flowchart showing the processing of the database update section in FIG. 1. In the figure, - database, - storage record, - code storage section, - history number storage section, - code table file, - coded data, code section, - data section, - history information section, - history number section, - Validity period section, - Code table maintenance section, - Coded data history information setting means, - Database update section, - Latest coded data retrieval means, - Storage record history information setting means.

Claims (1)

[Claims] A database having a storage record having a history number storage part as a field corresponding to the code storage part, and a code table file having coded data having a history information part as a field corresponding to the code part and the data part. When updating the data section of the coded data in this code table file, the history information is set in the history information section of the old and new coded data, and the old and new codes that have the same code in the code section are updated. Coded data history information setting means in a code table maintenance section that identifies data based on history information and makes it coexist in the code table file; and when generating a storage record in the database, a code related to the storage record in the code section. a latest coded data retrieval means in the database update section that retrieves the latest coded data among the coded data in the code table file having the code table file; 1. A coded data management method, comprising: storage record history information setting means within a database update unit that sets a history number in the history information stored in the stored record in the stored record.