Systems methods and apparatus for generation of a database object
AssigneeLive Nation Entertainment, Inc.
InventorThomas Mundar
Life of this patent
Estimating the term…
Abstract
Embodiments described herein generally related to efficient and scalable database querying mechanisms. Various embodiments disclose processes, methods, and systems for storing resource data within a database such that the resource data may be searched across a plurality of time periods. Various embodiments disclose processes, methods, and systems for determining a best resource to return given a specific set of data points. Various embodiments disclose processes, methods, and systems for rending one or more sets of query results based on velocity of received queries for resource data.
Claims21
A computer-implemented method for determining a set of available tickets for admittance to an event, the computer-implemented method comprising:
- receiving, by a computer system, a ticket request from a user device associated with a user, the ticket request comprising a series of time periods identifier identifying a first plurality of time periods to utilize a requested set of tickets and a location identifier identifying a location to utilize the requested set of tickets, and a ticket number identifying an amount of tickets within the requested set of tickets, wherein the ticket request is for one or more tickets to the event;
- querying, a ticket database system, based at least in part on the series of time periods identifier and the location identifier to identify a first database object comprising a first plurality of tickets associated with the series of time periods identifier and the location identifier, the first plurality of tickets comprising one or more first events that occur at a first plurality of time periods at a first location, and wherein each database object within the ticket database system is associated with a different plurality of tickets;
- receiving, by the computer system, a ticket parameter identifying one or more ticket restrictions, the one or more ticket restrictions being used to filter the one or more first events included in the first plurality of tickets;
- filtering, by the computer system, the first plurality of tickets into a second plurality of tickets based at least in part on the one or more ticket restrictions of the ticket parameter, the second plurality of tickets comprising one or more second events that occur at the first plurality of time periods at the first location;
- determining, by the computer system, resource history of the user, wherein:
- the resource history indicates genre of a plurality of ticket request sent by the user in past and one or more locations preferred by the user in past;
- ranking, by the computing system, each of the second plurality of tickets based on the resource history of the user and user availability;
- determining, by the computer system, a user characteristic-based preferential treatment based on the resource history, the user characteristic-based preferential treatment being one or more improvements provided to the user or the user device based on one or more user characteristics;
- selecting, by the computer system, a third plurality of tickets based on the user availability from the second plurality of tickets based on a rank of each of the second plurality of tickets, wherein the third plurality of tickets includes a set of highest ranked tickets from the second plurality of tickets;
- generating, by the computer system, an access token to simultaneously access at least two or more tickets from the third plurality of tickets at a time from the first plurality of time periods, wherein the access token is generated upon meeting of a bot-detection condition;
- determining priority level for the user to receive access token based on identifying if the ticket request is associated with inputs from a bot;
- modifying one or more attributes of communication between the computer system and the user device based on the one or more improvements, wherein modifying the one or more attributes of communication comprises extending time for confirmation of allocation of the access token from a first duration to a second duration, the time being extended for the user or the user device provided with the user characteristic-based preferential treatment, and the second duration being greater than the first duration;
- and
- transmitting, by the computer system, an indication of the third plurality of tickets to the user device associated with the ticket request, wherein each ticket of the third plurality of tickets is associated with a demand indicating a number of communications received for each ticket, and wherein the demand defines a length of a duration during which the number of communications received for each ticket exceeds a threshold of a plurality of thresholds, after start of a public on sale for the third plurality of tickets, wherein:
- where the demand is high, the length is decreased,
- where the demand is low, the length is increased,
- when the demand is greater than a first threshold of the plurality of thresholds, a first set of tickets from the third plurality of tickets and a first version of an interactive resource map are transmitted to the user device,
- the first version of the interactive resource map displays a first graphical details including locations of a first set of resources corresponding to each ticket of the first set of tickets,
- when the demand is less than the first threshold and greater than a second threshold of the plurality of thresholds, a second set of tickets from the third plurality of tickets and a second version of the interactive resource map are transmitted to the user device,
- the second set of tickets is greater than the first set of tickets and includes the first set of tickets,
- the second version of the interactive resource map displays second graphical details including a plurality resources surrounding a second set of resources corresponding to each ticket of the second set of tickets and a timer indicating a time period during which the user device can acquire the second set of tickets,
- the second graphical details further include entirety of the first graphical details of each ticket of the first set of tickets,
- when the demand is less than the second threshold and greater than a third threshold of the plurality of thresholds, a third set of tickets from the third plurality of tickets and a third version of the interactive resource map are transmitted to the user device,
- the third set of tickets is greater than the second set of tickets and includes the second set of tickets,
- the third version of the interactive resource map displays third graphical details including structures surrounding a third set of resources corresponding to each ticket of the third set of tickets,
- the third graphical details further include entirety of the second graphical details of each ticket of the second set of, and
- when the demand is less than the third threshold, the third plurality of tickets are transmitted to the user device.
A non-transitory computer-readable storage medium having stored thereon instructions for causing at least one computer to determine a set of available resources for admittance to an event, the instructions comprising:
- receiving, by a computer system, a ticket request from a user device associated with a user, the ticket request comprising a series of time periods identifier identifying a first plurality of time periods to utilize a requested set of tickets and a location identifier identifying a location to utilize the requested set of tickets, and a ticket number identifying an amount of tickets within the requested set of tickets, wherein the ticket request is for one or more tickets to the event;
- querying, a ticket database system, based at least in part on the series of time periods identifier and the location identifier to identify a first database object comprising a first plurality of tickets associated with the series of time periods identifier and the location identifier, the first plurality of tickets comprising one or more first events that occur at a first plurality of time periods at a first location, and wherein each database object within the ticket database system is associated with a different plurality of tickets;
- receiving, by the computer system, a ticket parameter identifying one or more ticket restrictions, the one or more ticket restrictions being used to filter the one or more first events included in the first plurality of tickets;
- filtering, by the computer system, the first plurality of tickets into a second plurality of tickets based at least in part on the one or more ticket restrictions of the ticket parameter, the second plurality of tickets comprising one or more second events that occur at the first plurality of time periods at the first location;
- determining, by the computer system, resource history of the user, wherein:
- the resource history indicates genre of a plurality of ticket request sent by the user in past and one or more locations preferred by the user in past;
- ranking, by the computing system, each of the second plurality of tickets based on the resource history of the user and user availability;
- determining, by the computer system, a user characteristic-based preferential treatment based on the resource history, the user characteristic-based preferential treatment being one or more improvements provided to the user or the user device based on one or more user characteristics;
- selecting, by the computer system, a third plurality of tickets based on the user availability from the second plurality of tickets based on a rank of each of the second plurality of tickets, wherein the third plurality of tickets includes a set of highest ranked tickets from the second plurality of tickets;
- generating, by the computer system, an access token to simultaneously access at least two or more tickets from the third plurality of tickets at a time from the first plurality of time periods, wherein the access token is generated upon meeting of a bot-detection condition;
- determining priority level for the user to receive access token based on identifying if the ticket request is associated with inputs from a bot;
- modifying one or more attributes of communication between the computer system and the user device based on the one or more improvements, wherein modifying the one or more attributes of communication comprises extending time for confirmation of allocation of the access token from a first duration to a second duration, the time being extended for the user or the user device provided with the user characteristic-based preferential treatment, and the second duration being greater than the first duration;
- and
- transmitting, by the computer system, an indication of the third plurality of tickets to the user device associated with the ticket request, wherein each ticket of the third plurality of tickets is associated with a demand indicating a number of communications received for each ticket, and wherein the demand defines a length of a duration during which the number of communications received for each ticket exceeds a threshold of a plurality of thresholds, after start of a public on sale for the third plurality of tickets, wherein:
- where the demand is high, the length is decreased,
- where the demand is low, the length is increased,
- when the demand is greater than a first threshold of the plurality of thresholds, a first set of tickets from the third plurality of tickets and a first version of an interactive resource map are transmitted to the user device,
- the first version of the interactive resource map displays a first graphical details including locations of a first set of resources corresponding to each ticket of the first set of tickets,
- when the demand is less than the first threshold and greater than a second threshold of the plurality of thresholds, a second set of tickets from the third plurality of tickets and a second version of the interactive resource map are transmitted to the user device,
- the second set of tickets is greater than the first set of tickets and includes the first set of tickets,
- the second version of the interactive resource map displays second graphical details including a plurality resources surrounding a second set of resources corresponding to each ticket of the second set of tickets and a timer indicating a time period during which the user device can acquire the second set of tickets,
- the second graphical details further include entirety of the first graphical details of each ticket of the first set of tickets,
- when the demand is less than the second threshold and greater than a third threshold of the plurality of thresholds, a third set of tickets from the third plurality of tickets and a third version of the interactive resource map are transmitted to the user device,
- the third set of tickets is greater than the second set of tickets and includes the second set of tickets,
- the third version of the interactive resource map displays third graphical details including structures surrounding a third set of resources corresponding to each ticket of the third set of tickets,
- the third graphical details further include entirety of the second graphical details of each ticket of the second set of, and
- when the demand is less than the third threshold, the third plurality of tickets are transmitted to the user device.
A system for determining a set of available resources for admittance to an event, the system comprising:
- receiving, by a computer system, a ticket request from a user device associated with a user, the ticket request comprising a series of time periods identifier identifying a first plurality of time periods to utilize a requested set of tickets and a location identifier identifying a location to utilize the requested set of tickets, and a ticket number identifying an amount of tickets within the requested set of tickets, wherein the ticket request is for one or more tickets to the event;
- querying, a ticket database system, based at least in part on the series of time periods identifier and the location identifier to identify a first database object comprising a first plurality of tickets associated with the series of time periods identifier and the location identifier, the first plurality of tickets comprising one or more first events that occur at a first plurality of time periods at a first location, and wherein each database object within the ticket database system is associated with a different plurality of tickets;
- receiving, by the computer system, a ticket parameter identifying one or more ticket restrictions, the one or more ticket restrictions being used to filter the one or more first events included in the first plurality of tickets;
- filtering, by the computer system, the first plurality of tickets into a second plurality of tickets based at least in part on the one or more ticket restrictions of the ticket parameter, the second plurality of tickets comprising one or more second events that occur at the first plurality of time periods at the first location;
- determining, by the computer system, resource history of the user, wherein:
- the resource history indicates genre of a plurality of ticket request sent by the user in past and one or more locations preferred by the user in past;
- ranking, by the computing system, each of the second plurality of tickets based on the resource history of the user and user availability;
- determining, by the computer system, a user characteristic-based preferential treatment based on the resource history, the user characteristic-based preferential treatment being one or more improvements provided to the user or the user device based on one or more user characteristics;
- selecting, by the computer system, a third plurality of tickets based on the user availability from the second plurality of tickets based on a rank of each of the second plurality of tickets, wherein the third plurality of tickets includes a set of highest ranked tickets from the second plurality of tickets;
- generating, by the computer system, an access token to simultaneously access at least two or more tickets from the third plurality of tickets at a time from the first plurality of time periods, wherein the access token is generated upon meeting of a bot-detection condition;
- determining priority level for the user to receive access token based on identifying if the ticket request is associated with inputs from a bot;
- modifying one or more attributes of communication between the computer system and the user device based on the one or more improvements, wherein modifying the one or more attributes of communication comprises extending time for confirmation of allocation of the access token from a first duration to a second duration, the time being extended for the user or the user device provided with the user characteristic-based preferential treatment, and the second duration being greater than the first duration;
- and
- transmitting, by the computer system, an indication of the third plurality of tickets to the user device associated with the ticket request, wherein each ticket of the third plurality of tickets is associated with a demand indicating a number of communications received for each ticket, and wherein the demand defines a length of a duration during which the number of communications received for each ticket exceeds a threshold of a plurality of thresholds, after start of a public on sale for the third plurality of tickets, wherein:
- where the demand is high, the length is decreased,
- where the demand is low, the length is increased,
- when the demand is greater than a first threshold of the plurality of thresholds, a first set of tickets from the third plurality of tickets and a first version of an interactive resource map are transmitted to the user device,
- the first version of the interactive resource map displays a first graphical details including locations of a first set of resources corresponding to each ticket of the first set of tickets,
- when the demand is less than the first threshold and greater than a second threshold of the plurality of thresholds, a second set of tickets from the third plurality of tickets and a second version of the interactive resource map are transmitted to the user device,
- the second set of tickets is greater than the first set of tickets and includes the first set of tickets,
- the second version of the interactive resource map displays second graphical details including a plurality resources surrounding a second set of resources corresponding to each ticket of the second set of tickets and a timer indicating a time period during which the user device can acquire the second set of tickets,
- the second graphical details further include entirety of the first graphical details of each ticket of the first set of tickets,
- when the demand is less than the second threshold and greater than a third threshold of the plurality of thresholds, a third set of tickets from the third plurality of tickets and a third version of the interactive resource map are transmitted to the user device,
- the third set of tickets is greater than the second set of tickets and includes the second set of tickets,
- the third version of the interactive resource map displays third graphical details including structures surrounding a third set of resources corresponding to each ticket of the third set of tickets,
- the third graphical details further include entirety of the second graphical details of each ticket of the second set of, and
- when the demand is less than the third threshold, the third plurality of tickets are transmitted to the user device.
Dependencies are inferred from the claim text.