JP3012254B2 - List information transmission method - Google Patents

Description

Description: TECHNICAL FIELD The present invention relates to a system in which a host computer and a workstation are connected to each other, and more particularly to transmission and display of list information of a database in the host computer to the workstation. About.

(Prior Art) Conventionally, in a system in which a host computer is connected to a workstation, information in a database in the host computer is transmitted to the workstation as list information, and the list is displayed, the list information is transmitted from the host computer to the workstation. Every day before, I created the entire list on the host computer and sent all the list information to the workstation.

(Problem to be Solved by the Invention) In the above-described conventional method, since the entire list information is transmitted from the host computer for each list request, there is a disadvantage that the amount of data on the communication path increases. In addition, there is a disadvantage that the time until the list information is received, that is, the response time becomes long.

Furthermore, some list information is not added or modified, and there is a drawback that it is meaningless that all list information is necessarily transmitted when a list is requested.

An object of the present invention is to perform each process of the database, record a process type and a process time for each item, search the database and extract items whose process time is later than the list creation time, and Create difference list information consisting of a set of items, create a list file from the difference list information, and display the contents of the list file on a display device to eliminate the above-mentioned drawbacks and reduce the response time It is another object of the present invention to provide a list information transmission method.

(Means for Solving the Problems) According to a list information transmission method of the present invention, in a system configured by connecting a host computer and a workstation, a list is transmitted at a workstation based on list information of a database created by the host computer. A list information transmission method for creating a file, wherein the host computer registers items in the database,
A database processing device that executes correction and deletion processing, and records a processing type and a processing time for each item;
In addition to creating list information in response to a list creation request from the workstation, the creation time is recorded in the database, and for information for which list information has already been created, information on which the above processing has been performed after the creation time A first list creation device that extracts only a difference list information by extracting only
A first communication device that returns the list information or the difference list information created by the first list creation device, and wherein the workstation receives the list information and the difference list information from the host computer. A second list creation device for creating a list file by creating a list file based on the list information, or for a list file that has already been created, by reflecting the difference list information; and And a list display device for displaying contents on a display device.

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

FIG. 1 is a block diagram showing one embodiment of a list information transmission system according to the present invention. In FIG. 1, 1 is a database, 2 is a database processing device, 3 is a first list creation device, 4 is a first communication device, 5 is a second communication device, 6
Is a second list creation device, 7 is a list display device, 8 and 9 are difference list information storage means, 10 is a list file, 11 is a display device, 100 is a host, and 200 is a work station.

The database processing device 2 executes each process (registration, correction, or deletion of information in the database) on the information on the database for which a list needs to be created, and executes any of the processes. Is recorded, and a processing time indicating the time at which the processing was executed is recorded. In the host 100, the first list creation device 3 searches the database in response to a list creation request from the workstation 200, creates a list, and records the time when the list was created as a list creation time on the database. .

If a value has already been entered in the list creation time field,
The processing time of each item of information in the list is compared with the list creation time, and a set of information configured by extracting information whose processing time is later than the list creation time is obtained, and difference list information composed of this set is created. I do. The first communication device 4 together with the second communication device 5 controls communication between the host and the workstation.

The first communication device 4 receives a list request from the workstation 200 and sends the list creation request to the first list creation device 3. The list created by the first list creation device 3 is sent to the workstation 200 in the first communication device 4. Second communication device 5 in work station 200
Is a workstation 200 together with the first communication device 4.
Communication between the host and the host 100. That is, the second
The communication device 5 sends a list creation request issued from the workstation 200 to the host 100, or
And the difference list information received from the first communication device 4 and stored in the difference list information storage means 9.

If the list information is stored in the difference list information storage means 9, the second list creation device 6 creates a list based on all the list information. When the difference list information is stored in the difference list information storage means 9, the record ID of the corresponding list in the second list file 10 is compared with the record ID of the difference list information to find a match. For each record type of the record in the difference list information,
Execute the corresponding process for each record. Here, if the record IDs of the difference list information do not match and the processing type is registration processing, the second list creation device 6 executes registration processing of the record to create a list.

The list display device 6 displays the list created by the second list creation device 6 of the workstation 200 and stored in the list file on the display device 11.

The list information in the database 1 of FIG. 1 is represented by a chain connection between a list structure of the list information and an item structure as shown in FIG. The list structure is a data group including a list name, a list creation time, and a next item address. The list creation time is the time when the list was created, and the next item address is the memory address of the next item structure displayed in the list.

The item structure in database 1 contains item numbers, data,
This is a data group including a processing type, a processing time, and a next item address. The item number is a number for the system to uniquely identify the item. The data is data of the database, the processing type indicates each processing, that is, registration, deletion, or change, of the data in the database, and the processing time is the time at which the processing was executed. The next item address is a memory address of an item structure indicating the next item shown in the list. The chain connection between the list structure and the item structure is performed by inserting the memory address of the next item structure into the next item address of the list structure or the item structure and forming an address pointer.

