JPH08272812A - Distributed data base system and data processing method therefor - Google Patents

Abstract

PURPOSE: To make a local data base(DB) system able to maintain the same latest DB file as a central DB system. CONSTITUTION: This distributed DB system 10 is composed of the central DB system 11 and the plural local DB systems 13 connected to the central DB system 11 through a communication channel 12 whose data transmission speed id relatively slow such as a public telephone liner or the like. When a member number which does not exist on a local DB is generated at the time of the input of ordered member data in the local DB system 13, a retrieval command is prepared and transmitted to the central DB system 11. Then, a center side server 11a performs retrieval corresponding to the retrieval command. the member number and member data corresponding to it are transmitted to the local DB system 13 and a local side server 13a updates data based on the member data.

Description

Detailed Description of the Invention

[0001]

FIELD OF THE INVENTION The present invention relates to a distributed database system in which a local database system can substantially maintain the same latest database files as a central database system.

[0002]

2. Description of the Related Art A conventional database system using LAN (Ethernet) will be described with reference to FIG. The database system shown in the figure is configured to perform various tasks related to duplication by a server and a large number of clients connected to the server. Here, "dupri" means duplication of software, packaging work, etc., and "various operations relating to dupri" mean order / production management, material management, production planning, etc. for duplication. .

In general, when performing duplication, an extremely large number of product specifications in which the name of a product, the member numbers of the members constituting the product and the member names corresponding to the member numbers are described are managed for each product. There is a need to. For example, 1500 kinds of product specifications will be required for 100 business partners, and the number of parts used to compose the 1500 kinds of products will reach 5700. In addition to this, the products subject to the duplication are generally switched very frequently (abolition of old products and addition of new products due to software version upgrades, etc.). Therefore, in order to keep the product specifications up to date, it is necessary to update the product specifications in an extremely complicated and enormous amount. By creating a database of such product specifications on the server, the update work can be made efficient and reliable, and the database can be used on each client to enable distributed processing of various operations using each client. Fig. 7 shows the configuration that realizes speedy and reliable duplication work.
Database system.

[0004]

However, the database system by LAN as described above is used only in a predetermined closed space, and the production and production due to diversification of products to be handled and the like are required. It is not possible to deal with the expansion of management work.

Therefore, a part of the database system as described above, which is indispensable for the production work, is configured as a local database system from a server and a client and is installed in a factory at a remote place, and in the central part of the database system. The parts other than the above that should be collectively managed are configured as a central database system from a server and clients, and are arranged on the central side. It is desirable to build a distributed database system. In the case of such a distributed database system, for example, various data in the database of the central server is periodically transmitted to the local server via the communication line, and the same database as the central server is the local server. Formed on. This allows the local database system to utilize the database on the central server.

However, the transmission of various data from the central server to the local server requires a relatively long time. Therefore, for example, at midnight after business hours, which is low cost and has no trouble in business. It will be done once per day. That is, the database of the local server is not updated during business hours. On the other hand, the database of the central server is updated at any time during business hours. Therefore, for example, when data is added (deleted) to the database on the central server during business hours, the data exists (does not exist) in the database on the central server, but on the local server. The inconsistent situation that it does not exist in the database will occur. If the added (deleted) data is data related to the product specification, the contradiction leads to a production error which can be fatal in performing the duplicating work.

[0007]

SUMMARY OF THE INVENTION The present invention comprises a central database system and at least one local database system connected to the central database system via a communication line having a relatively low data transmission rate such as a public telephone line. Is a distributed database system consisting of
It is configured such that the local database system can substantially maintain the same latest database files as the central database system. That is, the central database system stores a central member data storage unit that stores member data including at least a member identifier input by the central data input unit, and the member data stored in the central member data storage unit. Central member data transmitting means for periodically transmitting all of the above to the local database system via the communication line. Further, the local database system includes a local member data receiving unit that receives the member data transmitted by the central member data transmitting unit through the communication line, and a local member data receiving unit that receives the member data. Local member data storage means for storing all of the member data to form the same storage content as the central member data storage means, and the ordered member data including at least the member identifier input by the local data input means. Based on the local side member identifier searching means for searching the local side member data storage means for the member identifier included in the ordered member data based on the search result by the local side member identifier searching means Local member identifier presence / absence determining means and its local The member identifier for instructing the central database system to perform a search for the member identifier in the central member data storage unit when the member identifier presence / absence determining unit determines that the member identifier does not exist. And a local-side search-command transmitting means for transmitting the search command created by the local-side search-command creating means to the central database system via the communication line. Is equipped with. Further, the central database system receives the search command transmitted through the communication line by the local search command transmitting unit, and the central search command receiving unit receives the search command, and the central side search command receiving unit receives the search command. A central side search command executing means for performing a search for the member identifier included in the search command to the central side member data storage means in accordance with the search command, and at least a search result by the central side search command executing means. Central search result transmitting means for transmitting the search result data including the member identifier to the local database system via the communication line. Further, the local database system includes a local side search result receiving means for receiving the search result data transmitted by the central side search result transmitting means, and the search result data received by the local side search result receiving means. And a local member data updating means for updating the stored contents of the local member data storing means.

