JP3085141B2 - Master data management method - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

The present invention relates to a network system in which one master computer and a plurality of other computers managed by the master computer are connected by a communication line.
The present invention relates to a master data management method of the master computer.

[0002]

2. Description of the Related Art Conventionally, in a network system in which a plurality of computers are connected, master data is always managed by a specific master computer. In the update process for the master data, the master computer receives an update request from a terminal device connected to an arbitrary computer, and returns a result after the process to the terminal device.

FIG. 8 shows a configuration of a conventional network system. Computers 801, 802, and 803
Has database areas 821, 822, and 823 for storing databases, respectively.
The computer 801 and the computer 802 are connected by a communication line 830, and the computer 801 and the computer 803 are connected by a communication line 83.
1 connected. Terminal devices 810, 811,
And 812 are connected to the computer 802 and the terminal device 81
3 and 814 are connected to the computer 803.

A method of managing master data in this conventional network system will be described below.

[0005] The computer 803 is a master computer and has a database area 823 containing master data.

[0006] When an update request for master data in the database area 823 is input from the terminal device 810, the computer 802 and the computer 801 pass through the computer 801.
The master data in the 03 database area 823 is updated. When the master data update process is completed, the terminal device 810 is again transmitted via the computers 801 and 802.
Returns the result of the master data update process.

When a request for updating the master data in the database area 823 is input from the terminal device 813, the terminal device 813 is connected to the computer 803 having the database area 823, so that the terminal device 813 does not pass through another computer. , The master data in the database area 823 is updated. When the master data update process ends, the result of the master data update process is returned to the terminal device 813.

[0008]

In the conventional master data management method, the master data is always stored in a database area of a specific master computer.

Therefore, in the conventional master data management method, an update request for the master data from a terminal device connected to another computer cannot be transmitted to the master computer without passing through a plurality of computers. There is a problem that the update processing of the master data is delayed.

Also, since requests for updating the master data from all terminal devices are concentrated on the master computer, there is a problem that the load on the master computer increases and the processing efficiency of the master computer decreases.

Further, since the update requests for the master data from all the terminal devices are concentrated on the master computer,
There is a problem that a load on a communication line connecting the master computer and another computer increases, and a response from the master computer is delayed.

An object of the present invention is to efficiently execute a process of updating master data from all terminal devices connected to all computers constituting a network system.

Another object of the present invention is not to delay a response to an update request for master data from all terminal devices connected to all computers constituting a network system.

[0014]

According to a first master data management method of the present invention, a plurality of computers are connected by a communication line, and one of the computers holds the master data in a network system. In the management method, the calculation requested to update the master data
Machine owns the master data,
Perform desired processing with respect to the master data, if itself is not holding the master data, said other calculated with requests transmission of the master data to another computer
The computer that has performed a desired process on the master data received from the computer and that has been requested to transmit the master data from another computer has the master data itself.
In that case, move the master data to the other computer
Along with the information indicating that it has moved to the other computer.
The master data is not
Information that indicates to which computer the data has been
The computer indicated by the information,
Request transmission of the master data, and the computer sends the master data.
When the master data is received, the master data is transferred to the other computer.
Information that indicates that the
Information, and the
Information that indicates which computer the data was moved to.
If not, the computer is
Request transmission of the master data, and the computer sends the master data.
When the master data is received, the master data is transferred to the other computer.
Information that indicates that the
Information is maintained .

