JPH08137734A - Distribution method for information processing system and data base - Google Patents

Abstract

PURPOSE: To provide the distribution method of an information processing system and a data base by which the processing operation of data can effectively be executed in any processings. CONSTITUTION: The small-scaled information processors 12, 13 and 14 of a personal computer are connected with personal computer LAN 18. The data bases 15, 16 and 17 are arranged by distributing data in such a way that the items of the distinction of sex, and qualification become uniform in any data base in the respective information processors 12, 13 and 14. At the time of processing data, the processing is executed in the respective information processors 12, 13 and 14, and a processed result is unified and displayed on one information processor 12.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an information processing system and a database distribution method, and more particularly to an information processing system and a database distribution method for searching and processing data stored in a database. In computer systems in recent years, due to downsizing and opening, systemization by personal computers and UNIX workstations has rapidly become widespread.
Among them, the technological innovation of personal computers and the spread of Windows in Japan are particularly remarkable. For this reason, it has become possible to construct relatively complex processing, which was conventionally performed by a general-purpose machine or an office computer, on a personal computer.

Since relatively simple processing (for example, slip input processing) has been mainly performed in a personal computer or the like, online processing for accessing a database by inputting / outputting from a screen is very useful. It is not suitable for large-scale batch processing that has been performed on general-purpose machines and office computers. Therefore, in the future, it is necessary to have a system mechanism that can perform large-scale batch processing and relatively complicated processing on personal computers.

[0003]

2. Description of the Related Art Conventionally, for example, a personnel database that stores information such as gender and qualifications of employees for carrying out processing such as salary calculation is collectively managed by a relatively large computer. As usage patterns, so-called random processing such as personal inquiry to access with specific key items, so-called search processing to access in a narrow range such as general-purpose search, so-called sequential processing to access all data such as payroll calculation, etc. Processing was being performed.

[0004]

However, the conventional information processing system generally uses a large-sized computer. Therefore, its processing form is also adapted to batch processing for processing a large amount of data such as payroll calculation. Is designed and
It is not possible to exert its ability sufficiently with random processing and search processing,
There were problems such as a lot of waste.

The present invention has been made in view of the above points, and it is an object of the present invention to provide an information processing system and a database distribution method capable of effectively processing data in any processing.

[0006]

[Means for Solving the Problems] A plurality of information processing means 1 _-1
1- _n are connected by the network 2 and process data. The plurality of databases 3 _{-1 to} 3 _-n are distributed and arranged in the plurality of information processing means, and the data is divided so that the contents of the data are even.

The plurality of information processing means 1 _-1 to 1 _-n are operated in parallel to process the data stored in the plurality of databases. According to a second aspect of the present invention, a processing condition is input from a predetermined information processing means of the plurality of information processing means, and a result according to the processing condition is output, and the predetermined information processing means performs the processing. The plurality of information processing means are requested to perform a process in accordance with the condition, a predetermined result is waited for by the plurality of information processing means, and the request is canceled when the predetermined result is obtained. When the predetermined result exists, the result is transmitted to the predetermined information processing means.

According to a third aspect of the present invention, the data is sorted for each search item, and the sorted data is distributed and stored in the plurality of databases for each search item.

[0009]

According to claim 1 of the present invention, since data processing of a plurality of databases can be performed in parallel by a plurality of information processing means, it is possible to perform a sequential process for performing processing on all data at high speed. Since the contents of the data stored in the plurality of databases are also uniform, even if the random processing or the search processing for searching and extracting the data of the predetermined condition is performed, all the plurality of information processing means are It is possible to operate uniformly, and therefore, the response of all processes of the forward process, the random process, and the search process can be made uniform.

According to the second aspect, the information processing means for requesting the processing cancels the request after the processing request and when a predetermined result corresponding to the processing condition is obtained, the results from all the information processing means There is no need to wait, and if there is no information that meets the requested conditions even on the side of the information processing means requested to process, the result indicating that there is no information is not sent to the information processing means that requested the processing. , The result waiting time can be shortened,
The processing speed can be increased.

According to the third aspect, since the data in the plurality of databases are sorted for each search item and the data are distributed and stored in the plurality of databases for each item, the data is generated. Since the data of each item is included in the data, it is possible to make the data substantially uniform in each of the data items in the plurality of databases. Processing can be performed.

[0012]

FIG. 2 shows a block diagram of an embodiment of the present invention. The information processing system 11 of the present embodiment includes a first information processing device 12, a second information processing device 13, a third information processing device 14, first, second and third information processing devices 12, 1.
Databases 15 and 1 distributed in 3 and 14
6,17, first, second, third information processing device 12, 1
It is composed of a local area network (LAN) 18 which connects 3 and 14.

