US5253166A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Pre-ticket travel reservation record keeping system
Assignee: Disc Corp
•
Filing: 1991-03-29
•
Granted: 1993-10-12
•
Expires: 2011-03-29
Abstract
Abstract A record keeping system communicates with an airline's customer reservation system and a corporate client database system. A dedicated queue within the customer reservation system is accessed daily by the record keeping system to download data comprising travel itineraries. A relational database control within the record keeping system organizes the pre-travel data for efficient use by a corporate client. The reorganized data thus downloaded and organized is sent daily to the corporate clients for use in their own local database systems.
Inventors
- 👤 Susan S. Dettelbach
- 👤 Kenneth Dettelbach
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-24 22:52
CPC Classifications
G; G06; G06Q; G06Q10/00; G06Q10/02
Claims Analysis
Total Claims: 9
Claim 1
Independent Claim
229 words
A pre-travel reservation analyzing method in an information processing system comprising the steps of: receiving a first plurality of travel reservation data sets comprising scheduled travel itineraries from a first computer reservation system, each of the first plurality of data sets having a plurality of first travel itinerary data items corresponding to a first set of individual travelers; storing the first plurality of data sets in a memory of the system; receiving a second plurality of travel reservation data sets from a second computer reservation system, each of the second plurality of data sets having a plurality of second travel itinerary data items corresponding to a second set of individual travelers; storing the second plurality of data sets in the memory of the system; selecting predetermined travel itinerary data items from the first and second plurality of travel reservation data sets; arranging the selected items within the memory for ready importation into a relational database; importing the arranged items into the relational database; storing the imported items in a plurality of tables, each for storing portions of the travel reservation data sets corresponding to selected single travel components including tables for air, hotel, or automobile travel reservations; generating a report from the relational database; and, determining from the generated report a travel compliance of the first and second sets of individual travelers with respect to a predefined travel policy.
Claim 2
Dependent Claim
229 words
A pre-travel reservation analyzing method in an information processing system comprising the steps of: receiving a first plurality of travel reservation data sets comprising scheduled travel itineraries from a first computer reservation system, each of the first plurality of data sets having a plurality of first travel itinerary data items corresponding to a first set of individual travelers; storing the first plurality of data sets in a memory of the system; receiving a second plurality of travel reservation data sets from a second computer reservation system, each of the second plurality of data sets having a plurality of second travel itinerary data items corresponding to a second set of individual travelers; storing the second plurality of data sets in the memory of the system; selecting predetermined travel itinerary data items from the first and second plurality of travel reservation data sets; arranging the selected items within the memory for ready importation into a relational database; importing the arranged items into the relational database; storing the imported items in a plurality of tables, each for storing portions of the travel reservation data sets corresponding to selected single travel components including tables for air, hotel, or automobile travel reservations; generating a report from the relational database; and, determining from the generated report a travel compliance of the first and second sets of individual travelers with respect to a predefined travel policy.
Claim 3
Dependent Claim
60 words
The pre-travel reservation analyzing method according to claim 1 further comprising: defining the travel policy based upon a preexisting contractual agenda; and, generating a contract compliance report from the relational database to indicate non-compliance with the travel policy for each of the individual travelers when preselected ones of said travel itinerary data items do not comply with the travel policy.
Claim 4
Dependent Claim
43 words
The pre-travel reservation analyzing method according to claim 1 wherein the first plurality of travel reservation data sets are received at a first predetermined time and wherein the second plurality of travel reservation data sets are received at substantially the first predetermined time.
Claim 5
Dependent Claim
66 words
The pre-travel reservation analyzing method according to claim 1 wherein the step of importing comprises the steps of: loading a temporary table within the relational database with the imported arranged items; validating ones of the items loaded in the temporary table against predetermined criteria for conformity with the criteria; and, writing to an error log table when the ones validated do not conform with the criteria.
Claim 6
Dependent Claim
128 words
The pre-travel reservation analyzing method according to claim 1 wherein the step of storing comprises the steps of loading a current airline table within the relational database with ones of said travel itinerary data items relating to airline reservation information; loading a current automobile table within the relational database with ones of said travel itinerary data items relating to automobile reservation information; and, loading a current hotel table within the relational database with ones of said travel itinerary data items relating to hotel reservation information, and wherein the step of generating a report comprises the step of generating an airline reservation quality control report having a row for air travel reservations for each of said individual travelers and a column for comparing fares between each of the travelers.
Claim 7
Dependent Claim
114 words
The pre-travel reservation analyzing method according to claim 1 wherein the step of storing comprises the steps of appending an historical airline table within the relational database with current ones of said travel itinerary data items relating to airline reservation information; appending an historical automobile table within the relational database with current ones of said travel itinerary data items relating to automobile reservation information; and, appending an historical hotel table within the relational database with current ones of said travel itinerary data items relating to hotel reservation information, and wherein the step of generating a report comprises the step of generating an historical report of air travel reservations for each of said individual travelers.
Claim 8
Dependent Claim
157 words
A pre-travel reservation analyzing method in an information processing system comprising the steps of: receiving a plurality of travel reservation data sets from a computer reservation system, each of the plurality of data sets having a plurality of travel itinerary data items corresponding to a set of individual travelers; storing the plurality of data sets in a memory of the system; selecting predetermined travel itinerary data items from the plurality of travel reservation data sets; arranging the selected items within the memory for ready importation into a relational database; importing the arranged items into the relational database; storing the imported items in a plurality of tables, each for storing portions of the travel reservation data sets corresponding to selected single travel components including tables for air, hotel, or automobile travel reservations; generating a report from the relational database; and, determining from the generated report a travel compliance of the travelers with respect to a predefined travel policy.
Claim 9
Dependent Claim
157 words
A pre-travel reservation analyzing method in an information processing system comprising the steps of: receiving a plurality of travel reservation data sets from a computer reservation system, each of the plurality of data sets having a plurality of travel itinerary data items corresponding to a set of individual travelers; storing the plurality of data sets in a memory of the system; selecting predetermined travel itinerary data items from the plurality of travel reservation data sets; arranging the selected items within the memory for ready importation into a relational database; importing the arranged items into the relational database; storing the imported items in a plurality of tables, each for storing portions of the travel reservation data sets corresponding to selected single travel components including tables for air, hotel, or automobile travel reservations; generating a report from the relational database; and, determining from the generated report a travel compliance of the travelers with respect to a predefined travel policy.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1996-10-11 | 1997-04-12 | 1997-10-12 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2000-10-11 | 2001-04-12 | 2001-10-12 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2004-10-11 | 2005-04-12 | 2005-10-12 | $7700.00 | Window Closed / Lapsed |