Auxiliary marketing product processing method and system based on multiple supply sources and autonomous price library

Abstract

The invention discloses an auxiliary marketing product processing system and method based on multiple supply sources and an autonomous price library, and the system comprises the steps: constructing a first data structure of an aviation business, the first data structure is used for storing the first price information of the autonomous price library, and constructing a second data structure integrated by multiple supply sources; the second data structure is used for storing price data of different supply sources, each supply source comprises second price information of a plurality of auxiliary marketing products, and the optimal auxiliary marketing price information of the auxiliary marketing products in the aviation business is determined based on the first price information and the second price information. The problems of data integration, price management and calling efficiency in auxiliary marketing product reservation are solved, the working efficiency of auxiliary marketing product processing is improved, and the user experience is also improved.

Description

Technical Field

[0001] The present invention belongs to the technical field of the airline ticket industry, and particularly relates to a method and system for processing auxiliary products with multiple supply sources and an independent price library. Background Art

[0002] With the rapid development of the aviation industry, auxiliary products (such as seat selection and baggage) have become an important source of revenue for airlines and platforms. However, due to the diversity of supply sources and price complexity, the following problems exist in the prior art: (1) The data standards of auxiliary products from different supply sources are inconsistent, and there is a lack of a unified integration mechanism; (2) Dependence on external supply sources, uncontrollable price fluctuations, which are likely to cause user loss or revenue decline.

[0003] In view of the above problems, the present invention provides a method and system for auxiliary products based on multiple supply sources and an independent price library, which solves the problems of data integration, price management, and call efficiency in auxiliary product reservation. Summary of the Invention

[0004] In view of this, the present invention provides a method and system for processing auxiliary products based on multiple supply sources and an independent price library, which are specifically implemented by the following technical solutions.

[0005] In a first aspect, the present invention provides a method for processing auxiliary products based on multiple supply sources and an independent price library, including the following steps:

[0006] Construct a first data structure for the aviation business, where the first data structure is used to store the first price information of the independent price library;

[0007] Construct a second data structure for multi-supply source integration, where the second data structure is used to store the price data of different supply sources, and each supply source includes the second price information of multiple auxiliary products. Among them, the supply source and the independent price library form a multi-supply source;

[0008] Determine the optimal auxiliary price information of the auxiliary products in the aviation business based on the first price information and the second price information.

[0009] As a preference of the above technical solution, the first data structure for storing the first price information of the independent price library includes:

[0010] Respond to the data acquisition request regularly initiated by the timing scheduling mechanism, and perform real-time data update according to the data acquisition request;

[0011] Obtain the auxiliary data of the aviation business, where the auxiliary data includes at least one of the airline company's official website, high-quality auxiliary supplier API, or self-operated account interface;

[0012] Clean the auxiliary operation data to exclude abnormal data in the auxiliary operation data;

[0013] Perform structured processing on the auxiliary operation data after data cleaning to obtain the first data structure of the independent price library.

[0014] As an optimization of the above technical solution, write the first price information corresponding to the first data structure into the independent price library and store it using a relational database.

[0015] As an optimization of the above technical solution, the abnormal data includes at least one of missing price, baggage information, or airport data.

[0016] As an optimization of the above technical solution, construct a second data structure for multi-source integration, which is used to store price data of different sources, including:

[0017] Respond to the auxiliary operation price acquisition request initiated by the user;

[0018] Obtain the distribution rule in the operation configuration;

[0019] Obtain price data from multiple sources and the independent price library according to the distribution rule;

[0020] Merge the independent price library with the price data of multiple sources and generate second price information according to the second data structure of multiple sources.

[0021] As an optimization of the above technical solution, select the optimal price from the second price information according to a preset rule to obtain the auxiliary operation price information;

[0022] Return the processed auxiliary operation price information to the user.

[0023] As an optimization of the above technical solution, the first data structure includes at least one of airline, departure type, departure location, departure date, destination type, destination, cabin class, baggage type, weight, weight unit, quantity, currency, price, source, or sales stage.

[0024] In a second aspect, the present invention also provides an auxiliary operation product processing system based on multiple sources and an independent price library, which is applied to the above-mentioned auxiliary operation product processing method based on multiple sources and an independent price library, including:

[0025] A first data structure construction unit for constructing a first data structure of aviation business, which is used to store the first price information of the independent price library;

[0026] A second data structure construction unit constructs a second data structure for integrating multiple supply sources, where the second data structure is used to store price data of different supply sources, and each supply source includes second price information of multiple secondary products. Among them, the supply source and the independent price database form multiple supply sources.

[0027] An optimal secondary product price determination unit determines the optimal secondary product price information of the secondary products in the aviation business based on the first price information and the second price information.

[0028] The present invention provides a secondary product processing system and method based on multiple supply sources and an independent price database. By constructing a first data structure for the aviation business, the first data structure is used to store the first price information of the independent price database, constructing a second data structure for integrating multiple supply sources, the second data structure is used to store price data of different supply sources, and each supply source includes second price information of multiple secondary products. Based on the first price information and the second price information, the optimal secondary product price information in the aviation business is determined, solving the problems of data integration, price management, and call efficiency in secondary product reservation, improving the work efficiency of secondary product processing, and also enhancing the user experience. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the following will briefly introduce the drawings required for the embodiments. It should be understood that the following drawings only show some embodiments of the present invention and should not be regarded as limiting the scope. For those of ordinary skill in the art, other related drawings can be obtained based on these drawings without creative efforts.