[0015] The second master data management method of the present invention comprises:
Multiple computers are connected in a hierarchical structure by communication lines,
One of them has master data
In the master data management method of the network system
The computer may, for each user, identify the user,
User master data and the status of the master data
Has a database area that includes
The computer requested to update the statistics
The identifier of the user is held in the database area and the
The status of the master data exists in the master data itself
The database area
From the master data and perform the desired update processing.
The user identifier is stored in the database area
If not, the
The master data for the computer located at
Requesting the transmission of the master data from the computer.
Then, in the database area, the identifier of the user, the
User master data and the status of the master data
Indicates that the master data exists in itself as a task
Set information and desired for the master data
Update process, and the
Master of a user from another computer located below
The computer requested to transmit the data transmits the database.
Source area holds the identifier of the user and the master
The status of the data is that the master data exists
From the database area
Read the master data and move to the other computer
With the master data in the database area.
Set the identification number of the other computer as the status,
An identifier of the user is held in the database area.
And the status of the master data is
If the identification number of the destination computer is indicated,
Request transmission of the master data to the
When the master data is received from the
To the computer and
The status of the other computer is used as the status of the master data.
Set another number and enter the user in the database area.
If the identifier of the network
For computers that are higher in the system
Requests transmission of the master data, and the computer
When receiving the data, the master data is transferred to the other computer.
To the database area and the user
Of the master data and the status of the master data
It is characterized in that an identification number of another computer is set .

According to a third master data management method of the present invention,
Multiple computers are connected by a loop communication line,
One of them has master data
In the master data management method of the network system
The computer may, for each user, identify the user,
User master data and the status of the master data
Has a database area that includes
The computer requested to update the statistics
The identifier of the user is held in the database area and the
The status of the master data exists in the master data itself
The database area
From the master data and perform the desired update processing.
The user identifier is stored in the database area
If not, it is not included in the user's identifier.
To the computer corresponding to the identification number
Request transmission and receive the master data from the computer
And the identifier of the user in the database area.
User master data and the status of the master data
Information indicating that the master data exists in itself.
Information as well as the desired
Performs the update process and reads the master data of a user from another computer.
The computer requested to transmit the data sends the database
Area holds the user's identifier and the master data
The data status indicates that the master data exists in itself.
Indicates that the database area
When the master data is read and moved to the other computer
In both cases, the master data status is stored in the database area.
Set the identification number of the other computer as
The user's identifier is stored in the database area
The status of the master data is
If the identification number of the previous computer is indicated, the computer
Notify the other computer of the identification number of
The computer, which has been notified of the identification number of the computer,
Request transmission of master data from the computer of the
When receiving the master data, the master
The master data exists in itself as the data status
Is set to indicate information to be performed.

According to a fourth master data management method of the present invention,
A master data management method for a network system in which a master computer and at least one other computer managed by the master computer are connected in a hierarchical structure by a communication line, and each computer is connected to at least one terminal device. The master computer has, for each user of the master computer and the other computer, a master database area including an identifier of the user, master data of the user, and an identification number of a computer that manages the master data. And
The other computer has, for each user of the other computer, a general database area including an identifier of the user, master data of the user, and an identification number of a computer that manages the master data, The other computer, input from the terminal device connected to itself, after receiving a request for update processing on the master data of a certain user,
If the identifier of the user is held in the general database area and the identification number of the computer holding the master data indicates itself, the master data is read out from the general database area and requested. The update is transmitted to the original terminal device and the desired update process is performed. If the identifier of the user is not held in the general database area, the request for the update process is located at a higher rank in the network system. When the master data is received from a computer located at a higher level in the network system, the identifier of the user, the identification number of the user, and the master data are stored in the general database area. And transmits the master data to the requesting terminal device to perform a desired update process. The computer, after receiving a request for update processing on the master data of a certain user from a computer located below the network system, the identifier of the user is held in the general database area, and If the identification number of the computer holding the master data indicates itself, the master data is read from the general database area and transmitted to the requesting computer, and the requesting computer is stored in the general database area. Set the identification number of
When the identifier of the user is not held in the general database area, the update processing request is transmitted to a computer located at a higher level in the network system, and the request for the update processing is located at a higher level in the network system. When the master data is received from the computer performing the request, the identifier of the user and the identification number of the requesting computer are set in the general database area, and the master data is transmitted to the requesting computer. The computer, after receiving a request for an update process for the master data of a certain user from a computer located at a lower level in the network system, the identifier of the user is held in the master database area, and If the identification number of the computer that holds the master data indicates itself, The master data is read from the data base database area and transmitted to the requesting computer, and the identification number of the requesting computer is set in the master database area, and the identification numbers of other computers are stored in the master database area. Is transmitted, the update processing request is transmitted to the other computer.

