JPH09198345A - Client/server system with data collection/delivery function - Google Patents

Abstract

PROBLEM TO BE SOLVED: To improve operability by managing and operating data at necessary timing and in necessary units for respective products and respective departments. SOLUTION: A general-purpose computer 10 contains data bases 11-14 having product information. A temporary server 20 contains a data transmission/ reception function 21 with the general-purpose computer, collection/delivery functions 22 and 23 on data for plural clients and a data dictionary 24. The clients 31, 41 and 51 contain data bases 32, 42 and 52 which can retrieve, register and update data at arbitrary timing. A client 60 contains the maintenance function of the data dictionary. The server 20 receives temporary data from the general-purpose computer 10, refers to the data dictionary 24 by using the collection/delivery functions 22 and 23 and distributes and collects data for the respectives clients. The clients retrieve, register and update data at arbitrary timing and transmit temporary data to the general-purpose computer.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a client for performing processing such as production management, accounting management, budget management and purchase management.
The present invention relates to a server system, and more particularly to a client-server system with a data collection / delivery function, which management is different for each product and each department.

[0002]

2. Description of the Related Art Conventional production management, accounting management, budget management,
A basic system including a general-purpose computer and a client that performs processing such as purchasing management will be described in detail with reference to the drawings.

As a technique close to the present invention, Japanese Patent Laid-Open No. 05-1
There is a technique described in Japanese Patent No. 81765. FIG. 4 is a block diagram showing this conventional example. According to this example, the system configuration and operation are as follows.

The general-purpose computer 110 is a database 111, 112, 113, 11 having information about products.
4, the distribution file 117 and the distribution file 11 consisting of data distributed to the clients 121, 131, 141
7 from the distribution registration processing unit 115, the collection file 118 including the data collected from the clients 121, 131 and 141, and the collection registration processing unit 116 for registering and updating the database from the collection file 118. Become. The registration and update processing of the database on the general-purpose computer 110 is performed once a day at a predetermined time using batch processing or the like at night.

Department A 120, Department B 130, Department C 14
A plurality of clients 121, 131, 141 existing in No. 0 and performing accounting management, budget management, purchasing management, etc. receive data distributed from the general-purpose computer 110 and perform data search, registration, and update. Clients 121, 13
Reference numerals 1 and 141 cause the general-purpose computer to collect the registered and updated data.

[0006]

The first problem is that the number of times data is updated on a general-purpose computer is fixed, so that in each business, data management such as data search, registration, and update is performed in real time. In the conventional system, the latest data cannot be searched, registered, and updated. For example, for a certain product, the data in the budget management database on a general-purpose computer is updated once a day.
The budget control department updates the budget control data five times a day,
If you want to search and use, you will not be able to search, register, or update the latest budget control data.

The reason is that the conventional system does not use a database specialized for each department or each product, but uses a database of a general-purpose computer that operates with a fixed data update frequency. Because.

The second problem is that since the number of data updates on a general-purpose computer is fixed, the registration and update of data in one department can be searched in real time by another department.
This is a point that cannot be registered or updated.

The reason is that the conventional system does not use a database specialized for each department or each product, but uses a database of a general-purpose computer that operates with a fixed data update frequency. Because.

A third problem is that, in the conventional system, when it is desired to search, register, and update only necessary data for each product and each department, for example, information about a specific product for a certain budget number. Is a point that cannot be dealt with when necessary.

The reason is that in the conventional system, the database is not specialized for each department and each product, but a general-purpose database having a fixed data structure is used.

It is an object of the present invention to provide a client-server system with a data collection / delivery function which improves operability by enabling management of data and operation in units required for each product and department. It is in.

[0013]

DISCLOSURE OF THE INVENTION The present invention is a system proposed to solve the above-mentioned problems, and includes a general-purpose computer, a server for temporary data connected to the general-purpose computer via a network, and a plurality of servers connected to the server. The data processing client and the data dictionary maintenance client connected to the server.

