JPH06119224A - On-line system consisting of host computer and work station both of which have data base - Google Patents

Abstract

PURPOSE:To always secure the consistency of a data base of a host computer and a data base of a work station, in the on-line system consisting of the host computer and the work station connected thereto. CONSTITUTION:In the host computer 10, when new data is generated by a result of execution and a processing of a transaction, its data base 13 is updated by using this new data, and also, the new data is transferred immediately to a work station 20, and a data base 23 of the work station 20 is also updated in the same way. When new data is generated in the work station 20, as well, the data base 23 of the work station is updated, and also, the new data is transferred immediately to the host computer 10, and its data base 13 is updated in the same way.

Description

Detailed Description of the Invention

[0001]

TECHNICAL FIELD The present invention relates to an online system including a host computer and a work station both having a database.

[0002]

2. Description of the Related Art Online systems have been constructed in various fields. Online systems are generally hosted
It is composed of a computer system and one or a plurality of work stations or terminals connected to the computer system via various networks such as a LAN.

For example, in an online system used in the fields of finance and securities, data relating to domestic stocks, domestic bonds, foreign bonds, etc. is stored in the host computer data.
It is registered in the base, and the above-mentioned transaction information in the data base is updated every time a sales order is generated. A data base is also provided in the work station connected to the host computer, and the data in the data base is similarly updated in the work station each time a transaction occurs.

In the conventional online system, the host
The consistency between the data in the computer database and the data in the workstation data base was not always maintained. This is because the work station communicates with the host computer to capture the host computer's database only when needed. The host computer also receives data from the workstation's database only when needed.

[0005]

DISCLOSURE OF THE INVENTION It is an object of the present invention to always keep the same data in the data bases of a host computer and a work station connected thereto.

The online system according to the present invention is
It comprises a host computer system having a database and a work station having a database and connected to the host computer system.

The host computer system receives the generated data, updates the data base with the received data, and updates the data by the updating means.
Sending means is provided for transferring data relating to the generated data to the work station in response to the updating of the base.

The work station is provided with means for receiving data relating to the generated data transferred from the host computer system, and means for updating the data base with the data received by said receiving means.

According to the present invention, when new data is generated by the occurrence of a transaction or various processing in the host computer and the data of the data base is updated, this is used as a trigger. Immediately the data about the data that occurred is communicated to the workstation (download) and the corresponding data in the workstation's database is updated as well.

Therefore, the same data is always stored in the data base of the host computer and the data base of the work station.

In an online system comprising a host computer system having a database according to the present invention and a work station having a database and connected to the host computer system, a work system is provided. The station receives the generated data, updates the data base with the received data, and, in response to the update of the data base by the updating means, sends data relating to the generated data to the host.
A host computer system for receiving data relating to the generated data transferred from the work station; and a data means using the data received by the receiving means. It has a means to update the base.

According to the present invention, the data generated when a new data is generated due to the occurrence of a transaction or various processings in the work station and the data of the data base is updated. The data is immediately transmitted to the host computer (upload) and the corresponding data in the host computer's database is also updated in the same way.

Therefore, the same data is always stored in the database of the work station and the database of the host computer.

As described above, according to the present invention, the consistency between the data base of the host computer and the data base of the work station can always be ensured.

[0015]

[Explanation of Examples]

(1) Configuration of online system Figure 1 shows a host computer with a database.
The overall configuration of an online system including a system (hereinafter simply referred to as a host system) and a work station is shown.

The host system 10 is generally realized by a large computer and includes a CPU 11, a main storage device 12 and an auxiliary storage device 13. The auxiliary storage device 13 is, for example, a disk memory, and a database is provided therein. Communication control unit for host system 10
Terminals 19 are connected via 18 respectively.

A plurality of work stations 20 are connected to the host system 10 via a network (for example, token ring run) 17 and communication control devices 16 and 26, respectively.

The work station 20 also has a CPU 2
1. It has a main memory device 22 and an auxiliary memory device 23.
A data base is provided in the auxiliary storage device 23.

If necessary, another work station 29 is connected to the work station 20 via a network (for example, an Ethernet system run) 28.

Host system 10, terminal device 19, work
It goes without saying that the stations 20 and 29 are provided with a keyboard, a mouse, other input devices, a CRT display device, a printer, and other output devices.

