Path: utzoo!utgpu!watmath!att!tut.cis.ohio-state.edu!unmvax!ncar!asuvax!anasaz!john From: john@anasaz.UUCP (John Moore) Newsgroups: comp.databases Subject: Re: Concurrency control in real life Message-ID: <614@anasaz.UUCP> Date: 12 Aug 89 16:15:08 GMT References: <4875@macom1.UUCP> <328@csense.UUCP> Reply-To: john@anasaz.UUCP (John Moore) Organization: Anasazi Inc, Phoenix AZ Lines: 18 In article <328@csense.UUCP> bote@csense.UUCP (John Boteler) writes: ] ]I was particularly asking for a real-life (computer?) solution to ]a problem which is not overly difficult to grasp; some of ]those responding to me provided answers near this goal and ]raised new questions for me. Try this one from our current project. We are implementing a hotel reservation system. We have tuples representing the number of rooms not sold on a particular date for a particular room type for a hotel. It is not at all uncommon for more than one user to attempt to book the same room type at the same hotel on the same day. Thus, concurrency control is needed. -- John Moore (NJ7E) mcdphx!anasaz!john asuvax!anasaz!john (602) 861-7607 (day or eve) long palladium, short petroleum 7525 Clearwater Pkwy, Scottsdale, AZ 85253 The 2nd amendment is about military weapons, NOT JUST hunting weapons!