JPH09282322A - Currency information control system of cluster system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To efficiently perform retrieval from a data base by an interactive transaction on an optimum cluster. SOLUTION: A currency information retrieval means 111 takes an intermediate file record out of a work file 11 when an intermediate file record corresponding to currency information on the interactive transaction 101 is present in the work file 117. When not, on the other hand, a currency information retrieval means 121 for another cluster takes an intermediate file record out of the work file 122. A currency record return means 115 takes a record corresponding to the intermediate record taken out by the currency information retrieval means 111 or 121 out of the data base 107.

Description

Detailed Description of the Invention

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a currency system for a cluster system which enables an interactive transaction to be executed on an optimum cluster in a cluster system in which a plurality of clusters each comprising a plurality of hosts are further connected. It relates to an information control system.

[0001]

2. Description of the Related Art JP-A-63-245534 discloses that
There is described a technique for providing an input / output management device for working data, in which a buffer having a required size is prepared for each virtual file, a corresponding current point is managed, and the buffer is used efficiently.

Japanese Patent Application Laid-Open No. Hei 6-103308 discloses that when several records are read from a client system to a server system in one transmission / reception, if the read record includes the last record, the record is re-recorded. In order to control not to access the server system even if the read request is executed, a technique of managing the number of repetitions of transfer to the request source by currency is described.

[0003]

In the above-mentioned first conventional technique, a current point is held for each virtual file. Therefore, when an access conflict occurs with respect to the same file from a plurality of transactions, the current point is set. Points are frequently updated, and furthermore, eviction of buffers in file units also operates, resulting in a problem that transaction processing performance is deteriorated.

In the above-mentioned second conventional technique, currency information is held only in a server system.
When the operating status of the server system deteriorates, there is a problem that the efficiency of the record reading process is reduced.

An object of the present invention is to enable efficient database search processing by an interactive transaction.

Another object of the present invention is to enable interactive database search processing to be executed on an optimum cluster.

[0007]

A currency information control system in a first cluster system according to the present invention is a cluster system in which a plurality of clusters composed of a plurality of hosts are combined, and each cluster has a specific search condition. Information that uniquely indicates a record in the matching database, a work file that stores as an intermediate file record, and currency information that includes the currency information that points to the intermediate file record, and an interactive transaction that requests search processing for the record in the database, If the intermediate file record corresponding to the currency information of the interactive transaction exists in the work file,
Corresponds to the currency information retrieval unit that retrieves the intermediate file record from the work file and retrieves the intermediate file record from the work file in another cluster if it does not exist, and the intermediate file record retrieved by the currency information retrieval unit. And a currency record returning means for retrieving a record from the database.

The currency information control system in the second cluster system of the present invention is a cluster system in which a plurality of clusters composed of a plurality of hosts are combined, and each cluster is a record in a database that matches a specific search condition. A record number that uniquely indicates the intermediate file record, a work file that stores the intermediate file record, currency information that points to the intermediate file record, and an interactive transaction that requests a search process for a record in the database; It is determined whether the intermediate file record corresponding to the currency information exists in the work file, and if it is determined that the intermediate file record exists, the currency information for extracting the intermediate file record corresponding to the currency information from the work file. Inspection Means and the currency information search means determines that the intermediate file record corresponding to the currency information does not exist in the work file, the currency information to the currency information search means of another cluster to the currency information. The other system starting means for determining whether or not the corresponding intermediate file record exists in the work file of the other cluster, and the intermediate file record retrieved by the currency information retrieving means from another cluster, It is composed of currency registration means for registering in the work file and currency record returning means for extracting from the database a record corresponding to the intermediate file record extracted by the currency information retrieval means.

The currency information control system in the third cluster system of the present invention is the currency information control system in the first and second cluster systems, wherein the cluster further stores records in the database by the interactive transaction. It is characterized by further comprising a search end notifying means for deleting the intermediate file record corresponding to the record from the work file after the search processing is completed.

[0010]

DESCRIPTION OF THE PREFERRED EMBODIMENTS One embodiment of the present invention will be described below in detail with reference to the drawings.

Referring to FIG. 1, a currency information control system in a cluster system according to an embodiment of the present invention includes a system 1 (110) which is a cluster and a system 2 (system 2).
(120) construct a similar online system, share the database 107, and work file 1
17 and the work file 122 are occupied.

FIG. 4 shows a method for managing search information in a database according to the present invention.

