JPH10283319A - On-line transaction processing method and system therefor and medium - Google Patents

Abstract

PROBLEM TO BE SOLVED: To reduce transmission and reception information amounts, to reduce traffic, and to improve a transaction response in a network between a client and a server at the time of processing a transaction. SOLUTION: A data generating part 12 transmits transaction information in a batch to a server 2 based on the data of a slip. A transaction preserving part 21 preserves the transaction data of the slip in a slip transaction file 22 based on the received telegraphic message, and supplies information for updating another table to definition information 23. The definition information 23 generates a trigger for defining the update of another table using the stored procedure of a data base management system(DBMS) 24. The DBMS 24 calls the stored procedure based on the applied trigger, and updates a pertinent master table in a master table file 25.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to online transaction processing in a client-server system, and more particularly, to a technique for speeding up online transaction processing in a client-server system in which a server has a database management system.

[0002]

2. Description of the Related Art A database system is known in which a database is stored in a server and a plurality of clients access the server to read or update necessary data.

[0003] This type of database system adopts a system in which a client issues a SQL (Structured Query Language) to access a database (DB) of a server.

However, this method has a problem that in the online transaction processing, a large number of SQLs are transmitted and received between the client and the server, so that the traffic on the network increases and the response of the transaction may be delayed.

[0005] This point will be specifically described with reference to FIG. Here, it is assumed that a product having a certain product code is sold, and the sales are registered in an AA slip having a format shown in FIG.

(1) When inputting an AA slip, a "product code
Using the "" as a key, the server searches the product master file F2 of the server, and retrieves the product by referring to the "product name" and "unit price" of the record. (2) Next, the sales “quantity” is input, the “amount” is calculated from the unit price × the quantity, the “stock quantity” is read from the product master file F2, and the sales quantity is subtracted therefrom to obtain a new stock quantity. Ask for. (3) When the AA slip is completed, the entered transaction data of the AA slip is stored in the transaction F1 of the AA slip on the server, and the stock quantity in the product master file F2 is updated.

[0007]

As in the case where the product master file F2 or the like is updated along with the storage of the AA slip,
When updating other tables as an extension of saving the transaction, the transaction key, other table name,
Information such as another table key, another table update item, and update script is required.

[0008] These pieces of information are information held by the client, and a considerable amount of SQL is exchanged between the client and the server to exchange the information. Therefore, traffic on the network increases, and the response of the transaction becomes slow. That is, it takes a longer time to save the updated data and enter the next input mode.

The items on the slip (on the screen) are managed in a relational database in association with each other. Therefore, the data of each item is normalized and exists in a plurality of tables. For this reason, even when the own vote (table) is stored, it is necessary to access a plurality of tables between the client and the server. Therefore, a large number of SQLs are transmitted and received between the client and the server, and the traffic on the network increases, and as a result, the response deteriorates.

[0010] The present invention has been made in view of the above circumstances, and has as its object to provide an online transaction processing method and system capable of performing transaction processing at high speed. It is another object of the present invention to provide an online transaction processing method and system capable of reducing the amount of information transmitted and received in a network between a client and a server at the time of transaction processing to reduce traffic. In addition, the present invention provides a medium storing a program capable of realizing these methods and systems,
The purpose is to make these methods and systems feasible.

[0011]

To achieve the above object, an online transaction processing system according to a first aspect of the present invention provides a client-server system comprising a client and a server connected to the client. The client includes: input means for inputting new transaction information; and data transmission means for transmitting the new transaction information input by the input means to the server. The server includes a database including a database management system. Receiving means for receiving transaction information from the client, storing means for storing transaction data based on the transaction information received by the receiving means, and responding to the storing, according to predetermined processing definition information Serial run a stored procedure in the database management system, characterized by comprising a database update means for updating the database.

In the online transaction processing system according to the present invention, instead of updating the database related to the storage of the transaction by the client, the new transaction information is transmitted to the server, and the stored procedure of the database management system is executed by the server. Do. Therefore, there is no need to transmit and receive a large amount of SQL statements between the client and the server. Therefore, the response is improved as compared with the conventional online transaction processing involving update processing.

[0013] The data transmitting means of the client includes means for generating a message including the transaction information and transmitting the message to the server, and the receiving means of the server receives the message and includes the message. Extracting means for extracting the transaction information stored in the storage means, and the storage means stores the transaction information extracted by the extracting means.

[0014] In this configuration, the transaction information is transmitted from the client to the server collectively by electronic message. Therefore, the communication traffic can be greatly reduced as compared with the case of exchanging the SQL sentence, the traffic decreases, and the response speeds up.

The process definition information is, for example, information that defines the content of a process for updating the database by a stored procedure of the database management system in response to storing the transaction.
The process definition information includes, for example, key definition information of a table to be subjected to a transaction and other tables related thereto, update formula information describing an update formula for updating data, and the update formula by determining a condition. Update condition information for sorting the update items, clear condition information for setting the update item clear cycle and initial value, history information for specifying the history item, and the return value to be returned when an error or warning occurs. At least one of check condition information to be set and update time information to specify online update or batch update may be included. By generating such information, each table can be updated. The server may further include a definition generation unit that generates the process definition information and registers the process definition information in the database management system in advance.

