Method and device for processing point data of common passengers of airline company

Abstract

The invention discloses an airline common passenger integral data processing method and device, and the method comprises the steps: carrying out the data format verification and information validity verification of common passenger integral data, matching the common passenger integral data with a first main file through employing a common passenger plan type and an integral source after the verification is passed, and carrying out the matching of the common passenger integral data and a second main file; integral value calculation parameters are obtained; performing integral value calculation on the common passenger integral data by using the integral value calculation parameters to obtain integral value information; the point value information comprises an accounting type and an accounting attribute; using the accounting type, the accounting attribute, the common passenger plan type and the point source to match the common passenger point data with the second master file to obtain an accounting generation parameter; and generating a bill for opening an account for a cooperative enterprise of the airline company by using the accounting generation parameters, the common passenger point data and the point value information. According to the invention, the labor cost can be reduced, and the efficiency and accuracy of common passenger point value calculation and billing processing of an airline company are improved.

Description

Technical Field

[0001] The present invention relates to the technical field of aviation data processing, and in particular to a method and device for processing airline frequent flyer points data. Background Art

[0002] This section is intended to provide a background or context to the embodiments of the invention that are recited in the claims. No statement herein is admitted to be prior art by virtue of its inclusion in this section.

[0003] To boost customer loyalty, most airlines worldwide have launched frequent flyer programs centered around mileage-based rewards. Frequent flyer members accumulate miles through flight travel and co-branded credit card spending, which can be redeemed for benefits such as free flights, cabin upgrades, and hotel stays. Originating in the United States in the 1970s, frequent flyer programs have become a mainstream marketing tool for the global airline industry, serving the dual purpose of attracting frequent travelers and enhancing brand competitiveness.

[0004] Airlines use frequent flyer systems to manage the points accumulated by their frequent flyer members through travel on the airline's flights, flights of partner airlines, and purchases made with the airline's non-airline partners (such as hotels and car rental companies). Each frequent flyer member has a unique ID in the system, and accumulated points are recorded under that ID for subsequent purchases.

[0005] Frequent flyer members earn points by purchasing tickets or services from the airline, which can be considered a promotional tool of the airline. Frequent flyer members can subsequently redeem these points for reward tickets or services.

[0006] Frequent flyer members can redeem points earned through spending with other partners (for example, flights or hotel stays with other airlines that have partnered with the airline) for tickets or services offered by the airline. The airline is required to convert these points into corresponding amounts at the rates agreed upon with the partners and to make regular payments to these partners to compensate the airline for the losses incurred by providing these points to frequent flyer members.

[0007] An airline's frequent flyer system is responsible for managing the points accumulated and spent by frequent flyer members, as well as the source of the points (from flights with the airline or purchases of partner products) and the destination of the points (whether redeemed for airline award tickets or services or partner products). After verifying the accuracy and validity of the points, the airline's frequent flyer system regularly (usually monthly) transmits the points information accumulated by frequent flyer members to the airline's finance department. The finance department is responsible for calculating the value of the points and billing these partners for the calculated value of the points earned by frequent flyer members from purchases of partner products to compensate the airline for any losses.

[0008] After receiving the points accumulation data regularly sent by the frequent flyer system, the airline's finance department must calculate the corresponding amount of points based on the airline's own approved unit value and complete financial accounting. At the same time, based on the point unit price agreed with each partner, the airline manually calculates the value of airline points accumulated by frequent flyer members through consumption of partner products over a certain period of time. To achieve rapid capital repatriation, the partners must be billed immediately after the points value is calculated.

[0009] Airlines' finance departments typically need to complete accounting for all financial data from the previous month at the beginning of each month (usually within the first week of the month). This process is called "closing the account," meaning closing the account for the previous financial month. The airline's frequent flyer system can only send the previous month's accumulated frequent flyer points to the finance department at the beginning of each month at the earliest. Based on the previous month's frequent flyer points data, the finance department calculates the value of any points that have changed during the previous month and performs the corresponding financial accounting. It also calculates the value of airline points accumulated by frequent flyer members through purchases with the airline's partners (such as other airlines, hotels, car rentals, and credit card companies), and bills these partners for this value before "closing the account." Currently, this process is primarily handled manually by the finance department. Calculating the point value, completing the corresponding financial accounting, and billing all partners takes just a few days. This intensive manual processing within a short period of time places time pressure on the finance department, and manual operations are prone to errors, which are drawbacks of existing technologies. Summary of the Invention

[0010] An embodiment of the present invention provides a method for processing airline frequent flyer points data to reduce labor costs and improve the efficiency and accuracy of airline frequent flyer points value calculation and account opening. The method includes:

