Do we need Record Level Locking when we already have Transaction for online ordering? (of concert ti

Posted by Jian Lin on Stack Overflow See other posts from Stack Overflow or by Jian Lin
Published on 2010-04-25T10:24:53Z Indexed on 2010/04/25 10:33 UTC
Read the original article Hit count: 210

Filed under:

transactions

|

record-locking

|

rdbms

|

dbms

For online ordering of concert seat or airline ticket, do we need Record Level Locking or is Transaction good enough?

For concert ticket (say, seat Number 20B), or airline ticket (even with overbooking, the limit is 210, for example), I think the website cannot lock any record or begin transaction when showing the ticket purchase screen.

But after the user clicks "Confirm Purchase", then the server should Begin a Transaction, Purchase Seat Number 20B, and try to Commit.

If another user already bought Seat 20B in a previous transaction, then it is the "Commit" part that the current transaction will fail?

So... we don't need Record Level Locking? Do Transactions always go serialized (one after another), so that's why we can know for sure there is no "race condition"? In what situation is Record Level Locking needed then?

© Stack Overflow or respective owner

Related posts about transactions

NServiceBus and NHibernate - Message Handler and Transactions

as seen on Stack Overflow - Search for 'Stack Overflow'
From my understanding NServiceBus executes the Handle method of an IMessageHandler within a transaction, if an exception propagates out of this method, then NServiceBus will ensure the message is put back on the message queue (up X amount of times before error queue) etc.. so we have an atomic operation… >>> More
Reliable test for MSDTC promoting transactions to distributed?

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I reliably check that MSDTC has promoted a transaction to a distributed transaction, from .net code? Currently a co-worker is testing this by shutting down the coordinator on his machine - if an exception is thrown this is taken as evidence that an attempt to promote the transaction has occurred… >>> More
[News] Travailler avec Entity Framework et les transactions

as seen on Dot Net Guru - Search for 'Dot Net Guru'
Voici un article comme on voudrait en lire plus souvent sur l'utilisation des transactions dans le contexte des ORM Entity Framework et Linq2SQL. Il d?crit de mani?re tr?s synth?tique les transactions implicites et explicites et effleure l'approche pessimiste et optimiste. >>> More
Transactions in LINQ to SQL applications

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
In this post I would like to talk about LINQ to SQL and transactions.When I have a LINQ to SQL class I always get asked this question, "How does LINQ treat Transactions?". When we use the DeleteOnSubmit() method or the InsertOnSubmit() method, all of those commands at some point are translated into… >>> More
T-SQL Tuesday #31: Paradox of the Sawtooth Log

as seen on SQL Blog - Search for 'SQL Blog'
Today’s T-SQL Tuesday, hosted by Aaron Nelson ( @sqlvariant | sqlvariant.com ) has the theme Logging . I was a little pressed for time today to pull this post together, so this will be short and sweet. For a long time, I wondered why and how a database in Full Recovery Mode, which you’d expect to… >>> More

Related posts about record-locking

Record locking problem between linux and Windows

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to run a bunch of old DOS FoxPro / Clipper applications in linux under DOSEMU. The programs access their "databases" located on a network server (could be a Windows or Linux server) Actually, the programs ran fine, but I cannot manage to make the record locking work as supposed: I can run… >>> More
How can I get SQL Server transactions to use record-level locks?

as seen on Stack Overflow - Search for 'Stack Overflow'
We have an application that was originally written as a desktop app, lo these many years ago. It starts a transaction whenever you open an edit screen, and commits if you click OK, or rolls back if you click Cancel. This worked okay for a desktop app, but now we're trying to move to ADO.NET and SQL… >>> More
Do we need Record Level Locking when we already have Transaction for online ordering? (of concert ti

as seen on Stack Overflow - Search for 'Stack Overflow'
For online ordering of concert seat or airline ticket, do we need Record Level Locking or is Transaction good enough? For concert ticket (say, seat Number 20B), or airline ticket (even with overbooking, the limit is 210, for example), I think the website cannot lock any record or begin transaction… >>> More
Is there a limitation on the number of sockets being used in any application?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a limitation on the number of sockets being used in any application? In our application for record locking purpose we are handling all the connected users in a middle layer which sometimes get crashed when more number of users are connected to that. >>> More
Online ALTER TABLE in MySQL 5.6

as seen on Oracle Blogs - Search for 'Oracle Blogs'
This is the low-level view of data dictionary language (DDL) operations in the InnoDB storage engine in MySQL 5.6. John Russell gave a more high-level view in his blog post April 2012 Labs Release – Online DDL Improvements. MySQL before the InnoDB Plugin Traditionally, the MySQL storage… >>> More