The data bases of the host system 10 and the work station 20 are related to data relating to financial operations such as domestic stock data, domestic and foreign bond data, for example. Domestic bond data consists of issue, delivery date, unit price, quantity, etc., and can be accessed using, for example, the order number as a key. Foreign bond data consists of exchange rates, issues, etc., and is accessed using, for example, the order number as a key.

Such business data is input and output through the terminal 19 in the host system 10. Further, in the work station 20, the data is input and output through the input / output device. Data processing (insert), data replacement (replace)
) And delete. These are called updating of data in the database.

When the data of the data base is updated in the host system 10 in response to the input from the terminal device 19, the contents are transmitted to the work station 20 in real time, and the work station 20 Will be updated in the same way (this is called the download function). Also, when the data in the database is updated at work station 20,
The contents are transmitted to the host system 10 in real time, and the data in the data base of the host system 10 is updated in the same manner (this is called upload function).

The online system is
It has a load function, an upload function, and a function (communication monitoring function) for monitoring the communication between the host system 10 and the work station 20 for updating the database.

(2) Program Structure in Host System and Work Station FIG. 2 shows a program structure for the CPU 11 in the host system 10. FIG. 3 shows the program structure for CPU 21 at work station 20. Each program indicated by a block is called a software package.

This online system is premised on an existing program system, and by adding a new program thereto, the above-mentioned down load function,
It achieves the upload / load function and communication monitoring. The existing programs are shown in white blocks, and the blocks of the newly added programs are hatched.

First, an existing program package will be described.

Referring to FIG. 2, the existing program package in the host system 10 is an IBM host
It is run on a computer, and its contents are as follows. The name of the program is based on IBM's name.

MVS: Refers to the operating system of the host computer. VTAM: Communication control program, host computer and external devices (terminals, work stations, etc.)
Allows communication with. IMS / VS: Information Management
It is called a system. An online transaction program that manages business applications (programs) and updates the database. Business application: Accepts business-related inputs such as sales orders and accesses the database accordingly. A program that checks the balance of each account on a predetermined date is also included. SAIL: An operation support program under IMS / VS. Middle: A support program for SAIL.

Referring to FIG. 3, work station 20
The existing program package in IBM works on the work station RS / 6000 of IBM Corporation, and the contents are as follows. The name of the program is based on IBM's name.

AIX ver3.1.6: Refers to the operating system of the work station. SNA Service / 6000: A communication control program. SYBASE: A generic name for a database management program group, which accesses the database of a work station. Includes SQR Server and DB Library.

IMS / VS in host system 10
Database updates and workstations under
New programs are added to host systems and workstations to establish consistency with database updates under SYBASE at 20.

Referring to FIG. 2, the new programs added to the host system 10 are as follows.

IMS LU 6.2 Adapter: IMS / V
It is a program that enables S to communicate with external devices using the LU 6.2 / SNA protocol. This program is executed as a kind of application under VTAM in an address space independent of IMS / VS. The LU 6.2 / SNA protocol is a protocol that defines only the transmission / reception rules and has no restrictions on the data format. This gives I
MS / VS will be able to transfer business data to work stations in real time. Down load control: This is a kind of application program under SAIL that controls communication related to data transfer. Enables control of SAIL from business applications under IMS / VS. Adapter input process: S from the message from IMS / VS
A kind of application for converting to the format for AIL and passing it to the download control under SAIL
It is a program. Enables control from SAIL to IMS. Down-load transmission processing: This is a subroutine program that is called from a business application and edits down-load data and is responsible for the interface with down-load control. Data base initialization process: An application that uses the independent database function under SAIL that logically initializes the database used for download transmission.
It is a program.

Referring to FIG. 3, work station 20
The new programs to be added to are as follows.