The difference list information in the difference list information storage means 9 shown in FIG. 1 is represented by a chain connection between the difference list structure of the difference list information of FIG. 2 and an item structure. The difference list structure is a data group including a list name and a next item address, and the next item address is a memory address of a next item structure to be developed as a difference list.

The list file in FIG. 1 is represented by a chain connection between the list structure and the item structure in FIG.

The item deletion information in FIG. 1 is represented by a chain connection between the item deletion structure in FIG. 2 and the item structure. The item deletion structure is a data group including a list name and a next item address, and the next item address is a memory address of an item structure indicating the next item to be deleted from the list. The item structure linked with the item deletion structure is a structure having no data part.

As shown in FIG. 3, the list A displayed on the display device 11 is created as follows. That is, the second list creation device 6 searches for a list structure whose list name is A in the list information of the database. At this time,
Since the list creation time of the list structure is blank, the next item address of the list structure and the next item address of the item structure chained to the next item address are successively repeated until the next item address becomes blank. The item number, data, processing type, and processing time stored in the body are read.
Next, the second list creation device 6 creates an item structure that is linked to the difference list structure, records the time when the list was created at the list creation time of the list structure, and creates the difference list structure. The first communication device 4 is notified of the completion.

The first communication device 4 transfers, to the second communication device 5, difference list information in which a difference list structure and an item structure are linked in a chain. The second communication device 5 stores the difference list information transferred from the host 100 as difference list information, and passes control to the second list creation device 6. The second list creation device 6 collates the list name of the difference list structure in the difference list information with the list name of the list structure existing in the list file. In this case, since the corresponding file does not exist in the list file, the second communication device 5 determines that the file is a newly created list, and determines the list file 10 from all the difference list information.
Is created, and the end of the creation is notified to the list display device. The list display device 7 displays the list A on the display device 11 based on the contents of the list file 10.

Here, the flow when the list [A] is displayed again will be described on the assumption that one item of the list [A] has been deleted.

The database processing device 2 deletes the item of the list information A of the database. At this time, "Delete" is entered in the processing type of the item structure corresponding to the deleted item, which is linked to the list structure of the list information A, and the time at which the deletion process was executed is recorded in the processing time column. . First list creation device 3
Receives a list [A] creation request, searches for a list structure whose list name is A in the database list information, and lists the list creation time of the list structure and the items chained to the list structure. Compare with the processing time of the structure. If the processing time of the item structure is later than the list creation time, the first
The list creation device 3 copies the item structure so as to be an item structure that is cascaded with the difference list structure of the difference list information of the list [A], and creates the difference list information. A transfer request is issued to the communication device 4. First communication device 4
Transfers the difference list information of the workstation 200. The second list creation device 6 collates the list name of the difference list structure in the difference list information with the list name of the list structure existing in the list file 10, and searches the list file of the list A. Here, an item structure that is chain-connected to a list structure of a list file having the same value as the item number of the item structure that is chain-connected to the difference list structure of the difference list information is handled. Therefore, the process (deletion) indicated by the process type of the item structure is executed on the item structure, the contents of the list file 10 are changed, and the end of the list creation is notified to the list display device. .

The list display device 7 displays the list [A] from the list file 10 on the display device 11. In this way, by sending the difference list information from the host 100 to the workstation 200, a list can be created and displayed.

(Effects of the Invention) As described above, the present invention treats only list information in which a change such as registration, correction, or deletion has occurred as difference list information, and transmits the list between the host and the workstation. Since the entire list information is not transmitted for each list request from the host computer for creating / displaying the file, the amount of data on the communication path is reduced, and the time required to display the list can be shortened. effective.

[Brief description of the drawings]

FIG. 1 is a block diagram showing one embodiment of a list information transmission system according to the present invention. FIG. 2 and FIG. 3 are explanatory diagrams each showing an operation example utilizing the present invention. DESCRIPTION OF SYMBOLS 1 ... Database 2 ... Database processing device 3,6 ... List creation device 4,5 ... Communication device 7 ... List display device 8,9 ... Difference list information storage means 10 ... List file 11 ... Display apparatus

 ────────────────────────────────────────────────── ─── Continuation of front page (56) References JP-A-63-291142 (JP, A) JP-A-63-276640 (JP, A) JP-A-63-262724 (JP, A)

Claims (1)

(57) [Claims] 1. A list information transmission method in a system configured by connecting a host computer and a workstation, wherein a list file is created at a workstation based on list information of a database created by the host computer, The host computer executes a process of registering, correcting, and deleting items with respect to the database, and records a process type and a process time of each item, and responds to a list creation request from the workstation. In addition to creating list information, the creation time is recorded in the database, and for information for which list information has already been created, only information that has been subjected to the above processing after the creation time is extracted to create difference list information. And a list of the workstations. A first communication device that returns list information or difference list information created by the first list creation device in response to a creation request, wherein the workstation sends the list information and the difference list information from the host computer. A second communication device to receive, and a list file created based on the list information;
Alternatively, for a list file that has already been created, a second list creation device that creates a list file by reflecting the difference list information, and a list display device that displays the contents of the list file on a display device List information transmission method characterized by the following.