An SQL statement (40) specifying that a specific record in a database is searched based on a certain condition
When 1) is executed, a record number uniquely indicating a record that satisfies the condition is created on the work file (420) in the format of the intermediate file (421). In an interactive transaction, to retrieve the desired record,
Currency information (413) indicating a record on the work file (420) is held in the transaction.

A currency information control system in a cluster system according to an embodiment of the present invention will be described below with reference to FIGS.

According to the execution of the interactive transaction (101) in each terminal, the processing task determining means (10)
2) is started.

The processing task determining means (102) determines a task on which a transaction operates based on system operation information. In this embodiment, a task of the system 1 (110) is requested for processing.

The task of the system 1 (110) requested to process first activates the currency information search means (111).

The currency information retrieving means (111) outputs currency information (41) of the interactive transaction (101).
0), an intermediate file record (421) corresponding to the object serial number (411) and the intermediate file serial number (412).
Is searched for in the work file (117).

The currency information retrieval means (111) activates the other system activation means (104) if there is no corresponding result as a result of the retrieval.

The currency information search means (111) activates the currency record return means (115) if there is a corresponding one as a result of the search.

The other system starting means (104) uses the object serial number (411) and the intermediate file serial number (412) of the currency information as parameters to set the other system 2 (1).
20), the currency information retrieval means (12
1) Start up.

The currency information retrieving means (121) includes an object serial number (411) and an intermediate file serial number (4) of the currency information notified from the other system starting means (104).
It searches whether the intermediate file record (421) corresponding to 12) exists in the work file (122) of the own system.

In the system 2 (120), an intermediate file record (42) having a corresponding object serial number
If 1) is found, the requesting system 1 (11
0), the intermediate file record (421) is returned.

The system 1 (110) activates the object loading means (112) based on the object serial number (423) registered in the returned intermediate file record (421).

The object loading means (112) reads the detailed information of the search condition from the object file (105) and the detailed information for the search target table from the directory file (106), and prepares an environment necessary for the search.

The currency registering means (114) registers the returned intermediate file record (421) in the work file (117) on its own system, and activates the currency record returning means (115).

The currency record returning means (115)
Based on the intermediate file record (421) on the work file (117), the record serial number of the current intermediate file position (413) in the currency information (410) is read, and the data file is read based on the record serial number. The target record is returned from (107).

When the search for the target search condition is completed, the search end notifying means (116) is started, and the other system starting means (104) is started to notify the intermediate file record serial number to be released. As a result, the intermediate file records to be released are searched from the work files on all the systems, and all of them are deleted.

Hereinafter, a currency information control system in a cluster system according to an embodiment of the present invention will be described in more detail with reference to FIGS.

With reference to FIG. 5, an example of accessing a database called a membership table (530) by an SQL statement (500) which is a database access language will be described. Since various records are stored in the member table (530),
The search condition of the target record is designated by the SQL statement (501). In this example, a request is made to search for a member name in the forward direction on condition that the age is 35 to 65. It is also assumed that the corresponding record has already been read up to the second record from the current bitmap record position information of the currency information (510).

When the interactive transaction is executed (step 201), the processing task determining means (102)
Refers to the system operation information, selects the system 1 (110) with less resource waiting, and determines a processing task (step 202).

The currency information retrieving means (111), based on the object serial number (121 in the embodiment) and the bitmap record serial number (100 in the embodiment) of the currency information (510) of the transaction, creates a work file (100) in its own system. 520) is searched for the existence of a bitmap record (step 203).

The currency information retrieving means (111) retrieves the work file (520) and retrieves the object serial number:
121, the intermediate file serial number: No bitmap record corresponding to 100 is found, so the other system starting means (104) is started (step 204).

The other system starting means (104) is a currency information searching means (121) of the other system 2 (120).
Then, a search request is made as to whether a bitmap record corresponding to the work file (540) exists based on the object: 121 and the intermediate file serial number: 100 (step 211).

The currency information retrieving means (121) retrieves whether the bitmap record exists (step 21).
2) Since the corresponding bitmap record (541) is registered, the bitmap record (541) is returned to the requesting system 1 (110) (step 2).
13).

The object loading means (112) of the system 1 (110) has an object file (105).
Search conditions and directory files (10
The detailed information of the corresponding member table (530) is read from 6), and the environment necessary for the search is prepared (step 205).

The currency registering means (114) inserts the bitmap record (541) into the work file (520) on its own system (step 206).