When an error occurs in the course of data processing based on a transaction, a server which invalidates the data processing relating to the transaction, restores all the update data in the server relating to the transaction, and transmits error information to the client. An error processing unit and a client error processing unit that, when error information is received from the server, invalidates data processing relating to the transaction and returns all update data in the client relating to the transaction to the original state may be arranged. With this configuration, data consistency can be ensured even if an error occurs.

In order to achieve the above object, a second aspect of the present invention is provided.
The online transaction processing system according to the aspect of the present invention generates a transmission message including data relating to the transaction and saves the transmission data to the server in order to store the data relating to the transaction in the server every time the transaction occurs. And a server system including data processing means for executing predetermined processing including data storage based on the message.

According to this configuration, since the data relating to the transaction generated by the client is included in the message and transmitted collectively to the server, the server collectively receives and processes the data necessary for storing the data. Can be. Therefore, transmission and reception of data between the server and the client can be reduced, traffic can be reduced, and the response can be speeded up.

The server system includes, for example, a database provided with a database management system, receiving means for receiving the message, storing means for storing transaction data based on the transaction information received by the receiving means, and storing means And a database updating means for executing a stored procedure in accordance with the process definition information for defining the update content and updating the database.

According to this configuration, the transaction data can be stored based on the transaction information included in the message, and the related database can be updated by the stored procedure. In this configuration, the SQ between the server and the client
There is almost no need to send and receive L-sentences, and the amount of communication can be reduced.

In order to achieve the above object, a third aspect of the present invention is provided.
An online transaction processing system according to the aspect of the present invention comprises: a database including a database management system; a receiving unit that receives transaction information from outside; a storage unit that stores transaction data based on the transaction information received by the receiving unit; In response to a storage unit, executing a stored procedure in accordance with predetermined process definition information to define the update content of the database, and updating the database by a database update unit. I do.

According to this configuration, the transaction data can be stored and the database can be updated using the stored procedure according to external transaction information. With such a configuration, the amount of communication between the system and the external device can be reduced.

In order to achieve the above object, a fourth aspect of the present invention is provided.
The online transaction processing method according to the aspect of the present invention comprises a client transmitting a new transaction information to a server for each transaction, and a server storing transaction data based on the transaction information received from the client in the server. And updating the database by executing a stored procedure in accordance with predetermined process definition information in conjunction with the storing step.

According to this method, the database related to the storage of the transaction is not updated by the client, but new transaction information is transmitted to the server, and the stored procedure of the database management system is performed by the server. Therefore, there is no need to transmit and receive a large amount of SQL statements between the client and the server. Therefore, the response is improved as compared with the conventional online transaction processing involving update processing.

The process definition information is usually obtained by determining key definition information of a table to be subjected to a transaction and other tables related thereto, update formula information describing an update formula for updating data, and conditions. Conditional update formula information for distributing the update formula, clear condition information for setting a clear cycle and an initial value of the update item,
It includes history information for specifying a history item, check condition information for setting a return value to be returned when an error or a warning occurs, update time information for specifying whether to perform online update or batch update, and the like. Further, a step of generating the process definition information and registering it in advance in the database management system of the server may be arranged.

When an error occurs in the course of data processing based on a transaction, invalidating data update,
An error processing step for restoring all data related to the transaction may be arranged. By arranging this step, data can be synchronized regardless of the presence or absence of an error.

In order to achieve the above object, a fifth aspect of the present invention is provided.
In the online transaction processing method according to the aspect of the present invention, a client stores data related to a transaction in a server, so that every time a transaction occurs, a message including all data related to the transaction is generated and transmitted to the server. , On the server,
A predetermined process including data storage is executed based on the message.

According to this configuration, since the data relating to the transaction generated by the client is included in the message and transmitted collectively to the server, the server collectively receives and processes the data necessary for storing the data. Can be. Therefore, transmission and reception of data between the server and the client can be reduced, traffic can be reduced, and the response can be speeded up.

In the server, the message is received,
Transaction data based on the transaction information contained in the received message is stored, and triggered by this storage, the stored procedure is executed in accordance with the process definition information that defines the update content of the database, and processing such as updating the database is performed. You may go.

To achieve the above object, the sixth aspect of the present invention is described.
An online transaction processing method according to the aspect of the present invention receives a message including transaction information, saves transaction data based on the transaction information included in the received message, and triggers the stored procedure of the database management system with the saving as a trigger. It starts up, executes a stored procedure according to predetermined update process definition information, and updates the database.

According to this configuration, transaction data can be stored and a database related to the transaction can be updated using a stored procedure in accordance with external transaction information. With such a configuration, the amount of communication between the system and the external device can be reduced.