The general-purpose computer includes a database having product information. The temporary data server includes a data transmission / reception function with a general-purpose computer, a data collection / delivery function with respect to clients, and a data dictionary that holds the structure of each database, the relation of items between the databases, and data extraction conditions. Multiple data processing clients have different data units for each product and department.
Includes a database that allows you to search, register, and update data at any time.

The server receives the data in the same format from the database of the general-purpose computer. Next, the server refers to the data dictionary to the database of each data processing client, and distributes the data using the data distribution function. Next, each data processing client searches, registers, and registers data with the database of each data processing client at any time.
Perform an update. Next, each data processing client uses the data collection function to cause the server to collect the database registration / update results at the timing of data registration / update and update the temporary data. Next, at the timing of updating the temporary data, the server
The data dictionary is referred to the database of each data processing client, and the data is distributed using the data distribution function. Next, the server transmits the temporary data to the general-purpose computer at a fixed timing.

The data dictionary maintenance client updates the data dictionary of the server in accordance with the registration and update of the database structure of the general-purpose computer and the registration and update of the database structure of the data processing client.

[0017]

Next, embodiments of the present invention will be described with reference to the drawings.

FIG. 1 is a block diagram showing an embodiment of a client-server system with a data collection / delivery function according to the present invention. The client-server system 100 with a data collection / delivery function shown in FIG. 1 is a general-purpose computer, a general-purpose computer 10, a temporary server 20 connected to the general-purpose computer 10 via a network, and a domestic server 20 connected to the server 20 respectively. , Foreign budget management department 40, domestic manufacturing department 50 have clients 31, 4
1, 51 and a data dictionary maintenance client 60 connected to the server 20.

The general-purpose computer 10 includes a production management database 11 having various product information and a budget database 1.
2. Includes purchasing database 13 and accounting database 14. The budget database 12 is a database for holding budget information of a plurality of products existing for each product field such as “domestic mail” and “international mail”, and includes a budget number, a product field, a product name, a number of units, a delivery date, It has data 241 indicating the amount of money.

The temporary server 20 has a function 21 of transmitting / receiving data to / from the general-purpose computer 10, a data structure 241 of the databases 11, 12, 13, 14 of the general-purpose computer 10 and clients 31, 41, 51.
Data structure 24 of databases 32, 42, 52 owned by
2 and databases 11, 12, 13, 14 and 32,
A data dictionary 24 holding a relation 243 between data items held by 42 and 52 and a data extraction condition 244, a data collection function 22 for the clients 31, 41 and 51, and a data distribution to the clients 31, 41 and 51. It includes a function 23 and temporary data 25.

The client 31 of the domestic budget management department 30 is a database for holding data relating to budget information of individual domestic products, and includes a database 32 having budget numbers, product names, delivery dates, and amounts as data items.

The client 41 of the foreign budget management department 40 is a database for holding data relating to budget information of individual products for foreign countries, and includes a database 42 having budget numbers, product names, delivery dates, and amounts as data items.

Client 51 of domestic manufacturing department 50
Is a database for holding data related to manufacturing information of individual domestic products. Budget number, product name, number of units,
It includes a database 52 having a delivery date as a data item.

The client 60 is a client for maintenance of the data dictionary of the server, and the input device 6
Have one.

The data transmission / reception function 21 has a data dictionary 24.
Recognizing that the budget database 12 has data items such as budget number, product field, product name, number of units, delivery date, and amount of money, the data is received from the budget database 12 in the same format as the temporary data 25. obtain. Further, the temporary data 25 reflecting the data updated by each client is transmitted to the general-purpose computer 10 at a fixed timing such as once a day.

FIG. 2 shows a data distribution function 23 of the server.
Is shown.

