JPH10154090A - Data management system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve the usefulness of a master file by adding data valid time limit information to master data before update without overwriting it by master data after update and preserving it in the master file. SOLUTION: An update processing part 3 forms a master file updation means along with a data input control part 2 and it updates the master file and generates a hash table 4 based on the setting content of inputted data valid time limit information. A retrieval part 5 is provided as a master file retrieval means for retrieving the master file 1 based on a peculiar code and data valid time limit information. To put it concretely, it retrieves the master file 1 at a high speed by referring to a retrieval key which is set in the hash table 4. Namely, data valid time limit information is added and preserved without overwriting data which is previously written by data which is written later at the time of updating master data in the master file 1. At the time of retrieval, data is retrieved based on data valid time limit information.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data management system, and more particularly to a data management system capable of acquiring master data before updating of the same unique code even after updating master data stored in a master file.

[0002]

2. Description of the Related Art Performing a predetermined process based on data registered in a master file prepared in advance is common in various fields using a computer. For example, in a master file used for personnel management in a company, personal information about employees, such as employee code, name, affiliation or address, is registered for each employee. Applicable items are updated. If an employee is transferred, the transfer process on the master file is performed by updating the affiliation code of the personnel master file corresponding to the employee code of the employee on the transfer date. By this processing, the updated data becomes valid data. On the other hand, the belonging data before the update is usually overwritten by the data after the update.

A master file used in a system for managing program production in a broadcasting station includes a program code of each program, a program name, a producer,
Information on program production, such as the names of members of a production team involved in program production, is registered. The production team, that is, program production staff, is formed by assigning technicians to various tasks such as director, audio, camera, lighting, and the like. The technician is a member belonging to the technical group and has an unspecified task. The producer of the program production refers to the personal information master file or the like, grasps the working status of each member belonging to the technology group, and assigns a technician so as not to overlap with another program production performed in the same time zone. Since a program code (business code) is uniquely assigned to each program, it is distinguished from other programs by this program code.

[0004]

However, in the conventional personnel management system, even if an attempt is made to update the master file when the transfer of an employee is determined, the master file has not been transferred yet, so the master file with data overwriting has not been transferred. The file cannot be updated. Of course, it is possible to wait for the actual transfer date to perform the update process, but there is a possibility that the update process may be forgotten, and in large companies, there are many employees who are to be transferred. Further, on the master file, the data before update is overwritten, so that even if the user wants to refer to the past data, it cannot be referred to.

In a system for managing the production of programs, the program code (business code) assigned to each produced program is a unique number at the same time, but the program has ended and has become unused. The thing has been reused by other programs later. Therefore, even if it is desired to know how much the production cost was taken after the end of the program, or who participated as a staff member, it may not be possible to obtain information on past programs in the past. In addition, the staff members need to determine in advance and secure the staff before actually starting the program production. In particular, in the case of seasonal planning programs, there is a case where it is desired to secure personnel one year ahead, and it is desired that personnel can be easily secured for the future.

SUMMARY OF THE INVENTION The present invention has been made to solve the above problems, and an object of the present invention is to improve the usefulness of a master file by enabling past or future master data to be stored. It is to provide a data management system.

[0007]

In order to achieve the above object, a data management system according to a first aspect of the present invention provides a data management system according to a first invention, wherein data before and after updating is updated without overwriting with updated master data. And saves it in the master file.

According to a second invention, in the first invention, the updated master data is added to the data expiration date information and stored in the master file.

In a third aspect based on the first or second aspect, the data expiration date information includes information on a start time and an end time of a period in which the contents of the master data are valid.

In a fourth aspect based on the first or second aspect, a key for data retrieval generated based on the data expiration date information is added to the master data and stored in the master file. It is.

According to a fifth aspect of the present invention, there is provided a master file for storing master data including a unique code which is data identification information in an updatable manner, and adding the input data expiration date information to the master data and adding the data to the master file. Master file update processing means for performing registration of the master file, and master file search means for searching for the master file based on the unique code and the data expiration date information, wherein the master file search means has the same unique code. Master data that satisfies the input and designated time information from the included master data.

In a sixth aspect based on the fifth aspect, a hash storage means for registering a search key generated by combining the unique code and a search key generated based on the data expiration date information. It has.

[0013]

Preferred embodiments of the present invention will be described below with reference to the drawings.