[0011] Receive frequent flyer points data from multiple airlines; the frequent flyer points data includes frequent flyer program type and points source;

[0012] Perform data format verification and information validity verification on the frequent flyer points data to obtain the frequent flyer points data that has passed the verification;

[0013] Using the frequent flyer program type and the source of points, the verified frequent flyer points data is matched with the first master file to obtain point value calculation parameters; the point value calculation parameters are used for conversion calculation of the actual value of the points; the first master file includes a mapping relationship between the frequent flyer program type, the source of points, and the point value calculation parameters;

[0014] Calculating the points value of the verified frequent flyer points data using the points value calculation parameters to obtain points value information; the points value information includes account type and account attributes;

[0015] Using the account type, account attribute, frequent flyer program type, and points source, the verified frequent flyer points data is matched with a second master file to obtain account generation parameters; the account generation parameters are used to generate the account data; the second master file includes a mapping relationship between the account type, account attribute, frequent flyer program type, points source, and the account generation parameters;

[0016] The account generation parameters, the verified frequent flyer points data and the points value information are used to generate an invoice to the airline's partner company.

[0017] An embodiment of the present invention further provides an airline frequent flyer points data processing device for reducing labor costs and improving the efficiency and accuracy of airline frequent flyer points value calculation and account opening processing. The device includes:

[0018] A data receiving module, configured to receive frequent flyer points data from multiple airlines; the frequent flyer points data includes the frequent flyer program type and the source of the points;

[0019] The data verification and parsing module is used to perform data format verification and information validity verification on the frequent flyer points data, and obtain the frequent flyer points data that has passed the verification;

[0020] a points value calculation module, configured to use the frequent flyer program type and points source to match the verified frequent flyer points data with a first master file to obtain point value calculation parameters; the point value calculation parameters are used for conversion calculation of actual point values; the first master file includes a mapping relationship between the frequent flyer program type, points source, and the point value calculation parameters; and to use the point value calculation parameters to calculate the point value of the verified frequent flyer points data to obtain point value information; the point value information includes an account type and an account attribute;

[0021] an account generation module, configured to match the verified frequent flyer points data with a second master file using the account type, account attributes, frequent flyer program type, and points source to obtain account generation parameters; the account generation parameters are used to generate the account data; the second master file includes a mapping relationship between the account type, account attributes, frequent flyer program type, points source, and the account generation parameters;

[0022] The account generation parameters, the verified frequent flyer points data and the points value information are used to generate an invoice to the airline's partner company.

[0023] An embodiment of the present invention further provides a computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the above-mentioned airline frequent flyer points data processing method when executing the computer program.

[0024] An embodiment of the present invention further provides a computer-readable storage medium storing a computer program. When the computer program is executed by a processor, the computer program implements the above-mentioned airline frequent flyer points data processing method.

[0025] An embodiment of the present invention further provides a computer program product, which includes a computer program. When the computer program is executed by a processor, it implements the above-mentioned airline frequent flyer points data processing method.

[0026] In the embodiment of the present invention, data format verification and information validity verification are performed on frequent flyer points data. After the verification is passed, the first master file is used to calculate the points value, and then the second master file is used to generate accounts, and finally an invoice is generated for opening accounts to a third party. In the embodiment of the present invention, the automatic processing of the airline frequent flyer points value accounting and opening accounts shortens the work that the airline finance department needs to complete in about a week in the prior art to 1 to 2 hours, greatly improving work efficiency and reducing labor costs. At the same time, through the automated processing of verification, opening accounts and other procedures, the accuracy of the airline frequent flyer points value calculation and opening account processing is improved. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for the embodiments or the description of the prior art. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative work. In the drawings:

[0028] Figure 1This is a flow chart of a method for processing airline frequent flyer points data in an embodiment of the present invention;

[0029] Figure 2 This is a diagram showing a specific example of a method for processing airline frequent flyer points data according to an embodiment of the present invention;

[0030] Figure 3 Schematic diagram of an airline frequent flyer points data processing device according to an embodiment of the present invention;

[0031] Figure 4 This is a diagram showing a specific example of an apparatus for processing airline frequent flyer points data according to an embodiment of the present invention;

[0032] Figure 5 Schematic diagram of a computer device in an embodiment of the present invention. DETAILED DESCRIPTION

[0033] To make the purpose, technical solutions and advantages of the embodiments of the present invention more clear, the embodiments of the present invention are further described in detail below with reference to the accompanying drawings. Here, the exemplary embodiments of the present invention and their descriptions are used to explain the present invention, but are not intended to limit the present invention.