A program (which may include a part or the whole of the OS, or may be a program operated on the OS) and / or all or one of the data for causing a normal computer to function as a server or a client having the above functions. The server or the client may be configured by storing and distributing the unit in a recording medium (FD, CD-ROM, or the like) and installing this in a computer.

[0033]

Embodiments of the present invention will be described below with reference to the drawings. 1 and 2, an online transaction processing system according to a first embodiment of the present invention will be described. FIG. 1 shows a first embodiment of the present invention.
1 schematically shows the configuration of a client-server system that constructs an online transaction processing system according to an embodiment.

The online transaction processing system shown in FIG. 1 comprises a client-server system consisting of a client 1 and a server 2 connected to each other by a network NW.

The client 1 includes a slip input unit 11 and a data generation unit 12. The server 2 includes a transaction storage unit 21, a slip transaction file 2,
2, a definition information 23, a DBMS 24 and a master table file 25.

The slip input unit 11 includes a keyboard, a mouse, and the like, and is used to input data of each item of the slip. For example, one slip is completed by displaying the format of the slip on the client screen and inputting data from the slip input unit 11 to each item of the slip. When inputting a slip, the product name, unit price and stock quantity can be referenced from the product master table of the master table file 25 of the server 2 using the product code and the like as keys. When the slip is completed and storage is instructed, the slip input unit 11 gives the data of the input slip to the data generation unit 12.

The data generation unit 12 generates a message for transmitting the input transaction information in a lump based on the data of the given slip,
To the server 2 via.

The transaction storage unit 21 of the server 2
Receives the message transmitted from the data generation unit 12 of the client 1. The transaction storage unit 21 stores the transaction data of the slip in the slip transaction file 22 as a slip transaction table based on the received message.

Further, the transaction storage unit 21
Reference is made to definition information 23 for updating another table. The definition information 23 is generated in advance at the time of system development or the like, and is registered in the stored procedure table of the DBMS 24 in advance. The definition information 23 is based on the transaction data given from the transaction storage unit 21 and is based on a DBMS 24 (DBMS: Database).
This is information that defines the update content when another table is updated using a stored procedure of the Management System (a so-called “relational database”).
The transaction storage unit 21 gives a trigger generated and registered in advance at the time of definition to the DBMS 24 according to the definition information 23.

The DBMS 24 calls a stored procedure based on the given trigger to update the corresponding master table in the master table file 25.

As is well known, the stored procedure is one of the functions of the DBMS, and is a program stored together with the metadata of the database.
Can be called from any application or used within SQL.

Stored procedures are broadly divided into selection procedures and executable procedures.

The selection procedure is, for example, SELECT
Statements allow applications to substitute tables and views. The selection procedure is defined to return one or more values (output parameters) or an error result.

The executable procedure is an executable procedure, for example, EXECUTE PROCE
The DURE statement allows the application to call directly. An executable procedure may or may not return a value to the calling program.

These procedures have essentially the same syntax, for example, CREATE PROCE
Defined using the DURE statement. However, they differ in the procedure creation method and the intended use.
The select procedure can return multiple rows and looks like a table or view to the calling program. An executable procedure is simply a routine called by a program, and may or may not return a value.

CRE defining stored procedure
The ATE PROCEDURE statement is composed of a header and a body. The header has information including the name of the stored procedure, a list of input parameters, a data type to be received from the program in which the procedure is called, and a list and data type of output parameters when returning a value to the called program. . The procedure body consists of a list of local variables and a block of statements describing the data type, procedure and trigger.

The stored procedure used in this embodiment is an executable procedure and is prepared in advance.

Next, a general operation of the transaction processing system shown in FIG. 1 will be described with reference to a flowchart shown in FIG.

When the transaction processing is started, an operator or the like performs, for example, a slip input using the slip input unit 11 of the client 1 (step S1). In this slip input, required data is input into each item of the slip displayed on the terminal screen of the client to complete one slip.

The slip input unit 11 generates a message for inquiring about the product name, unit price, stock quantity, and the like registered in the product master table such as the master table file 25 by using the product code and the like as a key, if necessary. , To the server 2. The server 2 (process on the server 2) interprets (translates) the message, assembles the SQL statement, accesses the master table file 25, and acquires data corresponding to the answer. The server 2 generates a message including the acquired data and transmits the message to the data generation unit 12 of the client 1.
The slip input unit 11 appropriately inserts the data in the received message into the slip. When the input of the slip data is completed and the operator or the like instructs to save, the input slip data is provided from the slip input unit 11 to the data generation unit 12.

The data generating unit 12 generates and transmits a message for transmitting the input transaction information in a lump based on the data of the given slip (step S2).

This message is transmitted to the server 2 via the network NW, and the transaction storage unit 2 of the server 2
1 is received.

