JPH07234901A - Slip data processing method - Google Patents

Abstract

PURPOSE:To provide a slip data processing method capable of executing the processing of slip data on a data base that exists on a different kind of computer connected to a computer which performs the slip data with a communication channel. CONSTITUTION:Inputted slip data is processed according to the processing content of a slip stored in advance(101, 102). After the input of the slip data is completed, the data base in which the slip data is stored is detected from slip definition data(103, 104). The processing of the data base is requested to the computer in which a detected data base exists(105, 106, and 107). After the processing request of the data is accepted, the slip data is acquired(108, 109), and it is converted to data base operating language(110), then, it is stored in the data base(111).

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a form data processing method for processing form data for a database existing on a computer connected by a communication line.

[0002]

2. Description of the Related Art When using a computer such as a workstation to input form data into a database using, for example, a data input form (form), a format for inputting form data is displayed on a display screen. Displayed on
In some cases, the form data input by the preset process is input to the database.

As a typical representative form data processing method, for example, the manual issued by Hitachi, Ltd.
As described in the document titled FORM2-EV, a database existing in the computer that inputs the form data by using the format displayed on the display and inputs the form data according to a preset process, Alternatively, there is one that stores the form data or refers to the data in the database in a database existing on the computer connected by a communication line.

[0004]

The above-mentioned prior art is to store the input form data in the database or refer to the data stored in the database according to a preset process. In addition, according to a preset process, the input form data is stored in a database existing on the computer connected by a communication line, or the data stored in the database is referred to. However, in the above-mentioned conventional technology, in the database existing on the computer connected to the computer for inputting the form data via the communication line, in order to process the form data, the computer for inputting the form data and the computer connected via the communication line are used. Is limited to the same model or database of the same type.

An object of the present invention is to provide a form data processing method capable of executing form data processing on a database existing on a computer of a different model connected to a computer for processing form data by a communication line. To provide.

[0006]

In order to achieve the above object, a database detection unit for detecting a computer in which a database to be processed exists from data representing processing contents of a form set as form definition data. A database processing request unit for requesting database processing to a database on a computer connected by a communication line is provided. Also,
On a computer connected by a communication line, a database management unit that accepts database processing from a computer that inputs form data and a database processing unit that executes processing on the accepted database are provided.

By inputting the form data, the database detection unit detects the table name of the database to be processed and the computer in which the database exists from the data representing the processing contents of the form set in advance as the form definition data. When the computer in which the detected database exists is a computer connected by a communication line, the database request unit sends data representing the processing content of the corresponding form and the form data to the corresponding computer. In the computer to which the data representing the processing contents of the form and the form data are sent, the database management unit receives the data. The database processing unit executes, on a database existing on the computer, data representing the processing content of the received form and a process according to the form data.

[0008]

According to the present invention, the database processing detected from the preset processing contents of the form is sent to the relevant computer connected by the database processing request unit via the communication line, and the database processing is performed on the relevant computer. By executing the process, even if the computer that inputs the form data and the computer that has the database are different models connected by the communication line, the form is processed by the database that exists on the computer connected by the communication line. The processing of the form data can be easily realized without rewriting the program to be used.

[0009]

Embodiments of the present invention will now be described in detail with reference to the drawings.

FIG. 2 is a block diagram showing the overall structure. In the figure, 201 is an input device such as a keyboard and mouse, and 202 is a display device such as a display. Two
Reference numeral 03 is a processing device, 204 is a processing control function, and 205
Is a form definition management function, 206 is a database detection function,
207 is a database management function, and 208 is a database processing function. 209 is a database. 21
0 is a communication line. Input device 201, display device 20
2. A plurality of computers including the processing device 203 and the database 209 are interconnected via the communication line 210.

The form definition data is input by an operator from a keyboard and a mouse 201 which are input devices, is displayed on a display 202 which is a display device by a processing device 203, and is stored in a form definition management function 205. The processing control function 204 processes the form data input by the operator according to the processing contents of the form, which is the form definition data stored in the form definition management function 205. The database detection function 206 detects the computer in which the database exists from the processing contents of the form, which is the form definition data stored in the form definition management function 205. The database management function 207 is a processing request for the computer detected by the database detection function 206,
Alternatively, it accepts a database processing request requested from a computer connected via the communication line 210. The database processing function 208 executes the processing request from the database management function 207 to the database 209.

First, the process of storing the form data in the database will be described with reference to the flowchart of FIG.