[0018]

[0019]

[0020]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below in detail with reference to the drawings.

FIG. 1 shows the configuration of a network system to which the master data management method of the present invention is applied.

A master computer 1 and a plurality of local computers 2
Are connected by a communication line 4, and each computer is also connected to the updating terminal 3 by the communication line 4. The master computer 1 has a master database area 11, and the local computer 2 has a general database area 21.

Hereinafter, a first embodiment of the present invention will be described with reference to FIGS.

The first embodiment is a credit renewal terminal management system, which pays cash by passing a credit card through a renewal terminal (register terminal or cash lending terminal) installed in retail stores nationwide. It is.

FIG. 2 shows a configuration of a network system to which a master data management method according to a first embodiment of the present invention is applied.

The central center computer 201 is a master computer, and the local center computers 211 and 2 installed in each region
13. District center computer 221 installed in each prefecture or city
To 223 and group computers 231 to 234 installed in department stores and supermarkets are local computers. The update terminals 241 to 245 are ID card input terminals, and are registers and cash dispensers of each store connected to the group computers 231 to 234.

The group computers 231 to 234 have a general data table 301 as shown in FIG.
Has a master data table 401 as shown in FIG.

Referring to FIG. 3, the entry (row) of the general data table 301 is an ID area (ID in FIG. 3) 311 in which the customer's personal registration number is registered, and the entry contains the customer's personal data. A status area (STS in FIG. 3) 312 in which information as to whether or not to perform or the identification number of the computer holding the personal data is set, a password area (PASS in FIG. 3) 313, and a remaining usage area 314 (FIG. 3).

Referring to FIG. 4, the entry (row) of master data table 401 is an ID area (ID in FIG. 4) 411 in which the customer's personal registration number is registered, and the entry contains the customer's personal data. A status area (STS in FIG. 4) 412 in which information as to whether or not to perform or the identification number of the computer holding the personal data is set, and a management file number address area (management file number in FIG. 4) 413 It is composed of In the management file number address area 413, a file number indicating a storage location of personal data (address, password, balance, etc.) is set.

The process of registering a new customer in the master database area 11 of the central center computer 201 is performed as follows.

The customer's personal registration number IDn is registered in the ID area 411 of the master data table 401 in the master database area 11, and a value indicating that the customer's personal data is present in the status area 412 of the entry. The file number of the management file in which the customer's personal data is stored is set in the management file number address area 413 of the same entry.

When the updating terminal 241 connected to the group computer 231 requests an update process for the personal data of the customer with the personal registration number IDn (step 81), the group computer 231 receives the update request. Then, it is determined whether or not the personal registration number IDn of the customer is registered in the ID area 311 of the general data table 301 in the own general database area 21 (step 82).

When the personal registration number IDn is not registered in the ID area 311 of the general data table 301 in the general database area 21 of the group computer 231,
The group computer 231 requests the district center computer 221 to transmit the data of the customer with the personal registration number IDn.

The personal computer registration number I from the group computer 231
The district center computer 221 requested to transmit the personal data of the customer of Dn receives its own general database area 21.
It is determined whether or not the personal registration number IDn of the customer is registered in the ID area 311 of the general data table 301 (step 83).

However, this regional center computer 22
Since the personal registration number IDn is not registered in the ID area 311 of the general data table 301 of the general database area 21, the district center computer 221 sends the personal registration number IDn to the local center computer 211. Request data transmission.

The local center computer 211 requested to transmit the personal data of the customer with the personal registration number IDn from the local center computer 221 has its own general database area 2.
It is determined whether or not the personal registration number IDn of the customer is registered in the ID area 311 of the general data table 301 in Step 1 (Step 84).