Reception processing: Logical terminal (Logical Unit:
When data is received from the host system in LU units, a processing program that is activated each time by the SNA Service / 6000 receives one transfer data in LU units. Operates independently in LU units. Sending process: Sends one transfer data in LU units to the host system. Assembling process: Receives the transfer data from the receiving process defined in the transfer group in the message queue, and checks the host serial number and combines the divided format data. Operates independently for each transfer group. Conversion processing: Transfer data is converted and rearranged in field units according to the contents of the conversion definition file. The code system is converted between the host system and the work station. Primary table registration / secondary application start-up process: The converted transfer data is registered in the designated primary table in the received data base. This is achieved by calling the SYBASE stored procedure prepared for each table. After the registration in the primary table is completed, the designated secondary application is started. Initialization processing: Initializes the management table, starts the connection with the host system, and initializes the primary table. Start processing: When the open command is received from the host system, the processing to shift to the open mode is performed. Restart processing: When the restart command is received from the host system, the processing to shift to the open mode is performed. End processing: When the close command is received from the host system, the processing to shift to the close mode is performed. Monitor processing: Monitors the number of processes and the message queue. Operation support processing: Supports operation status inquiry, log inquiry, management area update, restart instruction, secondary application restart, etc.

(3) Down load processing In the host system 10, when there is input of some business data from the terminal device 19, the business application updates the data base according to the normal processing. At the same time (or immediately after this), the following download processing is performed, and the database in the work station 20 is updated.

The download / load processing will be described with reference to FIG. The numbers in parentheses shown in FIG. 4 represent the process numbers shown below.

In the host system, (S1) the business application calls the down load transmission processing by the U @ CALL macro instruction. (S2) In the down load transmission process, the added parameter is checked,
If (S3) OK, the down load data is edited based on the business data and output to the transmission data base (S4). (S5) Further, in the down load transmission processing, the status is checked, and if it is necessary to activate the down load control, (S6) In order to perform the actual transmission, the down load is transmitted via the IMS / VS. Derive to load control (transfer control). (S7) The download / load control checks the communication state when a transmission request is received,
(S8) Take download data from the transmission database, add a header, edit the transfer block, and (S9) send it to the LU 6.2 adapter via the IMS / VS message queue. . (S10) LU
6.2 When the adapter receives the transfer data from IMS / VS, (S11) it sends the transfer data to the work station.

At the work station, (S12)
The transfer data is received by the receiving process, (S13) After the assembling process and the converting process, the table of the receiving data base (SYBASE) is created by the primary table registration process. (S14) If the confirmation response is required, the confirmation process is transmitted to the LU 6.2 adapter by the transmission process.

In the host system again (S15)
When the LU 6.2 adapter receives the confirmation response, (S16) I
Send to MS / VS. (S17) The adapter input process is activated by the IMS in response to the acknowledgment transaction, receives the message, (S18) changes the message to the SAIL format, and downs the SAIL.
Derived to load control. (S19) Upon receiving the confirmation response, the down load control changes the corresponding data on the transmission data base to the confirmed state and ends the processing.

(4) Upload function The business data generated in the work station 10 is the same as the business data generated in the terminal device 19, and the IMS LU
6.2 IMS / VS is started via an adapter and passed to the business application under its control. This updates the database. The response from the business application is sent back to the work station via the IMS LU 6.2 adapter.

In summary, the download function uses the transaction message for updating the IMS / VS online database as a trigger to transfer the message to the work station using the SNA / LU 6.2 protocol. Then, the database is updated by SYBASE.

The upload function transfers the SYBASE update transaction that has occurred on the work station to the host system using the same protocol and updates its database by IMS / VS. It is a thing.

(5) Data Retransfer Function This online system has a function to retransfer data without any intervention by the operator when the data transfer fails for some reason. In order to realize this function, a transmission data base and a primary data base are provided on the host system side and the work station side, respectively, and the transfer data is held on these data bases.

Retransfer from the host system side Since the relevant business data is held in the transmission database on the host system, a retransfer instruction can be given to the data.

When retransmitting from the work station side Since the relevant business data is held in the primary database on the work station,
Re-transfer instruction can be given.

(6) Communication monitoring function A. Monitoring in the host system In order to check whether the down-load communication is going smoothly, the SAIL timer is used to periodically check the database and notify the operator in case of an abnormality.

A timer monitoring start command is input at the same time as the download / load start command is input, and the monitoring command is registered in the SAIL timer, thereby periodically generating a monitoring transaction.

The warning message is output in the following two cases. Response timeout If no response is received from the work station within a certain period of time since the transfer data for response was sent from the host system (the communication system after the middle of the host system, or the work station side) Middle failure is possible). Unsent timeout If the host system has unsent data and is ready to send, but has not been sent for a certain period of time (possibly due to a middle failure in the host system).

