JP2007094572A - Master data management device and master data management program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To reduce the occurrence probability of mismatching between data and to attain work efficiency in update operation such as addition and alteration of data constituting master data. <P>SOLUTION: This master data management device comprises a history storage means 11a for storing operation history data having a record including operation number information given in the unit of a series of operation in updating a plurality of master data, processing number information given in the order of updating of master data in the series of operation, master data identifier information for identifying master data to be updated in the processing number information, item identifier information for identifying items of data constituting the master data, and processing classification information for identifying classification of operated processing, wherein the record is related to time series information of procedure for carrying out processing; and a master data updating means 14c for updating the plurality of master data according to the order of processing included in the operation history data based on input update contents. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a master data management device and a master data management program.

  Master data shared and used in a plurality of systems and terminals may include a plurality of master data with different categories and different data configurations. In addition, the items of data constituting the master data of each category include (1) “primary key item” which is a data item used when constituting the master data of all categories, and (2) “primary key”. Although it is not an “item”, it is not an “essential item”, which is an item of data essential to the configuration of the master data, and (3) is not a “primary key” or “essential item” but is an attribute of the category There is an “arbitrary item” which is an item of arbitrary data in the configuration of the master data.

  For example, as described above, even when information that is a “primary key” that is commonly used in the master data of each category is included, the information in each master data is not stored in association with each other. Further, even when the “essential items” and “arbitrary items” data are used in common in the master data of a plurality of categories, the respective information is not stored in association with each other.

  Therefore, when performing update operations such as inserting new information into such conventional master data, deleting information contained in the master data, or changing the contents of the information, multiple categories of master data As for the data of the same item included in the data, the update operation is performed separately for each master data of each category, and it takes time to input the data of the same item a plurality of times. In addition, it is necessary to eliminate errors when inputting information for each category, and attention is given to the manual etc. in order to maintain the consistency of the master data of each category, and the operation of updating the master data is further complicated I have to.

In order to share master data, there is a technique for centrally managing a plurality of pieces of master data having the same contents that are managed in a distributed manner. Specifically, when any of the master data is updated, it is used for centralized management of the master data by deciding whether or not to reflect this update on the same master data. is doing. According to this, there is also a technique that unifies registration and update of master data with a degree of freedom (for example, Patent Document 1).
JP 2002-169717 A

  However, according to the technique described in Patent Document 1 described above, the update of master data is used for centralized management, and the operation of updating master data having different contents is not unified, but the consistency of data. Is not guaranteed. Further, even when updating data constituting the master data is performed a plurality of times in the same operation procedure, the same operation procedure must be repeated.

  According to the present invention, an object of the present invention is to reduce the probability of occurrence of inconsistency between data and to improve work efficiency for update operations such as addition / change of data constituting master data.

  In order to solve the above problems, a master data management device according to a feature of the present invention includes operation number information given in units of a series of operations for updating a plurality of master data, and updating of master data in a series of operations. Processing number information given in the order, master data identifier information for identifying master data to be updated in the processing number information, and item identifier information for identifying data items constituting the master data. Operation history data having a record including process type information for identifying the type of the processed process, and the record further stores a history of operation history data associated with time series information of a procedure for executing the process in the storage device Based on the storage means and the content of the input update, a plurality of master data are arranged according to the order of processing included in the operation history data. And having a master data updating means for updating the.

  According to the present invention having the above-described configuration, the same process as the master data update process executed in the past can be executed in the same order as the order of the past update processes.

  When the master data management device reads the operation history data from the storage device, the master data management device extracts a record having the same operation number information and process number information as a group for executing a process of updating master data in a series of operations; If it is determined that there are a plurality of groups having the same operation number information, a common item extraction unit that extracts items identified by item identifier information included in common in the group records as common items, and operation history data To generate a record including processing order information, master data identifier information, item identifier information, and processing type information given in chronological order for the update processing, and the same for items common to different groups Common item number information that is a number is added to the record, inserted into the operation data, and stored in the storage device It is desirable to provide a storage processing means for 憶.

  According to the present invention configured as described above, operation data can be generated based on a history of master data update processing executed in the past and used for updating master data.

  When the master data management apparatus determines that the group extracted by the group extraction unit includes a plurality of groups having the same combination of master data identifier information and item identifier information and the procedure for executing the process, the master data management apparatus selects one group from the plurality of groups. It is desirable to have group selection means for selecting a group and deleting other groups.

  The master data management device includes an input instruction processing means for displaying a screen for inputting processing type information of processing for executing update of a plurality of master data at a time, and operation data read from the storage device and inputted. It is desirable to have update instruction processing means for extracting a record including information from the operation data and displaying a batch operation screen for inputting update contents based on item identifier information included in the record.

  In addition, the update content includes all actual data for common items in the master data and actual data for non-common items that are items other than the common items when the processing type information of the selected update is addition or change. It is desirable that the common items of each master data are associated with each other.

  In the master data management device, the operation data includes main key flag information for determining whether or not the item is a main key serving as a key of the master data, and the master data update means operates when updating the master data. When additional update is instructed by referring to the primary key flag information of the data for use, a new record is generated and inserted into the master data, and when update of deletion is instructed, the group in which the actual data of the primary key matches Is deleted from the master data, and it is desirable to change the actual data of the set value of the record of the group in which the actual data of the primary key is matched to the newly input actual data when the correction update is instructed .

  The master data management device reads history storage presence / absence data having a record including operation number information from the storage device, and when an operation including operation number information is being executed, operation number information, processing number information, and master data It is desirable to have a history storage unit that generates a new record including identifier information, item identifier information, and process type information, and stores the generated record in operation history data.

  The master data management device preferably has an operation data update means for changing the operation data stored in the storage device based on the change contents of the input operation data.

  The master data management program includes operation number information given in units of a series of operations for updating a plurality of master data, process number information given in the order of updating the master data in a series of operations, and the processing Master data identifier information for identifying master data to be updated in the number information, item identifier information for identifying data items constituting the master data, and process type information for identifying the type of the operated process Operation history data having a record, and further, the record is based on a history storage step of storing operation history data associated with time-series information of a procedure for executing processing in a storage device, and the content of the input update A master data update schedule that updates multiple master data according to the processing order included in the operation history data It is desirable to execute and-up to a computer.

  According to the present invention, it is possible to provide a master data management device and a master data management program for reducing the probability of occurrence of inconsistency between data and improving work efficiency for update operations such as addition / change of data constituting the master data. it can.

  The best mode for carrying out the present invention will be described below with reference to the drawings.