[0034] In order to clearly describe the technical solutions of the embodiments of the present invention, in the embodiments of the present invention, words such as "first" and "second" are used to distinguish between identical or similar items with basically the same functions and effects. Those skilled in the art can understand that words such as "first" and "second" do not limit the quantity and execution order.

[0035] The acquisition, transmission, storage, use, and processing of data in the technical solution of this application comply with the relevant provisions of national laws and regulations.

[0036] First, the technical terms involved in the embodiments of the present invention are explained.

[0037] 1. Frequent Flyer Program (FFP): A promotional program offered by airlines, hotels, and other industries to customers who frequently use their products, primarily through accumulating miles or points to reward them. It is a marketing tool to attract passengers and enhance the company's competitiveness.

[0038] 2. Credit card and hotel membership points: These are points awarded by credit cards or hotels based on factors such as the amount and type of spending by members, according to specific rules. These points can be accumulated and, after reaching a certain amount, can be redeemed for a variety of gifts, services, or cash discounts.

[0039] 3. Airline Award Ticket Redemption: refers to the act of passengers using accumulated airline frequent flyer miles or points from airline partners (such as other airlines, hotels, credit card organizations, etc.) to redeem air tickets or other travel services.

[0040] To meet the requirements of airline financial departments for efficiently and accurately calculating the value of frequent flyer points and managing the opening of accounts for the value of points to airline partners, embodiments of the present invention provide a method and apparatus for processing airline frequent flyer points data. These methods and apparatus involve calculating and opening accounts for airline frequent flyer points, and their primary functions include receiving, verifying, and parsing airline frequent flyer points data, calculating the value of points, performing accounting, and opening accounts for points. Figure 1 FIG. 1 is a flow chart of a method for processing airline frequent flyer points data according to an embodiment of the present invention. Figure 1 As shown, the method includes:

[0041] Step 101: Receive frequent flyer points data from multiple airlines; the frequent flyer points data includes frequent flyer program type and points source;

[0042] Step 102: Perform data format verification and information validity verification on the frequent flyer points data to obtain the verified frequent flyer points data.

[0043] Step 103: Using the frequent flyer program type and the points source, the verified frequent flyer points data is matched with the first master file to obtain point value calculation parameters; the point value calculation parameters are used for conversion calculation of the actual value of the points; the first master file includes a mapping relationship between the frequent flyer program type, the points source, and the point value calculation parameters;

[0044] Step 104: Calculate the point value of the verified frequent flyer point data using the point value calculation parameters to obtain point value information; the point value information includes account type and account attributes;

[0045] Step 105: Using the account type, account attribute, frequent flyer program type, and points source, the verified frequent flyer points data is matched with a second master file to obtain account generation parameters; the account generation parameters are used to generate the account data; the second master file includes a mapping relationship between the account type, account attribute, frequent flyer program type, points source, and the account generation parameters;

[0046] Step 106: Generate an invoice to the third party using the account generation parameters, the verified frequent flyer points data, and the points value information.

[0047] from Figure 1As can be seen from the flow, the main functions of the method of the embodiment of the present invention include the following four parts:

[0048] (1) Verification and analysis of airline frequent flyer points data;

[0049] (2) Calculation of point value;

[0050] (3) Accounting treatment of the value of points;

[0051] (4) Billing to airline partners.

[0052] The following is a detailed explanation of these four parts.

[0053] In step 101, frequent flyer points data of multiple airlines are received.

[0054] There may be multiple airlines under an aviation group, and each airline may have its own frequent flyer program. However, different frequent flyer programs under the same aviation group can be managed by the same frequent flyer system or the same frequent flyer points financial accounting system.

[0055] During implementation, a platform or system can be built to receive frequent flyer points data and perform at least Figure 1 The method shown, for example, the system is a frequent flyer accumulated points accounting and management system, referred to as a points accounting system for short.

[0056] Table 1 shows the frequent flyer points data.

[0057] Table 1

[0058]

[0059] Description of the fields in Table 1:

[0060] 1. Frequent Flyer Program Type: Each airline can have its own frequent flyer program brand. For example, Airline A's frequent flyer program brand is Panda, and Airline B's frequent flyer program brand is Great Wall. When multiple airlines under an airline group have different frequent flyer program brands, this field is used to distinguish them (for example, "Panda" and "Great Wall" in the example above are both frequent flyer program brands of the same airline group).

[0061] 2. Points accumulation month: refers to the month in which the points data is accumulated.

[0062] 3. Organization code of the points source, i.e. the source of points: Each internal unit of an airline and its partners may accumulate frequent flyer points, so each of these units is assigned a unique account code.

