Re: Informix vs. Sybase vs. Oracle vs. (gasp) MS SQL Server

On 01 Dec 1997 21:02:24 -0700, Pablo Sanchez <pablo@sgi.com> wrote: : :I phoned two airline companies: United and US Air. I :interviewed the person taking reservations and here are the :responses: Since it's been _YEARS_ since I messed at all with Sabre, things may have changed. However, last I remember, the record is locked as long as an attendant has it on the viewscreen with the "context" set to the seat level. (There's a flight level, a class level and a seat level) If you don't "do something" within a specific period, (1 minute I think) the context pops back to the level above (class level) and the seat is released. In the VIEW mode, you can see whatever seats are available at a given moment in time: They can be swiped, out but, when you move from view to reserve, the screen refreshes and taken seats are marked out. : :US Air: :------- :You can view the list of available seats and present that to :the customer. If the customer requests that seat, they go :through the reservation process and that seat *may* be :swiped by another office. That is, there's no lock that is :placed on that seat. : :I interpreted this in db terms as follows: : :tx #1: : : select list of available seats for flight number : :tx #2: : : begin tx : update seat_table where flight_number is the one we are on : and it's not already taken : if taken, failure ... rollback tran : else, print "happy days are here" : :I believe that this is SABRE. : :United Airlines :--------------- :You can lock a seat if you have a specific seat in mind :without making a reservation yet. You can make the :reservation and have that seat. If the system crashes :between locking the seat and making the reservation, the :seat remains locked. (I found this interesting). That IS indeed interesting. : :I interpret this in db terms as follows: : :tx #1: : : select list of seats.... : :tx #2: : : update seat_table .... (as before) : :tx #3: : : update reservation_table I'm beginning to wonder why I'm still responding to this. gburnore@netcom dot com or gburnore@netcom databasix com --------------------------------------------------------------------------- How you look depends on where you go. --------------------------------------------------------------------------- Gary L. Burnore | '۳'''''''ۺ''''''''''۳ | '۳'''''''ۺ''''''''''۳ DOH! | '۳'''''''ۺ''''''''''۳ | '۳ 3 4 1 4 2 '' 6 9 0 6 9 '۳ spamgard(tm): zamboni | Official Proof of Purchase =========================================================================== PGPprint: C63B CF4E 1B71 4D7E C6F8 AF4E 338D 5CB4 KeyID: 0x0F7EDBD9 (RSA) finger gburnore@netcom.com for public key ---------------------------------------------------------------------------