(Master data management device)
FIG. 1 is a diagram showing a configuration of a master data management apparatus 1 according to the best embodiment of the present invention. As shown in FIG. 1, the master data management apparatus 1 according to the preferred embodiment of the present invention includes an employee master management unit 11, a menu master management unit 12, an operation history processing unit 13, a batch operation processing unit 14, and an operation A data update processing unit 15 is included.

  The master data management device 1 is connected to the terminals 2 a to 2 c via the network 3. The terminals 2 a to 2 c can update the master data 16 via the network 3. In the following, description will be made using the terminal 2a, but the same applies to the case where the terminal 2b or the terminal 2c is used. In FIG. 1, the master data management apparatus 1 is connected to three terminals, but is not limited to three.

  As shown in FIG. 2, the master data management device 1 includes a central processing control device 101, a ROM (Read Only Memory) 102, a RAM (Random Access Memory) 103, and an input / output interface 109 connected via a bus 110. Yes. The input / output interface 109 includes an input device 104, a display device 105, a communication control device 106, a storage device 107, and a removable disk 108.

  The central processing control device 101 reads out and executes a boot program for starting the master data management device 1 from the ROM 102 based on an input signal from the input device 104, and further reads out an operating system stored in the storage device 107. Further, the central processing control device 101 controls various devices based on input signals from the input device 104, the communication control device 106, etc., and reads programs and data stored in the RAM 103, the storage device 107, etc., into the RAM 103. A processing device that loads and implements a series of processing described later, such as data calculation or processing, based on a program command read from the RAM 103.

  The input device 104 includes input devices such as a keyboard and a mouse through which an operator inputs various operations. The input device 104 generates an input signal based on the operation of the operator, and inputs via the input / output interface 109 and the bus 110. It is transmitted to the central processing control apparatus 101. The display device 105 is a CRT (Cathode Ray Tube) display, a liquid crystal display, or the like. The display device 105 receives an output signal to be displayed on the display device 105 from the central processing control device 101 via the bus 110 and the input / output interface 109. This is a device that displays the processing results of the processing control device 101. The communication control device 106 is a device such as a LAN card or a modem, and is a device that connects the master data management device 1 that executes the accounting program to a communication network such as the Internet or a LAN. Data transmitted / received to / from the communication network via the communication control device 106 is transmitted / received to / from the central processing control device 101 via the input / output interface 109 and the bus 110 as input signals or output signals.

  The storage device 107 is a semiconductor storage device, a magnetic disk device, or the like, and stores programs and data executed by the central processing control device 101. The removable disk 108 is an optical disk or a flexible disk, and signals read / written by the disk drive are transmitted / received to / from the central processing control apparatus 101 via the input / output interface 109 and the bus 110. The storage device 107 stores master data 16, history storage presence / absence data 17, operation history data 18, and operation data 19.

  Further, the master data management apparatus 1 reads and executes the master data management program in the central processing control apparatus 101, so that the employee master management section 11, the menu master management section 12, the operation history processing section 13, and the collective operation processing The unit 14 and the operation data update processing unit 15 are mounted.

  Note that the master data management apparatus 1 according to the preferred embodiment of the present invention may be executed by a single computer as shown in FIG. 2, or may be executed by a plurality of computers that can communicate with each other. It is. For example, the storage device 107 may be provided outside the master data management device 1, and the storage device 107 may be configured by a plurality of storage devices. Furthermore, the master data 16 does not need to be stored in the storage device 107 of the master data management device 1, and the same applies even if a storage device dedicated to master data is provided outside.

  Further, although not described in detail, the central processing control device, ROM, RAM, and input / output interface are also connected to the terminal 2a through the bus in the same manner as the master data management device 1 described with reference to FIG. The input / output interface includes an input device, a display device, a communication control device, a storage device, and a removable disk.

  The master data 16 includes a plurality of categories of master data composed of different data. In the following embodiment, description will be made using the employee master 16 a and the menu master 16 b as master data included in the master data 16. For example, the master data 16 is stored by the operation of the terminal 2a connected to the master data management apparatus 1, and is used in the terminal 2a.

  FIG. 3 is an example of the employee master 16a. The employee master 16a shown in FIG. 3 has a record including “employee name” and “department ID” that is the identifier of the department to which the employee belongs, with “employee ID” that is the identifier of the employee as a key. In the employee master 16a shown in FIG. 3, the name of the employee identified by the employee ID “E001” is “AAA”, and the department ID of the department to which the employee belongs is “S70”.

  FIG. 4 is an example of the menu master 16b. The menu master 16b shown in FIG. 4 has a record including “menu ID” which is an identifier of a menu program that can be used by the employee, using “employee ID” as a key. The menu master 16b shown in FIG. 4 indicates that the employee identified by the employee ID “E001” can use the menu program having the menu ID “A”.

  In the present embodiment, the master data included in the master data 16 will be described using only the employee master 16a and the menu master 16b. However, the same applies to a case where a plurality of master data are included. Moreover, it is the same even if another master data is included instead of the employee master 16a or the menu master 16b.

  The history storage presence / absence data 17 has a record including an operation number given in units of a series of operations in updating master data. The history storage presence / absence data 17 is used to determine whether or not to store the update operation history as the operation history data 18 when the master data 16 is updated. Specifically, when the operation number stored in the history storage presence / absence data 17 is operated, the history of this operation is stored.

  FIG. 5 is an example of the history storage presence / absence data 17. The history storage presence / absence data 17 shown in FIG. 5 has a record in which a “terminal ID” for identifying a terminal and an “operation number” for identifying an operation are associated. When the operation identified by the “operation number” is performed by the terminal identified by the “terminal ID” of the record included in the history storage presence / absence data 17, the operation history is accumulated and stored in the operation history data 18. The history storage presence / absence data 17 shown in FIG. 5 indicates that an operation history is stored when an operation with an “operation number” of “1” is performed by a terminal with a “terminal ID” of “T1”. Yes.

  For example, the history storage presence / absence data 17 is an identifier of the terminal 2a when an instruction to store the operation history is input through the input device of the terminal 2a by the operator when the update operation is started. A new record is generated and stored based on the information and the operation number information.

  The operation history data 18 includes a “terminal ID” that identifies a terminal that performs an operation, an “operation number” that is assigned in units of a series of operations for updating a plurality of master data, and master data in a series of operations. “Process number” given in the order of update, “Master data name” for identifying master data to be updated in the process number, and “Item name” for identifying data items constituting the master data , “Main key flag” that determines whether the item identified by the item name is the primary key that is the key of the master data, “Processing type” that identifies the type of the operated process, and the item name It has a record including “setting value” which is data on the item to be processed. Further, the record of the operation history data 18 is further associated with time-series information of a procedure for executing the process. Associating with time-series information, for example, it is conceivable that records are stored in time-series order, or that records include time-series order. The operation history data 18 is an operation history in which the master data 16 stored in the storage device 107 is updated.

  FIG. 6 shows an example of the operation history data 18. The first record in the operation history data 18 shown in FIG. 6 is referred to. In this record, an update in which information of “employee ID” “E101” is newly added to the employee master by a terminal identified by “terminal ID” “T1” (hereinafter referred to as “terminal T1”). It is stored that the operation was performed. Since the “primary key flag” is “1”, the “employee ID” included in this record is the primary key in the employee master. Specifically, the “primary key flag” is flag information for identifying whether or not the item is a primary key item. In the operation history data 18 as shown in FIG. 6, the main key flag is set to ON when the key is a primary key, and the main key flag is set to OFF when the key is not a primary key. Here, the main key flag being set to ON means that the actual data for the item of the main key flag is set to, for example, “1 (true or true)”.

  In the operation history data 18 illustrated in FIG. 6, the second record and the third record having the same “process number” “1” are processes following the first record. According to the second record, it is stored that the “employee name” of the newly inserted employee is “CCC”. Further, according to the third record, the newly inserted employee stores that the “department ID” is assigned to the department identified by “S6”.

  The operation data 19 includes an “operation number”, an “operation name” that identifies the operation, a “processing order” that is given in chronological order for update processing, a “master data name”, and an “item name”. ”,“ Processing type ”, and“ common item number ”assigned as the same number to items common to different groups. The operation data 19 is used to execute an operation of updating the master data 16 generated by the operation history processing unit 13 based on the operation history data 18 stored in the storage device 107.

  FIG. 7 shows an example of the operation data 19. The example shown in FIG. 7 is data used when an update operation for adding a new employee to the master data 16 is performed. As the actual data of each item of the operation data 19 shown in FIG. 7, “1” for “operation number”, “T1-1” for “operation name”, “1” for “processing order”, “master data name” “Employee Master”, “Item Name” “Employee Code”, “Primary Key Flag” “1”, “Process Type” “Insert”, “Setting Value” “E101”, “Common Number” “1” And a record including “1”, which is the same as the “operation number” of this record, are processes for performing an insertion operation in the master data.

  Specifically, the processing in the first order in the operation is performed using a record in which “1” is described in the processing order. Specifically, a new record generated based on the input “employee ID”, “employee name”, and “department ID” is inserted into the “employee master”. The second order process is performed using a record in which “2” is described in the process order. Specifically, a new record generated based on the input “employee ID” and “menu ID” is inserted into the “menu master”.

  As shown in FIG. 7, “1” is described in the “common item number” of the record in which the actual data of “item name” is “employee ID”. In this way, since the actual data of the “item name” of the records in which the same number is described in the “common item number” is common, all the “common item number” is the same number by one input. Used for item name.

  The employee master management unit 11 updates the employee master 16a by changing, adding, or deleting data based on an operation instruction input from the terminal 2a. The employee master management unit 11 includes a history storage unit 11a. The history storage unit 11a reads the history storage presence / absence data 17 from the storage device 107, and when an operation including “terminal ID” and “operation number” included in the read history storage presence / absence data 17 is being executed, the “terminal ID” ”,“ Operation number ”,“ processing number ”,“ master data name ”,“ item name ”,“ primary key flag ”,“ processing type ”, and new information including information on“ setting value ” A new record is generated, and the generated record is inserted into the operation history data 18 and stored. The actual data of “master data name” is “employee master”.

  The menu master management unit 12 updates the menu master 16b by changing, adding, or deleting data based on an operation instruction input from the terminal 2a. Further, the menu master management unit 12 has a history storage unit 12a. The history storage unit 12a has the same configuration as the history storage unit 11a, and when an operation including “terminal ID” and “operation number” included in the history storage presence / absence data 17 read from the storage device 107 is being executed. , “Terminal ID”, “operation number”, “processing number”, “master data name”, “item name”, “primary key flag”, “processing type”, and “setting value” A new record including information is generated, and the generated record is inserted into the operation history data 18 and stored. The actual data of “master data name” is “menu master”.

  The operation history processing unit 13 reads the operation history data 18 from the storage device 107, generates a record used to execute the master data update process based on the read operation history data 18, and stores the record in the storage device 107. The operation data 19 is inserted.

  As shown in FIG. 8, the operation history processing unit 13 includes a group extraction unit 13a, a group selection unit 13b, a common item extraction unit 13c, and a storage processing unit 13d.

  When the group extraction unit 13a reads the operation history data 18 from the storage device 107 at a predetermined timing, the group extraction unit 13a performs a process of updating master data in a series of operations on records having the same “operation number” and “processing number”. Extract as

  The group selection unit 13b determines whether or not the group extracted by the group extraction unit 13a includes a plurality of groups having the same combination of “master data name” and “item name” and the procedure for executing the process. When the group selecting unit 13b determines that there are a plurality of groups, the group selecting unit 13b selects one group from the plurality of groups as a group to be used for changing the operation data 19, and deletes the other groups. When grouped by the group extraction means 13a, it is determined whether or not there are a plurality of groups having the same order and combination of “master data name” and “item name” included in each group. For example, the group selection unit 13b selects a group having the smallest actual data of “processing number”.

  The common item extraction unit 13c determines whether there are a plurality of groups having the same group “operation number” selected by the group selection unit 13b or the group “operation number” extracted by the group extraction unit 13a. If the common item extraction unit 13c determines that there are a plurality of items, the common item extraction unit 13c extracts items identified by “item names” included in common in the group records as common items.

  The storage processing unit 13d stores information on “operation number”, “operation name”, “processing order”, “master data name”, “item name”, “main key flag”, “processing type”, and “common item number”. A record including the generated record is generated, and the generated record is inserted into the operation data 19. Here, the “processing order” is described using newly consecutive numbers based on the “processing number”. The actual data of “common item number” uses numbers, and when there are a plurality of common “item names”, consecutive numbers are set.

  The batch operation processing unit 14 reads the operation data 19 from the storage device 107, extracts the record of the input operation, and performs the operation process.

  As shown in FIG. 9, the batch operation processing unit 14 includes an input instruction processing unit 14a, an update instruction processing unit 14b, and a master data update unit 14c.

  The input instruction processing unit 14a reads the operation data 19 from the storage device 107, generates a screen for inputting a processing type for executing a batch update of a plurality of master data, and displays the screen on the display device.

  The update instruction processing unit 14 b reads the operation data 19 from the storage device 107, and extracts a record including the input processing type from the operation data 19. The update instruction processing means 14b displays a collective operation screen for inputting update contents based on the “item name” included in the extracted record.

  Here, the update content includes all the actual data for the common items in the master data and the actual data for the non-common items that are items other than the common items when the processing type of the selected update is addition or change. Each master data is related.

  The master data updating unit 14c updates a plurality of master data in accordance with the order of processing included in the operation data 19 based on the input update content. The master data updating unit 14c refers to the “main key flag” of the operation data 19 when updating the master data. When an additional update is instructed, the master data update unit 14c generates a new record and inserts it into the master data. In addition, when an instruction to update deletion is given, the master data update unit 14c deletes the record of the group in which the actual data of the primary key matches from the master data. Further, when the master data update unit 14c is instructed to update the correction, the master data update unit 14c changes the actual data of the set values of the records in the group having the same primary key actual data to the newly input actual data.

  The operation data update processing unit 15 changes the operation data 19 based on the content of the update input from the input device of the terminal 2 a and stores it in the storage device 107.

  As shown in FIG. 10, the operation data update processing unit 15 includes an update instruction processing unit 15a and an operation data update unit 15b.

  When the change request for the operation data 19 is input, the update instruction processing unit 15a generates screen data for displaying the operation data change screen based on the input change request, and displays the change contents of the operation data. Prompt for input.

  The operation data update means 15b changes the operation data 19 stored in the storage device 107 based on the input operation data change content.