[0063] 4. Points accumulated during the period: refers to the points accumulated by passengers during the period due to consumption of products of the airline or its partners.

[0064] 5. Points deducted during the period: refers to the points that have been found to be incorrectly accumulated during the period and need to be deducted.

[0065] 6. Net increase in points during the period: refers to the "net increase in points" obtained by deducting the "reduced points" from the "accumulated points" during the period.

[0066] In one embodiment, receiving frequent flyer points data of multiple airlines may include:

[0067] By verifying the time point information of the received frequent flyer points data and / or the name identifier of the frequent flyer points data file, if it is determined that frequent flyer points data of the same frequent flyer program type has been received within a set period, the received frequent flyer points data is rolled back.

[0068] During implementation, an airline's frequent flyer system sends frequent flyer points accumulated over a specified period to the points accounting system at a fixed frequency (e.g., monthly). To prevent duplicate data imports, the points accounting system only allows one file per frequent flyer program type to be entered during a specified period, using a control table.

[0069] The following uses the frequent flyer file frequency of "monthly" as an example to illustrate the role of the control table, as shown in Table 2.

[0070] Table 2

[0071]

[0072]

[0073] Control logic: When a frequent flyer data file is imported, the control table is searched for: (1) whether a file with the same file name has been imported, or (2) whether a file has been imported in the same file import month. If so, the new file is not allowed to be imported. Otherwise, the above four fields are written to the control table.

[0074] For example, when importing file ABC in 202x0406, the control table must first be checked for a record with file name = ABC. If so, the import is not allowed and the file is rolled back. If not, the control table is checked for a record with file import month = 202x04. If not, the relevant information about the ABC file is written. If data for 202x04 already exists, it proves that the frequent flyer points file for April has already been imported, and this import is not allowed. The file is rolled back and an error warning email is automatically sent to the designated email address for investigation by relevant personnel.

[0075] In step 102, the frequent flyer points data is subjected to data format verification and information validity verification to obtain the frequent flyer points data that has passed the verification.

[0076] For example, perform file-level verification and record-level verification on frequent flyer points data.

[0077] File-level validation checks whether the contents of the frequent flyer points file match the defined file format. For data that matches the file format, temporary frequent flyer points data is written and the next step, record-level validation, is performed. If the file-level validation result indicates that the format does not match the specification, the entire file needs to be rolled back and the frequent flyer system must correct the error and retransmit it.

[0078] For example, data format verification includes whether the file naming is standardized and whether the file format is the agreed format.

[0079] In one embodiment, after performing data format verification and information validity verification on the frequent flyer points data, the method further includes: when the data format verification and / or information validity verification fails, sending an alarm message to a designated address, receiving modification information, and using the modification information to modify the frequent flyer points data.

[0080] (1) File-level inspection content:

[0081] 1.1 Check file naming rules;

[0082] Frequent flyer points files that do not comply with the naming conventions will not pass the file-level check.

[0083] 1.2 File format and structure check;

[0084] Frequent flyer points documents must comply with the pre-agreed format structure, otherwise they will not pass the inspection.

[0085] For frequent flyer points files that fail the document check, a warning email needs to be automatically sent to a designated email address. The error description in the email locates the specific error location to facilitate error checking and repair.

[0086] 1.3 Frequent flyer points temporary database;

[0087] Frequent flyer points data that passes file-level verification is written to a temporary database for further processing.

[0088] (2) Record-level verification:

[0089] After frequent flyer points data is written to the temporary database, each entry is validated. For data that passes validation, the points value is calculated. For data that fails validation, a correction platform is provided, displaying error messages and suggesting changes. Manual intervention is required to make corrections, and validation is repeated after the changes are made until the data passes validation.

[0090] After the frequent flyer points data passes the aforementioned file-level and record-level verification, the frequent flyer points value calculation is performed. In step 103, the verified frequent flyer points data is matched with the first master file using the frequent flyer program type and points source to obtain points value calculation parameters. In step 104, the points value calculation parameters are used to calculate the points value of the verified frequent flyer points data, obtaining points value information. The points value calculation parameters are used to convert the actual value of the points. The first master file includes a mapping between the frequent flyer program type, points source, and the points value calculation parameters. The points value information includes the account type and account attributes.

[0091] In one embodiment, the points value calculation parameters include currency type, point unit value, and point value sharing ratio.

[0092] The calculation of the points value requires the use of the "Frequent Flyer Points Value Calculation Reference Master File" (hereinafter referred to as the first master file). The main information in the first master file is shown in Tables 3 and 4 below.

[0093] Table 3

[0094]

[0095]

