Systems methods and apparatus for generation of a database object
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.
1 . 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.
2 . The computer-implemented method of claim 1 , wherein the first database object further comprises accessibility bitmasks associated with each ticket of the first plurality of tickets, the accessibility bitmasks comprising bit values that indicate an accessibility of a ticket of the first plurality of tickets at a different time within the first plurality of time periods.
3 . The computer-implemented method of claim 2 , further comprising:
performing, by the computer system, one assembly language process to compare accessibility bitmasks of a first ticket in the third plurality of tickets and accessibility bitmasks of a second ticket in the third plurality of tickets to determine one or more time periods of the first plurality of time periods that both the first ticket in the third plurality of tickets and the second ticket in the third plurality of tickets are available.
4 . The computer-implemented method of claim 2 , further comprising:
performing, by the computer system, one assembly language process to compare accessibility bitmasks of a third ticket in the third plurality of tickets and accessibility bitmasks of a fourth ticket in the third plurality of tickets to determine one or more time periods of the first plurality of time periods that both the third ticket in the third plurality of tickets and the fourth ticket in the third plurality of tickets are not available.
5 . The computer-implemented method of claim 1 , further comprising:
receiving, by the computer system from the user device, a selected ticket identifier comprising an indication of at least two or more tickets from the third plurality of tickets and a particular time period identifier of the first plurality of time periods; and
generating, by the computer system, the access token to simultaneously access the at least two or more tickets from the third plurality of tickets at a time identified by the particular time period identifier of the first plurality of time periods.
6 . The computer-implemented method of claim 5 , wherein the selected ticket identifier further comprises a particular location identifier, and wherein one or more access tokens are valid only at particular location identified by the particular location identifier.
7 . The computer-implemented method of claim 5 , wherein the selected ticket identifier comprises an indication of at least three or more tickets from the third plurality of tickets.
8 . 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.
9 . The non-transitory computer-readable storage medium of claim 8 , wherein the first database object further comprises accessibility bitmasks associated with each resource of the first plurality of resources, the accessibility bitmasks comprising bit values that indicate an accessibility of a resource of the first plurality of resources at a different time within the first plurality of time periods.
10 . The non-transitory computer-readable storage medium of claim 9 , the instructions further comprising:
performing one assembly language process to compare accessibility bitmasks of a first resource in the third plurality of resources and accessibility bitmasks of a second resource in the third plurality of resources to determine one or more time periods of the first plurality of time periods that both the first resource in the third plurality of resources and the second resource in the third plurality of resources are available.
11 . The non-transitory computer-readable storage medium of claim 9 , the instructions further comprising:
performing one assembly language process to compare accessibility bitmasks of a third resource in the third plurality of resources and accessibility bitmasks of a fourth resource in the third plurality of resources to determine one or more time periods of the first plurality of time periods that both the third resource in the third plurality of resources and the fourth resource in the third plurality of resources are not available.
12 . The non-transitory computer-readable storage medium of claim 8 , the instructions further comprising:
receiving a selected resource identifier comprising an indication of at least two or more resources from the third plurality of resources and a particular time period identifier of the first plurality of time periods; and
generating the access token to simultaneously access the at least two or more resources from the third plurality of resources at a time identified by the particular time period identifier of the first plurality of time periods.
13 . The non-transitory computer-readable storage medium of claim 12 , wherein the selected resource identifier further comprises a particular location identifier, and wherein one or more access tokens are valid only at particular location identified by the particular location identifier.
14 . The non-transitory computer-readable storage medium of claim 12 , wherein the selected resource identifier comprises an indication of at least three or more resources from the third plurality of resources.
15 . 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.
16 . The system of claim 15 , wherein the first database object further comprises accessibility bitmasks associated with each resource of the first plurality of resources, the accessibility bitmasks comprising bit values that indicate an accessibility of a resource of the first plurality of resources at a different time within the first plurality of time periods.
17 . The system of claim 16 , wherein the instructions that when executed by the one or more processors further cause the one or more processors to:
perform one assembly language process to compare accessibility bitmasks of a first resource in the third plurality of resources and accessibility bitmasks of a second resource in the third plurality of resources to determine one or more time periods of the first plurality of time periods that both the first resource in the third plurality of resources and the second resource in the third plurality of resources are available.
18 . The system of claim 16 , further comprising:
perform one assembly language process to compare accessibility bitmasks of a third resource in the third plurality of resources and accessibility bitmasks of a fourth resource in the third plurality of resources to determine one or more time periods of the first plurality of time periods that both the third resource in the third plurality of resources and the fourth resource in the third plurality of resources are not available.
19 . The system of claim 15 , wherein the instructions that when executed by the one or more processors further cause the one or more processors to:
receive, from the user device, a selected resource identifier comprising an indication of at least two or more resources from the third plurality of resources and a particular time period identifier of the first plurality of time periods; and
generate the access token to simultaneously access the at least two or more resources from the third plurality of resources at a time identified by the particular time period identifier of the first plurality of time periods.
20 . The system of claim 19 , wherein the selected resource identifier further comprises a particular location identifier, and wherein one or more access tokens are valid only at particular location identified by the particular location identifier.
21 . The computer-implemented method for determining the set of available tickets for admittance to the event as claimed in claim 1 wherein:
the first version of the resource map indicates a visual representation of the first set of tickets.