JPH0738203B2 - Seat reservation system - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION [Industrial field of application] The present invention is suitable for use in a system for seat reservation by a computer. The present invention relates to an online update process of a seat reservation system in which a plurality of update processes occur.

〔Overview〕

The present invention includes a plurality of seating processing units, a main storage unit including a seat management table for seat management, and an external storage unit including seat files. By providing a plurality of seat request information, which file of the plurality of seat files contains the restoration information by managing the serial number, the response of the updating process can be improved.

[Conventional technology]

Conventionally, this type of seating system is composed of a plurality of seating processing units, a main storage device including a seat management table for seat management, and an external storage device. Because of only one, when a plurality of seat request information is issued at the same time, a state of waiting for a seat file occurs.

[Problems to be solved by the invention]

In the conventional seating method described above, since there is only one seat file in the external storage unit (restoration information file), waiting occurs due to exclusive processing of the seat file during update processing, so multiple seat request information is stored. If they occur at the same time, there is a drawback that waiting for seat files adversely affects the response.

The present invention eliminates such drawbacks, and an object of the present invention is to provide a method of distributing seat file waiting times and improving response of update processing.

[Means for solving problems]

The present invention relates to a main storage unit having a seat management table for managing seat reservation status, an input unit for seat request information, a plurality of seat reading tables that read out the seat management table, and perform a seat taking process according to the input seat request information. In the seat reservation system of the seat reservation system including the seat request information processing unit having the seat acquisition processing unit and the external storage unit having a plurality of seat files for temporarily storing the information of the seat management table,
The main storage unit includes a serial number management table that manages, by serial numbers, in which seat file of the plurality of seat files the recovery information is recorded.
Each time a seating process is updated for each data identification name, the serial number is added, and the updated information is stored by being distributed to the multiple seat files, and the data identification name and new serial number are also stored in the serial number management table. It is characterized in that it includes means for storing and in correspondence with each other.

[Action]

When the seat request information arrives, the seat removal processing unit reads out the seat management table that manages seats and performs the seat removal processing. Each time the seating process is updated, the serial number is added for each data identification name and stored in the serial number management table, and the updated information is distributed and stored in a plurality of seat files. Which seat file of a plurality of seat files is stored is managed by the latest serial number for each data identification name stored in the serial number management table.

In this way, the information temporarily stored in the seat management table is distributed and stored as the latest information in a plurality of seat files, so that even if a plurality of pieces of seat request information arrive at the same time, the seat picking processing unit applies the corresponding seat file. Therefore, the waiting state due to the exclusive processing of the seat file can be eliminated, and the response of the update processing in the seat reservation can be promptly performed.

〔Example〕

Next, embodiments of the present invention will be described with reference to the drawings. FIG. 1 is a block diagram showing the configuration of the embodiment of the present invention. In the embodiment of the present invention, a train seat reservation system will be described in the case where four seating processing units are provided.

The seat reservation system (transaction processing system) according to the embodiment of the present invention includes a seat management table 10 for managing seats.
And a main storage unit 3 having an input unit 1 for seat request information a
, The seat management table 10 is read out, and a plurality of seat removal processing units 5 to 8 for performing seat removal processing according to this seat request information.
Seat request information processing unit 2 having a seat management table 10
The external storage unit 4 having a plurality of seat files 11 to 14 for temporarily recording the information of the above is provided, and in the main storage unit 3, the seat file of the plurality of seat files 11 to 14 in which the restoration information is recorded is determined by a serial number. Each of the seating processing units 5 to 8 including the serial number management table 9 to be managed adds the serial number each time the seating processing is updated for each data identification name, and distributes it to the plurality of seat files 11 to 14. A means for storing the updated information and also storing the serial number management table 9 in association with the data identification name and the new serial number, and referring to the serial number management table 9 when a failure occurs in the seat management table 10, A means for restoring the seat update information from the seat files 11 to 14 storing the seat update information of the latest serial number is provided.

The serial number management table 9 has the latest serial number for each train identification name, and the seat management table 10 has a seat pit pattern for one row for each train identification name. Further, the seat request information processing unit 2 uses the serial number management table 9, the seat management table 10 of the main storage device 3 and the seat files 11, 12, 1 of the external storage unit 4.
Input and output from 3 and 14.

FIG. 2 is a diagram showing an image of the restoration information 15 according to the embodiment of the present invention. This restoration information 15 is set as a restoration information file on the external storage unit 4. The restoration information 15 is composed of a train identification name (data identification name) 16, a serial number 17, and a seat bit pattern 18 for one train. A serial number 17 is secured for each train identification name 16, and each serial number is incremented by 1. Seating processing section 5,
6, 7, 8 are added to the serial number 17 in the serial number management table 9 for each train identification name 16 according to a certain rule, and each seat request information a
The recovery information 15 serial number is added to.