The operator inputs the form data into the input device 201.
Is input (step 101). The input form data is processed by the process control function 204 and the form definition management function 205.
Processing is performed according to the processing contents of the form stored in advance (step 102). If there is more form data to be input, the processing from step 101 is repeated (step 103). After inputting the form data, the database detection function 206 detects a database storing the form data processed in step 102 from the form definition data stored in the form definition management function 205 (step 104). If the computer in which the detected beta base exists is a computer connected by the communication line 210, the database management function 207 requests the computer to process the database (step 10).
5, 106) and waits for a response to the end of processing (step 10).
7). If the computer having the database detected in step 104 is the computer to which the form data is input, the database management function 207 of the computer to which the form data is input accepts the storage process (steps 105, 1
08), the form data is acquired from the processing control function 204 of the computer to which the form data is input (step 109).
The database processing function 208 of the computer to which the form data is input converts the form data acquired in step 108 into the database operation language (step 110), and the form data is input. It is stored in the database 209 of the computer (step 111).

FIG. 3 shows an example of a form definition data table used for detecting the computer in the database in step 104 in the process flow of FIG. Three
Reference numeral 01 is a form management table that manages the entire form definition data, which is the name of the form definition data, the form type, the table name that stores the form data, and the logical network of the computer that has the database that stores the form data. An address and a sequence ID, which is the registration order of the form definition data, are managed. A processing formula table 302 stores a processing formula that is the content of the form process. Reference numeral 303 is an actual data table used as a work table for storing the form data in the database table. A data information table 304 stores data information of form data, and manages item names, item lengths, and attributes.

Here, FIG. 4 shows the details of the processing formula table 302 in which the processing formulas that are the contents of the form process are described, and the process of detecting the computer in which the database of step 104 exists will be described.

The example in the figure shows the processing of the form data input by the operator for the form of sales slips.
In this process, the operator inputs the form data entered in the items of "Product code", "Product name", "Unit price", "Quantity", and "Amount" of "Sales slip" to "Sales ledger. Product code". This is a process of storing "," sales ledger. Product name "," sales ledger. Unit price "," sales ledger. Quantity "," sales ledger. Amount ". The database detection function 206 uses the left side ("" of the processing formula stored in the processing formula table 302.
= ”Description on the left side of the description”) “Sales ledger.
From the description such as “product code”, it is detected that the form that is the storage destination of the input form data is “sales ledger.” Further, the database detection function 206 detects the form name “sales ledger” from the form management table 301. The computer in which the database exists is detected from the table name and logical network address of the database that stores the form data registered in ".

Therefore, from the form management table 301 shown in FIG. 3, the table name of the database for storing the form data of the form name "sales ledger" is "sales ledger",
Since the logical network address of the computer in which the database table exists is "abcd", the computer having the logical network address "abcd"
Detects the existence of the database table "Sales Ledger".

Next, the storage process in the database requested to the computer connected by the communication line in step 106 in FIG. 1 will be described with reference to the process flow of FIG.

The database management function 207 of the computer connected by the communication line waits for the arrival of a database processing request (step 501). When a database storage processing request arrives from the computer to which the form data is input via the communication line, the database storage processing request is accepted (step 502), and the database management function 207 of the computer to which the form data is input to the database The processing data is acquired (step 503). The database processing data acquired here is the processing formula table 302 shown in FIG. 4 and the actual data table 30 shown in FIG.
3, the contents of the data information table 304. The database processing function 208 of the computer connected by the communication line is
The actual data table 3 is included in the “sales ledger. Product code” that is the database processing data acquired in step 503.
Data No. 03 “10001” in the data information table 30
In the same way as the character from the data of 4, the "sales ledger. Product name" has "TV" as a character, and "sales ledger. Unit price"
"65000" is a real number, and "Sales ledger. Quantity"
"1" is a real number, and "Sales ledger. Amount" is "6"
It is converted into a database operation language with 5000 "as a real number (step 504) and stored in the database 209 on the computer connected by the communication line (step 5).
05), the completion of processing is returned to the computer to which the form data is input (step 506). When the processing is to be continued, the state returns to the state of step 501.

From this, the form data to be stored in the database existing on the computer and its processing are sent to the computer detected from the preset form definition data, and the storing process to the database is executed on the computer. Therefore, even if the computer in which the database exists has a model different from that of the computer that inputs the form data, or a database of a different type, the form processing that stores the input form data in the database does not It is possible to easily store the form data in the database without being aware of it.