First, second and third information processing devices 12, 1
Reference numerals 3 and 14 denote personal computers or UNIX workstations having a system configured with a multi-programming function or a multi-processor system, which are capable of simultaneously processing a plurality of tasks, that is, so-called multi-task data processing. The first, second, and third information processing devices 12, 13, and 14 have databases 15, 16, and 17 respectively.
Are distributed and arranged. Database 15,1
Personnel management data is stored in files 6 and 17, for example.

Personnel management data includes employee number, gender, qualification,
It is composed of data such as clerk. Database 15,1
6 and 17, the data are distributed and arranged so that the contents such as sex, qualification, and the like that compose the data are equalized by a method described later. Next, the general-purpose search processing according to the embodiment of the present invention will be described. 3 and 4 show flowcharts of general-purpose search processing. FIG. 3 is a flowchart of a search process of the information processing apparatus that gives a search instruction and obtains a result, FIG.
Shows a flowchart of another information processing apparatus.

Here, it is assumed that the first information processing apparatus 12 is used to instruct the general-purpose search processing and display the results. First, the general-purpose search expression is input to the first information processing apparatus 12 (step S1 _-1), online JOB12a is subjected generic search expression, and instructs the search to search the management JOB12b (step S1 _-2).

Search management JOB 12b is an online JOB
When receiving the search instruction from 12a, the JOB of the execution of the own terminal
12c and another terminal execution JOB13c, do a search instruction to the search corresponding to the instructed search expression is performed for 14c (step S1 _-3). Execution JOB1 of own terminal
When a search instruction is issued from the search management JOB 12b, 2c reads data from the database 15 of its own terminal,
A search is executed (step _S1-4 ).

The execution JOB12c After search end, and supplies the results performs processing of aggregate such as search administration JOB12b (Step S1 _-5). Here, in the case of a so-called random process of searching for one specific information such as a search for the information of a specific employee from the databases 15, 16 and 17, the search management JOB 12b receives the information to be received. Since there is only one, waiting for reception of one information, execution JOB1 of the first to third information processing devices 12, 13, 14
When the information is provided from any one of 2c, 13c, and 14c, it is determined that the result is obtained, the result is edited, the online JOB 12a is started, and the result is displayed on the screen (step S1. _-6 , S1 _-7 ). At this time, the first
Thru the execution JOB of the third information processing device 12, 13, 14
When there is no corresponding information in 12c, 13c, and 14c, the result is not transmitted to the search management JOB 12b as described later.

Further, so-called retrieval processing for retrieving information that meets a specific condition, such as retrieving an employee having a specific history, and so-called forward processing for performing processing on all information, such as salary calculation. In case of, search management JOB12
b receives the results from the execution JOBs 12c, 13c, 14c of the first to third information processing devices 12, 13, 14 and then compiles and edits the results and activates the online JOB 12a to display the results on the screen. (Steps _S1-6 , S
_1-8 ).

Next, the second and third information processing devices 13 and 14
The processing in step will be described. The first and second information processing devices 1 and 14 issue a search instruction in the second and third information processing devices 13 and 14.
When the second search management JOB12b is search processing request via the LAN 18, executes JOB13c, 14c receives this (step S2 _-1). Execution JOB 13c, 14
When c receives the search processing request supplied from the search management JOB 12b via the LAN 18, the data is read from the databases 16 and 17 arranged in the respective devices (step S2 _-2 ) and input by the first information processing device 12. A search or process is executed according to the retrieved search formula (step S2).
_-3 ).

Here, if the processing requested by the search management JOB 12b of the first information processing apparatus 12 is irregular processing, if there is information, the information is edited and the first information processing apparatus is connected via the LAN 18. 12 to the search management JOB 12b, and if the information does not exist in the databases 16 and 17, the process is terminated as it is, and the result is not transmitted to the search management JOB 12b of the first information processing apparatus 12 (step S2). _{-4 to} S2 _-7 ).

Further, in the case of a search or a forward process other than the random process, a process according to a search formula or the like is performed, the result is edited regardless of the presence or absence of information, and the search management of the first information processing unit 12 is performed. and transmits the JOB12b (step S2 _-4, S
_2-6 , _S2-7 ). Next, data is stored in three databases 1
A method of evenly distributing to 5, 16, and 17 will be described.

FIG. 5 shows a diagram for explaining a method of distributing data to the databases 15, 16 and 17. Here, for example, data such as gender and qualification of 3000 employees is 3
A method of distributing the data to one database 15, 16, 17 will be described. First, the data of 3000 persons gender, qualification A~D sorted separately, to create a single database (step S3 _-1).

