JPH10340239A - Information exchanging method of client server system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an information exchange method of a client server system that reduces the ability load in information exchange between a server computer and a client computer and that can easily change and extend the system. SOLUTION: The ability load in information exchange between the client computer 21 and the server computer 28 can be reduced by using individual management programs in the retrieval or reference processing of data and the other job processing of storage and update. A user program 22 and a job processing program 33 can exchange information only by outputting some functions required for access programs 25 and 30. Then, the programs can easily be corrected and generated even if a data base 34 is changed or added and the user program 22 and the job processing program 33 are changed.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an information exchange method between a server computer and a client computer based on the processing in a client-server system in which a server computer processes a processing request from a client computer.

[0002]

2. Description of the Related Art In recent years, a plurality of computers have been connected by communication means and a server storing common information and data has been provided in order to increase the efficiency of work, share information, and promote utilization of information assets. Client / server systems that connect the server to communication means and perform business processes such as searching, referencing, storing, and updating various types of information and data have been increasingly used.

In order to carry out the above-mentioned business processing such as data search, reference, storage and update in these client / server systems, information data is transmitted between the client computer and the server computer via communication means. Exchange is essential, but the content of the processing is mainly search and reference processing to send necessary information data stored in the server computer to the client computer, and storing new data or various types of data stored in the past. It can be distinguished into business processes such as storing and updating data and the like.

Conventionally, in these client-server systems, when processing data processed on the client computer side is stored and updated in the server computer, if a failure of the communication means occurs,
When there is a plurality of client computer data and server computers, especially a plurality of server computers, there is a possibility that data having consistency arranged in each server may be different data, and the entire system may become inoperable. For this reason, a method of exchanging information between a server computer and a client computer which has increased redundancy so as to be able to cope with the above-mentioned problem is used.

[0005]

However, in the above-mentioned conventional information exchange method, it is necessary to perform complicated processing and control of communication means in order to increase redundancy, and thus a large load is imposed on a computer. Yes,
When many client computers access the same server computer at the same time, the processing load becomes too large, and even when searching and referencing data in the server computer, the processing results are not sent to the client computer. This requires a lot of time, and in the worst case, the server computer goes down.

In a conventional client-server system, in order to exchange information between a client computer and a server computer, a processing program for exchanging information between a client and a server for each program for performing various business processes. In addition, it is necessary to prepare a separate processing program for each type of information to be exchanged and each type of hardware.

Therefore, in order to construct a new client / server system, it is necessary to create a large number of programs for each type of processing performed by the server computer and for each type of OS, and each program is complicated as described above. These programs require a great deal of labor to create them, and when adding or changing functions or adding or changing a database, it is necessary to add or modify a large amount of programs. There is a problem that the system cannot be changed or expanded.

Further, once a request to start data processing is issued from the client computer, a processing program for exchanging the information is started in the server computer, and the operator leaves the seat during the data processing request, or changes the program. In the case of forced termination, etc., the started processing program for exchanging the information continues to run unless the client computer side issues a processing end request, and becomes an unnecessary load on the server computer, resulting in a response of the server computer. Has the problem of lowering

Therefore, the present invention reduces the capability load in exchanging information between the server computer and the client computer, and does not require individual programs to be created according to the types of application programs and OSs for performing various business processes. It is an object of the present invention to provide a client / server system information exchange system that can change or expand the system.

[0010]

In order to solve the above-mentioned problems, an information exchange method of a client-server system according to the present invention provides a method of communicating between a server computer having at least one server function and at least one client computer. In the server computer and the client computer, based on various processing requests such as business processing such as data search, reference, storage and update from the client computer, the server computer requests this In a client-server system for performing various processes performed and returning the processing results to the client computer, a management program for managing data exchange between the server computer and the client computer is provided, And search or browse processing procedure over data, in the processing procedure of the business process such as other storage and updating, and wherein each using a separate said management program. According to this feature, in the data search or reference processing and the other processing such as business processing such as storage and update, by using the separate management programs, the data search or reference processing is temporarily performed. Even if a failure occurs in the communication means, the whole system does not go down, so that the management program does not require complicated processing, and thus the processing load is reduced, so that the server computer Capability load in exchanging information with the client computer can be reduced.