[0096] By matching the frequent flyer points data obtained from the upstream frequent flyer system with the "frequent flyer program type" and "points source organization code" of the first master file, the "points unit value" and currency of each "points source organization code" can be found. The "net growth points" for the current period obtained through the points data can be used to calculate the "monetary value" corresponding to the "net growth points".

[0097] Table 4

[0098]

[0099] In one embodiment, after calculating the point value of the verified frequent flyer point data using the point value calculation parameters and obtaining the point value information, the following steps are further included:

[0100] The point value information and the corresponding frequent flyer point data are written into the frequent flyer point value database; the frequent flyer point data in the frequent flyer point value database carries an identifier of waiting for account generation or having generated an account.

[0101] During implementation, the data on the frequent flyer points value calculation is written into the frequent flyer points value database, and an "account generated" indicator is printed. At the same time, the points information in the database can be used to provide corresponding analytical statistical reports according to the requirements of the airline.

[0102] Afterwards, the account opening process is performed. In step 105, the verified frequent flyer points data is matched with the second master file using the account type, account attributes, frequent flyer program type, and points source to obtain account generation parameters; the account generation parameters are used to generate the account data; the second master file includes a mapping relationship between the account type, account attributes, frequent flyer program type, points source, and account generation parameters; in step 106, the account generation parameters, the verified frequent flyer points data, and the points value information are used to generate an invoice to the third party.

[0103] In one embodiment, in order to ensure that all account information is generated at once for each period of frequent flyer points data, a data integrity check is required. The method is as follows:

[0104] 1. Go to the frequent flyer points value database and search for the "File Name" field (i.e., the "File Name" of the frequent flyer points data) for data that has not yet been generated (controlled by the "Account Generated" flag in the database).

[0105] 2. Use the "file name" found in step 1 to search the "frequent flyer points temporary database" to see if there is any data with the same file name. If there is data with the same file name, it means that there is still erroneous data in the file in the temporary database. In this case, the account cannot be generated. If there is no data with the same file name in the temporary database, it means that all data errors under the file have been cleared, and all the data in the file is in the "frequent flyer points value database". In this case, the conditions for generating accounts are met, and the "whether the account is generated" flag is set to "waiting for account generation". (When the account generation is completed, the status of this flag is set to "account generated").

[0106] As described in the frequent flyer points data format verification, a frequent flyer points file may contain thousands of records. When each record is written to the temporary frequent flyer points database, its file name is recorded. If some records in a file have been written to the final database, while others remain in the temporary database due to errors, the file name associated with these records in the final database can be used to search the temporary database for records with the same file name to determine whether all records in the same frequent flyer points file have been imported into the final database. If different records with the same file name exist in both the temporary database and the final database, this indicates that some data in the file has not been fully corrected. Frequent flyer points data accounting requires that all records be generated simultaneously. Only after passing the data integrity verification will the next step of account opening be processed.

[0107] In one embodiment, the verified frequent flyer points data is matched with the second master file using the account type, account attribute, frequent flyer program type, and points source to obtain account generation parameters, including:

[0108] According to the preset account generation frequency, frequent flyer points data waiting for account generation is screened from the frequent flyer points value database, and matched with the second master file to obtain account generation parameters; the account generation parameters specifically include parameters reflecting the account structure. The account structure is a framework system for classifying, recording and reporting various types of financial data, reflecting the organization method and internal logic of financial information.

[0109] During specific implementation, set up accounting generation tasks and execute them according to the agreed frequency, time point, and duration.

[0110] When generating accounts, you'll need the "Frequent Flyer Points Accounting Reference Master File" (hereinafter referred to as the "Second Master File"). This Second Master File determines the accounting entries that should be generated for each type of Frequent Flyer Points. See Table 5 below for key information in the Second Master File.

[0111] Table 5

[0112]

[0113] The "Account Generation" flag in the frequent flyer points value database identifies data with a "Waiting for Account Generation" status. This data is compared with the information in the first and second master files to determine the required accounting structure. The corresponding accounting data is then generated and written to the accounting database. Account generation is accomplished by periodically executing the "Account Generation Job" mentioned above.

[0114] Account generation is divided into two categories:

[0115] (1) Points accumulated by frequent flyer members of an airline by consuming the airline’s products or services are classified as the airline’s general ledger (GL);

[0116] The following uses the points accumulated by frequent flyers of an airline on flights of this airline to illustrate the accounts generated by using the first and second master files. Refer to Table 6:

[0117] In the frequent flyer points file, frequent flyer members of Great Wall Airlines accumulated 100,000 points that month due to Great Wall Airlines flights. Given that each point is worth 0.10 yuan in xx coins, the calculated value of the points is 10,000 yuan in xx coins. Based on the first master file, the account type for points accumulated by members of this airline by flying the airline is A, and the account attribute is general ledger (GL). The system then reads the general ledger of type A from the second master file, finds the corresponding account structure, and generates the account based on this structure:

[0118] Debit: Deferred income - Great Wall Card RMB 10,000;

[0119] Credit: Frequent traveler account opening of 10,000 yuan;

[0120] Credit: Passenger promotion 10,000 yuan;

[0121] Debit: Great Wall Card mileage redemption of RMB 10,000;

[0122] Table 6

[0123]

[0124] (2) The points accumulated by the airline’s frequent flyer members through consumption of the airline’s partner products or services are classified as airline accounts receivable (AR);

[0125] The following uses the points accumulated by frequent flyers of an airline by taking flights of other airlines to illustrate the accounts generated by using the first and second master files. Refer to Table 7:

[0126] In the frequent flyer points file, Great Wall Airlines frequent flyer members accumulated 100,000 points that month due to flying on United Airlines. Given that each point is worth USD 0.10, the calculated value of the points is USD 10,000. Based on the first master file, the account type for points accumulated by members of this airline through flying on United Airlines is found to be A, with an account attribute of accounts receivable (AR) and a points share ratio of 15%. The system then reads the A account receivable of type A from the second master file, finds the corresponding account structure, and generates the accounts based on this structure:

[0127] Debit: United Airlines opening amount USD 1,000;

[0128] Credit: Points commission USD 1,500;

[0129] Credit: Opening amount: USD 8,500;

[0130] Table 7

[0131]

[0132] Based on the frequent flyer points account data, an invoice is generated for the "airline partner." This invoice includes information such as the invoice number, issuing company, billed company, billing period, billing date, frequent flyer program name, credit points, commission ratio, and billing amount. The system automatically sends the invoice to the airline partner's designated email address using the "points source organization email address" maintained in the first master file.

[0133] In addition, the generated frequent flyer points accounting data can also be regularly transmitted to the downstream accounting system in a fixed format. The downstream accounting system uses the accounting data for data processing and executes it at an agreed frequency by setting automatic operations.

[0134] Figure 2 FIG. 1 is a specific example of a method for processing airline frequent flyer points data in an embodiment of the present invention. Figure 2 The figure shows the overall process of verifying and parsing airline frequent flyer points data, calculating point values, accounting for point values, and billing airline partners. This includes receiving frequent flyer points data from the frequent flyer system, verifying the file reception frequency using a control table, performing file-level and record-level validation, storing the data in a temporary frequent flyer points database, calculating the frequent flyer points value using a first master file, storing the data in the frequent flyer points value database, generating accounting data using a second master file, storing the data in the accounting database, obtaining the accounting file, and using the accounting data to generate billing data. Furthermore, a frequent flyer points value report can be generated based on the frequent flyer points value database.

[0135] The method for automatically calculating the value of airline frequent flyer points and opening accounts designed in the embodiment of the present invention greatly improves the efficiency of frequent flyer points data processing, the accuracy of points calculation, and the efficiency and accuracy of account opening.

[0136] The present invention also provides an apparatus for processing airline frequent flyer points data, as described in the following embodiments. Because the principles underlying the apparatus are similar to those of the airline frequent flyer points data processing method, the implementation of the apparatus can be referenced to the implementation of the airline frequent flyer points data processing method, and any repetitions will not be repeated.

[0137] Figure 3 FIG. 1 is a schematic diagram of an airline frequent flyer points data processing device according to an embodiment of the present invention. Figure 3 As shown, the device 300 includes:

[0138] The data receiving module 301 is used to receive frequent flyer points data of multiple airlines; the frequent flyer points data includes the frequent flyer program type and the source of the points;

[0139] The data verification and analysis module 302 is used to perform data format verification and information validity verification on the frequent flyer points data to obtain the frequent flyer points data that has passed the verification;

[0140] The points value calculation module 303 is configured to match the verified frequent flyer points data with the first master file using the frequent flyer program type and points source to obtain point value calculation parameters; the point value calculation parameters are used to convert the points into actual values; the first master file includes a mapping relationship between the frequent flyer program type, points source, and the point value calculation parameters; the point value calculation parameters are used to calculate the point value of the verified frequent flyer points data to obtain point value information; the point value information includes the account type and account attributes;

[0141] The account generation module 304 is configured to match the verified frequent flyer points data with a second master file using the account type, account attributes, frequent flyer program type, and points source to obtain account generation parameters; the account generation parameters are used to generate the account data; the second master file includes a mapping relationship between the account type, account attributes, frequent flyer program type, points source, and the account generation parameters; and the account generation parameters, the verified frequent flyer points data, and the points value information are used to generate an invoice to the airline's partner company.