Next, the data classified into sex and qualifications A to D are stored in three databases 15, 16 and 17, respectively.
Each dispersed distributes the name (step S3 _-2). As a result of the above, the three databases 15, 16 and 17 have sex,
The employees of qualifications A to D are stored in a substantially evenly distributed manner. As described above, according to this embodiment, since the data processing of the database can be performed in parallel by the first to third information processing means, the sequential processing of processing all the data can be performed at high speed, and the database 15 can be processed. Since the contents of the data stored in Nos. 16, 16 and 17 are also uniformed, a plurality of information processing means can be used even when performing a random process or a search process of searching and extracting and processing data of conditions such as sex and qualification. Can be operated evenly, and the response can be made uniform until results are obtained by different processing such as random processing, search processing, and forward processing, which enables effective use of each information processing device. Therefore, personal computers and UNI
By using a relatively small-scale information processing means such as an X workstation, it is possible to construct a system that can perform data processing efficiently at low cost.

Further, according to the present embodiment, the search management JOB12 of the first information processing apparatus 12 which requests the processing at the time of the irregular processing.
b is an execution JOB 12 of each information processing device 12, 13, 14
After requesting the processing to c, 13c, 14c, the request is canceled when a predetermined result corresponding to the processing condition is obtained from any of the execution jobs 12c, 13c, 14c of the respective information processing devices 12, 13, 14. , All information processing devices 12, 13, 1
It is not necessary to wait for the results from the execution jobs 12c, 13c, 14c of No. 4 and the execution jobs 12c, 13c, 14c of each of the information processing devices 12, 13, 14 requested to be processed.
If there is no information that meets the requested conditions on the side as well, the search management JOB12 of the first information processing apparatus 12 that requested the processing
Since the result indicating that there is no information is not transmitted to b, the result waiting time can be shortened and the processing speed can be increased.

[0025]

As described above, according to claim 1 of the present invention, since data processing of a plurality of databases can be performed in parallel by a plurality of information processing means, sequential processing is performed for all data. Since the contents of the data stored in multiple databases are uniform, even if random processing or search processing is performed to search for and extract data of specified conditions, multiple data can be processed. The information processing means can be operated uniformly, and the response of all processes can be made uniform. Therefore, using a relatively small-scale information processing means such as a personal computer or a UNIX workstation, at low cost, In addition, it has features such as being able to construct a system that can effectively perform data processing.

According to the second aspect, since the information processing means for requesting the processing cancels the request after the processing request, when the predetermined result according to the processing condition is obtained, the results from all the information processing means are processed. There is no need to wait, and if there is no information that meets the requested conditions even on the side of the information processing means requested to process, the result indicating that there is no information is not sent to the information processing means that requested the processing. , The result waiting time can be shortened,
It has features such as high-speed processing.

According to claim 3, the data is generated by sorting the data in a plurality of databases for each search item and then distributing and storing the data for each item in the plurality of databases. The data for each item will be included, and the data can be approximately even in multiple databases for each item of data, thus
When the data processing is performed, each information processing unit can perform the processing evenly, and the data processing can be made uniform.

[Brief description of drawings]

FIG. 1 is a principle diagram of the present invention.

FIG. 2 is a block diagram of an embodiment of the present invention.

FIG. 3 is a flowchart of search processing according to an embodiment of the present invention.

FIG. 4 is a flowchart of search processing according to an embodiment of the present invention.

FIG. 5 is a diagram illustrating a database creation processing method according to an embodiment of the present invention.

[Explanation of symbols]

1 _-1 to 1 _-n information processing means 2 network 3 _{-1 to} 3 _-n database 11 information processing system 12, 13, 14 information processing device 12a, 13a, 14a online JOB 12b, 13b, 14b search management JOB 12c, 13c , 14c Execution JOB 15,16,17 Database

Claims (3)

[Claims] 1. A plurality of information processing means connected by a network for processing data, and a plurality of data processing means arranged in a distributed manner among the plurality of information processing means, the data being divided so that the contents of the data are equalized. An information processing system, characterized in that it processes data stored in the plurality of databases by operating the plurality of information processing means in parallel. 2. A processing condition is input from a predetermined information processing means of the plurality of information processing means, and a result according to the processing condition is output, and the predetermined information processing means is Requesting the plurality of information processing means to perform processing according to processing conditions, waiting for a predetermined result from the plurality of information processing means, canceling the request when the predetermined result is obtained, The information processing system according to claim 1, characterized in that when the predetermined result exists, the result is transmitted to the predetermined information processing means. 3. The information processing system according to claim 1, wherein the data is sorted for each search item, and the sorted data is distributed and stored in the plurality of databases for each search item. Database distribution method.