Pre-ticket travel reservation record keeping system
First Claim
Patent Images
1. 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.
1 Assignment
0 Petitions
Accused Products
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.
182 Citations
7 Claims
-
1. 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. - View Dependent Claims (2, 3, 4, 5, 6)
-
-
7. 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.
-
Specification