However, this local center computer 21
Since the personal registration number IDn is not registered in the ID area 311 of the general data table 301 of the general database area 21, the local center computer 211 sends the personal registration number IDn to the central center computer 201. Request data transmission.

The central center computer 201 requested to transmit the personal data of the customer with the personal registration number IDn from the local center computer 211 receives the ID area 4 of the master data table 401 in its own master database area 11.
It is determined whether or not the customer's personal registration number IDn is registered in 11.

The master data table 40 in the master database area 11 of the central center computer 201
In the ID area 411, the personal registration number IDn of the customer
Is registered, it is determined whether or not a value indicating that personal data exists is set in the status area 412 of the entry.

Since a value indicating that personal data exists is set in the status area 412 of the master data table 401 in the master database area 11 of the central center computer 201, the management file number of the entry is set. The personal data (password and balance) of the customer is read from the address area 413 and transmitted to the local center computer 211, and the master data table 401 in the own master database area 11 is read.
The identification number of the local center computer 211 is set in the status area 412 (step 85).

The local center computer 211, having received the personal data of the customer with the personal registration number IDn from the central center computer 201, registers the personal registration number IDn in the ID area 311 of the general data table 301 in its own general database area 21. Then, the received personal data is transmitted to the district center computer 221 and the identification number of the district center computer 221 is set in the status area 312 (step 86).

The district center computer 221 that has received the personal data of the customer with the personal registration number IDn from the local center computer 211 registers the personal registration number IDn in the ID area 311 of the general data table 301 in its own general database area 21. Then, the received personal data is transmitted to the group computer 231 and the identification number of the group computer 231 is set in the status area 312 (step 8).
7).

The group computer 2 that has received the personal data of the customer with the personal registration number IDn from the district center computer 221
Numeral 31 registers the personal registration number IDn in the ID area 311 of the general data table 301 in the own general database area 21, sets a value indicating that the customer's personal data exists in the status area 312, and sets the personal data. The middle password is set in a password area 313 and the remaining balance is set in a remaining balance area 314.

The group computer 231 checks the password set in the password area 313 of the general data table 301 in its own general database area 21, updates the remaining amount set in the remaining usage area 314, and updates the terminal. 241 is notified of the processing result of the update processing for the personal data of the customer with the personal registration number IDn (step 88).

In this way, the central center computer 201
The personal data of the customer with the personal registration number IDn stored in the master data table 401 in the master database area 11 is stored in the general data table 301 in the general database area 21 of the group computer 231.

Thereafter, when an update process for the personal data of the customer with the same personal registration number IDn is requested from the update terminal 242, the group computer 231 receives the request and updates the personal data. Then, the processing result is notified to the updating terminal 242.

If the update terminal 243 requests an update process for the personal data of the customer with the same personal registration number IDn, the group computer 232 receives the update request and stores it in its own general database area 21. It is determined whether or not the personal registration number IDn of the customer is registered in the ID area 311 of the general data table 301.

When the personal registration number IDn is not registered in the ID area 311 of the general data table 301 of the general database area 21 of the group computer 232,
The group computer 232 requests the district center computer 221 to transmit the data of the customer with the personal registration number IDn.

The personal computer number I from the group computer 232
The district center computer 221 requested to transmit the personal data of the customer of Dn receives its own general database area 21.
It is determined whether or not the personal registration number IDn of the customer is registered in the ID area 311 of the general data table 301 in the table.

The ID of the general data table 301 in the general database area 21 of the district center computer 221
Since the personal registration number IDn is registered in the area 311 and the identification number of the group computer 231 which is the computer holding the personal data of the customer of the personal registration number IDn is set in the status area 312. , The district center computer 221 is a group computer 231.
Is requested to transmit the data of the customer with the personal registration number IDn.