[0008]

The central database system stores the member data including at least the member identifier input by the central data input means in the central member data storage means. All of the member data stored in the central member data storage means are periodically transmitted to the local database system via the communication line by the central member data transmission means. Further, the local database system receives the member data transmitted from the central member data transmitting means by the local member data receiving means, stores all of the received member data in the local member data storing means, and stores it in the central portion. The same storage content as the side member data storage means is formed. Furthermore, the local database system searches the local side member data storage unit for the member identifier included in the ordered side member data based on the ordered side member data input by the local side data input unit by the local side member identifier searching unit. The presence / absence of the member identifier is determined by the local member identifier presence / absence determining unit based on the search result. The member identifier for instructing the central database system to search the central member data storage unit for the member identifier when the local member identifier presence / absence determining unit determines that the member identifier does not exist. The search command including the search command is created by the local search command creating means, and the search command is transmitted to the central database system via the communication line by the local search command sending means. Further, the central database system receives the search command transmitted via the communication line by the central side search command receiving means, and searches the member identifier included in the search command according to the received search command on the central side. The central side search command execution means performs the member data storage means, and the central side search result transmission means transmits the search result data including at least the member identifier as the search result to the local database system via the communication line. Further, the local database system receives the transmitted search result data by the local side search result receiving means, and updates the contents stored in the local side member data storage means based on the received search result data. This is performed by the data updating means.

[0009]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENT FIG. 1 shows an outline of a distributed database system for duplication according to the present invention. The distributed database system 10 includes a central database system 11 arranged at a head office and the like, and a central database system 11 via a communication line 12 having a relatively low data transmission rate such as a public telephone line.
And a plurality of local database systems 13 connected to each other. The local database systems 13 are respectively installed in a plurality of factories and the like in remote places.

The central database system 11 comprises a server 11a for centrally managing all information, and clients 11b-11f for performing various data processing such as ledger registration and specification registration using the management information by the server 11a. . The local database system 13 includes a server 13a that centrally manages all information on the local side, and clients 13b to 13f that perform various data processing such as production planning and inventory management using the management information by the server 13a. Become.

Each of the servers 11a and 13a is provided with an external storage device (not shown) for creating a database, and a part of the external storage device stores central member data and local member data. Each means is implemented.

Further, the servers 11a and 13a are connected to the communication line 12
Each of the central side servers 11a is provided with a communication interface (not shown) similar to the conventional one that enables the transmission and reception of various data via the server. The central server 11a stores the communication interface and the external storage device of the server 11a. With the Duplicate build-to-order manufacturing management software for the central
Central member data transmitting means, central search command receiving means,
And a central side search result transmitting means are formed, and in the local side server 13a, with its communication interface,
With the local duplica make-to-order manufacturing management software stored in the external storage device of the server 13a,
Local side search command transmitting means, local side search result receiving means, and local side member data receiving means are formed.

Further, the central side search command executing means is implemented as a part of the central duplicating make-to-order manufacturing management software, and includes a local side member identifier searching means, a local side member identifier presence / absence determining means, and a local side. The search command creating means and the local side member data updating means are implemented as part of the local duplicate manufacturing order management software.

The implementation of such means using software will be more easily understood from the description given below with reference to the flowcharts of FIGS. 2 and 4.

On the other hand, the central database system 11
Is the FA of customers and sales offices via the public telephone line 14.
It is connected to X. In addition, the client 11f, which performs inventory confirmation and parts order support, is connected to the FAX 15 of the parts supplier of the order destination through a public telephone line, and the purchase order created on the client 11f is automatically sent to the parts supplier. It is possible to send. Note that it is possible to connect an overseas network to the central database system 11 if necessary.

In such a configuration, when the customer A to C or the sales offices A and B send the product specifications regarding the new product etc. to the central database system 11 via the public telephone line 14, the client 11c. Operator
With reference to the product specification, the keyboard 11c 'of the client 11c is used to register or update the member data in the central member data storage means of the server 11a. Here, the member data is data including a member number as a member identifier uniquely corresponding to each member, a member name corresponding to the member number, a member supplier, a customer side member name, a customer side member number, and the like. Refers to.