[0030] Figure 1 It is a flowchart of the secondary product processing method based on multiple supply sources and an independent price database provided by the present invention.

[0031] Figure 2 It is a structural block diagram of the secondary product processing system based on multiple supply sources and an independent price database provided by the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0032] The following details the embodiments of the present invention. The examples of the embodiments are shown in the drawings, where the same or similar reference numerals represent the same or similar elements or elements with the same or similar functions from beginning to end. The embodiments described below with reference to the drawings are exemplary and are only used to explain the present invention and should not be construed as a limitation of the present invention.

[0033] Refer to Figure 1 , the present invention provides a secondary product processing method based on multiple supply sources and an independent price database, including the following steps:

[0034] S1: Construct the first data structure for the aviation business, where the first data structure is used to store the first price information of the independent price library;

[0035] S2: Construct the second data structure for multi-source integration, where the second data structure is used to store the price data of different sources, and each source includes the second price information of multiple secondary products. Among them, the source and the independent price library form a multi-source;

[0036] S3: Determine the optimal secondary price information of the secondary products in the aviation business based on the first price information and the second price information.

[0037] In this embodiment, the first data structure is used to store the first price information of the independent price library, including: responding to the data acquisition request regularly initiated by the timing scheduling mechanism, and performing real-time data update according to the data acquisition request; acquiring the secondary data of the aviation business, where the secondary data includes at least one of the airline official website, high-quality secondary product supplier API or self-operated account interface; performing data cleaning on the secondary data to exclude abnormal data in the secondary data; performing structured processing on the secondary data after data cleaning to obtain the first data structure of the independent price library. Write the first price information corresponding to the first data structure into the independent price library and store it using a relational database. The abnormal data includes at least one of missing price, baggage information or airport data.

[0038] It should be noted that constructing the second data structure for multi-source integration, where the second data structure is used to store the price data of different sources, includes: responding to the secondary price acquisition request initiated by the user; acquiring the distribution rules in the operation configuration; acquiring price data from multiple sources and the independent price library according to the distribution rules; merging the price data of the independent price library and the multi-source, and generating the second price information according to the second data structure of the multi-source. Select the optimal price from the second price information according to the preset rules to obtain the secondary price information; return the processed secondary price information to the user. The first data structure includes at least one of airline, departure type, departure location, departure date, destination type, destination, cabin class, baggage type, weight, weight unit, quantity, currency, price, source or sales stage.

[0039] Specifically, the first data structure can refer to Table 1 below:

[0040] Table 1 Price data structure of the independent price library

[0041]

[0042] The above data structure is used to store the price information of the independent price library of secondary products.

[0043] Specifically, the second data structure for multi-source integration mainly includes: ancillary product types (e.g., 1 represents selection, 2 represents luggage), with the corresponding field being "ancillaryType" and selecting "1"; the field for ancillary product information is "ancillaryInfos", and the ancillary product information includes luggage type (e.g., 1 represents checked luggage, 2 represents carry-on luggage), luggage weight (e.g., 10), weight unit (e.g., KG), quantity (e.g., 1), price (e.g., 100), and currency (e.g., CNY). The field for luggage type is "baggageType", the field for luggage weight is "weight", the field for weight unit is "weightUnit", the field for quantity is "quantity", the field for currency is "currency", the field for supply ID is "supplierId" (e.g., supplier1), the field for the departure location is "origin" (e.g., SHA), and the field for the arrival location is "destination" (e.g., DMK). The second data structure is used to store price data from different supply sources (such as supply sources and the independent price library), and each supply source will contain price information for multiple ancillary products.

[0044] Specifically, the process of obtaining and storing data in the independent price library is as follows: The timed scheduling mechanism periodically initiates data acquisition requests to ensure real-time data updates; obtain ancillary data, and the sources of ancillary data include airline official websites, high-quality ancillary supplier APIs, and self-operated account interfaces; data cleaning, excluding abnormal data such as missing prices, luggage information, or airport data; support manual import for data that cannot be automatically obtained. After the user manually uploads the data, the system performs unified processing; perform structured processing on the obtained ancillary data, and finally convert it into the data structure (the first data structure) of the independent price library price; write the structured data into the independent price library and use a relational database (such as MySQL) for storage to ensure data persistence and efficient query.

[0045] Specifically, the multi-source integration process is to integrate the independent price library with third-party real-time data sources to uniformly form a standardized data structure (the second data structure) and return the optimal ancillary price according to user needs. The specific process is as follows: The user initiates an ancillary price acquisition request; obtain the distribution rules in the operation configuration; according to the distribution rules, obtain ancillary data from different supply sources and the independent price library; merge the independent price library and multi-source price data, and finally generate data according to the multi-source integration data structure; select the optimal price (such as the lowest price) according to the preset rules; return the processed ancillary price information to the user.