The group computer 231 requested to transmit the personal data of the customer with the personal registration number IDn from the district center computer 221 has its own general database area 21.
The personal registration number IDn is searched for in the ID area 311 of the general data table 301, the password is read from the password area 313 of the corresponding entry, and the balance is read from the remaining balance area 314, and the personal registration number I is read.
District center computer 221 as personal data of Dn customer
And the personal registration number I from the general data table 301 in its own general database area 21.
Delete all personal data of Dn customer.

The personal computer number I from the group computer 231
District center computer 2 receiving personal data of Dn customer
21 sets the identification number of the group computer 232 in the status area 312 of the general data table 301 in its own general database area 21, and transmits the received personal data to the group computer 232.

The group computer 2 that has received the personal data of the customer with the personal registration number IDn from the district center computer 221
Numeral 32 registers the personal registration number IDn in the ID area 311 of the general data table 301 in its own general database area 21, sets a value indicating that the customer's personal data exists in the status area 312, The middle password is set in a password area 313 and the remaining balance is set in a remaining balance area 314.

The group computer 232 checks the password set in the password area 313 of the general data table 301 in its own general database area 21, updates the remaining amount set in the remaining usage area 314, and updates the remaining terminal. 243 is notified of the processing result of the update processing for the personal data of the customer with the personal registration number IDn.

As described above, the personal data of the customer with the personal registration number IDn stored in the general data table 301 in the general database area 21 of the group computer 231 is transferred to the general database area 21 of the group computer 232. It is stored in the general data table 301.

Thus, the processing of the master data management method according to the first embodiment of the present invention is completed.

According to the master data management method of the first embodiment of the present invention, the personal master data held in the central center computer is transferred to the computer to which the terminal requesting the update of the master data is connected. Will be sent to
The first time takes a long time to transfer the master data, which delays the update processing. However, the second time has the effect that the update processing can be executed quickly.

Also, there is an effect that an update request from a terminal connected to a computer connected to a computer connected to a terminal having updated the master data and a computer adjacent to the computer on the network is promptly executed.

A second embodiment of the present invention will be described below with reference to FIGS.

Referring to FIG. 5, the second embodiment is a network system in which computers installed in each branch of a company are connected by a loop communication line, and computers in each branch (hereinafter, referred to as branch computers). Manages document data stored in a database.

The branch computer 501 has an update terminal 511.
However, the branch computer 502 has update terminals 512 and 513.
And the branch computer 503 has update terminals 514 and 5
15 are connected. When operating an update terminal of a branch computer, an employee who is an operator of each update terminal passes an ID card on which his or her personal registration number is recorded through an ID card reader connected to the update terminal. Thereby, the branch computer can recognize the employee who is the operator.

Note that the personal registration number includes the identification number of the branch computer of the branch to which the employee belongs.

FIG. 6 shows the contents of the ID management table included in the database area of each branch computer.

Each entry (row) of the ID management table is
Personal ID name area 60 where the personal registration number of the employee is registered
1 and a database management table address area 602 in which the address of the database management table corresponding to the personal registration number is set.

FIG. 7 shows the contents of the database management table included in the database area of each branch computer.

The database management table is a table set for each personal registration number. Each entry (line) has a file name area 701 indicating the name of a data file, a comment area 702 for storing comments of the contents of the database, It comprises a CPU number area 703 for storing the identification number of the computer managing the data file, and a dummy file name area 704 for storing the file name of the data file in the computer in which the data file is stored. .

In the present embodiment, as shown in FIG. 6, the personal registration number IDn of a certain employee is registered in the personal ID name area 601 of the ID management table of the branch computer 502, and corresponds to the personal registration number IDn. The address of the corresponding database management table is set in the database management table address area 602 of the entry.

Further, as shown in FIG.
The file name “file XXX” is set in the file name area 701 of the database management table corresponding to “n”, and indicates that master data is held in the CPU number area 703 of the entry corresponding to the file name “file XXX”. MASTER "is set, and in the branch computer 502," file XXX "is also called" XX ".
X. DUMMY ”, the file name“ XXX.DUMMY ”is stored in the dummy file name area 704.
Is set.