The currency record returning means (115)
The next record in the forward direction from the current bitmap record position (second in the embodiment) in the currency information (510) based on the bitmap record of the work file (520) on the own system: Sato of record serial number 108 Expo data is read (step 207).

When terminating the retrieval process, the retrieval end notifying means (116) retrieves a corresponding bitmap record from the work file of the own system (step 30).
2) If found, delete it (step 303).

For the other system 2 (120), a bitmap record to be released is notified by the other system starting means (104) (step 311), and if found in the work file (540), it is similarly deleted (step 303). ).

As described above, the processing of the currency information control system in the cluster system according to one embodiment of the present invention is completed.

The currency information control system in the cluster system according to one embodiment of the present invention stores an intermediate file as a search result of a database of an interactive transaction, and can transfer the intermediate file between the clusters. have.

[0043]

As described above, the currency information control system in the cluster system according to the present invention stores an intermediate file, which is a search result of a database of an interactive transaction, and inherits the intermediate file between the clusters. With this configuration, it is possible to execute an interactive transaction database search process on any cluster constituting the cluster system. That is, there is an effect that the database search processing by the interactive transaction can be efficiently executed on the optimal cluster.

[Brief description of drawings]

FIG. 1 is a block diagram according to an embodiment of the present invention.

FIG. 2 shows a processing task determining means (102), a currency information searching means (111), another system starting means (104), and a currency information searching means (12) in one embodiment of the present invention.
1 is a flowchart showing processing of an object loading unit (112), a currency registration unit (114), and a currency record returning unit (115).

FIG. 3 is a flowchart showing a process of a search end notifying unit (116) and another system starting unit (104) in one embodiment of the present invention.

FIG. 4 is a diagram showing a method for managing search information in a database according to an embodiment of the present invention.

FIG. 5 is a diagram illustrating a state of movement of a bitmap record between clusters according to an embodiment of the present invention.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 101 Interactive transaction 102 Processing task determination means 104 Other system activation means 105 Object file 106 Directory file 107 Data file 110 System 1 111 Currency information search means 112 Object load means 114 Currency registration means 115 Currency record return means 116 Search processing end means 117 Work file 120 System 2 121 Currency information search means 122 Work file 401 SQL statement 410 Currency information 411 Object serial number 412 Intermediate file serial number 413 Current intermediate file position 420 Work file 421 Intermediate file record 500 Transaction information 501 SQL statement 510 Currency information 520 Work file 521 Bitmap record 530 Member table 540 Work file 541 Bitmap record

Claims (3)

[Claims] 1. In a cluster system in which a plurality of clusters composed of a plurality of hosts are combined, each cluster stores, as an intermediate file record, information uniquely indicating a record in a database that matches a specific search condition. A work file, including currency information pointing to the intermediate file record,
If an interactive transaction requesting a search process for a record in the database and the intermediate file record corresponding to the currency information of the interactive transaction are present in the work file, the intermediate file record is set to the work file. A currency information retrieval unit that retrieves the intermediate file record from the work file in another cluster if it does not exist, and a record corresponding to the intermediate file record retrieved by the currency information retrieval unit from the database A currency information control system in a cluster system, comprising a currency record returning means. 2. In a cluster system in which a plurality of clusters composed of a plurality of hosts are combined, each cluster stores, as an intermediate file record, a record number uniquely indicating a record in a database that matches a specific search condition. And a currency file that points to the intermediate file record,
An interactive transaction requesting a search process for a record in the database, and whether or not the intermediate file record corresponding to the currency information of the interactive transaction is present in the work file, is determined to be present. In this case, a currency information search unit that extracts an intermediate file record corresponding to the currency information from the work file, and the currency information search unit does not include the intermediate file record corresponding to the currency information in the work file. When it is determined, the other system is started, which causes the currency information search unit of another cluster to determine whether the intermediate file record corresponding to the currency information exists in the work file of the other cluster. Means from other clusters Currency registration means for registering the intermediate file record retrieved by the currency information retrieval means in the work file, and currency record returning means for retrieving a record corresponding to the intermediate file record retrieved by the currency information retrieval means from the database. A currency information control system in a cluster system, characterized by comprising: 3. The cluster further comprises search end notifying means for deleting the intermediate file record corresponding to the record from the work file after the search process for the record in the database by the interactive transaction is completed. A currency information control system in a cluster system according to claim 1 or 2, characterized in that.