How can people access booking system multiple at the same time?

Asked By Kristin Runaldou 30 points N/A Posted 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.

• Status: Open
• Question Views: 571
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database

Answered By Ccharle William 5 points N/A #184487

How can people access booking system multiple at the same time?

Hi,

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.

Regards,

Ccharle Williams

 

About Ccharle William

Questions
1

Answers
24

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 02/25/2013
• Question Category: Database