Assuming such a situation, a case will be described where an employee updates the file name “fileXXX” from the updating terminal 511 connected to the branch computer 501.

First, the employee having the personal registration number IDn makes the ID card reader connected to the updating terminal 511 read his / her own ID card, and makes the branch computer 501 recognize that he is the operator.

Next, when the employee requests update processing of the file name “fileXXX” from the update terminal 511 (step 91), the branch computer 501 stores the employee in the personal ID name area 601 of its own ID management table. It is determined whether the personal registration number IDn is registered (step 9).
2).

If the personal registration number IDn of the employee is not registered in the personal ID name area 601 of the ID management table of the branch computer 501, the branch computer 501 calculates the personal registration number of the employee from the personal registration number IDn of the employee. Recognizing that IDn is managed by the branch computer 502, it requests the branch computer 502 to transfer "file XXX".

From the branch computer 501, "File XXX"
The branch computer 502 which has been requested to transfer the information, recognizes that the personal registration number IDn of the employee is registered in the personal ID name area 601 of its own ID management table, and stores the database management table address area 602 of the entry.
The personal registration number I of the employee from the address stored in
Recognize the database management table corresponding to Dn.

Next, the branch computer 502 searches for the file name “file XXX” in the file name area 701 of the database management table, and determines that the CPU number area 703 of the entry is “MASTER”. It recognizes that the file with the dummy file name “XXX.DUMMY” set in the area 704 is the master file.

Further, the branch computer 502 sets the identification number of the branch computer 501 in the CPU number area 703 of the entry, and transfers the file “XXX.DUMMY” to the branch computer 501 (step 93).

The file “XXX.
The branch computer 501 to which "DUMMY" has been transferred sets the database management table corresponding to the personal registration number IDn, and sets the personal ID name area 60 of its own ID management table.
1, the personal registration number IDn is registered, and the address of the database management table is set in the database management table address area 602 of the corresponding entry.

Next, the branch computer 501 registers the file name “file XXX” in the file name area 701 of the created database management table,
“MASTER” is set in the number area 703, and a dummy file name “XXX.DUMMY” is set in the dummy file name area 704 of the entry.

Further, the branch computer 501 stores the file “X
XX. After "DUMMY" is stored in its own database area, an update process is performed (step 94).

Thereafter, when the employee whose personal registration number is IDn requests update processing for the file name “file XXX” from the update terminal 515 connected to the branch computer 503, the branch computer 503 sets its own ID management table. The personal registration number I of the employee in the personal ID name area 601
It is determined whether Dn is registered.

If the personal registration number IDn of the employee is not registered in the personal ID name area 601 of the ID management table of the branch computer 503, the branch computer 503 determines the personal registration number of the employee from the personal registration number IDn of the employee. Recognizing that IDn is managed by the branch computer 502, it requests the branch computer 502 to transfer "file XXX".

From the branch computer 503, "File XXX"
The branch computer 502 which has been requested to transfer the information, recognizes that the personal registration number IDn of the employee is registered in the personal ID name area 601 of its own ID management table, and stores the database management table address area 602 of the entry.
The personal registration number I of the employee from the address stored in
Recognize the database management table corresponding to Dn.

Next, the branch computer 502 searches the file name “file XXX” in the file name area 701 of the database management table, and finds that the CPU number area 703 of the entry is the identification number of the branch computer 501. "File XXX" is the branch computer 50
1 is notified to the branch computer 503.

From the branch computer 502, "file XXX"
Is notified to the branch computer 501, the branch computer 503 sends the file XX to the branch computer 501.
X ".

From the branch computer 503, "file XXX"
The branch computer 501 that has been requested to transfer the information recognizes that the personal registration number IDn of the employee is registered in the personal ID name area 601 of its own ID management table, and stores the database management table address area 602 of the entry.
The personal registration number I of the employee from the address stored in
Recognize the database management table corresponding to Dn.