[0142] In one embodiment, the data receiving module 301 is specifically configured to:

[0143] By verifying the time point information of the received frequent flyer points data and / or the name identifier of the frequent flyer points data file, if it is determined that frequent flyer points data of the same frequent flyer program type has been received within a set period, the received frequent flyer points data is rolled back.

[0144] In one embodiment, the data format verification includes whether the file naming is standardized and whether the file format is the agreed format;

[0145] Figure 4 FIG. 1 is a diagram showing a specific example of an apparatus for processing airline frequent flyer points data in an embodiment of the present invention. Figure 4 As shown, the device 300 further includes:

[0146] The data modification module 401 is configured to send an alert message to a designated address after the data format verification and information validity verification are performed on the frequent flyer points data by the data verification and analysis module, and receive modification information to modify the frequent flyer points data using the modification information if the data format verification and / or information validity verification fails.

[0147] In one embodiment, the points value calculation parameters include currency type, points unit value, and points value sharing ratio.

[0148] In one embodiment, the apparatus 300 further includes:

[0149] a points value database, configured to calculate the points value of the verified frequent flyer points data using the points value calculation parameters in the points value calculation module, and after obtaining the points value information, write the points value information and the corresponding frequent flyer points data into the frequent flyer points value database; the frequent flyer points data in the frequent flyer points value database carries an indication of whether an account is pending or has been generated;

[0150] The account generation module 304 is specifically configured to: filter the frequent flyer points data waiting for account generation from the frequent flyer points value database according to a preset account generation frequency, match the data with the second master file, and obtain account generation parameters.

[0151] Figure 5 Schematic diagram of a computer device according to an embodiment of the present invention. Figure 5 As shown, an embodiment of the present invention further provides a computer device 500, including a processor 501, a memory 502, and a computer program 503 stored in the memory 502 and executable on the processor 501. When the processor 501 executes the computer program 503, the above-mentioned airline frequent flyer points data processing method is implemented.

[0152] An embodiment of the present invention further provides a computer-readable storage medium storing a computer program. When the computer program is executed by a processor, the computer program implements the above-mentioned airline frequent flyer points data processing method.

[0153] An embodiment of the present invention further provides a computer program product, which includes a computer program. When the computer program is executed by a processor, it implements the above-mentioned airline frequent flyer points data processing method.

[0154] In the embodiment of the present invention, data format verification and information validity verification are performed on frequent flyer points data. After the verification is passed, the first master file is used to calculate the points value, and then the second master file is used to generate accounts, and finally an invoice is generated for opening accounts to a third party. In the embodiment of the present invention, the automatic processing of the airline frequent flyer points value accounting and opening accounts shortens the work that the airline finance department needs to complete in about a week in the prior art to 1-2 hours, greatly improving work efficiency and reducing labor costs. At the same time, through the automated processing of verification, opening accounts and other procedures, the accuracy of the airline frequent flyer points value calculation and opening account processing is improved.

[0155] It will be understood by those skilled in the art that embodiments of the present invention may be provided as methods, systems, or computer program products. Thus, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment, or an embodiment combining software and hardware. Furthermore, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to magnetic disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0156] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowcharts and / or block diagrams, as well as combinations of processes and / or blocks in the flowcharts and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowcharts and / or block diagrams. Figure 1 a process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0157] These computer program instructions may also be stored in a computer readable memory that can direct a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 a process or multiple processes and / or boxes Figure 1 The function specified in one or more boxes.

[0158] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operational steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing the instructions executed on the computer or other programmable device for implementing the process. Figure 1 a process or multiple processes and / or boxes Figure 1 The steps for the function specified in one or more boxes.

[0159] The specific embodiments described above further illustrate the objectives, technical solutions and beneficial effects of the present invention in detail. It should be understood that the above description is only a specific embodiment of the present invention and is not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present invention should be included in the scope of protection of the present invention.

Claims

1. A method for processing airline frequent flyer points data, characterized in that: include: Receive frequent flyer points data from multiple airlines; The frequent flyer points data includes the frequent flyer program type and the source of points; Perform data format verification and information validity verification on the frequent flyer points data to obtain the frequent flyer points data that has passed the verification; Using the frequent flyer program type and the points source, matching the verified frequent flyer points data with the first master file to obtain a points value calculation parameter; The points value calculation parameters are used for conversion calculation of the actual value of points; the first master file includes a mapping relationship between the frequent flyer program type, the points source, and the points value calculation parameters; Calculating the points value of the frequent flyer points data after verification using the points value calculation parameters to obtain points value information; Point value information includes account type and account attributes; Using the account type, account attribute, frequent flyer program type, and points source, the verified frequent flyer points data is matched with the second master file to obtain account generation parameters; The account generation parameters are used to generate account data; the second master file includes a mapping relationship between the account type, account attribute, frequent flyer program type, points source and the account generation parameters; The account generation parameters, the verified frequent flyer points data and the points value information are used to generate an invoice to the airline's partner company.