The seat request information (transaction) a is distributed to the seat removal processing units 5, 6, 7, 8 according to a certain rule, and the respective seat removal processing units 5, 6, 7, 8 simultaneously convert the seat request information into the respective seat request information. Based on this, processing is started.

First, the seating processing unit refers to the seat bit pattern of one train from the seat management table 10 by using the train identification name of the seat request information a as a key, and regarding the seat bit pattern for this one train, References and updates from other seating processing units 6, 7, and 8 are temporarily disabled. Then, if the seat number information of the seat request information a satisfies a certain condition that is equal to or less than the number of seats of the train referenced from the seat management table 10, the seat is taken and the seat bit pattern of the corresponding one train of the seat management table 10 is updated. In addition, the seat bit pattern of one train after the update is stored in the seat take processing unit, and the seat bit pattern of the corresponding one train can be referenced and updated from another seat take processing unit.

Secondly, the train identification name of the seat request information a is used as a key to refer to the serial number from the serial number management table 9, and this seat number cannot be temporarily referenced or updated by other seating processing units. . And 1 for the serial number of the referenced train identification name
Is added to update the corresponding serial number in the serial number management table 9, and the serial number after addition is saved in the seat picking processing unit, and the corresponding serial number in the serial number management table 9 can be referred to and updated from another seat picking processing unit. To

Thirdly, the allocation of the seat file for which the recovery information is to be updated is such that when the remainder when the serial number stored from the serial number management table 9 is divided by 4 of the seat file is 1, the seat file 11
When the remainder is 2, the seat file 12 is assigned, when the remainder is 3, the seat file 13 is assigned, and when the remainder is 0, the seat file 14 is assigned. When the seat file to be updated is assigned, seat request information a
Restoration information 15 is created from the train identification name, the serial number management table 9 and the seat management table 10 and the bit pattern of the seats for one train, and the assigned seat file is updated.

Next, a method of recovery when a failure occurs in the seat management table 10 will be described. First, focusing on one train, because there are four seat files for one train, there are four pieces of restoration information 15 for one train per train. Restoration is possible for one train by moving only the seat bit pattern of the latest serial number (the serial number increases by 1 for each request, so the maximum serial number is the latest serial number) to the seat management table 10. Becomes Similarly, the seat management table 10 can be restored by moving the seat bit pattern 18 for one train in the restoration information 15 of the latest serial number to the seat management table 10 for every train identification name.

In addition, even if the seat management table 10 fails and one of the seat files 11, 12, 13, and 14 also fails, it fails because there are multiple seat files 11, 12, 13, and 14. By using the seat bit pattern of the maximum serial number of the recovery information 15 for each train identification name from a seat file that is not stored, the latest serial number or the seat bit pattern immediately before the latest serial number can be restored for each train.

〔The invention's effect〕

As described above, according to the present invention, a plurality of seat files are prepared, and the allocation destination of the seat file to be updated is determined and assigned by the remainder obtained by dividing the serial number, which increases by one for each train, by the number of seat files. Distributing the seat file to be updated after updating the seat file and the file waiting time of the seat at the time of updating have the effect of improving the response of the update process.

[Brief description of drawings]

FIG. 1 is a block diagram of information of the present invention. FIG. 2 is an image diagram of restoration information stored in the seat file according to the embodiment of the present invention. 1 ... Input means, 2 ... Seat request information (transaction) processing section, 3 ... Main storage section, 4 ... External storage section (restoration information file), 5, 6, 7, 8 ... Seat picking processing section ,
9 …… Serial number management table, 10 …… Seat management table, 1
1, 12, 13, 14 …… Seat file, 15 …… Recovery information, 16
…… Train identification name (data identification name), 17 …… Serial number, 18 ……
Bit pattern of seats for one train.

Claims (1)

[Claims] 1. A main storage unit having a seat management table for managing seat reservation status, an input unit for seat request information, the seat management table is read, and a seat taking process is performed according to the input seat request information. In the seat reservation system of the seat reservation system, which includes a seat request information processing unit having a plurality of seat processing units and an external storage unit having a plurality of seat files for temporarily recording the information of the seat management table, The section includes a serial number management table that manages, by serial number, which seat file of the plurality of seat files the recovery information is recorded, and the plurality of seat take processing units update the seat take processing for each data identification name. Each time it is performed, the serial number is added, and the updated information is stored by being distributed to the above-mentioned seat files. A seat reservation system for a seat reservation system, which includes a means for storing an alias and a new serial number in association with each other.