Next, the branch computer 501 searches the file name “file XXX” in the file name area 701 of the database management table, and finds that the CPU number area 703 of the entry is “MASTER”. It recognizes that the file with the dummy file name “XXX.DUMMY” set in the area 704 is the master file.

Further, the branch computer 501 sets the identification number of the branch computer 503 in the CPU number area 703 of the entry, and transfers the file “XXX.DUMMY” to the branch computer 503.

The file “XXX.
The branch computer 503 to which "DUMMY" is transferred sets the database management table corresponding to the personal registration number IDn, and sets the personal ID name area 60 of its own ID management table.
1, the personal registration number IDn is registered, and the address of the database management table is set in the database management table address area 602 of the corresponding entry.

Next, the branch computer 503 registers the file name “file XXX” in the file name area 701 of the created database management table,
“MASTER” is set in the number area 703, and a dummy file name “XXX.DUMMY” is set in the dummy file name area 704 of the entry.

Further, the branch computer 503 stores the file “X
XX. After the "DUMMY" is stored in its own database area, an update process is performed.

After the completion of the updating process, the branch computer 503 notifies the branch computer 502 that the “file XXX” is held.

From the branch computer 503, "file XXX"
The branch computer 502 notified that the branch computer 503 is stored in the file name area 701 of the database management table searches for the file name “fileXXX”, and sets the identification number of the branch computer 503 in the CPU number area 703 of the entry. .

As described above, the processing of the master data management method according to the second embodiment of the present invention is completed.

According to the master data management method according to the second embodiment of the present invention, any one of the updating terminals connected to the computers connected via the loop network can be used to update an arbitrary file. Even if an update process is requested, the file is transmitted to the requesting computer, so that the update process can be executed quickly.

[0094]

As described above, according to the master data management method of the present invention, the updating process for the master data from all the terminal devices connected to all the computers constituting the network system is efficiently executed. It has the effect of being able to.

Further, there is an effect that the response to the update request for the master data from all the terminal devices connected to all the computers constituting the network system is not delayed.

[Brief description of the drawings]

FIG. 1 is a diagram showing a configuration of a network system to which a master data management method according to the present invention is applied.

FIG. 2 is a diagram illustrating a configuration of a network system to which a master data management method according to a first embodiment of the present invention is applied.

FIG. 3 is a diagram showing the contents of a general data table 301 according to the first embodiment of the present invention.

FIG. 4 is a diagram showing contents of a master data table 401 in the first embodiment of the present invention.

FIG. 5 is a diagram showing a configuration of a loop network system to which a master data management method according to a second embodiment of the present invention is applied.

FIG. 6 is a diagram showing the contents of an ID management table according to the second embodiment of the present invention.

FIG. 7 is a diagram showing contents of a database management table according to the second embodiment of the present invention.

FIG. 8 is a diagram showing a configuration of a conventional network system.

FIG. 9 is a flowchart showing processing of a master data management method according to the first embodiment of the present invention.

FIG. 10 is a flowchart showing processing of a master data management method according to the second embodiment of the present invention.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Master computer 2 Local computer 3 Update terminal 4 Communication line 11 Master database area 21 General database area 201 Central center computer 211-213 Local center computer 221-223 District center computer 231-234 Group computer 241-245 Update terminal 301 General data table 311 ID area 312 Status area 313 Password area 314 Unused amount area 401 Master data table 411 ID area 412 Status area 413 Management file number address area 501-503 Branch computer 511-515 Update terminal 601 Personal ID Name area 602 Database management table address area 701 File name area 702 Comment area 703 CPU number area 704 dummy file name area 801 to 803 computer 810-814 terminals 821 to 823 database area 830-831 communication line

──────────────────────────────────────────────────続 き Continuation of the front page (56) References JP-A-3-111948 (JP, A) JP-A-61-286920 (JP, A) JP-A-2-56664 (JP, A) JP-A-5-286 334262 (JP, A) JP-A-1-243168 (JP, A) JP-A-6-19768 (JP, A) JP-A-2-144739 (JP, A) (58) Fields investigated (Int. Cl. ⁷ , DB name) G06F 15/16-15/177 G06F 12/00