(Master data update process)
Next, the update process of the master data 16 will be described with reference to FIG. 11 taking as an example the case where new regular employee data is added to the master data.

  The employee master management unit 11 determines whether or not to store an operation history in the storage device 107 when an operation for updating the master data 16 is started (S001). Specifically, the employee master management unit 11 reads the history storage presence / absence data 17 from the storage device 107, and a record including the ID of the terminal executing the update operation and the “operation number” of the update operation is recorded as history storage presence / absence data. 17, it is determined whether there is a request for storing the history of operation of the update process.

  If it is determined in step S001 that there is a request to store the operation history in the storage device 107 (YES in S001), the history storage unit 11a of the employee master management unit 11 performs the operation history of the update process of the employee master 16a. The generated record is inserted into the operation history data 18 stored in the storage device 107 (S002). The process in step S002 is repeated until the update operation for the master data of all categories from the terminal 2a is completed (S003).

  Specifically, when the master data 16 is changed by adding a new regular employee by an operation from the terminal T1 identified by “T1”, the employee master management unit 11 issues a new employee ID and records Is generated, and the generated record is inserted into the employee master 16a to be changed. Thereafter, the menu master management unit 12 generates a record including a system menu that can be used by each employee in the “menu master”, and inserts the generated record into the menu master 16b to be updated. In step S002, the operation history data 18 is stored based on the update operation for the master data of all categories of the master data 16 as described above.

  An example in which two employees are added and updated will be described with reference to FIGS. 12 and 13. FIG. 12 shows an example in which two employees are added and updated to the employee master 16a shown in FIG. The employee master 16a shown in FIG. 12 additionally stores an employee identified by the employee ID “E101” and an employee identified by the employee ID “E102”. In FIG. 13, a system menu that can be used by these employees is additionally stored in the menu master 16b shown in FIG. The employee master 16a shown in FIG. 3 is updated as shown in FIG. 13, and the history of operations in which the menu master 16b shown in FIG. 4 is updated as shown in FIG. 14 is shown in FIG. This is operation history data 18.

  When the update process of the master data 16 is completed (YES in S003), the group extraction unit 13a of the operation history processing unit 13 reads the operation history data 18 from the storage device 107 at a predetermined timing such as regularly or at a fixed time (S004). ). In addition, the group extracting unit 13a sets a plurality of groups as one group for executing the process of updating the master data in a series of operations on the records having the same “terminal ID” and “processing number” from the read operation history data 18. Extract (S005).

  In the operation history data 18 illustrated in FIG. 6, four groups having “processing numbers” of “1”, “2”, “3”, and “4” are extracted.

  When groups are extracted in step S005, the group selection unit 13b of the operation history processing unit 13 determines whether or not there are a plurality of groups of the same process in these groups (S006). Specifically, if there are multiple groups whose processing order matches the combination of the actual data of “master data name” and “item name” in the group, it is determined that there are multiple groups of the same process. To do.

  If it is determined that there are a plurality of groups with the same process (YES in S006), the group selection unit 13b selects only the group with the smallest “process number” value and deletes the other groups ( S007).

  The records of the group whose actual data “processing number” is “1” and “3” in the operation history data 18 shown in FIG. 6 are all in the same order as the actual data of “master data name” and “item name”. To do. For this reason, the group selection unit 13b selects only records in which the “process number” is “1”. In addition, the actual data of “master data name” and “item name” all match for the records in the group whose “processing number” is “2” and “4”. Therefore, the group selection unit 13b selects only the records of the group whose “processing number” is “3”. In addition, when there are a plurality of groups with the same process in this way, the group with the smallest “process number” is used to generate the operation data 19, but the present invention is not limited to this, and another group is selected and updated. It may be used for the processing of the operation.

  Thereafter, the common item extraction unit 13c of the operation history processing unit 13 determines whether or not there are a plurality of selected groups (S008). If it is determined that there are a plurality of selected groups (YES in S008), the common item extraction unit 13c extracts a record having a common “item name” from the plurality of groups (S009).

  In the operation history data 18 shown in FIG. 6, when comparing the “item name” of the records of the group whose “processing number” is “1” and “2”, the actual data of “item name” has the same “employee ID”. Therefore, the common item extraction unit 13c extracts a record including “employee ID”.

  Next, the storage processing unit 13d of the operation history processing unit 13 assigns “processing order” in the order of “processing number” and records each group of records including the same “item name” extracted in step S009. The same number is set in the “common item number”, and a record to be inserted into the operation data 19 is generated (S010). Thereafter, the storage processing unit 13d inserts the generated record into the operation data 19 (S011).

  An example in which a record is inserted by the processing in step S011 is the operation data 19 shown in FIG. In addition, when the record is generated in step S010, a record including “employee ID” in the actual data of “item name” is extracted in step S009. In the example illustrated in FIG. 7, the record is generated based on these. “1” is set as the same number in the “common item number” of the record whose actual data of “item name” is “employee ID”.

  If it is determined in step S001 that the history storage is not requested (NO in S001), the input instruction processing unit 14a of the collective operation processing unit 14 determines whether the use of the operation data 19 is requested. Is determined (S012).

  If it is determined that the use of the operation data 19 is requested (YES in S012), the input instruction processing unit 14a causes the terminal 2a to generate screen generation data for displaying the batch operation screen 200 on the display device of the terminal 2a. The user is prompted to input an operation number (S013), and waits for the operation number transmitted from the terminal 2a (S014).

  FIG. 14 is an example of the collective operation screen 200 displayed on the display device of the terminal 2a. 14 includes an operation number input box 201, a search button 202, and an execution button 203. In the operation number input box 201, an “operation number”, which is an operation number in which the master data 16 is updated using the operation data 19, is input. In step S013, an “operation number” is input, but a method of selecting a desired operation name based on a list of operation names displayed on the display screen of the terminal 2a may be used. The list of operation names is displayed when the search button 202 on the collective operation screen 200 is pressed. The execution button 203 is a button for executing an operation. For example, when the “operation number” is entered in the operation number input box 201 and pressed, the inputted “operation number” is transmitted to the master data management apparatus 1.

  In step S013, when the operation number is input (YES in S014), the update instruction processing unit 14b of the collective operation processing unit 14 reads the operation data 19 from the storage device 107 and inputs it from the read operation data 19. A record including the “operation name” is extracted (S015).

  Subsequently, the update instruction processing unit 14b generates screen data for displaying the new collective operation screen 200 based on the record extracted in step S015, and displays the new collective operation screen 200 on the display device of the terminal 2a. This prompts the user to input an instruction including the contents of the update (S016), and waits for an instruction to update (S017).

  FIG. 15 shows an example of the newly displayed collective operation screen 200. 15 includes an operation number input box 201, a search button 202, an execution button 203, and a setting value input box 204. The set value input box 204 is used to input actual data for each item when the master data 16 is updated. With respect to the “common number” in the same operation data 19, only one place can be input for updating. Specifically, in the example of FIG. 15, a plurality of “employee IDs” are displayed in the set value input box 204, but only one place can be changed. The execution button 203 is pressed after data is input to the set value input box 204, whereby an update instruction is input from the terminal 2a to the master data management apparatus 1, and the process proceeds to the subsequent process. When the execution button 203 is pressed when the set value is the set value input in the set value input box 204 of the collective operation screen 200 shown in FIG. 15, the “employee ID” is “E103”, “employee name” "EEE", "Department ID" is "S7", and "Menu ID" is "A".

  When an instruction including the content of update is input (S017), the master data updating unit 14c of the batch operation processing unit 14 updates the master data 16 based on the input content (S018).

  Specifically, the master data update unit 14c refers to the “primary key flag” of the operation data 19, and generates an additional record based on the input content when an instruction for additional update is input. Insert into master data. Further, when an instruction to update the deletion is input, the master data update unit 14c deletes the record of the group in which the actual data of the input “primary key” matches from the master data. Alternatively, the master data update unit 14c newly inputs the actual data of the set value of the record of the group that matches the actual data of the “primary key” of the input content when an instruction to update the correction is input. Change to content.

  FIG. 16 shows the employee master 16a updated with the set values input on the collective operation screen 200 shown in FIG. FIG. 17 shows the menu master 16b updated with the set values input on the collective operation screen 200 shown in FIG.

  As described above, when the master data is updated for the first time, it can be stored in the storage device as operation data for updating the update contents based on the process of the operation. When updating, when the data of the same item is input to a plurality of master data using the operation data read from the storage device, the same content is changed with respect to the master data associated with only one input. I can do it.

