Abstract: Methods, systems, and computer program products for managing an Electronic Miscellaneous Document (EMD). In response to receiving a request for an ancillary service, an aggregation module generates an aggregation record. The aggregation module may obtain passenger and segment data from a plurality of Passenger Name Records (PNRs), and add this data to the aggregation record. The aggregation record may thereby provide a database object including passenger and segment data from multiple PNRs associated with an itinerary. The aggregation record may be associated with an EMD, and may be configured so that a single EMD can be issued to a traveler for an ancillary service provided across an itinerary comprising multiple PNRs. A mapping record may also be generated that links the EMD, aggregation record, and PNRs. The mapping record may thereby provide an index that enables a database to quickly identify relationships between EMDs, aggregation records, and PNRs.

Abstract: Systems, methods, and computer program products for processing an online transaction to purchase a set of products comprising an itinerary. In response to receiving a rejection of a request to book one of the products, an On-Line Transaction Processing (OLTP) system determines if the rejected booking is for a product that is critical to the itinerary. The OLTP system may make this determination based on critical product rules retrieved from a database of critical product rules. In response to determining the rejected booking is for a product that is non-critical to the itinerary, the OLTP system may be confirm bookings for the remaining products in the itinerary. In response to determining the rejected booking is for product that is critical to the itinerary, the OLTP system may roll back any previously confirmed bookings and cancel any previously made reservations for the other products in the itinerary.

Abstract: Systems, methods, and computer program products for processing an online transaction to purchase a set of products comprising an itinerary. In response to receiving a message indicating a form of payment being used to purchase the itinerary may be fraudulent, an OLTP system may identify product recovery rules with input parameters that are satisfied by a context of the online transaction. The OLTP system may apply the identified recovery rules to products determined to be critical to the itinerary. If the critical products are determined to be recoverable, the OLTP system may book the critical products to preserve the availability and pricing of the critical products while the form of payment is subjected to a fraud screening process. If the itinerary includes at least one critical product that is not recoverable, the OLTP system may determine that the questionable form of payment should be canceled.

Abstract: Systems, methods, and computer program products for processing an online transaction to purchase a set of products. An On-Line Transaction Processing (OLTP) system includes a plurality of databases, each maintaining rules for determining a merchant at a different analytical level. To process the online transaction, the OLTP system searches a global rules database for rules defining the merchant at a transaction level, and a product rules database for rules defining the merchant at a product level. The OLTP system applies the rules returned by each database to the products to determine a baseline merchant assignment for each product. The OLTP system may then search an override rules database for applicable merchant override rules, and applies the override rules to the products. When a final merchant has been determined for each product, the OLTP system updates a database record defining the set of products to indicate the merchant for each product.

Abstract: Methods, systems, and computer program products for managing an Electronic Miscellaneous Document (EMD). In response to receiving a request for an ancillary service, an aggregation module generates an aggregation record. The aggregation module may obtain passenger and segment data from a plurality of Passenger Name Records (PNRs), and add this data to the aggregation record. The aggregation record may thereby provide a database object including passenger and segment data from multiple PNRs associated with an itinerary. The aggregation record may be associated with an EMD, and may be configured so that a single EMD can be issued to a traveler for an ancillary service provided across an itinerary comprising multiple PNRs. A mapping record may also be generated that links the EMD, aggregation record, and PNRs. The mapping record may thereby provide an index that enables a database to quickly identify relationships between EMDs, aggregation records, and PNRs.