The transaction storage unit 21 stores the transaction data of the slip in the slip transaction file 22 as a slip transaction table based on the received message (step S3). The transaction storage unit 21 further extracts predetermined information for updating another table from the received message and refers to the definition information 23. The transaction storage unit 21 refers to the definition information 23 registered in the stored procedure table of the DBMS 24, and based on the given transaction data, sends a trigger to the DBMS 24 for defining the update of another table using the stored procedure of the DBMS 24. Supply. DBMS24
Calls the stored procedure in response to the trigger (step S4). It is checked whether an error has occurred with respect to the call of the stored procedure (step S5).

If no error has occurred, the DBMS2
4 executes the called stored procedure to update the corresponding master table in the master table file 25 (step S6). It is checked whether an error has occurred during this updating work (step S).
7). If no error has occurred, the process ends.

If an error is detected in steps S5 and S7, all update information is invalidated, and the storage information of the transaction data by the transaction storage unit 21 is rolled back (step S8), and the latest transaction is updated. It is restored to the state before the occurrence.

As described above, D is used for updating the database.
By adopting the stored procedure of BMS, the transmission and reception of SQL between the client and the server can be performed in addition to the reference of, for example, the product code and the stock quantity when inputting the slip.
Almost gone. For this reason, the response is remarkably improved as compared with the response of the online transaction processing involving the conventional update processing.

Further, the definition of the update-related processing is collectively defined on the side to be updated, so that it can be defined independently of the transaction design.

In the conventional system, for example, when maintenance such as correction occurs, the definition of each transaction side, that is, the side to be updated is also changed, but in the system of FIG. 1, the master side, that is, the update is made. You only need to change the side. Also, in the system shown in FIG. 1, for storing the own table of the input slip transaction and the like, instead of exchanging the SQL between the client and the server, the own slip data is assembled and transmitted as one message. The data transfer load between the client / server is also reduced.

Next, an application example of the online transaction processing system shown in FIGS. 1 and 2 will be described with reference to FIGS.

FIG. 3 schematically shows the configuration of this application example. FIG. 4 schematically shows a hardware configuration, a software configuration, and a logical model of data communication of this application example.

The online transaction processing system shown in FIG. 3 includes a client 100 and a server 200.

The client 100 performs a transaction process, for example, an AA slip input and storage process by an operation of an operator or the like.

The server 200 stores the AA slip transaction table 201 by the AA slip saving process in the client 100. The server 200 uses another table update definition tool in advance, and
The trigger is registered in the stored procedure table of the DBMS 0. The server 200 is the client 1
In response to the AA slip saving operation of 00, a trigger 202 is generated together with the insertion (Insert) or update (Update) of the AA slip transaction table 201.

According to the description of the trigger 202, a stored procedure for updating a required table, for example, a stored procedure X203 and a stored procedure Y2
04 is called. Stored procedure X203
Is a stored procedure for updating or inserting the X master table 205, and stored procedure Y2
A stored procedure 04 updates or inserts the Y master table 206.

The stored procedure X203 and the stored procedure Y204 are registered in the stored procedure table of the DBMS in advance by another table update definition tool, and the trigger 20 generated when the AA slip transaction table 201 is inserted / saved.
2 designates a parameter or the like.

The above-described update processing is performed by the DB on the server 200 side.
The processing executed using the stored procedure of the MS will be described more specifically.

(1) Use the trigger and stored procedure of the DBMS function. Using the other table update definition tool of DBMS, the following information is defined / generated and stored in the DBMS stored procedure table.
Register a trigger. In this case, the definition is a definition on the side to be updated, and defines the following information.

(A) Key definition: own table master key / other table key (can be updated from a plurality of other table transactions) For example, the AA slip is a sales slip, the database is a product master, and the AA slip is In the case where the number of stocks on the product master is updated based on the number of products sold, for example, the product code is the key.

(B) Update formula: Normal update formula For example, when the AA slip is a sales slip, the database is a sales master, and the total sales on the sales master is updated by the sales on the AA slip. Sets, for example, an update expression shown in Expression 1.

[0070]

[Equation 1] Total sales on sales master = total sales on sales master + sales on AA slip

(C) Conditional updating formula: true /
Update formula of the type that determines false and distributes the update formula For example, if the database is the product master and the number of products on the product master is updated based on the number of products on the AA voucher, if the AA voucher is a sales voucher For example, a conditional update formula is set such that the update formula shown in Formula 2 is selected, and if the AA slip is a delivery slip, the update formula shown in Formula 3 is selected.

[0072]

[Equation 3] The number of stocks on the product master = the number of stocks on the product master-the number of products on the AA slip

[Equation 4] Number of stocks on product master = number of stocks on product master + number of products on AA slip

(D) Clear condition: setting of clear cycle and initial value of update item For example, when totaling sales data on a monthly basis, the clear cycle is defined as one month and the initial value is defined as zero.

(E) History: Designation of History Item When totaling sales data on a monthly basis, an item to be saved is defined, for example, when saving past data instead of clearing past data.