Further, as in the case of FIG. 4 of the above-mentioned embodiment, a processing formula table 3 in which processing formulas which are the contents of form processing are described.
Details of No. 02 are shown in FIG. 6, and a process of storing the form data in the database existing on the computer into which the form data is input will be described.

The example of the figure shows the form processing for a form called a sales slip as in FIG. This is the operator's "sales slip""productcode","productname","
The form data entered in the items of “unit price”, “quantity”, and “amount” are respectively referred to as “sales slip. Product code "," sales slip. Product name "," sales slip. Unit price ”,“ Sales slip. Quantity "," sales slip. The amount of money is stored in the processing amount table. The database detection function 206 uses the “sales slip. It is detected from the description such as “product code” that the form that is the storage destination of the form data is “sales slip.” Furthermore, the database detection function 206 is registered in the form name “sales slip” of the form management table 301. The computer in which the database exists from the table name and the logical network address of the database that stores the specified form data in step 104.
Detect with.

Therefore, from the form management table 301 shown in FIG. 3, the database table for storing the form data of the form name "sales slip" is "sales slip", and the logical network of the computer in which the database table exists. Since the address is "-", it is detected that the database table of "sales slip" exists on the computer to which the form data is input. Based on the detection result, the database management function 207 of the computer to which the form data is input acquires the contents of the processing formula table 302, the actual data table 303, and the data information table 304 from the storage request to the database received in step 108. .

In the example of FIG. 3, "sales slip. Merchandise code"
Is the data “10001” of the actual data table 303.
Is acquired from the data in the data information table 304 as a character. Similarly, "Sales slip. Product name" has "TV" as a character, "Sales slip. Unit price" has "65000" as a real number, and "Sales slip. Quantity" has "1" as a real number, and " “65000” is acquired as a real number for “Sales slip. Amount”. The acquired data is processed by the database processing function 2 in step 110.
08 converts it into a database operation language and stores it in the database 209.

Therefore, even when the computer detected from the preset form definition data is the computer to which the form data is input, the form data is stored in the database existing on the computer connected by the communication line. Similarly to the case, it is possible to easily store the form data in the database without rewriting the program.

Next, the process of referring to the data already stored in the database will be described with reference to the process flow of FIG.

The operator inputs the form data into the input device 201.
Is input (step 701). The input form data is processed by the process control function 204 and the form definition management function 205.
Processing is performed according to the processing contents of the form stored in advance in step 702. Here, the process control function 204 detects whether or not there is a process for referring to the data in the database (step 703). If there is a reference process, the database detection function 206 detects a database that refers to the data from the form definition data (steps 704 and 705). If the computer in which the detected beta base exists is a computer connected by a communication line, the database management function 207 requests the detected computer to process the database (step 70).
6) Wait for a response of reference data from the computer (step 707). If the computer having the database detected in step 705 is the computer to which the form data is input, the database management function 207 of the computer to which the form data is input accepts the reference process (step 70
5, 708), the database processing data is acquired from the processing control function 204 of the computer to which the form data is input (step 709). The database processing function 208 of the computer, to which the form data is input, converts the database reference process received in step 708 and the database processing data acquired in step 709 into a database operation language (step 710), and the form data is input. The reference data is acquired from the database 209 of the computer (step 711). With respect to the reference data acquired in step 711 or step 707, the database management function 207 of the computer to which the form data is input responds to the processing control function 204 of the computer to which the form data is input (step 712). If there is further processing for referring to the data in the database, the processing from step 701 is repeated.

FIG. 8 is a processing formula table 3 in which reference processing to a database on a computer connected by a communication line is described.
Details of No. 04 will be described, and after detecting the database reference processing in step 703, the processing of detecting the computer in which the referred database exists will be described.

From the example shown in the figure, the description indicating the reference processing to the database detected by the processing control function 204 in step 703 is "sales slip. Product name = @ code (product code, sales ledger. Product code, sales ledger. Product. Name) ”. In this process, the operator retrieves the data of "Product code" from the database table called "Sales register" based on the form data entered in "Product code", and then the "Product name"
Is a process of acquiring the data. In the database detection function 206, from the description of “sales ledger. Product code” and “sales ledger. Product name”, the reference form is “sales ledger”
Is detected. Database detection function 2
06 is the form management table 30 as in the above-described embodiment.
From 1, the computer in which the database exists is detected from the table name and logical network address of the database that stores the form data registered in the form name “sales ledger”.

Therefore, from the form management table 301 shown in FIG. 3, the table name of the database for storing the form data of the form name "sales ledger" is "sales ledger",
Since the logical network address of the computer in which the database table exists is "abcd", the computer having the logical network address "abcd"
Detects the existence of the database table "Sales Ledger".