(Operation data update processing)
Next, a process of updating the operation data 19 will be described using the flowchart shown in FIG.

  When the update of the operation data 19 is started, the update instruction processing means 15a of the operation data update processing unit 15 reads the operation data 19 from the storage device 107 (S101). Thereafter, the update instruction processing means 15a generates screen data for generating the operation data update screen 300 to be displayed on the terminal 2a in order to change the operation data 19, and displays the operation data update screen 300 on the terminal 2a. Then, the input of the change content is prompted (S102), and the input of the change content is waited (S103).

  FIG. 16 shows an example of the change screen displayed in step S102. For example, when the search button 302 of the operation data update screen 300 is pressed, “operation number” and “operation name” are displayed, and an “operation number” is set by selecting an arbitrary “operation name” therefrom. You may do it.

  When the change content is input (YES in S103), the operation data update unit 15b of the operation data update processing unit 15 writes the operation data 19 stored in the storage device 107 based on the input content. Change (S104). FIG. 17 shows an example in which changes are input to the operation data update screen 300 shown in FIG. FIG. 18 shows an example of the operation data 19 changed by the operation data update screen 300 shown in FIG.

  If no change is input in step S103 (NO in S103), the operation data update unit 15b determines whether a deletion operation has been performed (S105). When a deletion operation is performed (YES in S105), the operation data update unit 15b deletes the corresponding record or data from the operation data 19 based on the content of the operation (S106).

  Thereafter, the processes in steps S101 to S106 are repeated until the process is completed (S107).

  Thus, by updating the operation data based on the operator's input, it is possible to change the master data by reusing it while transforming it into operation data that suits the operator's wishes. .

  As described above, the embodiments of the present invention have been described. However, it should not be understood that the descriptions and drawings constituting a part of this disclosure limit the present invention. From this disclosure, various alternative embodiments, examples, and operational techniques will be apparent to those skilled in the art.

  It goes without saying that the present invention includes various embodiments not described herein. Therefore, the technical scope of the present invention is defined only by the matters described in the above description and the invention specific matters according to the obvious claims.