(F) Check condition: setting of return value at the time of error / warning (warning) The return value at the time of warning when any error occurs is defined.

(G) Update time: designation of online update or batch update Defines whether to update online or in batch processing.

(2) Operation at Execution (1) The client 100 performs a “save” operation on its own table. By this operation, the transaction table of the own table of the server 200, for example, the AA slip transaction table 201 is inserted or updated.

(2) AA slip transaction table 2
At the timing of inserting or updating 01, a trigger 202 for updating or inserting another table is activated. (3) The trigger 202 describes which stored procedure of the stored procedure X and the stored procedure Y (203 or 204) is to be called, and calls the corresponding stored procedure.

(4) Stored procedure X or Y (2
03 or 204), that is, the X master table 205 or the Y master table 206 is updated or inserted. (5) If an error occurs in the update / insert, the update / insert is invalidated, the save information related to the own table is rolled back, and the state before the save is restored.

Next, in connection with the above-described processing, a data transmission / reception system between the client and the server will be specifically described with reference to FIG.

FIG. 4 schematically shows a hardware configuration, a software configuration, and a logical model of data communication of the system shown in FIG. Client (client machine) 10
0 includes an operating system (hereinafter, referred to as “OS”) 111, a database access client 112, and an application 113.

Database access client 112
The application 113 is an application that operates on the OS 111 of the client 100. The application 113 is, for example, a program for performing processing such as slip input, and processing relating to data is performed by transmitting / receiving a message to / from the database access server 212 of the server 200 via the database access client 112. .

The software of the server (server machine) 200 is an OS 211, a database access server 21
2 and the DBMS 213.

Database access server 212 and D
The BMS 213 is an application that runs on the OS 211 of the server 200. The DBMS 213 is a so-called relational database that controls and manages the database 221 that depends on the server machine 200, and manages the components of the database in a relational manner. Processing related to the database is performed between the client 100 and the database access client 112 via the database access server 212. That is, transmission / reception of data related to the database between the client 100 and the server 200 is mainly performed between the database access client 112 and the database access server 212.

The system shown in FIG. 4 also creates original messages DP1 and DP2 in order to stop transmission / reception of an SQL statement between a client and a server as in the related art and to reduce the number of transmission / reception in one transaction process. Use. This message has a format in which data collectively for each transaction processing unit can be transmitted and received between the client and the server.

Next, messages used in this embodiment will be described. As shown in FIG. 5, a plurality of types of messages (packets) are prepared according to the intended use.
Also, a plurality of types of formats of each message are prepared according to the intended use. FIG. 6 shows a basic form of a message format. As shown, when a series of fields starting from F4 to F8 among the packet fields F1, F2,. In addition, fields F6 to
There are n (one or more) F8s in a row.

The packet fields F1, F2, F3, F
As shown in FIG. 7, “Pkt_id”, “Pkt_len”, and “Prc_i” are assigned to F4, F5, F6, F7, and F8, respectively.
d "," View_Name "," Rec_num "," Ope_id "," Lev
Field names "el" and "data" are given.
Each of these packet fields F1, F2, F3, F4,
Each of F5, F6, F7 and F8 has a packet I which is an ID (identifier) for identifying the packet.
D, packet length which is the length of the entire packet, process ID which is an ID for identifying a process, view name, number of records for each view name, update operation ID which is an ID for identifying an update operation, and view name at the time of insertion Level and data are stored.

The packet ID stored in the packet field F1 corresponds to the packet type shown in FIG. More specifically, “UP” and “D” shown in FIG.
"OWN" means that each of the clients 100 to the server 20
0 and the server 200 to the client 10
Indicates a packet to 0. Connection to database (DB), termination of connection, selection of record set, selection of record set for list display, selection of item value,
There are types such as record edit, record edit cancel, record existing check, record set update, issue number acquisition, issue number cancellation, and dummy.

"Update Record Set" (RUDUP:
The message from the client to the server) uses the format shown in FIG. 6 as it is. The message of “Update Record Set” (RUDDOWN: from server to client) has the format shown in FIG.

FIG. 9 shows the structure of a message for checking authority. FIG. 9A shows a configuration of a packet transmitted from the client to the server, and FIG. 9B shows a configuration of a packet transmitted from the server to the client.

FIG. 10 shows the structure of a message for selecting a record set. FIG. 10A shows the structure of a packet transmitted from the client to the server.
(B) shows the configuration of a packet transmitted from the server to the client.

FIG. 11 shows the structure of a message for selecting an item value. FIG. 11A shows a configuration of a packet transmitted from the client to the server, and FIG. 11B shows a configuration of a packet transmitted from the server to the client.

The operation described above will be described with reference to FIG.
This will be described with reference to FIG. FIG. 12 shows the processing and the flow of data. Here, it is assumed that a product having a certain product code is sold, and the sales are registered in a sales slip in a format shown in FIG. In such a case, the relational database stores a header portion (one record) including a date, a slip number, a customer code, a total amount, and the like.
Data is managed in a detailed section table storing detailed sections including a product code, a quantity, an amount, a stock quantity, and the like.