At the timing when the temporary data 25 is updated, the server 20 extracts a record satisfying the extraction condition 244, “product field =“ domestic mail ””, that is, the record a11, from the records a11 and a12 which are temporary data. The data dictionary 24,
According to the correspondence 243 between the data 241 indicating the budget number, the product name, the delivery date, and the amount of money in the budget database 12 and the data 242 indicating the budget number, the product name, the delivery date, and the amount of money in the database 32, it is converted into the record a2 and stored in the database 32. Distribute.

Further, record a11 and record a1
A record satisfying the extraction condition 248 “product field =“ international mail ””, that is, the record a12 is extracted from 2 and the budget number of the budget database 12, the product name, the delivery date, and the amount described in the data dictionary 24 are extracted. Data 245 and the database 42 budget number, product name, delivery date,
According to the correspondence 247 with the data 246 indicating the amount of money, the record a3 is converted and distributed to the database 42.

Further, record a11 and record a1
A record satisfying the extraction condition 24c "product field =" domestic mail ", that is, the record a11 is extracted from 2, and the budget number, product name, number of units, delivery date of the budget database 12 described in the data dictionary 24 are extracted. 249 showing the data, the budget number of the database 52, product name, number of units,
According to the correspondence 24b with the data 24a indicating the delivery date, it is converted into the record a4 and distributed to the database 52.

In this way, the data distribution function 23 has a relationship between the data structure of the budget database 12 of the data dictionary 24 and the data structure of the database of each data processing client at the timing when the temporary data 25 is updated. By referring to the data extraction condition, the record of the temporary data 25 is converted into the data of the record satisfying the condition and distributed to the database 32, 42, 52.

By distributing the temporary data 25 to the respective databases 32, 42 and 52, the respective data processing clients 31, 41 and 51 in the respective departments 30, 40 and 50 have the general-purpose computer 10 operate.
Each product, without being bound by the data update frequency of
Data can be searched, registered, and updated in real time for each department.

Furthermore, since the temporary data is distributed to each of the databases 32, 42 and 52 in an appropriate format, the data can be managed in units different for each product and each department.

FIG. 3 shows a data collection function 22 of the server.
Is shown.

The server 20 refers to the data dictionary 24 and understands that the database 32 has data items 242 indicating budget number, product name, delivery date, and amount of money,
Data is collected when the database 32 is updated. From the record b2 collected from the database 32, the budget number, product name,
The correspondence 243 between the data 241 indicating the delivery date and the amount of money and the data 242 indicating the budget number, product name, delivery date and the amount of money in the database 32 is obtained from the data dictionary 24, and the record b11 is registered or updated.

The server 20 also understands the data structure of the database 42 and the database 52 by referring to the data dictionary 24, and updates the temporary data 25 at the timing when the databases 42 and 52 are updated.

As described above, in the data collecting function 22, the databases 32, 42 and 52 of the client 31 of the domestic budget management department 30, the client 41 of the foreign budget management department 40, and the client 51 of the domestic manufacturing department 50 are updated. Each database 32, 4 at the timing
From the data 2, 52, the data is collected in the server 20, and then the relationship between the data items in the data dictionary 24 is referenced to extract and convert the data having the same budget number from the collected data. Then, the temporary data 25 is updated.

By the data distribution function 23 and the data collection function 22 described above, each data processing client 31,
The temporary data 25 is updated at the timing when the databases 32, 42, 52 in 41, 51 are updated, and the data is distributed to the data processing clients 31, 41, 51. It is possible to search and use in real time.

The client 31 of the domestic budget management department 30 retrieves the budget information of domestic products from the database 31 at any time without being restricted by the data update frequency and data structure of the general-purpose computer 10.・ It is possible to register and update.

Further, the data distribution function 23 allows the client 31 to distribute only necessary data for each product and each department, and can easily perform search, registration, and update.

Further, the client 31 uses the data collection function 22 and the data distribution function 23 to reflect the data changes made by the clients of other departments in the database 32 in real time. It is possible to search and update the data reflecting the.

The same processing can be performed for the client 41 owned by the foreign budget management department 40 and the client 51 owned by the domestic manufacturing department 50.