After the down load end command is input,
When the end response is returned from the work station side, the monitoring of the corresponding transfer group ends. When monitoring for all transfer groups ends, the monitoring command is set to SA
It is deleted from the IL timer and monitoring is terminated.

When the normal termination of the down load is impossible due to some failure, the host system sends the SA
The monitoring is terminated by inputting a command for deleting the monitoring command from the IL timer.

B. Monitoring in work station Monitoring and control of message queue Message queue size used by middle system is managed by operating system (OS) M
It is monitored so as not to exceed the AX value (65 Kbytes).

When the total size of messages waiting to be processed in each message queue exceeds 60% of the MAX value managed by the OS, a communication stop message is transmitted to the transfer group having the maximum total size. After that, when it returns to 40% or less, the communication start message is output.

Monitoring and Controlling the Number of Processes The total number of processes used by the middle system is controlled so as not to exceed the MAX value (80) managed by the OS. The number of processes allowed for one user is 80.

The middle system uses 5 processes per transfer group. In consideration of the fact that a maximum of 6 processes are started at the same time in the secondary application startup process, the total number of secondary application processes that are permitted = maximum permitted number− (number of transfer groups × 5) −6 When the total number exceeds 60% of the above value, a communication stop message is sent to the maximum used transfer group. After that, when it returns to 40% or less, the communication start message is output.

(7) Transfer method Transfer work data of various patterns (record length, layout, etc.) to a work station,
In order to be able to store in the database on the station, the following mechanism is provided.

A detailed ID is assigned to each business data item. This is because processing is performed according to the type of business data. The item ID indicates the category of business data, and the process to be executed can be recognized based on this item ID.

Each work station is also assigned a work station ID for identifying them.

Further, the business data to be transferred is grouped. As a result, a plurality of business data can be serialized and a large amount of data can be transmitted.

The destination of the down load is decided in the down load transmission process based on the detail ID designated by the business application.

The logical terminal used when transmitting the download to the work station is determined by the destination work station ID and the transfer group ID. One logical terminal is assigned to one transfer group. A logical terminal (LU) is a basic unit of communication and is an identification code of a virtual line according to the SNA standard.

The table and definition information for uniquely determining the logical terminal from the detailed ID are as follows.

[0064]

[Table 1]

[0065]

[Table 2]

For each business data item description I
By adding D, it is possible to recognize the pattern for each business data and realize the processing corresponding thereto.

By associating a transfer group ID with each logical terminal (LU) on the SNA, data transfer can be performed in parallel for each transfer group ID.

The item ID and transfer group ID are item IDs.
The correspondence can be defined on the table. That is, the user can make this definition dynamically (at any time without stopping the system). Further, which transfer group ID uses which logical terminal can be defined in the control segment on the transmission database on the host system, which can also be dynamically defined by the user.

On the work station side, the received business data can be stored as general-purpose data after being subjected to processing such as code conversion by the detailed ID, and an application program for reformatting it can be started.

The database on the side of the work station has a primary database and a secondary database. The former stores each item on the host system in a compressed general-purpose form with 255 bytes per item. The latter is the database used by the application system on the workstation side.

[Brief description of drawings]

FIG. 1 is a block diagram showing the overall configuration of an online system.

FIG. 2 shows a program structure of a host computer system.

FIG. 3 shows a work station program structure.

FIG. 4 shows a processing flow of download / load.

[Explanation of symbols]

 10 Host computer system 11,21 CPU 13,23 Auxiliary storage device (data base) 17 Network 19 Terminal 20 Work station

Claims (2)

[Claims] 1. A host computer system comprising a host computer system having a database and a work station having a database and connected to the host computer system The work station is provided with means for receiving data, updating the data base with the received data, and transmitting means for transferring data relating to the generated data to the work station in response to the update of the data base by the updating means. Is an online system comprising means for receiving data relating to generated data transferred from a host computer system, and means for updating a database with the data received by said receiving means. 2. A host computer system having a data base and a work station having the data base and connected to the host computer system, the work station receiving the generated data. A host computer, comprising means for updating the data base with the received data, and means for transmitting data relating to the generated data to the host computer system in response to the update of the data base by the updating means. An online system wherein the system comprises means for receiving data relating to the generated data transferred from the work station, and means for updating the database with the data received by said receiving means.