[0046] It should be understood that by constructing a first data structure for the aviation business, which is used to store the first price information of the independent price library, and constructing a second data structure for multi-source integration, which is used to store the price data of different supply sources, and each supply source includes the second price information of multiple auxiliary products, the optimal auxiliary price information of the auxiliary products in the aviation business is determined based on the first price information and the second price information, solving the problems of data integration, price management and call efficiency in the reservation of auxiliary products, improving the work efficiency of auxiliary product processing, and also enhancing the user experience.

[0047] Refer to Figure 2 , the present invention also provides an auxiliary product processing system based on multi-supply sources and an independent price library, which is applied to the above-mentioned auxiliary product processing method based on multi-supply sources and an independent price library, and includes:

[0048] A first data structure construction unit, configured to construct a first data structure for the aviation business, and the first data structure is used to store the first price information of the independent price library;

[0049] A second data structure construction unit, which constructs a second data structure for multi-source integration, and the second data structure is used to store the price data of different supply sources, and each supply source includes the second price information of multiple auxiliary products, wherein the supply source and the independent price library form a multi-supply source;

[0050] An optimal auxiliary price determination unit, which determines the optimal auxiliary price information of the auxiliary products in the aviation business based on the first price information and the second price information.

[0051] In all the examples shown and described here, any specific value should be construed as merely exemplary and not as a limitation. Therefore, other examples of the exemplary embodiments may have different values.

[0052] It should be noted that like reference numerals and letters denote like items in the following figures. Therefore, once an item is defined in one figure, it does not need to be further defined and explained in subsequent figures.

[0053] The above-described embodiments merely represent several implementation manners of the present invention, and their descriptions are relatively specific and detailed, but should not be construed as limiting the scope of the present invention. It should be pointed out that for those of ordinary skill in the art, without departing from the concept of the present invention, several modifications and improvements can still be made, and these all belong to the protection scope of the present invention.

Claims

1. A method for processing auxiliary products based on multiple supply sources and an autonomous price library, characterized in that It includes the following steps: Construct a first data structure for the aviation business, which is used to store the first price information of the independent price library; Construct a second data structure for multi-source integration, which is used to store the price data of different suppliers. Each supplier includes the second price information of multiple secondary products. Among them, the supplier and the independent price library form a multi-source; Determine the optimal secondary product price information of the aviation business based on the first price information and the second price information.

2. The secondary product processing method based on multiple supply sources and an autonomous price library according to claim 1, wherein The first data structure is used to store the first price information of the independent price library, including: Respond to the data acquisition request regularly initiated by the timing scheduling mechanism, and perform real-time data update according to the data acquisition request; Obtain the secondary data of the aviation business, where the secondary data includes at least one of the airline company's official website, high-quality secondary product supplier API, or self-operated account interface; Clean the secondary data to exclude abnormal data in the secondary data; Perform structured processing on the secondary data after data cleaning to obtain the first data structure of the independent price library.

3. The method for processing auxiliary products based on multiple supply sources and an autonomous price library according to claim 2, wherein It also includes: Write the first price information corresponding to the first data structure into the independent price library and store it using a relational database.

4. The secondary product processing method based on multiple supply sources and an autonomous price library according to claim 2, characterized in that The abnormal data includes at least one of missing price, baggage information, or airport data.

5. According to the method for processing secondary products based on multi-source and independent price library described in claim 1, construct a second data structure for multi-source integration, which is used to store the price data of different suppliers, including: Respond to the secondary product price acquisition request initiated by the user; Obtain the distribution rules in the operation configuration; Obtain price data from multiple suppliers and the independent price library according to the distribution rules; Merge the price data of the independent price library and the multi-source, and generate the second price information according to the second data structure of the multi-source.

6. According to the method for processing secondary products based on multi-source and independent price library described in claim 5, it also includes: Select the optimal price from the second price information according to the preset rules to obtain the secondary product price information; Return the processed secondary product price information to the user.

7. According to the method for processing secondary products based on multi-source and independent price library described in claim 1, the first data structure includes at least one of airline company, departure type, departure place, departure date, destination type, destination, cabin class, baggage type, weight, weight unit, quantity, currency, price, source, or sales stage.

8. According to the method for processing secondary products based on multi-source and independent price library described in claim 1, the second data structure includes at least one of secondary product type, secondary product information, baggage type, baggage weight, weight unit, quantity, price, currency, supply ID, departure place, or arrival place.

9. A secondary product processing system based on multiple supply sources and an independent price library, characterized in that, Applied to the method for processing secondary products based on multi-source and independent price library described in any one of claims 1-4, it includes: A first data structure construction unit for constructing a first data structure for the aviation business, which is used to store the first price information of the independent price library; The second data structure construction unit constructs a second data structure for integrating multiple supply sources, and the second data structure is used to store price data of different supply sources. Each supply source includes second price information of multiple secondary products. Among them, the supply source and the independent price database form multiple supply sources; The optimal secondary product price determination unit determines the optimal secondary product price information of the aviation business based on the first price information and the second price information.

Images