The client 60 is a general-purpose computer 1.
0 and update of the data dictionary 24 of the server when the items of the databases 32, 42, 52 of the clients 31, 41, 51 are changed, the databases are added, the correspondence of the data items is changed, and the like. . As a result, the general-purpose computer 10 and each client 31,
Data transmission / reception, collection, even when an item in each database 32, 42, 52 of 41, 51 is changed, a database is added, or a correspondence relationship of data items is changed,
Allows distribution.

[0043]

The first effect is that, without being restricted by the data update frequency of the database of the general-purpose computer,
It is possible to manage data in real time for each product and each department.

The reason is that in the present invention, a database for searching, registering, and updating data exists in each client, and the database of each client can perform data management in real time.

The second effect is that data registration and update results in one department can be searched, registered, and updated in real time in another department without being bound by the data update frequency of the database of a general-purpose computer. This is a possible point.

The reason is that, in the present invention, the data collection function and the data distribution function collect data at the timing when the database of each data processing client is registered and updated, and the update result of temporary data is displayed as Since the data is distributed to the processing clients, the data registration and update results in one department can be searched, registered, and updated in another department in real time.

The third effect is that data management can be performed in units different for each product and each department, and unnecessary data items and records relating to a certain product or a certain department that a general-purpose computer has are not used. It is easy to register, update and search data.

The reason is that, in the present invention, a database for searching, registering, and updating data exists in each client, and the database of each client has a different management unit for each product and each department.

[Brief description of drawings]

FIG. 1 is a configuration diagram of an embodiment of the present invention.

FIG. 2 is a work configuration diagram showing a detailed configuration of a data distribution function in FIG.

3 is a work configuration diagram showing a detailed configuration of a data collection function in FIG. 1. FIG.

FIG. 4 is a configuration diagram showing a conventional example.

[Explanation of symbols]

100 Client-Server System with Data Collection / Distribution Function 10 General-purpose Computer 11 Production Management Database 12 Budget Database 13 Purchasing Database 14 Accounting Database 20 Server 21 Data Transmission / Reception Function 22 Collection Function 23 Distribution Function 24 Data Dictionary 25 Temporary Data 241 Data 242 Data Structure 243 Relationship between data items 244 Extraction conditions 30 Domestic budget control department 31 Client 32 Database 40 Foreign budget control department 41 Client 42 Database 50 Domestic manufacturing department 51 Client 52 Database 60 Client 61 Input device

Claims (3)

[Claims] 1. A plurality of clients, each of which holds an individual database for each product or department of each department, and a data transmission / reception function with the general-purpose computer, which is provided between the general-purpose computer and the client, which is a core system. A client-server system consisting of a temporary server that holds the data distribution function to each client and the data collection function from each client. 2. The general-purpose computer includes a database having product information, and the server has a function of transmitting / receiving data to / from the general-purpose computer, a function of collecting / delivering data to / from a client, and a structure of each database and between the databases. A database that includes a data dictionary that holds the relationship between items and data extraction conditions. The data processing units of multiple data processing clients are different for each product and department, and it is possible to search, register, and update data at any time. The client-server system according to claim 1, further comprising: 3. The server receives data in the same format from a database of a general-purpose computer, refers to the data dictionary to the database of each data processing client, and distributes data using a data distribution function. Each of the data processing clients searches, registers, and updates data in the database of each of the data processing clients at an arbitrary timing, and each of the data processing clients has a data collection function. Using the above, the database registration and update results are collected by the server at the time when the data is registered and updated, and the temporary data is updated.
At the timing when the temporary data is updated, with respect to the database of each of the data processing clients, the data dictionary is referred to, the data is distributed using the data distribution function, and at a predetermined timing,
The temporary data is transmitted to the general-purpose computer, and the data dictionary maintenance client registers or updates the database structure of the general-purpose computer or the database structure of the data processing client in response to the registration or update of the database structure of the server. 3. The client according to claim 2, wherein the data dictionary of the client is updated.
Server system.