Next, the server 11a transmits the data in the central member data storage means to the local database system 12 at regular intervals, for example, once a day during the duplication hours and once a day. . As a result, the same database as the central member data storage means is formed on the local member data storage means of the local server 13a.

Next, during the duplicating hours, the operator of the client 13b of the local database system 13 refers to the order specifications from the customers A to C or the sales offices A and B which are faxed via the head office. Input the order material data including the material number and the number of materials described in the specification using the keyboard 13b '.

The processing performed by the local server 13a when the order material data is input in this manner is shown in FIG.
Shown in As shown in the figure, the local server 13a is
When the ordered material data is input, the member number included in the ordered material data is searched for in the local member data storage means (step 1). Next, as a result of the search, it is determined whether or not there is a member number that does not exist in the local member data storage means (step 2).

If there is no member number that does not exist in the local member data storage means, that is, if all of the input member numbers exist in the local member data storage means, create a component member list. (Step 3) The process ends. The constituent member list is a list in which the specifications of the ordered product as shown in FIG. 3 are described, and the factory staff advances the duplication work with reference to the constituent member list.

If there is a member number that does not exist in the local member data storage means, a search command is created (step 4). This search command is a command including the member number for instructing the central server 11a to search the central member data storage unit for the member number that does not exist in the local member data storage unit. .

Next, after transmitting the created search command to the central database system 11 (step 5), the system waits until the search result data is received from the central server 11a (step 6). The search result data will be described in detail later.

When the search result data is received from the central server 11a, the data update processing of the local member data storage means is performed based on the received search result data (step 7), and then the data update is successful. It is determined whether or not (step 8). If the data update is successful, the process returns from step 1 to step 3 from determination step 2 to create a component member list and end the process. If the data update fails, the process ends. This "data update failure" will be described later.

On the other hand, the central server 11a repeatedly executes the processing shown in FIG. That is, the central server 11a determines whether or not the search command has been received from the local server 13a (step 9), and when the search command has not been received, the processing ends.

When a search command is received from the local server 13a, the member number included in the search command is searched for in the central member data storage means based on the search command (step Ten),
The search result data as the search result is transmitted to the local database system 13 (step 11).

