Abstract: Systems, methods, and computer program products for processing database records. A database management system may receive a query identifying a ticket in a ticket database that is being exchanged. In response to receiving the query, the database management system may retrieve, from a transitional database, a transitional record that is indexed to the ticket. The transitional record may include a disruption index having one or more arrays each defining a set of linked data elements. The database management system may retrieve additional tickets from the ticket database that are identified by the data elements, and arrange the tickets into an ordered set that defines a disruption history for the ticket being exchanged. The database management system may then generate a hybrid itinerary based on the disruption history, and use the hybrid itinerary to determine a value for the ticket being exchanged.

Abstract: Systems, methods, and computer program products for processing database records. A database management system may receive a query identifying a ticket in a ticket database that is being exchanged. In response to receiving the query, the database management system may retrieve, from a transitional database, a transitional record that is indexed to the ticket. The transitional record may include a disruption index having one or more arrays each defining a set of linked data elements. The database management system may retrieve additional tickets from the ticket database that are identified by the data elements, and arrange the tickets into an ordered set that defines a disruption history for the ticket being exchanged. The database management system may then generate a hybrid itinerary based on the disruption history, and use the hybrid itinerary to determine a value for the ticket being exchanged.

Abstract: Systems, methods, and computer program products for creating and managing database records. A database management system receives requests to exchange tickets. In response to determining that a request requires enhanced processing, the system queries a penalty collection database for instructions on providing the enhanced processing. The instructions may be identified based on an identity of a provider of a travel product and/or the market in which the product is sold. The penalty collection database may include a table that provides instructions on collecting the penalty which are indexed to a specific provider, market, or combination of provider and market. If a penalty is owed for the exchange, the instructions may cause the system to implement a specific method of collecting the penalty. The instructions may cause the penalty to be encoded and stored in a manner specific to the provider and/or market to avoid an incompatibility with another system.

Abstract: A method, apparatus and program product perform re-pricing operations for low cost carrier travel itineraries in connection with itinerary changes in a manner that is compatible with systems and/or workflows utilized for standard carriers. Re-pricing operations may include, for example, access to a pricing engine for a low cost carrier to retrieve pricing information for a changed travel itinerary, along with the generation of one or more pricing records and the population of a passenger name record for the travel itinerary using the retrieved pricing information.