(1) First, the operator operates the slip input unit 11 to read the form of the sales slip from an external storage device or the like, and displays it on the screen, for example, as shown in FIG. Next, from the slip input unit 11, the "product code" of the sold product is displayed.
". The entered product number is incorporated in the displayed form. Further, the slip input unit 11 searches the product master file F2 of the server using the input product code as a key, and generates a message for capturing the “product name” and “unit price” of the record.

This message has the format shown in FIG. 11A. In the first field F1, an ID (ISLDN: 8) indicating selection of an item value is set, and a "product code" as a key, “Product name” and “unit price” as item values are set as data F8. The slip input unit 11 converts the generated message into a message DP1 shown in FIG.
Send to server 2.

The server 2 receives this message, and a process (database access server) on the server determines from the packet ID of the message that this message is a packet for acquiring an item value, and from the data F8, a key and S for determining an item and acquiring target data
Generate a QL sentence. The DBMS 24 executes the SQL statement and acquires the data requested by the client 1. The server 2 generates a message including the acquired data. This message has the format shown in FIG. 11B, and the first field F1 contains an ID indicating selection of an item value.
(ISLUP: 9) is set, and "Product code"
“Product name” and “unit price” as item values are set as data F8. The server 2 sends the generated message to the client 1 as a message DP2 shown in FIG.

The client 1 receives the message DP2,
From the packet ID of the message, it is determined that the message is a reply of a message for acquiring an item value, and a key and an item value (“product name” and “unit price”) are acquired from the data F8, and the slip input unit 11 To provide. The slip input unit 11
Insert the received "product name" and "unit price" into the form.

(2) Next, the sales “quantity” is input from the slip input unit 11. The slip input unit 11 obtains “amount” from unit price × quantity and inserts it into the slip. Further, the slip input unit 11 searches the product master file F2 of the server using the product code as a key, creates a message that captures the stock quantity of the corresponding product, and transmits the message to the server 2. The server 2 generates an SQL sentence from this message. DBMS of server 2
24 executes this SQL statement, searches the product master file F2 of the server, reads out the “stock quantity” associated with the corresponding product code, inserts it into a message, and sends it to the slip input unit 11. The slip input unit 11 obtains a new stock quantity by subtracting the sales quantity from the received "stock quantity", and stores the new stock quantity in the slip form.

(3) When the sales slip is completed on the screen, the operator instructs to save the generated sales slip. In response to this instruction, the data generation unit 12 transmits an ID (RUD) indicating that the message is a message including transaction data of a sales slip.
DN: 17) is set as the packet ID, a message including the product code, the product name, the unit price, the quantity, the amount, the stock number, and the like in the data F8 is generated, and transmitted to the transaction storage unit 21. The date, the operator ID, and the like may be included in the message.
As described above, in a relational database, data is managed in a header part table and a detail part table. In this case, the message assembled on the client side is the “record set update operation system” shown in FIG. 7, and the specific format is as shown in FIG. 14, for example.

Transaction storage unit 21 of server 2
Receives the message, determines from the message ID that the message is a sales slip message, extracts data such as a product code, a product name, a unit price, a quantity, an amount, and the number of stocks from the message, and executes the slip transaction. 22.

In response to this storage, the stored procedures of the product master table and the sales master table are started (called). In the stored procedure of the product master table, for example, the product code,
The product code is defined as the key of the other form, the “stock quantity = stock quantity−sales quantity” is defined as the update formula, and the online update is defined as the update time. In the stored procedure of the sales master table, for example, a product code as a self-vote key, a product code as another vote key, and an update formula of “total sales amount = total sales amount + sales amount”, “total sales unit = total sales unit + "Online renewal" is defined as the "sales quantity" and the renewal time.

According to the definition, the stored procedure of the product master table searches the product master table using the product code as a key, reads out the stock data relating to the product, subtracts the sales quantity from this, calculates a new stock, This is stored in the product master table.

The stored procedure of the sales master table reads “total sales amount” and “total sales unit” from the sales master table according to the definition, and calculates “total sales amount + sales amount” and “total sales unit + sales unit”. And calculate them as new "total sales" and "total sales units"
Store in sales master table. Thus, the update operation ends.

For example, when updating the stock quantity in the product master table, the stock quantity in the product master table is updated only when the stock quantity calculated by the stored procedure matches the stock quantity included in the message. It is also possible to define a conditional update expression in For example, if the two stock quantities do not match, the server 2 determines that an error has occurred, and the sales master table 206 and the product master table 2
The stored procedure 05 restores all the updated contents, and also restores the sales slip transaction. Further, a warning (error message) is issued to the client 100.
Sent to and displayed.