Claims (3)

(57) [Claims] 1. In a master data management method for a network system in which a plurality of computers are connected by a communication line and one of the computers holds master data, the computer requested to update the master data includes: , when held by itself the master data, performs a desired processing with respect to the master data, itself when not holding the master data of the master data to another computer Request transmission and receive from other computers
The requested computer performs desired processing on the received master data, and the computer requested to transmit the master data from another computer is in a case where the computer itself holds the master data.
Move the master data to the other computer
Maintains information indicating that it has moved to the other computer
And does not hold the master data,
Holds information indicating which computer the data was moved to
In this case, the computer indicated by the information
Requesting the transmission of master data, and the computer
Move the master data to the other computer
Information indicating that the information has been transferred to the other computer
And the master itself does not hold the master data.
It also holds information indicating which computer the data was moved to.
If not, the computer is
Requesting the transmission of master data, and the computer
Move the master data to the other computer
Information indicating that the information has been transferred to the other computer
Master data management method characterized in that to hold the. 2. A plurality of computers having a hierarchical structure by communication lines.
One of the computers is the master data
Master data tube of the network system that holds the
In the processing method, The computer includes, for each user, an identifier of the user,
Master data and status of the master data
Has a database area containing The calculation required to update the master data of a user
The machine stores the identifier of the user in the database area.
And the status of the master data
If it indicates that data exists,
Tab area Read the master data from the
Performs an update process and stores the user's information in the database area.
If the identifier is not stored, the network system
To computers that are higher in the system
Requests transmission of master data, and sends the master data from the computer.
When the data is received, the user is stored in the database area.
Identifier of the user, the master data of the user, and the master data.
The master data exists in itself as the data status
Information indicating that the master data
Perform the desired update process on Positioned below itself in the network system
Request transmission of master data of a user from another computer
The calculated computer is used in the database area.
Of the master data and the status of the master data
Indicates that the master data exists in itself.
Read the master data from the database area.
Move to the other computer and
In the base area, the status of the master data is
Set the identification number of another computer and enter the database
The user identifier is held in the rear and the master data
Of the computer to which the master data is moved
If the number is indicated, the master
Requests data transmission and receives master data from the computer.
Transfer the master data to the other computer
With the master data in the database area.
Set the identification number of the other computer as the status,
An identifier of the user is held in the database area.
If it is not,
To send the master data to the computer
Request and receive the master data from the computer
And transferring the master data to the other computer.
In the database area, the identifier of the user and the
Identification of the other computer as the status of master data
Master data management method characterized by setting a number
Law. 3. A plurality of computers are connected by a loop communication line.
Connected, and one of the computers is the master data
Master data tube of the network system that holds the
In the processing method, The computer includes, for each user, an identifier of the user,
Master data and status of the master data
Has a database area containing The calculation required to update the master data of a user
The machine stores the identifier of the user in the database area.
And the status of the master data
If it indicates that data exists,
Read the master data from the database area and
Performs an update process and stores the user's information in the database area.
If no identifier is stored, the identifier of the user
To the computer corresponding to the identification number contained in
Request transmission of the master data, and the computer sends the master data.
When the data is received, the database area
An identifier, the master data of the user, and the master data
The master data exists in itself as the status of the data
And the master data
Perform the desired update process, Request transmission of master data of a user from another computer
The calculated computer is used in the database area.
Of the master data and the status of the master data
Indicates that the master data exists in itself.
Read the master data from the database area.
Move to the other computer and
In the base area, the status of the master data is
Set the identification number of another computer and enter the database
The user identifier is held in the rear and the master data
Of the computer to which the master data is moved
Number, the identification number of the computer
Notify other calculators, The calculation in which the identification number of the computer is notified from another computer
Requests transmission of master data from the computer with the identification number
When the master data is received, the database
To the master as the status of the master data.
Information that data exists.
Characteristic master data management method.