[0011] In the information exchange method of the client-server system according to the present invention, the management program outputs a function associated with various processing instructions on the server computer. It is preferable that the processing program includes a server access program on the server computer that executes various processing instructions on the server computer corresponding to the various functions or outputs the various functions. By doing so, the application programs (hereinafter referred to as “user programs”) that perform various business processes used on the client computer side and the business processing programs used on the server computer are common to both the server computer and the client computer. The information exchange can be performed only by causing the access program provided in the computer to output the necessary functions associated with the various processing instructions, and the user program and the business processing program that perform various business processes can exchange information. It is possible to eliminate the necessity of individually creating the programs, and even if the database is changed or added or the user program or the business processing program is changed, the program can be easily modified or created.

According to the information exchange method of the client-server system of the present invention, the information to be transmitted to the server computer by the client access program is O.
S and sends it separately to a header section including the type of code system of data dependent on S, a data type, and a transmission data length, and a data section including actual data such as the processing request item. Preferably, the access program converts the actual data into a data format corresponding to the OS of the server computer based on the information in the header section and outputs the data. By doing so, in the access program for exchanging information between the client computer and the server computer, it is not necessary to separately create a program for information exchange for each type of OS or hardware type. Even if the database is changed or the business processing program is changed, the program can be easily changed.

According to the information exchange method of the client-server system of the present invention, a communication monitoring program for constantly monitoring a communication connection request from the client access program is provided on a server computer. The server access program is started based on a connection request, and if no information is sent from the client access program for more than a preset time, the server access program is automatically terminated. It is preferable to be able to do so. With this configuration, it is possible to prevent the server access program from being activated more than necessary, and as a result, it is possible to reduce the capacity load of the server computer in information exchange.

[0014]

Embodiments of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram of a first embodiment showing a basic processing flow in data retrieval / reference processing in a client / server system according to the present invention, and FIG. 2 is a client / server system according to the present invention. FIG. 9 is a block diagram of a second embodiment illustrating a basic processing flow in business processing such as data update.

In the present invention, as shown in the above figures,
In addition to managing data exchange in the data search / reference processing between the client and the server, a DB (database) access processing program as each access program on the client computer and the server computer for outputting various processing functions, and data storage and updating A business access processing program is used in each of the client computer and the server computer as an access program on the client computer and the server computer that outputs various processing functions and manages data exchange in the business processing. Processing is performed according to procedures.

First, in the data search / reference processing, the DB access processing programs 3 and 4 are prepared in the client computer 1 and the server computer 2, respectively.
For the client computer 1 and the server computer 2, the environment variables are set to the Japanese code system and the byte order (the method of expressing integers and real numbers in the computer differs depending on the hardware and OS). The user program 5 of the client computer 1 passes the name of the database to be processed and the processing method to the DB access processing program 3.

The DB access processing program 3 of the client computer 1 checks whether communication with the server computer 2 has been established. If the connection has not been established, the server computer 2 that constantly monitors the communication connection request from the client computer 1
A connection request is made to the communication daemon 6 which is a communication monitoring program of the communication.

Thus, the D of the server computer 2
The B access processing program 4 is started by the communication daemon 6.

The DB access processing program 3 of the client computer 1 obtains the information of the Japanese code system (SJIS, EUI, etc.) and the format of byte order (upper byte prefetch, lower byte prefetch, etc.) from the environment variables and transmits the information. (1) Japanese code system and type of byte order format, and (2) Data type (integer, number of characters, characters, etc.)
And (3) a transmission data length and (4) a database name to be processed on the server computer side, a header part of ASCII characters including a header part and a data part including actual data, and a DB access processing program of the server computer 2. Send to 4. This transmission process uses TCP / IP socket communication, and API (Application).
This is performed by using a program interface, and can be performed by common processing without depending on the type of the program or the OS.

The DB access processing program 4 of the server computer 2 converts the received information into data that can be handled by the server computer 2, performs a requested search / reference process on the data from the data, and transmits the data to the client computer. 1 to the DB access processing program 3. Then, the DB access processing program 3 passes the result to the user program 5.