It is a figure explaining the master data management apparatus which concerns on the best embodiment of this invention. It is a hardware block diagram of the master data management apparatus which concerns on the best embodiment of this invention. It is a figure explaining the employee master memorize | stored in the master data management apparatus which concerns on best embodiment of this invention. It is an example of the menu master memorize | stored in the master data management apparatus which concerns on best embodiment of this invention. It is an example of the history storage presence / absence data stored in the master data management device according to the preferred embodiment of the present invention. It is an example of the operation history data memorize | stored in the master data management apparatus which concerns on best embodiment of this invention. It is an example of the operation data memorize | stored in the master data management apparatus which concerns on best embodiment of this invention. It is a detailed block diagram of the operation history process part of the master data management apparatus which concerns on the best embodiment of this invention. It is a detailed block diagram of a batch operation processing unit of the master data management device according to the preferred embodiment of the present invention. It is a detailed block diagram of the operation data change processing unit of the master data management device according to the best mode of the present invention. It is a flowchart explaining the update process of the master data in the master data management apparatus which concerns on the best embodiment of this invention. It is an example after the update of the employee master shown in FIG. It is an example after the update of the menu master shown in FIG. It is an example of the batch operation screen used when performing batch operation in the master data management device according to the best embodiment of the present invention. FIG. 13 is an example in which update content is input to the collective operation screen illustrated in FIG. 12. FIG. It is an example after the update of the employee master shown in FIG. It is an example after the update of the menu master shown in FIG. It is a flowchart explaining the update process of the operation data in the master data management apparatus which concerns on best embodiment of this invention. It is an example of the operation data update screen utilized when changing the operation data in the master data management apparatus according to the best embodiment of the present invention. FIG. 17 shows an example in which update content is input to the operation data update screen shown in FIG. 16. FIG. It is an example after the change of the operation data shown in FIG.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Master data management apparatus 2a-2b ... Terminal 3 ... Network 11 ... Employee master management part 12 ... Menu master management part 11a, 12a ... History storage means 13 ... Operation history processing part 13a ... Group extraction means 13b ... Group selection means 13c ... Common item extraction means 13d ... Storage processing means 14 ... Batch operation processing section 14a ... Input instruction processing means 14b ... Update instruction processing means 14c ... Master data update means 15 ... Operation data update processing section 15a ... Update instruction processing means 15b ... Operation data update means 16 ... Master data 16a ... Employee master 16b ... Menu master 17 ... History memory presence / absence data 17a ... Employee master 17b ... Menu master 18 ... Operation history data 19 ... Operation data 101 ... Central processing control device 102 ... ROM
103 ... RAM
DESCRIPTION OF SYMBOLS 104 ... Input device 105 ... Display device 106 ... Communication control device 107 ... Memory | storage device 108 ... Removable disk 109 ... Input / output interface 110 ... Bus 200 ... Batch operation screen 300 ... Operation data update screen 302 ... Search button