Embodiment 1 FIG. 1 is a functional block diagram showing Embodiment 1 of a data management system according to the present invention. The data management system according to the present embodiment
An example in which the present invention is applied to personnel management in a company will be described. In FIG. 1, a data input control unit 2 is a means for inputting various data and the like to be registered in the master file 1 on a screen, and is provided by input / output means such as a display, a mouse, a keyboard, and software for controlling the operation of those devices. Be composed. The update processing unit 3 forms a master file update processing unit together with the data input control unit 2,
The master file 1 is updated and the hash table 4 is generated based on the set contents such as the input data expiration information. The search unit 5 is provided as a star file search unit that searches the master file 1 based on the unique code and data expiration date information described later. Specifically, the search unit 5 refers to a search key set in the hash table 4. By doing so, the master file 1 is searched at high speed. The data output unit 6 displays the search result by the search unit 5 in a predetermined output format. The data output unit 6 includes a printer and a display. The data management system in the present embodiment can be constructed by a general computer. The master file update processing means and the master file search means are realized by an application program running on a CPU of a computer. The data input control unit 2 and the data output unit 6 operate on a CPU, and are realized by the peripheral devices and an application driver for controlling the operation of the devices.

FIG. 2 is a diagram showing an example of the data format of the master file 1 in the present embodiment. The master file 1 in the present embodiment stores employee personal information. That is, as shown in FIG. 2, in addition to the renewable master data such as a name, an affiliation code, an address and a telephone number, an expiration date key is associated with a personal code which is a unique code for identifying each individual. In addition, data expiration date information is added and stored in the master file 1.
In the present embodiment, one record to which data expiration date information is added among information on each individual is referred to as master data. FIG. 3 is a diagram showing the relationship among the data expiration date information, the expiration date key, and the hash table 4. In the present embodiment, the data expiration date information " A "valid start" time and a "valid end" time are set. The expiration date key is a key for data search generated based on the data expiration date information. The update process of the master file 1 including the expiration date key will be described later.

The hash table 4 in the present embodiment is a hash storage unit for registering a search key obtained by combining an expiration date key with a personal code which is a unique code. The hash table 4 is generated in a disk device (not shown), and a generation method thereof will be described later.

In general, when the contents of the master data registered in the master file 1 are updated, the data before the update is overwritten. Is to add data expiration date information to the master data before update without overwriting the master data with the master data after update, and save it in the master file. In addition, the data expiration date information is added to the updated master data and stored in the master file 1. That is, the master data stored in the master file 1 is provided with a plurality of master data corresponding to the personal code as shown in FIG. 2 only by adding the data expiration date information. In this way, the master data before update is saved,
If a search is performed based on data expiration date information at the time of search, past master data can be obtained. Further, it is possible to register the master data in the master file 1 in advance before the future master data becomes effective data.

Next, a process of registering personal information in the master file 1 according to the present embodiment will be described with reference to a flowchart shown in FIG.

When the user inputs necessary items such as data to be registered and data expiration date information (step 101), the data input control unit 2 checks whether the input has been performed according to preset conditions (step 101). 1
02). For example, whether a required item has been input or whether it has been input in a correct format. If the input is not correct, an error message is displayed to prompt the user to input again (step 103).

Next, the update processing unit 3 creates an expiration date key for the input data based on the data expiration date information (step 104). As shown in FIG. 3, the expiration date key is represented by expressing the “valid start” time information of the “valid start” and “valid end” time information constituting the data expiration date information as a character string. Create For example, if “validity start” represents May 2, 1995, the validity term key is created by converting it to a character string “199950502”.

Subsequently, a search key is created (step 10).
5). This is created by combining the character strings of the personal code and the expiration date key as shown in FIG. According to the example of Fig. 3, the expiration date key included in each record data may follow the personal code "A123". In the registration process, the created search key "A123199" is used.
Since it is impossible to imagine that “502502” has already been registered in the hash table 4, an error message is displayed and the user is prompted to re-enter (step 103). It is confirmed that the created search key is not registered in the hash table 4. Upon confirmation (step 106), it is confirmed whether the master data of the personal code corresponding to the input data is registered in the master file 1. (step 107) In the case of new registration, the master data is stored in the master file 1 as it is. (Step 109) Then, the created search key is registered in the hash table 4 (Step 11).
0).