By a series of these procedures, the search and reference of the database from the client computer can be realized.

Next, in the business process such as updating data, first, the business access processing program 1 is stored in the client computer 11 and the server computer 12.
3 and 14 are prepared respectively.

In the client computer 11 and the server computer 12, a Japanese code system and a byte order format are set as environment variables. The user program 15 of the client computer 11 passes the name of the program to be processed and the parameters to the business access processing program 13.

The business access processing program 13 of the client computer 11
Check whether communication with the second has been established. If the connection has not been established, the client computer 11
A connection request is made to the communication daemon 16 of the server computer 12 which constantly monitors the communication connection request from the server computer 12.

Thus, the business access processing program 14 and the business processing program 17 of the server computer 12 are started by the communication daemon 16.

The business access processing program 13 of the client computer 11 acquires the Japanese code system and the byte order format from the environment variables and transmits the information to be transmitted to (1) the Japanese code system (SJIS, EUI, etc.). And the type of byte order (high-order byte look-ahead, low-order byte look-ahead, etc.), (2) data type (integer, number of characters, characters, etc.), (3) transmission data length, and (4) program name to be processed on the server computer side And (5) the header part of the ASCII character including the processing database name and the data part including the actual data, which are transmitted to the business access processing program 14 of the server computer 12. This transmission process uses TCP / IP socket communication,
This is performed using an API, and can be performed by a common procedure without depending on the type of the program, the OS, and the like.

The business access processing program 14 of the server computer 12 converts the received information into data that can be handled by the server computer, passes the requested processing from the data to the business processing program 17, and the business processing program 17 It performs processing such as updating data in the server. The business access processing program 14 of the server computer 12 receives the result from the business processing program 17 and returns the result to the business access processing program 13 of the client computer 11. Then, the business access processing program 13 passes the result to the user program 15.

The business process from the client computer is executed by these series of procedures.

The DB access processing program 4 and the business access processing program 14 constantly monitor the reception time of information from the client computer, and information is transmitted from the client computer even after a set time. If not, terminate the program.

The DB access processing program 3 and the business access processing program 13 of the client computer
When transmitting information, first checks whether communication with the server computer has been established. If the connection is broken, the communication daemon 6, 1
6 is requested to reconnect, and communication is established. At this time,
User programs 5, 15 and business processing program 17
Does not require any processing. All processing is performed between the DB access processing program 3 or the business access processing program 13 of the client computer and the communication daemons 6 and 16 of the server computer.

By these processes, unnecessary execution of the business processing program 17 on the server computer can be restricted.

Next, a third embodiment of the present invention will be described with reference to FIG.

The user of the client computer 21 selects an item to be processed according to the menu displayed on the monitor screen 23 by the user program 22.
For example, it is assumed that the search / reference processing of employee information is selected. An instruction field 24 is displayed on the monitor screen 23 so as to input an employee number. The user enters the employee number whose information he / she wants to refer to.

The user program 22 receives the employee number (S1), checks the name of the database in which the information is stored, and sets a function for starting use of the database as a client access program provided with a function in a dynamic library format. The processing execution is requested by calling it from the DB access processing program 27 which is one of the 25 (S2).

The DB access processing program 27 checks whether communication with the server computer 28 has been established. If the communication is not established, the communication daemon 29 of the server computer 28 is requested to establish the communication (S3), and the communication daemon 29 calls the DB access processing program 31 which is one of the server computer access programs 30. Upon activation (S4), communication is established.

The DB access processing program 27 of the client computer 21 obtains the Japanese code system and the byte order format of the client computer 21 from the environment variables, and obtains the Japanese code system and the byte order format and the data to be transmitted. ASCII including type and size of database and database name processed by server computer
The header part of the character and the data part including the actual data such as the employee number are transmitted to the DB access processing program 31 (S5).

The DB access processing program 31 acquires the Japanese code system and the byte order format of the server computer 28 from the environment variables, first recognizes the data in the header part of the received data, and If the code system and the byte order format are different, the received actual data is converted into a code that can be handled by the server computer according to the type and size of the data in the header (S6). FIG. 4 shows the procedure, and FIG. 5 shows the contents of the data in the header section.