Here, the search result data is data including at least a member number, that is, if the member number exists in the central member data storage means, the member number and the member number. If the member data consists of the member name corresponding to, the member supplier, the customer member name, and the customer member number, and the member number does not exist in the central member data storage means (sent to the local side (Caused by an erroneous description of the member number in the order specification) is data including the member number and a code indicating that the member number does not exist. When the latter data is received, "data update failure" occurs in the processing step 8 of the local server 13a.

Next, the operation of the distributed database system of the present invention will be described more specifically. As shown in FIG. 5, the operator of the client 11c in the central database system 11 operates the central member data storage means when the customer or the sales office faxes the order receipt 1 in which only the member name and the number of points used are described. Material data stored in 2
Refer to to find the member number corresponding to the member name described in the order sheet 1, create another order sheet 3 consisting of the member number and the number of points used, and send it to the local side by FAX etc. . The operator of the client 13b in the local database 13 inputs the member number and the number of points used in the order form 3 from the keyboard 13b '(reference numeral 4: screen display of the client 13b). After this input, the member numbers 9000001 and 9000002 are searched for in the local member data storage means 5, and based on the search result (reference numeral 6: screen display of the client 13b), the members that do not exist in the local member data storage means. It is determined that there is a number, and the search command 7 is created for the member number 9000002 that does not exist. Then, the search command 7 is transmitted to the central database system 11, the central server 11a searches the central member data storage means 8 for the member number 9000002 based on the search command, and the member as the search result. Send data 9 to local database system 13. The local server 13a that has received this member data 9 updates the stored contents of the local member data storage means 5 based on the received member data. The constituent member list (see FIG. 3) is created based on the contents stored in the local member data storage unit 5 after the update.

Although the present invention has been described with reference to the embodiment in which the FAX is used for transmitting information between the customer / sales office and the central database system, the present invention is not limited to this, and FIG. Terminals 16 and 17 are installed at customers and sales offices as shown in Fig.
It is also possible to apply this embodiment to a distributed database system configured so that customers and sales offices can check inventory and place orders using terminals 16 and 17 by connecting to the central database system 11 via Those skilled in the art will understand that

[0029]

As described above, the present invention is configured to transmit the member data relating to the member identifier from the central database system to the local database system only when the member identifier which does not exist in the local database system is generated. Therefore, the local database system maintains the same latest database file as the central database system without causing a delay and increasing the communication cost even when using a communication line having a relatively low data transmission rate. Therefore, it is possible to reliably prevent a production error due to a difference in data between the central side database and the local side database.

[Brief description of drawings]

FIG. 1 is an explanatory diagram showing an outline of a distributed database system of the present invention.

FIG. 2 is a flowchart showing a process performed on a server of a local database system in the distributed database system of the present invention.

FIG. 3 is an explanatory diagram showing an example of a component member list created in step 3 of the flowchart of FIG.

FIG. 4 is a flowchart showing a process performed on the server of the central database system in the distributed database system of the present invention.

FIG. 5 is an explanatory diagram specifically showing the operation of the distributed database system of the present invention.

FIG. 6 is an explanatory diagram showing another embodiment of the distributed database system of the present invention.

FIG. 7 is an explanatory diagram showing an example of a conventional database system.

[Explanation of symbols]

 10 distributed database system 11 central database system 12 communication line 13 local database system 11a server 11b to 11f client 11c 'keyboard 13a server 13b to 13f client 13b' keyboard

 ─────────────────────────────────────────────────── ─── Continuation of the front page (72) Inventor Tomoharu Kadoma 2-1-3 Sumika-ku, Tokyo Bunhana 2-1-3 Kao Co., Ltd. (72) Inventor Kenichi Kasahara 2-1-3 Sumida-ku, Fumika Tokyo Kao Stock company research institute

Claims (2)

[Claims] 1. A distributed database system comprising a central database system and at least one local database system connected to the central database system via a communication line, wherein the central database system comprises central side data input means. The central side member data storage means for storing the member data including at least the member identifier input by, and all the member data stored in the central side member data storage means via the communication line, the local database system. A central member data transmitting unit for periodically transmitting the member data to the local database system, wherein the local database system receives the member data transmitted by the central member data transmitting unit via the communication line. Data receiving means and its Local member data storage means for storing all of the member data received by the local member data receiving means to form the same storage content as the central member data storage means, and input by the local data input means. And a local side member identifier searching means for searching the local side member data storage means for a member identifier included in the ordered material data based on the ordered material data including at least the member identifier, and the local side member identifier searching means. A local member identifier presence / absence determining unit that determines the presence or absence of the member identifier based on the search result, and a search for the member identifier when the local side member identifier presence / absence determining unit determines that the member identifier does not exist What is done to the side member data storage means is the central database system. System for creating a search command including the member identifier for instructing a system, and the search command created by the local search command creating means to the central database system via the communication line. A central side search command receiving means for transmitting the local side search command transmitting means, wherein the central database system receives the search command transmitted by the local side search command transmitting means via the communication line. Means, and a central side search command execution means for searching the central side member data storage means for the member identifier included in the search command in response to the search command received by the central side search command receiving means. , The search result data including at least the member identifier as the search result by the central side search command execution means Central side search result transmitting means for transmitting to the local database system via the communication line, and further, the local database system receives the search result data transmitted by the central side search result transmitting means. Local side search result receiving means, and local side member data updating means for updating the stored contents of the local side member data storage means based on the search result data received by the local side search result receiving means. A distributed database system characterized by the following. 2. A central database system and at least one connected to the central database system via a communication line such as a public telephone line having a relatively low data transmission rate.
A data processing method used in a distributed database system consisting of two local database systems,
In the central database system, the member data including at least the member identifier input by the central data input unit is stored in the central member data storage unit, and all the member data stored in the central member data storage unit. Periodically transmitted to the local database system via the communication line, and in the local database system, the member data transmitted from the central database system via the communication line is received and received All of the member data is stored in the local member data storage unit to form the same storage content as the central member data storage unit, and the ordered member data including at least the member identifier input by the local data input unit is obtained. Included in the order material data based on A search for a material identifier is performed on the local side member data storage means, the presence or absence of the member identifier is determined based on the search result, and if it is determined that the member identifier does not exist, the search for the member identifier is performed Creating a search command including the member identifier for instructing the central database system to perform the central member data storage means, and transmitting the search command to the central database system via the communication line; Further, in the central database system, the search command transmitted from the local database system via the communication line is received, and the search for the member identifier included in the search command is performed according to the received search command. At least the member identification as a result of the search performed for the central member data storage means Transmitting search result data including a child to the local database system via the communication line, and further receiving the search result data transmitted from the central database system via the communication line in the local database system. The data processing method further comprises the steps of updating the stored contents of the local member data storage means based on the received search result data.