N/APosted on - 02/22/2013
I wonder to know how people access booking system multiple at the same time. There are limited seats and for those seats people send a request to the booking system. Suppose for a seat 10 people may hit “reserve now”. How the system handles then? Anyone can explain me.
How can people access booking system multiple at the same time?
The classic method using for this is by using a transactional database and to do a tentative allocation of the seat to you that expires after some length of time (e.g., 5 minutes for kiosks) that gives you enough time to pay. If the (customer-visible) transaction falls through or times out, the seat allocation can be released back into the pool. (All state changes are processed via the transactional database, and one customer-visible transaction might require many database-level transactions.). As per your example when 10 people are requesting a reservation for a single seat, based on the first customer who booked the same seat will be allocated to the user. Till this user finishes or time out from the transaction others can't book the seat.