Subsequently, the DB access processing program 31
Is a database 34 based on the converted actual data.
(S7), and the result is returned to the DB access processing program 27 of the client computer 21 (S8).

The DB access processing program 27 returns the received result to the user program 22 (S9). Thus, the database 34 called from the user program 22
The start function ends.

Table 1 shows an embodiment of the function for the above processing.

[Table 1]

Subsequently, when searching for employee information,
When the information retrieval function is called from the user program 22, (S2) → (S5) → (S6) → (S7) →
The search is performed in the order of (S8) → (S9), and the search result is returned to the user program. Thereafter, the user program displays the result on the screen 1 (S10).

When there are a plurality of databases,
The above processing is performed by the number of databases by the user program 22, and the obtained information is processed and displayed on the screen 1.

Next, a description will be given of a procedure in a business process such as data update performed subsequent to the data search / reference operation.

The user of the client computer 21 selects an item to be processed from the menu displayed on the screen 23 by the user program 22. For example, it is assumed that the business process program of the employee's business trip instruction referred to above is selected. In the menu on the screen, an instruction column 2 for inputting information such as a business trip period, a business trip location, and travel expenses.
4 is displayed. The user inputs information according to the menu.

The user program 22 receives the input information (S11), checks the name of the business processing program in the business trip instruction, and finds a function for starting the processing for client access, provided with a function in a dynamic library format. Execution is requested by calling from a business access processing program 26 which is one of the programs 25 (S1).
2).

The business access processing program 26 checks whether communication with the server computer 28 has been established. If the communication is not established, the communication daemon 29 of the server computer 28 is requested to establish the communication (S13), and the communication daemon 29 activates the business processing program 33 (S14) and starts the server access program 30. One of the business access processing programs 32 is started (S15), and communication is established.

The business access processing program 26 acquires the Japanese code system and the byte order format of the client computer 21 from the environment variables, and obtains the Japanese code system and the byte order format, the type and size of the data to be transmitted. A header part including the name of a program to be started on the server computer 28 and a database name to be processed, and a data part including actual data such as the business trip period are stored in the business access processing program 32 of the server computer 28.
(S16).

The business access processing program 32 obtains the Japanese code system and the byte order format of the server computer 28 from the environment variables, first recognizes the data in the header part of the received data, and If the word code system and the byte order format are different, the received actual data is converted into a code that can be handled by the server computer 28 according to the type and size of the data in the header (S17). This procedure is performed by the method shown in FIGS.

Subsequently, the business access processing program 32
Sends the converted actual data to the business processing program 33 that performs the processing (S18), and the business processing program 33 adds the requested employee information or business trip information,
In addition to processing such as update and deletion (S19), processing such as calculation of travel expenses / expenses and requesting payment of travel expenses / expenses is performed, and the processing results are passed to a function that returns processing results (S20).

The business access processing program 32 returns the processing result received from the business processing program 33 to the business access processing program 26 (S21).

The business access processing program 26 returns the received result to the user program 22 (S22). Thus, the function of executing the business processing program called from the user program 22 ends.

Table 2 shows an embodiment of a function for executing business processes such as addition, update, and deletion of data.

[Table 2]

The user program 22 displays the result received from the business access processing program 25 on the screen 1 (S23).

If the processing is to be continued, the user program calls a function to continue the processing, and (S12) → (S1)
6) → (S17) → (S18) → (S19) → (S2)
0) → (S21) → (S22).

In the third embodiment, as shown in FIG. 6, the DB access processing program 31 and the business access processing program 32 (server access program) of the server computer 28 communicate from the client computer 21. The latest time is kept and the elapsed time is constantly monitored, and if the elapsed time exceeds a preset end time (timeout value), the program is terminated, and as shown in FIG. When the DB access processing program 27 and the business access processing program 26 (client access program) communicate with the server computer 28 again, the previously connected DB access processing program 31 and business access processing program 32 (server Access pro Acquires the process ID of the ram), by checking whether the process on the server computer 28 exists, DB access processing program 3
1 and the business access processing program 32 (server access program)
If it is not operating, it requests the communication daemon 29 of the server computer 28 to establish communication again,
The access processing program 31 and the business access processing program 32 (the server access program) are started and communication is established again, and the new DB access processing program 31 and the business access processing program 32 (the server access program) of the server computer 28 are executed. ), The process ID can be transmitted and received.