On the other hand, if it is not a new registration, it means that master data of the same personal code exists.
The end time is set to "valid end" in the latest master data among the master data (step 10).
8). The value to be set is created based on the time information designated as “valid start” in the newly written master data. In this embodiment, the date is used as the time information. For example, if the “valid start” in the newly written master data is May 2, 1995, the date is one day before the date, that is, the date of May 1995 The data of month 1 is set as “valid end” of the immediately preceding master data. Thereafter, the new master data is stored in the master file 1 (step 109), and the created search key is registered in the hash table 4 (step 110).

Next, the search processing of the master file 1 will be described with reference to the flowchart shown in FIG.

First, a search item is input as to who and when to acquire data (step 121).
Specifically, a personal code and a date are input. Then, the search unit 5 creates a key for searching the hash table 4 from the input search item (step 122). Specifically, it is created by combining the personal code and the character string obtained by converting the date in the same manner as the method of generating the search key registered in the hash table 4. Then, with this created key, hash table 4
(Step 123). It is determined whether the corresponding data, that is, the search key is registered in the hash table 4 (step 124). If the data is registered, the corresponding record (master data) from the master file 1 is determined.
Is acquired and displayed (step 125). The storage address of the master data in the master file 1 corresponding to each search key is stored in the hash table 4. If there is no matching search key, error processing such as displaying an error message is performed (step 12).
6). However, if a date that does not match the start time of the expiration date is entered, it is necessary to perform processing to uniquely identify the relevant search key by comparing the size of the search keys containing the same personal code. Become. As described above, by providing the hash table 4 in which the search key is registered, the record registered in the master file 1 can be searched at high speed.

For example, in FIG. 3, the personal code "A12
When the user wants to know where the employee of “3” has been assigned since April 2, 1994, the user enters the personal code “A12
3 ", April 2, 1994, and that the data to be acquired is an affiliation code is input as a search item.
The search unit 5 sets the key for searching the master file 1 via the hash table 4 to “A1231994040”.
By generating “2” and performing a search, it is possible to easily obtain the affiliation code of the employee at that time.

As described above, according to the present embodiment, when updating the master data in the master file 1, the previously written data (the data before the update) is written later (the data after the update). The data expiration date information is added and saved without overwriting, and the search is performed based on the data expiration date information at the time of search, so even after the validity of the data set in the past is lost, refer to it can do. Therefore, for example, since a person before marriage and the like other than the affiliation code of the employee are still stored, data such as past employment history can be obtained by searching the master file 1. Unlike a transaction file or the like, in a master file that does not normally hold a transition of data of a specific code, in the present embodiment, the history of the master data is stored. In some systems, information about a time limit may be provided as data. However, this only deals with data called “period” and does not serve as a material for judging the validity of the data. In other words, it is not just history information in the same personal code,
Only information on a specified date can be extracted from a plurality of master data corresponding to the same personal code. On the other hand, there may be a problem caused by retaining the history of data, for example, a delay in the search processing speed due to an increase in the amount of information. In the present embodiment, the hash table 4 in which the search keys are registered is provided. The adverse effects can be sufficiently eliminated.

Further, by adding expiration date information to the master data, not only is it possible to acquire a past job history, but also information about the future can be registered in the master file 1 in advance. Therefore, even when there are a large number of employees who have been subject to personnel changes in place of the fiscal year, etc., there is no need to wait for the actual transfer date and update the master file 1 collectively. Can be done.

In the present embodiment, it is also possible to perform an update process such as deleting or changing future master data registered in the master file 1. For example, in the case of deleting data, the "valid end" of the master data to be deleted is updated with the "valid end" of the preceding master data in the same personal code, or the "valid start" of the master data to be deleted is changed. Therefore, it is necessary to adjust the period by updating the “valid start” of the subsequent master data in the same personal code. Of course, only the master data to be deleted may be deleted. These are design considerations.

Embodiment 2 In the first embodiment, a case where the data management system according to the present invention is applied to a system relating to personnel management is described as an example. In the present embodiment, a case where the data management system is applied to a system which manages program production is described as an example. Will be explained. Note that functional blocks in the present embodiment are the same as those in FIG. FIGS. 6 and 7 are diagrams showing examples of the data format of the master file 1 for personal information and business information in the present embodiment. The personal information master file 1 is associated with a personal code, which is a unique code for identifying each individual such as a staff member, and includes an expiration date in addition to renewable master data such as a name, a business code, and a work in charge. The key and data expiration date information are added and stored in the master file 1. In the work code and the work in charge, the work code of the program in charge of the individual and the work such as lighting and sound in the production of the program are registered. The validity start and validity end constituting the validity period key and the data validity period information are the same as in the first embodiment.