It is also possible to realize update processing without using other table update tools. For example, based on information equivalent to the definition information of the other table update system, an operation corresponding to a stored procedure and a trigger is coded by an SQL statement or the like. The number of stored procedures required in this case corresponds to the number of update tables, and the number of triggers corresponds to the number of transactions. Then, a query is executed on the database, and the stored procedure and the trigger created as described above are registered in the database and the table. Although the above operation is sufficient, the amount of coding of the stored procedure and the trigger is considerable. That is, the other table updating tool performs these processes semi-automatically.

In the above description, the transaction data is included in the message and transmitted from the client to the server, and the server updates another vote (database) using the stored procedure. However, the transaction data may be included in the message, transmitted from the client to the server, and the received transaction may be stored in the server without updating the other votes. Alternatively, the transaction data may be transmitted from the client to the server without using a telegram, the received transaction may be stored in the server, and the other votes may be updated using the stored procedure.

In this way, traffic on the network can be reduced, and the response between the client and the server is improved. Further, since the process of accessing the database is separated into the client side and the server side, portability is improved and maintainability is improved as compared with the conventional system.

The client server system of the present invention can be realized by using a general computer system without using a dedicated system. For example, a medium (floppy disk, C, etc.) storing a program (which may include all or part of the OS) for executing the above-described operation in a computer mutually connected via a network.
By installing the program from a D-ROM or the like, each terminal (client or server) that executes the above processing can be configured.

The medium for supplying the program to the computer may be a communication medium (a medium that temporarily and fluidly stores the program, such as a communication line, a communication network, or a communication system). For example, the program may be posted on a bulletin board (BBS) of a communication network and distributed via the network. Then, by starting this program and executing it in the same manner as other application programs under the control of the OS, the above-described processing can be executed.

[0110]

As described above, in the online transaction processing method and system according to the present invention, new transaction information is transmitted from a client to a server, and the server stores transaction data based on the received transaction information. Generating process definition information for defining the update of the database and registering it in the DBMS of the server, and the DBMS executes a stored procedure according to the process definition information;
Update the database.

In this system, data relating to a transaction is transmitted to the server in a lump,
Since the database related to the transaction is processed using the stored procedure of the BMS, there is almost no exchange of SQL between the client and the server, which is remarkable as compared with the online transaction processing involving the conventional update processing. Response improves.

That is, the present invention provides an online transaction processing method and system capable of reducing the amount of information transmitted and received in a network between a client and a server during transaction processing, thereby reducing traffic and improving transaction response. it can.

[Brief description of the drawings]

FIG. 1 is a block diagram schematically showing a configuration of an online transaction processing system according to a first embodiment of the present invention.

FIG. 2 is a flowchart illustrating an operation of the online transaction processing system of FIG. 1;

FIG. 3 is a system block diagram schematically showing a configuration of an online transaction processing system according to a second embodiment of the present invention.

FIG. 4 is a schematic diagram showing a hardware configuration, a software configuration, and a logical model of data communication for describing an operation in the online transaction processing system of FIG. 3;

FIG. 5 is a diagram showing types of messages (packets) and packet IDs.

FIG. 6 is a diagram showing a basic format of a message.

FIG. 7 is a diagram showing the contents of fields of the message shown in FIG. 6;

FIG. 8: “Update record set” (RUDDOWN:
FIG. 4 is a diagram showing a format of a message from a server to a client).

FIG. 9 shows the structure of a message for checking authority, and FIG.
Is the composition of the message sent from the client to the server,
(B) shows the structure of a message transmitted from the server to the client.

10A and 10B show a configuration of a message for selecting a record set, wherein FIG. 10A shows a configuration of a message transmitted from the client to the server, and FIG. 10B shows a configuration of a message transmitted from the server to the client.

11A and 11B show a configuration of a message for selecting an item value, wherein FIG. 11A shows a configuration of a message transmitted from the client to the server, and FIG. 11B shows a configuration of a message transmitted from the server to the client.

FIG. 12 is a diagram illustrating a specific operation of the online transaction processing system of FIG. 3;

FIG. 13 is a diagram showing an example of a sales slip input screen.

FIG. 14 is a diagram showing a message format for transmitting a transaction input using the screen shown in FIG. 13;

FIG. 15 is a schematic block diagram for explaining a conventional online transaction processing system.

[Explanation of symbols]

Reference Signs List 1 client system (client) 2 server system (server) 11 slip input section 12 data generation section 21 transaction storage section 22 slip transaction file 23 definition information 24 DBMS (database management system) 25 master table file 100 client machine (client) 111 OS (Operating system) 112 Database access client 113 Application 200 Server machine (server) 201 AA slip transaction table 202 Trigger 203, 204 Stored procedure 205, 206 Master table file 212 Database access server 213 DBMS (database management system) 221 Database

──────────────────────────────────────────────────続 き Continued on the front page (51) Int.Cl. ⁶ Identification code FI G06F 19/00 G06F 15/22 N

Claims (19)