2. The method according to claim 1, wherein Receive frequent flyer points data from multiple airlines, including: By verifying the time point information of the received frequent flyer points data and / or the name identifier of the frequent flyer points data file, if it is determined that frequent flyer points data of the same frequent flyer program type has been received within a set period, the received frequent flyer points data is rolled back.

3. The method according to claim 1, wherein The data format verification includes whether the file naming is standardized and whether the file format is the agreed format; After checking the data format and information validity of frequent flyer points data, the following also applies: When the data format check and / or information validity check fails, an alarm message is sent to a designated address, modification information is received, and the frequent flyer points data is modified using the modification information.

4. The method according to claim 1, wherein The points value calculation parameters include currency type, point unit value, and point value sharing ratio.

5. The method according to claim 1, wherein The point value calculation parameters are used to calculate the point value of the frequent flyer point data after verification. After obtaining the point value information, the following steps are also included: Writing the point value information and the corresponding frequent flyer point data into the frequent flyer point value database; the frequent flyer point data in the frequent flyer point value database carries an indication of whether the account is waiting to be generated or has been generated; Using the account type, account attribute, frequent flyer program type, and points source, the verified frequent flyer points data is matched with the second master file to obtain account generation parameters, including: According to the preset account generation frequency, the frequent flyer points data waiting for account generation is screened from the frequent flyer points value database, matched with the second master file, and the account generation parameters are obtained.

6. An airline frequent flyer points data processing device, characterized in that: include: A data receiving module, used to receive frequent flyer points data from multiple airlines; The frequent flyer points data includes the frequent flyer program type and the source of points; The data verification and parsing module is used to perform data format verification and information validity verification on the frequent flyer points data, and obtain the frequent flyer points data that has passed the verification; a points value calculation module, configured to match the verified frequent flyer points data with the first master file using the frequent flyer program type and the points source to obtain a points value calculation parameter; The points value calculation parameters are used for conversion calculation of the actual value of points; the first master file includes a mapping relationship between the frequent flyer program type, the points source, and the points value calculation parameters; Calculating the points value of the frequent flyer points data after verification using the points value calculation parameters to obtain points value information; Point value information includes account type and account attributes; an account generation module, configured to match the verified frequent flyer points data with the second master file using the account type, account attribute, frequent flyer program type, and points source to obtain account generation parameters; The account generation parameters are used to generate account data; the second master file includes a mapping relationship between the account type, account attribute, frequent flyer program type, points source and the account generation parameters; The account generation parameters, the verified frequent flyer points data and the points value information are used to generate an invoice to the airline's partner company.

7. The device according to claim 6, characterized in that The data receiving module is specifically used for: By verifying the time point information of the received frequent flyer points data and / or the name identifier of the frequent flyer points data file, if it is determined that frequent flyer points data of the same frequent flyer program type has been received within a set period, the received frequent flyer points data is rolled back.

8. The device according to claim 6, wherein The data format verification includes whether the file naming is standardized and whether the file format is the agreed format; Also includes: The data modification module is used to send an alarm message to a designated address after the data format verification and information validity verification are performed on the frequent flyer points data by the data verification and analysis module, receive modification information, and use the modification information to modify the frequent flyer points data.

9. The device according to claim 6, wherein The points value calculation parameters include currency type, point unit value, and point value sharing ratio.

10. The device according to claim 6, wherein Also includes: a points value database, configured to calculate the points value of the verified frequent flyer points data using the points value calculation parameters in the points value calculation module, and after obtaining the points value information, write the points value information and the corresponding frequent flyer points data into the frequent flyer points value database; the frequent flyer points data in the frequent flyer points value database carries an indication of whether an account is pending or has been generated; The account generation module is specifically used for: According to the preset account generation frequency, the frequent flyer points data waiting for account generation is screened from the frequent flyer points value database, matched with the second master file, and the account generation parameters are obtained.

11. A computer device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the computer program, the method according to any one of claims 1 to 5 is implemented.

12. A computer-readable storage medium, characterized in that The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 5 is implemented.

13. A computer program product, characterized in that The computer program product comprises a computer program, and when the computer program is executed by a processor, the method according to any one of claims 1 to 5 is implemented.

Images