The business information master file 1 in the present embodiment stores information related to program production. The business code is a program code assigned to each program. The master file 1 of the business information is stored in the master file 1 with an expiration date key and data expiration date information added to the business name and the staff list in association with each business code. The staff list is created by designating the name of a technician in charge of various tasks such as camera and lighting. The validity start and validity end constituting the validity period key and the data validity period information are the same as in the first embodiment.

Each program is uniquely assigned a program code (business code), and can be distinguished from other programs by this program code. However, as described above, this business code is specified uniquely during the same period,
Reused later by other programs. That is, in the related art, by assigning a used business code to another program, the business information on the program for which the business code is specified has been overwritten and deleted.

Therefore, in the present embodiment, even when the same business code is assigned to another program, the existing master data is not overwritten with new master data as described in the first embodiment. Added data expiration date information and save. As a result, it is possible to calculate the cost of the production after the end of the program, and it is possible to easily know who participated as a staff member in the finished program. To explain with a specific example, for example, suppose that member A will be in charge of lighting from December 1 to 15, 1996, and voice from December 18 to 25, 1996. In order to obtain the work “Lighting” that was assigned from December 1, 1996, input and specify that the member's personal code, December 1, 1996, and the data of the assigned task are desired. Is "illumination". This means that the same result can be obtained regardless of the date of the search.

On the other hand, before producing a program, staff must be reserved in advance. In the present embodiment, information about a future program must be registered in the master file 1 of the business information. Therefore, even if it is desired to know who participated in which program as a staff member, it can be easily grasped. Also, these master data can be registered in advance even during the production of a program having the same business code.

In this manner, the present embodiment can provide the same effects as those of the first embodiment.

In the embodiment, an example in which the present invention is applied to a system relating to personnel management and program production has been described.
It can also be applied to systems such as temporary staffing and rental of construction equipment.

[0036]

According to the present invention, the master data before update is not overwritten by the master data after update,
Since the data expiration date information is added and stored in the master file, and the retrieval is performed based on the data expiration date information at the time of retrieval, it is possible to refer to past master data.

If data expiration date information is added to the updated master data and stored in the master file, the master data is registered in the master file before the master data becomes effective data. I can put it.
As a result, master data that will be valid in the future can be registered in the master file in advance. Of course, master data relating to the future can be referred to.

Further, by providing a hash table in which a search key created based on a unique code and a data search key is registered, a search process for a master file can be performed at high speed.

[Brief description of the drawings]

FIG. 1 is a functional block diagram showing a first embodiment of a data management system according to the present invention.

FIG. 2 is a diagram showing an example of a data format of a master file according to the first embodiment.

FIG. 3 shows data expiration date information according to the first embodiment,
FIG. 4 is a diagram illustrating a relationship between an expiration date key and a hash table.

FIG. 4 is a flowchart showing a process of registering personal information in a master file according to the first embodiment.

FIG. 5 is a flowchart showing a master file search process according to the first embodiment.

FIG. 6 is a diagram showing an example of a data format of a master file of personal information according to the second embodiment.

FIG. 7 is a diagram showing an example of a data format of a master file of business information according to the second embodiment.

[Explanation of symbols]

1 master file, 2 data input control section, 3 update processing section, 4 hash table, 5 search section, 6 data output section.

Claims (6)

[Claims] 1. A data management system characterized by adding data expiration date information to master data before update without overwriting with master data after update and storing the data in a master file. 2. The data management system according to claim 1, wherein said updated master data is added to said data expiration date information and stored in said master file. 3. The data according to claim 1, wherein the data expiration date information includes information of a start time and an end time of a period in which the content of the master data is valid. Management system. 4. The data according to claim 1, wherein a key for data search generated based on the data expiration date information is added to the master data and stored in the master file. Management system. 5. A master file storing a master data including a unique code as data identification information in an updatable manner, and inputting data expiration date information to the master data to register the master data. Master file update processing means; and master file search means for searching for the master file based on the unique code and the data expiration date information, wherein the master file search means includes the same master code including the same unique code. A data management system, wherein master data that satisfies input and designated time information is selected from data. 6. The apparatus according to claim 5, further comprising a hash storage unit for registering a search key generated by combining the unique code and a search key generated based on the data expiration information. Data management system.