[0057]

The present invention has the following effects.

(A) According to the first aspect of the present invention, the separate management programs are used in the data search or reference processing and the other processing such as storage and update and other business processing. In the data search or reference processing, even if a failure occurs in the communication means, the entire system does not go down, so that the management program does not require complicated processing, and thus the processing load is reduced. As a result, the capacity load in exchanging information between the server computer and the client computer can be reduced.

(B) According to the second aspect of the present invention, the user program used on the client computer for performing various business processes is provided in an access program provided commonly to both the server and the client computer. Information can be exchanged only by outputting the necessary function associated with the processing instruction,
Eliminates the need to create a separate information exchange program for each user program that performs various business processes.Even if a database is changed or added or a business process program is changed, the program can be easily modified and created. Can be implemented.

(C) According to the invention of claim 3, in the access program for exchanging information between the client computer and the server computer,
It is possible to eliminate the need to individually create a program for information exchange for each type of OS and hardware type, and to easily change the program even if the database or the business processing program is changed.

(D) According to the invention of claim 4, it is possible to prevent the server access program from being activated more than necessary, and as a result, to reduce the capacity load of the server computer in information exchange. Can be.

[0062]

[Brief description of the drawings]

FIG. 1 is a block diagram illustrating a flow of a first embodiment.

FIG. 2 is a block diagram showing a flow of a second embodiment.

FIG. 3 is a block diagram illustrating a flow of a third embodiment.

FIG. 4 is a diagram illustrating a procedure of code conversion of a server access program according to a third embodiment.

FIG. 5 is a diagram illustrating a structure of a header portion of data transmitted from a client access program to a server access program according to a third embodiment.

FIG. 6 shows a procedure of an automatic program end function in a third embodiment.

FIG. 7 illustrates a procedure of a re-access function according to the third embodiment.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Client computer 2 Server computer 3 DB access processing program 4 DB access processing program 5 User program 6 Communication daemon 7 Database 11 Client computer 12 Server computer 13 Business access processing program 14 Business access processing program 15 User program 16 Communication daemon 17 Business processing program 18 Database 21 Client Computer 22 User Program 23 Monitor Screen 24 Instruction Column 25 Client Access Program 26 Business Access Processing Program 27 DB Access Processing Program 28 Server Computer 29 Communication Daemon 30 Server Access Program 31 DB Access Processing Program 32 Business Access Processing program 33 business processing program 34 database

(Equation 1)

(Equation 2)

Claims (4)

[Claims] 1. A server computer having at least one server function and at least one client computer are connected by communication means, and between the server computer and the client computer, retrieval and reference of data from the client computer A client-server system that executes various requested processes in the server computer based on various processing requests such as business processes such as storing and updating, and returns a processing result to the client computer; A management program for managing data exchange between the computer and the client computer is provided, and the data search or reference processing procedure and the other processing procedures such as storage and updating are separately performed. Information exchange method of a client-server system, characterized by using the management program. 2. The client program according to claim 1, wherein the management program outputs a function associated with various processing instructions on the server computer, and a client access program on the server computer corresponding to the various functions. 2. The information exchange method according to claim 1, further comprising a server access program on a server computer for executing various processing instructions or outputting the various functions. 3. The information that the client access program sends to the server computer includes a type of a data code system, a data type, and a transmission data length depending on an operation system (hereinafter abbreviated as OS). The server access program sends the actual data based on the information of the header part to the OS of the server computer. 3. A data format which is converted into a data format and output.
2. An information exchange method for a client / server system according to (1). 4. A communication monitoring program for constantly monitoring a communication connection request from the client access program is provided on a server computer, and the communication monitoring program is configured to execute the server access program based on the communication connection request. The server access program is automatically terminated when no information is transmitted from the client access program for a time exceeding a preset time. 2. An information exchange method for a client / server system according to (1).