Claims (11)

In a master data management device that manages a plurality of master data having different data configurations,
Operation number information given in units of a series of operations for updating the plurality of master data, processing number information given in the order of updating the master data in the series of operations, and updating in the processing number information Master data identifier information for identifying the master data that is the target of the data, item identifier information for identifying the items of the data constituting the master data, and process type information for identifying the type of the operated process A history storage means for storing operation history data in a storage device, the operation history data being further associated with time-series information of a procedure for executing processing;
Master data updating means for updating the plurality of master data in accordance with the order of processing included in the operation history data based on the content of the input update;
A master data management device comprising: When the operation history data is read from the storage device, a group extraction unit that extracts a record having the same operation number information and process number information as a group that executes master data update processing in a series of operations;
When it is determined that there are a plurality of groups having the same operation number information, a common item extraction unit that extracts items identified by item identifier information included in common in the records of the group as a common item;
Based on the operation history data, a record including processing order information, master data identifier information, item identifier information, and processing type information given in chronological order with respect to the update processing is generated and assigned to different groups. Storage processing means for adding common item number information that is the same number to common items, adding it to the record and inserting it into operation data, and storing it in a storage device;
The master data management apparatus according to claim 1, further comprising:   If the group extracted by the group extracting means determines that there are a plurality of groups having the same combination of master data identifier information and item identifier information and the procedure for executing the process, one group is selected from the plurality of groups. 3. The master data management apparatus according to claim 2, further comprising group selection means for deleting other groups. Input instruction processing means for displaying a screen for inputting processing type information of processing for collectively executing the update of the plurality of master data;
The operation data is read from the storage device, a record including the input processing type information is extracted from the operation data, and a collective operation screen for inputting update contents based on item identifier information included in the record is displayed. Update instruction processing means;
The master data management apparatus according to claim 1, further comprising:   The update content includes all actual data about common items in the master data and actual data about non-common items that are items other than the common items when the processing type information of the selected update is addition or change, 5. The master data management apparatus according to claim 4, wherein each master data is associated. The operation data includes main key flag information for determining whether the item is a main key that is a key of the master data,
The master data update means refers to the main key flag information of the operation data when updating the master data,
When an additional update is instructed, a new record is generated and inserted into the master data,
When update of deletion is instructed, a record of a group in which the actual data of the primary key matches is deleted from the master data,
3. The master according to claim 2, wherein when the update of the correction is instructed, the actual data of the set value of the record of the group in which the actual data of the primary key matches is changed to the newly input actual data. Data management device.   Reading history storage presence / absence data having a record including operation number information from the storage device, and when an operation including the operation number information is being executed, operation number information, processing number information, master data identifier information, and item 2. The master data management apparatus according to claim 1, further comprising history storage means for generating a new record including identifier information and process type information and storing the record in operation history data.   3. The master data management apparatus according to claim 2, further comprising operation data updating means for changing the operation data stored in the storage device based on the change contents of the input operation data. In a master data management program for managing a plurality of master data having different data structures,
Operation number information given in units of a series of operations for updating the plurality of master data, processing number information given in the order of updating the master data in the series of operations, and updating in the processing number information Master data identifier information for identifying the master data that is the target of the data, item identifier information for identifying the items of the data constituting the master data, and process type information for identifying the type of the operated process A history storage step of storing the operation history data, which is operation history data, and the record is associated with time-series information of a procedure for executing the process in a storage device;
A master data update step for updating the plurality of master data according to the order of processing included in the operation history data based on the content of the input update,
A master data management program for causing a computer to execute. When the operation history data is read from the storage device, a group extraction step of extracting records having the same operation number information and process number information as a group for executing a process of updating master data in a series of operations;
When it is determined that there are a plurality of groups having the same operation number, a common item extraction step of extracting items identified by item identifier information included in common in the records of the group as common items;
Based on the operation history data, a record including processing order information, master data identifier information, item identifier information, and processing type information given in chronological order with respect to the update processing is generated and assigned to different groups. A storage processing step of adding common item number information that is the same number to a common item, adding it to the record and inserting it into operation data, and storing it in a storage device;
The master data management program according to claim 9, comprising: When it is determined that the group extracted in the group extraction step includes a plurality of groups having the same combination of master data identifier information and item identifier information and the procedure for executing the process, one group is selected from the plurality of groups. The master data management program according to claim 10, further comprising a group selection step of deleting other groups.

Images