System and method for caching and utilizing flight availability data
View Patent ↗A system and method operable to cache and retrieve flight availability data. System components are a cache database for storing flight availability data, an airline cache control for configuring the cache database for a plurality of airlines, a subscriber cache control for configuring the cache database for a plurality of subscribers, and a cache query utility for interacting with the cache database. Additional system components are a data display utility for displaying flight availability data stored in the cache database, a success rate utility for tracking statistics associated with use of the cache database, and a dual mode processing utility that allows access to flight availability data from either the cache database or a real-time response. The system is provided as an intermediary between the subscribers and a plurality of airline servers.
1. A method for caching and utilizing airline flight availability data for specific subscribers by an electronic distribution computer comprising the steps of:
configuring a cache database by the electronic distribution computer for each of a plurality of airlines using an airline cache control and for each of a plurality of subscribers using a subscriber cache control;
receiving an availability request from a subscriber by the electronic distribution computer over a communications network;
accessing a control list by the electronic distribution computer to verify that the subscriber can utilize the configured cache database for a particular airline corresponding to the received availability request for flight availability information;
querying the configured cache database for flight availability data of the particular airline stored for use by the verified subscriber and corresponding to the received availability request, wherein the flight availability data corresponding to the received availability request is includes OR associated with a minimum seat count;
retrieving the flight availability data corresponding to the received availability request for the verified subscriber if found in the configured cache database and if an available seat count of the found flight availability data corresponding to the received availability request is not less than the associated minimum seat count;
sending a real-time request for flight availability data from the electronic distribution computer over the communications network to an airline server database, if flight availability data corresponding to the received availability request is not found in the configured cache database or if available seat count of the found flight availability data in the configured cache database is less than the associated minimum seat count; and
sending the flight availability data in response to the sent real-time request from the airline server database to the verified subscriber.
2. The method for caching and utilizing airline flight availability data of claim 1 further comprising the step of identifying a matching trip for the received availability request in the configured cache database by the electronic distribution computer.
3. The method for caching and utilizing airline flight availability data of claim 2 further comprising the step of obtaining flight availability data from a third party database by the electronic distribution computer over the communications network if a matching trip is not found in the configured cache database, and if no response is received in response to the real-time request sent to the airline server database.
4. The method for caching and utilizing airline flight availability data of claim 1 wherein the flight availability information stored in the configured cache database for a trip comprises a subscriber identification code, a carrier code, a boarding point, a class of service, a flight number, a date and a time for each flight in the trip.
5. The method for caching and utilizing airline flight availability data of claim 1 wherein the cache database is configured by the electronic distribution computer to cache flight availability information for a specific airline in a plurality of variable day ranges.
6. The method for caching and utilizing airline flight availability data of claim 5 wherein the plurality of day ranges varies based on an expected frequency of changes to the flight availability information.
7. The method for caching and utilizing airline flight availability data of claim 6 wherein flight availability information in each day range has an associated shelf life.
8. The method for caching and utilizing airline flight availability data of claim 7 wherein the associated shelf life for each day range is less than a predefined value.
9. The method for caching and utilizing airline flight availability data of claim 7 further comprising removing flight availability information for a trip in each day range from the configured cache database by the electronic distribution computer when the associated shelf life is exceeded.
10. The method for caching and utilizing airline flight availability data of claim 7 further comprising reducing the associated shelf life in a day range by the electronic distribution computer when a minimum seat count is reached.
11. An electronic distribution system for caching and utilizing airline flight availability data for specific subscribers comprising:
an electronic distribution computer including a processor for executing a plurality of components and communicating with at least one database;
a memory at the electronic distribution computer including a cache database for storing flight availability information;
an airline cache control component for configuring the cache database for each of a plurality of airlines;
a subscriber cache control component for configuring the cache database for each of the specific subscribers;
a component for receiving an availability request from a subscriber over a communications network;
a component for accessing a control list to verify that the subscriber can utilize the configured cache database for a particular airline corresponding to the received availability request for flight availability data;
a cache query utility for querying the configured cache database for flight availability data of the particular airline stored for use by the verified subscriber, wherein the flight availability data corresponding to the received availability request is associated with a minimum seat count;
a component for retrieving the flight availability data corresponding to the received availability request for the verified subscriber if found in the configured cache database and if an available seat count of the found flight availability data is not less than the associated minimum seat count;
a component for transmitting a real-time request for flight availability data from the electronic distribution computer over the communications network to an airline server, if flight availability data is not found in the cache database or if available seat count of the found flight availability data in the configured cache database is less than the associated minimum seat count; and
a component for transmitting the flight availability data in response to the sent real-time request from the airline server to the verified subscriber.
12. The system for caching and utilizing airline flight availability data of claim 11 further comprising a component for identifying a matching trip for the received availability request in the configured cache database.
13. The system for caching and utilizing airline flight availability data of claim 11 wherein the flight availability data stored in the configured cache database for a trip comprises a subscriber identification code, a carrier code, a boarding point, a class of service, a flight number, a date and a time for each flight in the trip.
14. The system for caching and utilizing airline flight availability data of claim 11 wherein the cache database is configured by the electronic distribution computer to cache flight availability information for a specific airline in a plurality of variable day ranges.
15. The system for caching and utilizing airline flight availability data of claim 14 wherein the plurality of day ranges varies based on an expected frequency of changes to the flight availability information.
16. The system for caching and utilizing airline flight availability data of claim 15 wherein flight availability information in each day range has an associated shelf life.
17. The system for caching and utilizing airline flight availability data of claim 16 wherein the associated shelf life for each day range is less than a predefined value.
18. The system for caching and utilizing airline flight availability data of claim 16 wherein the cache query utility removes flight availability information for a trip in each day range from the configured cache database when the associated shelf life is exceeded.
19. A computer program product for caching and utilizing airline flight availability data for specific subscribers when executed on an electronic distribution computer comprising a computer readable medium having computer readable code embedded therein, the computer readable medium comprising:
program instructions that configure a cache database for each of a plurality of airlines and for each of a plurality of subscribers;
program instructions that receive an availability request from a subscriber over a communications network;
program instructions that access a control list to verify that the subscriber can utilize the configured cache database for a particular airline corresponding to the received availability request for flight availability information;
program instructions that query the configured cache database for flight availability data of the particular airline stored for use by the verified subscriber and corresponding to the received availability request, wherein the flight availability data corresponding to the received availability request is associated with a minimum seat count;
program instructions that retrieve the flight availability data corresponding to the received availability request for the verified subscriber if found in the configured cache database and if an available seat count of the found flight availability data corresponding to the received availability request is not less than the associated minimum seat count;
program instructions that transmit a real-time request for flight availability data over the communications network to an airline server, if flight availability data corresponding to the received availability request is not found in the configured cache database or if available seat count of the found flight availability data in the configured cache database is less than the associated minimum seat count; and
program instructions that transmit the flight availability data in response to the sent real-time request from the airline server database to the verified subscriber.
20. The computer program product for caching and utilizing airline flight availability data of claim 19 further comprising program instructions that identify a matching trip for the received availability request in the configured cache database.
21. The computer program product for caching and utilizing airline flight availability data of claim 20 further comprising program instructions that obtain flight availability data from a third party database over the communications network if a matching trip is not found in the configured cache database, and if no response is received in response to the real-time request sent to the airline server.
22. The computer program product for caching and utilizing airline flight availability data of claim 19 wherein the flight availability information stored in the configured cache database for a trip comprises a subscriber identification code, a carder code, a boarding point, a class of service, a flight number, a date and a time for each flight in the trip.
23. The computer program product for caching and utilizing airline flight availability data of claim 19 further comprising program instructions that configure the cache database to cache flight availability information for a specific airline in a plurality of variable day ranges.
24. The computer program product for caching and utilizing airline flight availability data of claim 23 wherein the plurality of day ranges varies based on an expected frequency of changes to the flight availability information.
25. The computer program product for caching and utilizing airline flight availability data of claim 24 wherein the flight availability information in each day range has an associated shelf life.
26. The computer program product for caching and utilizing airline flight availability data of claim 25 wherein the associated shelf life for each day range is less than a predefined value.
27. The computer program product for caching and utilizing airline flight availability data of claim 25 further comprising program instructions that remove flight availability information for a trip in each day range from the configured cache database when the associated shelf life is exceeded.
28. The computer program product for caching and utilizing airline flight availability data of claim 25 further comprising program instructions that reduce the associated shelf life in a day range when a minimum seat count is reached.