[Claims] 1. A client-server system comprising a client and a server connected to the client, wherein the client has input means for inputting new transaction information, and new transaction information input by the input means. Data transmitting means for transmitting to the server, the server comprising: a database having a database management system; receiving means for receiving transaction information from the client; and a transaction based on the transaction information received by the receiving means. Storage means for storing data; database update means for executing a stored procedure of the database management system in accordance with predetermined processing definition information in response to the storage and updating the database Online transaction processing system, characterized by comprising a. 2. The data transmission unit of the client includes a unit that generates a message including the transaction information and transmits the message to the server. The reception unit of the server receives the message and transmits the message to the server. 2. The apparatus according to claim 1, further comprising an extraction unit configured to extract the transaction information included therein, wherein the storage unit stores the transaction information extracted by the extraction unit.
An online transaction processing system according to claim 1. 3. The process definition information is information that defines the content of a process for updating the database by a stored procedure of the database management system in response to storage of the transaction. The online transaction processing system according to claim 1. 4. The process definition information includes at least one of key definition information of a table to be subjected to a transaction and other tables related thereto, and update formula information describing an update formula for updating data. 4. The online transaction processing system according to claim 3, wherein: 5. The process definition information includes: conditional update formula information for determining a condition and distributing the update formula; clear condition information for setting a clear cycle and an initial value of an update item; And at least one of the following: check information that sets a return value to be returned when an error or warning occurs, and update timing information that specifies whether to update online or batch. 4. The online transaction processing system according to claim 3, wherein: 6. The server according to claim 1, wherein the server includes a definition generation unit that generates the process definition information and registers the process definition information in the database management system in advance. Online transaction processing system. 7. When an error occurs in the course of data processing based on a transaction, data processing related to the transaction is invalidated, all update data in the server related to the transaction is restored, and error information is transmitted to the client. Further comprising: a server error processing unit for transmitting; and a client error processing unit for invalidating data processing relating to the transaction upon receiving error information from the server, and restoring all update data in a client relating to the transaction. The online transaction processing system according to any one of claims 1 to 6, wherein: 8. Every time a transaction occurs, data relating to the transaction is stored in a server.
A client system that includes a transmission data generation unit that generates a message including data related to the transaction and transmits the message to the server; and a server system that includes a data processing unit that performs a predetermined process including data storage based on the message. An online transaction processing system comprising: 9. The server system, comprising: a database having a database management system; receiving means for receiving the message; storing means for storing transaction data based on the transaction information received by the receiving means; 9. The online transaction processing according to claim 8, further comprising: a database update unit that executes a stored procedure in accordance with the process definition information for defining update content and updates the database. system. 10. A database having a database management system, receiving means for receiving transaction information from the outside, storage means for storing transaction data based on the transaction information received by said receiving means, and responsive to said storage means. And a database updating means for executing a stored procedure in accordance with predetermined process definition information for defining the update content of the database and updating the database. . 11. A client, comprising: a client for transmitting new transaction information to a server for each transaction; a server for storing transaction data based on the transaction information received from the client; An update step of executing a stored procedure according to predetermined process definition information and updating a database. 12. The processing definition information includes determining key definition information of a table to be subjected to a transaction and other tables related thereto, update expression information describing an update expression for updating data, and conditions. Conditional update formula information for distributing the update formula, clear condition information for setting the update item clear cycle and initial value, history information for specifying a history item, and returning when an error or warning occurs 12. The online transaction processing method according to claim 11, further comprising at least one of check condition information for setting a return value and update time information for specifying online update or batch update. 13. The online transaction processing method according to claim 11, further comprising the step of generating the processing definition information and registering the processing definition information in a database management system of the server in advance. 14. The method according to claim 1, further comprising, when an error occurs in the course of data processing based on the transaction, invalidating the data update and restoring all data relating to the transaction. 14. The online transaction processing method according to 11, 12, or 13. 15. In a client, for storing data relating to a transaction in a server, each time a transaction occurs, a message including all data relating to the transaction is generated and transmitted to the server. An online transaction processing method, wherein a predetermined process including data storage is executed based on the message. 16. The server receives the message, saves transaction data based on the transaction information included in the received message, and uses the save as a trigger to define processing update information of a database. Execute the stored procedure according to
16. The database according to claim 15, wherein the database is updated.
Online transaction processing method according to the above. 17. Receiving a telegram including transaction information, storing transaction data based on the transaction information included in the received telegram, triggering a stored procedure of the database management system by using the storage as a trigger, and predetermining the stored procedure. Executing a stored procedure in accordance with the update process definition information and updating a database. 18. A storage step for storing transaction data based on transaction information received from a client;
In conjunction with the saving step, a stored procedure is executed according to predetermined process definition information, and an update step of updating a database is recorded. Medium. 19. A client for storing, in a server, data relating to a transaction, each time a transaction occurs, a computer that generates a message including all data relating to the transaction and transmits the message to a server; A medium on which is recorded a program that functions as a client of a client-server system that is configured by a server that executes a predetermined process including data storage based on a server.