System for propagating, retrieving and using transaction processing facility airline computerized reservation system data on a relational database processing platform

• US 6,122,642 A
• Filed: 01/18/1996
• Issued: 09/19/2000
• Est. Priority Date: 01/18/1996
• Status: Expired due to Term

• Current Assignee: Sabre GLBL Inc. (Sabre Corp.)
• Original Assignee: Sabre Incorporated (Sabre Corp.)
• Inventors: Mehovic, Farid
• Primary Examiner(s): Alam, Hosain T.
• Assistant Examiner(s): RONES, CHARLES
• Application Number:
  US08/588,463
• Time in Patent Office: 1,706 Days
• Field of Search: 340/825.28, 395/206, 395/205, 395/610, 395/705, 705/5, 705/6, 707/1, 707/3, 707/4, 707/10, 707/200, 707/104, 709/206, 700/216
• US Class Current: 705/5
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06Q 10/02 Reservations, e.g. for tickets, services or events
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

A system and method for propagating airline computerized reservation system TPF data to a relational database platform comprising a computerized reservation system transaction processing source computer in communication with an output data file, an input data structure, a functional server computer and a relational database management system target computer. The relational database management system target computer is in communication with the functional server computer and an output database. A data propagation selection means is resident within the transaction source computer and is in communication with the functional server computer and target relational database management system target computer. A function management means is resident within the functional server computer and is in communication with the transaction source computer and the relational database management system computer.

Claims

1. A method for processing airline reservations comprising the steps of:

inputting airline reservation records to a transaction processing server computer;

appending at least one selected database query statement to each airline reservation record received from said transaction processing server computer;

storing airline reservation records with the selected database query statement in a storage subsystem; and

permitting use by a client terminal of airline reservation records stored in said storage subsystem.

2. A method according to claim 1, wherein a functional server computer receives each airline reservation record and the step of permitting use includes the substep of accessing airline reservation records stored in said storage subsystem independently of said transaction processing server computer and the functional server computer.

3. A method according to claim 1, wherein said appending step includes parsing asynchronously transferred data, including the airline reservation records, from said transaction processing server computer.

4. A method according to claim 1, wherein a functional server computer receives each airline reservation record and the step of permitting use includes the substep of using airline reservation records stored in said storage subsystem independently of said transaction processing server computer and the functional server computer.

5. An airline reservation system comprising:

a memory having program instructions; and

a processor configured to use the program instructions to receive airline reservation records from a transaction processing server computer;

to append at least one selected database query statement to each airline reservation record received from said transaction processing server computer; and

to allow use of airline reservation records with the selected database query statement by a client terminal.

6. An airline reservation system according to claim 5, wherein the airline reservation system is configured to permit the client terminal to access airline reservation records with a selected database query statement independently of said transaction processing server computer and the processor.

7. An airline reservation system according to claim 5, wherein the instruction to receive airline reservation records parses asynchronously transferred data, including the airline reservation records, from said transaction processing server computer.

8. An airline reservation system according to claim 5, wherein the airline reservation system is configured to permit the client terminal to use airline reservation records independently of said transaction processing server computer and the processor.

9. An airline reservation system comprising:

a transaction processing server computer for receiving airline reservation records;

at least one transaction terminal, coupled to said transaction processing server computer, providing an interface for inputting airline reservation records to said transaction processing server computer and for receiving airline reservation records from said transaction processing server computer in response to requests from said transaction terminal;

a functional server computer, coupled to said transaction processing server computer, for receiving airline reservation records propagated from said transaction processing server computer and for appending at least one selected database query statement to each airline reservation record received from said transaction processing server computer;

a database server computer, coupled to said functional server computer, for receiving airline reservation records with the selected database query statement from said functional server computer and for storing airline reservation records with the selected database query statement in a storage subsystem; and

at least one client terminal, communicably linked to said storage subsystem, for using airline reservation records stored in said storage subsystem.

10. An airline reservation system according to claim 9, wherein said client terminal includes means for accessing said storage subsystem independently of said transaction processing server computer and said functional server computer.

11. An airline reservation system according to claim 9, wherein said client terminal includes means for using selected database queries to access airline reservation records stored in said storage subsystem.

12. An airline reservation system according to claim 9, wherein said database server computer includes a module for transmitting airline reservation records from said storage subsystem to said client terminal in response to selected database queries from said client terminal.

13. An airline reservation system according to claim 9, wherein said transaction processing server computer asynchronously transfers data including said airline reservation records to said functional server computer and said functional server computer parses the transferred data to extract the airline reservation record.

14. An airline reservation system according to claim 9, wherein said client terminal includes means for using information transferred from said storage subsystem independently of said transaction processing server computer and said functional server computer.