System and method for maintaining coherency of data entries
The present invention relates to a system and method for maintaining coherency of data entries related to seat information obtained from remote venues. The method handles queries regarding seat status, including information indicating seat availability. Information obtained based on the queries are transmitted to a first general purpose computer for display to a first user. Upon receiving, from the first general purpose computer, selections by the first user, the system or method creates in the database a temporary record based on the selections and requests a confirmation of the selections by the first user. Once the first user sends the confirmation, the system or method locks entries in the database, preventing a second user from selecting any seat confirmed for the first user. The system or method also includes transmitting, to a second general purpose computer, information to be displayed to the second user indicating seats selected by the first.
1. A computer-implemented method for maintaining coherency of data entries related to a database that relates to an inventory for a venue and providing access to a plurality of users to the database, the method comprising:
receiving, from a first general purpose computer, a query for information from the database regarding a status of one or more seats in the venue;
determining information indicating an availability of the one or more seats in the venue based on parameters specified in the query;
transmitting, to the first general purpose computer, a response to the query that includes information to be displayed to a first user, wherein the information to be displayed to the user comprises an interactive set of user interface elements that allow the first user to select one or more seats in the venue, wherein, in response to the first user placing a mouse over at least a portion of the interactive set of user interface elements, current available seat information in the venue indicating seats that are currently available is transmitted to the first general purpose computer;
receiving, from the first general purpose computer, information indicating selections with a mouse by the first user;
creating a temporary record in the database, for the first user, based on the information indicating selections by the first user;
transmitting, to the first general purpose computer, a request for confirmation of the selections by the first user based on information in the temporary record;
receiving, from the first general purpose computer, the confirmation of the selections by the first user;
locking entries in the database based on the confirmation, wherein the lock prevents a second user from selecting any seat confirmed for the first user; and
transmitting, to a second general purpose computer, information to be displayed to the second user that indicates seats selected by the first user.
2. The method of claim 1 further comprising:
transmitting a portion of the information to the second general purpose computer to be displayed, the portion including updated information indicating the purchased seat as unavailable.
3. The method of claim 1 , wherein the database comprises entries denoting availability of a plurality of venues.
4. The method of claim 1 , wherein the venue is a theater.
5. The method of claim 1 , wherein the venue is a stadium.
6. The method of claim 1 , wherein the venue is an airplane.
7. A computer system, comprising:
a database that relates to an inventory for a venue; and
a server system that provides to a plurality of users access to the database, the server system configured to:
receive, from a first general purpose computer, a query for information from the database regarding a status of one or more seats in the venue;
determine information indicating an availability of the one or more seats in the venue based on parameters specified in the query;
transmit, to the first general purpose computer, a response to the query that includes information to be displayed to a first user, wherein the information to be displayed to the user comprises an interactive set of user interface elements that allow the first user to select one or more seats in the venue, wherein, in response to the first user placing a mouse over at east a portion of the interactive set of user interface elements, current available seat information in the venue indicatinci seats that are currently available is transmitted to the first general purpose computer;
receive, from the first general purpose computer, information indicating selections with a mouse by the first user;
create a temporary record in the database, for the first user, based on the information indicating selections by the first user;
transmit, to the first general purpose computer, a request for confirmation of the selections by the first user based on information in the temporary record;
receive, from the first general purpose computer, the confirmation of the selections by the first user;
lock entries in the database based on the confirmation, wherein the lock prevents a second user from selecting any seat confirmed for the first user; and
transmit, to a second general purpose computer, information to be displayed to the second user that indicates seats selected by the first user.
8. The computer system of claim 7 , wherein the server is further configured to:
transmit a portion of the information to the second general purpose computer to be displayed, the portion including updated information indicating the purchased seat as unavailable.
9. The computer system of claim 7 , wherein the database comprises entries denoting availability of a plurality of venues.