Next, the flow of processing a database reference request on the computer from the database reference request to the computer connected via the communication line in step 706 will be described with reference to FIG.

Database management function 20 on the computer
7 waits for the arrival of a database processing request (step 901). When a database reference processing request arrives from the computer to which the form data is input, the database reference processing request is accepted (step 902), and the database management function 2 of the computer to which the form data is input is also received.
The database processing data is acquired from 07 (step 903). The database processing data acquired here is
These are the contents of the processing formula table 302, the actual data table 303, and the data information table 304 shown in FIG.

Therefore, the database processing function 208 of the computer has the "product code""10001" which is the database processing data acquired in step 903.
Is converted to a database operation language in which data of "product name" having the same data of "product code" is acquired from the database table "product register" (step 904). The reference data is acquired from the database 209 (step 905), and the reference data is returned to the computer requesting the database reference processing (step 906). When processing is to be continued, the state returns to the state of step 901 (step 907).

From this, even when the process of referring to the data of the database from the preset form data is the process to the computer connected by the communication line, the form data and its reference process are sent to the computer. Thus, it is possible to easily obtain the required reference data from the database existing on the computer connected by the communication line.

From this, even in the form process requesting the database reference process, the reference process to the database is executed on the computer detected from the form definition data set in advance and the reference data is acquired.
It is possible to easily refer to the data in the database without paying attention to the computer in which the database exists and the database type.

[0036]

According to the present invention, the database for processing the form data is detected from the preset processing contents of the form, and the form processing for the database is performed to the computer having the detected database through the communication line. When the computer that inputs the form data and the database that processes the form data exist on a different type of computer connected by the processing communication line, the program is The remarkable effect is that the processing of the form data can be easily realized in the database without rewriting.

[Brief description of drawings]

FIG. 1 is a diagram showing a flowchart showing a process of storing form data in a database.

FIG. 2 is a diagram showing a block diagram showing an overall configuration.

FIG. 3 is a diagram showing a table configuration of form definition data.

FIG. 4 is a diagram showing an example of a processing expression table describing a storage processing in a database.

FIG. 5 is a view showing a flowchart showing a storage process in a database on a computer connected by a communication line.

FIG. 6 is a diagram showing an example of a processing formula table describing a storage process in a database existing on a computer into which form data has been input.

FIG. 7 is a flowchart showing a process of referring to data in a database.

FIG. 8 is a diagram showing an example of a processing expression table in which reference processing to a database is described.

FIG. 9 is a diagram showing a flowchart showing a data reference process to a database on a computer connected by a communication line.

[Explanation of symbols]

201: Input device such as keyboard and mouse, 202: Display device such as display, 203: Processing device, 204:
Processing control function, 205: form definition management function, 206: database detection function, 207: database management function,
208: database processing function, 209: database, 210: communication line, 301: form management table, 3
02: processing formula table, 303: actual data table, 3
04: Data information table.

 ─────────────────────────────────────────────────── ─── Continuation of the front page (72) Masamitsu Tenma 1099, Ozenji, Aso-ku, Kawasaki-shi, Kanagawa, Ltd. Inside the Hitachi, Ltd. Systems Development Laboratory (72) Inventor, Kazuhiko Taniguchi, 1099, Ozen-ji, Aso-ku, Kawasaki, Kanagawa Hitachi Systems Development Laboratory

Claims (5)

[Claims] 1. A method comprising: inputting form definition data and form data; displaying a form; processing input form data; and storing the input form data in a database. A form data processing method for processing form data on a form processing system, comprising a step of processing a database existing on a computer connected by a communication line. . 2. A step of processing a database existing on a computer connected by the communication line, a step of detecting a computer having a database to be processed, and a step of detecting a plurality of computers connected by the communication line. The form data processing method according to claim 1, further comprising: a step of requesting a process to a computer having the corresponding database, and a step of waiting for a response to the end of the process. 3. The method according to claim 1, wherein the step of detecting a computer having a database for performing the process includes a step of detecting a process to the database from form definition data representing preset process details of the form. Form data processing method. 4. A step of receiving a database process on a computer having a corresponding database among a plurality of computers connected by the communication line, and a step of processing the database. Form data processing method. 5. The step of processing a database on a computer having a corresponding database among a plurality of computers connected by the communication line acquires database processing data from the computer requesting the database processing. The form data processing method according to claim 4, comprising steps and a step of converting into a language for operating a database.