Airline passenger data processing method and device, electronic equipment and storage medium

Abstract

The invention discloses an airline passenger data processing method and device, electronic equipment and a storage medium. The method comprises the following steps: acquiring flight travel information of passengers; data aggregation is carried out on the flight trip information to obtain flight intermediate data, field information of the flight intermediate data at least comprises a transit flight pair, and the transit flight pair is used for representing a data pair composed of front-section flight information and rear-section flight information for flight transit of passengers; and in response to received query demand information for querying flight transfer by the user, performing data query on the flight intermediate data based on the query demand information to obtain a transfer information query result. According to the method and the device, the technical problem of relatively low processing efficiency of the passenger data of the airline in related technologies is solved.

Description

Technical Field

[0001] The present invention relates to the field of airline data processing, and in particular to an airline passenger data processing method, device, electronic device and storage medium. Background Art

[0002] With the gradual development of inter-airline transfer business in civil aviation, the transfer passenger service platform needs to create early, accurate, flexible and effective transfer guarantee information for basic transfer services. Nowadays, the gap in statistical data in various fields and angles is gradually increasing, and business departments need to frequently query different statistical data from various dimensions, such as the number of transfers, the number of check-ins at one time, the number of luggage directly hung, and other indicators according to airports, routes, regions, airlines, etc. Therefore, when the transfer platform conducts statistics on data such as the number of transfers, it often faces a large statistical caliber, a large time span, and multiple calculation dimensions, resulting in a large total amount of data involved in the query, which significantly increases the pressure on database query and aggregation calculations, and the server performance reaches a bottleneck, and the entire statistical operation speed is slow.

[0003] Based on the above scenario, the query and processing of airline passenger data in the related technology usually requires these time-consuming statistical calculations to be performed at night when there are fewer query operations, or it is necessary to build a more expensive big data processing platform and use larger storage and computing nodes. The upgrade and transformation is more complicated and costly, resulting in low efficiency in processing airline passenger data in the related technology.

[0004] To address the above-mentioned problems, no effective solution has been proposed yet. Summary of the invention

[0005] The embodiments of the present invention provide a method, device, electronic device and storage medium for processing passenger data of an airline company, so as to at least solve the technical problem of low efficiency in processing passenger data of an airline company in the related art.

[0006] According to one aspect of an embodiment of the present application, a passenger data processing method for an airline is provided, comprising: obtaining flight itinerary information of a passenger; performing data aggregation on the flight itinerary information to obtain intermediate flight data, wherein the field information of the intermediate flight data at least includes a transfer flight pair, and the transfer flight pair is used to represent a data pair consisting of a front-end flight information and a rear-end flight information of a passenger's flight transfer; in response to receiving query demand information from a user regarding flight transfers, performing a data query on the intermediate flight data based on the query demand information to obtain a transfer information query result.

[0007] Optionally, data aggregation is performed on the flight itinerary information to obtain intermediate flight data, including: filtering the flight itinerary information to obtain transfer flight information, wherein the transfer flight information is used to indicate information on flight transfers in the flight itinerary information; and data aggregation is performed on the transfer flight information to obtain intermediate flight data.

[0008] Optionally, the flight itinerary information is filtered to obtain the connecting flight information, including: obtaining the passenger identification information, airport information and time information in the flight itinerary information; determining the flight related information based on the passenger identification information, airport information and time information; based on the flight related information, filtering the flight itinerary information to obtain the connecting flight information.

[0009] Optionally, data aggregation is performed on the transfer flight information to obtain intermediate flight data, including: obtaining the front flight number, the front flight schedule information, the rear flight number and the rear flight schedule information in the transfer flight information; composing the front flight information based on the front flight number and the front flight schedule information, and composing the rear flight information based on the rear flight number and the rear flight schedule information; constructing a transfer flight pair based on the front flight information and the rear flight information; and based on the transfer flight pair, performing data aggregation on the transfer flight information to obtain intermediate flight data.

[0010] Optionally, in response to receiving query demand information from a user regarding flight transfers, a data query is performed on the flight intermediate data based on the query demand information to obtain a transfer information query result, including: constructing a transfer query instruction based on the query demand information and the transfer flight pair; and based on the transfer query instruction, performing a data query on the flight intermediate data to obtain a transfer information query result.

[0011] Optionally, the method also includes: in the event that the flight itinerary information changes, updating the flight intermediate data based on the changed flight itinerary information to obtain updated flight intermediate data; in response to receiving query demand information, performing a data query on the updated flight intermediate data based on the query demand information to obtain a transit information query result.

[0012] According to another aspect of an embodiment of the present invention, there is also provided a passenger data processing device of an airline, comprising: an acquisition module for acquiring flight itinerary information of a passenger; an aggregation module for performing data aggregation on the flight itinerary information to obtain intermediate flight data, wherein the field information of the intermediate flight data at least includes a transfer flight pair, and the transfer flight pair is used to represent a data pair consisting of the front flight information and the rear flight information of a passenger's flight transfer; a query module for performing data query on the intermediate flight data based on the query demand information in response to receiving query demand information from a user on a flight transfer, and obtaining a transfer information query result.

[0013] According to another aspect of an embodiment of the present invention, there is further provided an electronic device, comprising: a memory storing an executable program; and a processor for running the program, wherein the method in each embodiment of the present invention is executed when the program is running.

[0014] According to another aspect of an embodiment of the present invention, a computer-readable storage medium is provided. The computer-readable storage medium includes a stored executable program, wherein when the executable program is running, the device where the computer-readable storage medium is located is controlled to execute the methods in various embodiments of the present invention.

[0015] According to another aspect of an embodiment of the present invention, a computer program product is provided, including a computer program. When the computer program is executed by a processor, the method in each embodiment of the present invention is implemented.

[0016] According to another aspect of an embodiment of the present invention, a computer program product is provided, including a non-volatile computer-readable storage medium, wherein the non-volatile computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method in each embodiment of the present invention is implemented.

[0017] According to another aspect of the embodiments of the present invention, a computer program is further provided. When the computer program is executed by a processor, the methods in the embodiments of the present invention are implemented.

[0018] In an embodiment of the present invention, a passenger data processing method of an airline is provided, comprising: obtaining flight itinerary information of a passenger; aggregating the flight itinerary information to obtain intermediate flight data, wherein the field information of the intermediate flight data at least includes a transfer flight pair, and the transfer flight pair is used to represent a data pair consisting of the front flight information and the back flight information of the passenger's flight transfer; in response to receiving a query demand information of a user querying flight transfer, querying the intermediate flight data based on the query demand information to obtain a transfer information query result. It is easy to notice that the present application can update the data of the transfer flight pair immediately when the passenger data is updated by aggregating the flight itinerary information in advance, avoiding a large amount of data calculation when querying, and reducing the calculation pressure of the system. By aggregating the intermediate flight data, the original data can be compressed into the intermediate flight data, thereby reducing the amount of data to be processed each time the query is made, and improving the query efficiency. By aggregating the data in advance and updating it in real time, the real-time nature of the statistical data can be guaranteed, and at the same time, when the query demand arises, the query result of the transfer information can be directly queried to meet the needs of real-time calculation and query. Thus, the technical problem of low efficiency in processing the passenger data of the airline in the related art is solved. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] The drawings described herein are used to provide a further understanding of the present invention and constitute a part of this application. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the drawings:

[0020] Figure 1 is a flow chart of a passenger data processing method of an airline according to an embodiment of the present invention;

[0021] Figure 2 is a schematic diagram of data changes during an optional passenger data processing process of an airline according to an embodiment of the present invention;

[0022] Figure 3 is a schematic diagram of a passenger data processing device of an airline according to an embodiment of the present invention. DETAILED DESCRIPTION

[0023] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.

[0024] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0025] According to an embodiment of the present invention, an embodiment of a passenger data processing method of an airline is provided. It can be explained that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0026] Figure 1 is a flow chart of a passenger data processing method of an airline according to an embodiment of the present invention. Figure 1As shown, the method comprises the following steps:

[0027] Step S102, obtaining the passenger's flight itinerary information.

[0028] In an optional embodiment, the airline company can obtain the flight itinerary information of the passenger through various channels. Specifically, through the airline company's reservation system or online ticket booking platform, when the passenger completes the ticket booking and generates the ticket, the system can automatically generate order data containing the flight itinerary information. It is also possible to monitor the real-time take-off and landing of the flight through the flight information system to obtain the actual flight itinerary information of the passenger. It is also possible to obtain the boarding information of the passenger through the airport check-in system, the boarding gate scanning system, etc. The obtained flight itinerary information may include the basic information of the passenger, such as name, ID number; flight information, such as flight number, cabin, take-off and landing time, take-off and landing location; and luggage information, etc. This information can be obtained and sorted by automatic system capture or manual entry. In the process of obtaining the flight itinerary information, the obtained information can be checked and processed by data verification and cleaning to ensure the consistency and correctness of the data. Through the above implementation process, the flight itinerary information of the passenger can be effectively obtained, which provides basic data support for subsequent data processing and query. Obtaining flight itinerary information through various channels can ensure the comprehensiveness and integrity of the data, reduce data missing and errors, and improve data quality. Integrating and uniformly managing flight itinerary information obtained from different channels can achieve data integration and facilitate subsequent data processing and analysis.

[0029] Step S104, performing data aggregation on the flight itinerary information to obtain the intermediate flight data.

[0030] The field information of the intermediate flight data at least includes a transfer flight pair, and the transfer flight pair is used to represent a data pair consisting of the preceding flight information and the succeeding flight information of the passenger's flight transfer.

[0031] In an optional embodiment, the acquired flight itinerary information can first be cleaned and preprocessed, including removing duplicate data, processing missing data, format normalization, etc., to ensure the accuracy and consistency of the data. And according to the passenger's flight itinerary information, the relevant flights can be matched and combined to form a data structure of transfer flight pairs. The transfer flight pair can be a data pair consisting of the front flight information and the back flight information when the passenger transfers, which is used to represent the passenger's transfer itinerary. In this data structure, each transfer flight pair can contain relevant information of the two flights, such as flight number, take-off and landing time, take-off and landing location, etc. Then, the formed transfer flight pair data can be associated and integrated with other relevant information of the passenger, such as name, ID number, and luggage information, to construct a complete flight intermediate data set. In the process of data aggregation, data processing tools or programming languages ​​can be used for automated processing, and by writing corresponding algorithms and logic, flight intermediate data can be generated quickly and accurately. In the above process, by aggregating the flight itinerary information to obtain flight intermediate data containing transfer flight pair information, the association and combination between different flights can be realized, providing more dimensional data support for subsequent analysis and query. By constructing intermediate flight data containing various statistical indicators, various statistical analyses can be easily performed, such as statistics on the number of transfer flights and distribution analysis of transfer time.

[0032] Step S106, in response to receiving the query demand information of the user for querying the flight transfer, a data query is performed on the flight intermediate data based on the query demand information to obtain the transfer information query result.

[0033] In an optional embodiment, when the system receives the query demand information of the user, the system can first parse and verify the query demand information to ensure the legitimacy and accuracy of the query demand. The query demand information may include relevant information such as the take-off and landing time, transfer location, flight number, etc. of the transfer flight. Then, the system can perform data query based on the pre-aggregated flight intermediate data according to the user's query demand information. The system can filter out the transfer flight pair data that meets the conditions according to the conditions in the query demand, and extract the corresponding information for return. During the data query process, the system can use the database query language or a custom query algorithm to retrieve and filter the flight intermediate data to obtain the transfer information query result that meets the user's query requirements. After obtaining the transfer information query result, the system can organize and format the result and then return it to the user. The query result may include specific information of the transfer flight pair, such as transfer time, transfer location, transfer flight number, etc., to meet the user's query requirements for flight transfer. In the above process, through the pre-aggregated flight intermediate data, the system can quickly perform data query operations, reduce query time, improve system response speed, and improve query efficiency. By collating and formatting the query results, the system can present the transfer information query results to users in an intuitive manner, such as tables, charts, etc., to improve user experience and data visualization. Through reasonable implementation and optimization, the system query efficiency and accuracy can be improved, providing airlines with better data support and decision-making basis.

[0034] In an embodiment of the present invention, a passenger data processing method of an airline is provided, comprising: obtaining flight itinerary information of a passenger; aggregating the flight itinerary information to obtain intermediate flight data, wherein the field information of the intermediate flight data at least includes a transfer flight pair, and the transfer flight pair is used to represent a data pair consisting of the front flight information and the back flight information of the passenger's flight transfer; in response to receiving a query demand information of a user querying flight transfer, querying the intermediate flight data based on the query demand information to obtain a transfer information query result. It is easy to notice that the present application can update the data of the transfer flight pair immediately when the passenger data is updated by aggregating the flight itinerary information in advance, avoiding a large amount of data calculation when querying, and reducing the calculation pressure of the system. By aggregating the intermediate flight data, the original data can be compressed into the intermediate flight data, thereby reducing the amount of data to be processed each time the query is made, and improving the query efficiency. By aggregating the data in advance and updating it in real time, the real-time nature of the statistical data can be guaranteed, and at the same time, when the query demand arises, the query result of the transfer information can be directly queried to meet the needs of real-time calculation and query. Thus, the technical problem of low efficiency in processing the passenger data of the airline in the related art is solved.

[0035] Optionally, data aggregation is performed on the flight itinerary information to obtain intermediate flight data, including: filtering the flight itinerary information to obtain transfer flight information, wherein the transfer flight information is used to indicate information on flight transfers in the flight itinerary information; and data aggregation is performed on the transfer flight information to obtain intermediate flight data.

[0036] In an optional embodiment, data aggregation of flight itinerary information may include screening the flight itinerary information to obtain transfer flight information, and then data aggregation of the transfer flight information to finally obtain flight intermediate data. Specifically, first, the flight itinerary information may be screened to obtain transfer flight information, and the take-off and landing time, flight number, flight company and other information of the flight may be matched and compared to determine which flights are transfer flights, so that flights that require passengers to transfer at a certain airport may be screened out. Then, data aggregation of the transfer flight information may be performed to obtain flight intermediate data, and different transfer flight information may be integrated together. In the above process, by screening the flight itinerary information and retaining only the transfer flight information, the amount of data may be reduced and the efficiency of data processing may be improved. The flight intermediate data finally obtained may be used to provide more personalized and optimized services and provide passengers with a better user experience. By data aggregation of transfer flight information, the needs of users may be better understood, more accurate recommendations and suggestions may be provided to users, user satisfaction may be improved, and data processing efficiency may be improved, data processing may be refined, and system performance may be improved.

[0037] Optionally, the flight itinerary information is filtered to obtain the connecting flight information, including: obtaining the passenger identification information, airport information and time information in the flight itinerary information; determining the flight related information based on the passenger identification information, airport information and time information; based on the flight related information, filtering the flight itinerary information to obtain the connecting flight information.

[0038] In an optional embodiment, the passenger identification information, airport information and time information in the flight itinerary information can be obtained, and the passenger identification information in the flight itinerary information, such as name, ID number, etc., can be obtained from the airline's database or other data sources; airport information, departure airport, arrival airport, and time information, take-off time, arrival time. Then, according to the passenger's identification information, airport information and time information, the association information between flights can be determined. For example, if the departure airport and arrival airport of two flights are the same, there is a reasonable time interval between the departure time and the arrival time, and they belong to the flight itinerary of the same passenger, then these two flights can be determined as the transfer flights of the passenger. Finally, based on the flight association information, the flight itinerary information can be screened to obtain the transfer flight information that meets the conditions. This information may include the flight number, departure airport, arrival airport, transfer time, etc. of the transfer flight. The specific implementation of the above steps can be achieved with the help of data processing tools and programming languages, such as using database query statements to query and filter the flight itinerary information in the database, or using programming languages ​​for data processing and analysis. In the above process, by aggregating flight itinerary information into the dimension of transfer flight information, the passenger data originally scattered on each flight can be aggregated, reducing the number of repeated queries and the amount of data. This can improve the efficiency and speed of data processing, while also reducing the burden on the system, improving the performance and stability of the system, making it easier to perform secondary aggregation and analysis, and obtaining more accurate and comprehensive statistical results, providing airlines with more targeted data support and decision-making references.

[0039] Optionally, data aggregation is performed on the transfer flight information to obtain intermediate flight data, including: obtaining the front flight number, the front flight schedule information, the rear flight number and the rear flight schedule information in the transfer flight information; composing the front flight information based on the front flight number and the front flight schedule information, and composing the rear flight information based on the rear flight number and the rear flight schedule information; constructing a transfer flight pair based on the front flight information and the rear flight information; and based on the transfer flight pair, performing data aggregation on the transfer flight information to obtain intermediate flight data.

[0040] In an optional embodiment, the front flight number, front flight time information, rear flight number and rear flight time information in the transfer flight information can be obtained, and the relevant information of the transfer flight, including the flight number and time information of the front flight and the rear flight, can be obtained from the airline's database. Based on the obtained front flight number and front flight time information, the front flight information is composed; based on the obtained rear flight number and rear flight time information, the rear flight information is composed; and the front flight information and the rear flight information can be combined to construct a transfer flight pair. Finally, the transfer flight pair can be aggregated to obtain the intermediate data of the flight. This intermediate data may include information such as the number of transfer flight pairs, the number of passengers, and the average travel time. In the above process, by aggregating passenger data into the dimension of transfer flight pairs, the amount of data to be processed can be reduced and the efficiency of data processing can be improved. At the same time, through the intermediate statistical results at the transfer flight pair level, secondary aggregation can be more convenient to obtain the statistical caliber actually required.

[0041] Optionally, in response to receiving query demand information from a user regarding flight transfers, a data query is performed on the flight intermediate data based on the query demand information to obtain a transfer information query result, including: constructing a transfer query instruction based on the query demand information and the transfer flight pair; and based on the transfer query instruction, performing a data query on the flight intermediate data to obtain a transfer information query result.

[0042] In an optional embodiment, the system can receive the user's query demand information, including the departure place, destination, departure time, arrival time and other information. This information will be used as the basis for the query to screen the transfer flights that meet the user's needs. Then, based on the user's query demand information and the transfer flight pair, the system can construct a transfer query instruction. The transfer query instruction includes information such as the departure place, destination, transfer location, transfer time, etc., which is used to screen the transfer flights that meet the conditions in the flight intermediate data. The system can perform data query in the flight intermediate data based on the constructed transfer query instruction. This includes querying the flight's take-off and landing time, flight number, aircraft model, stopover location and other information, so as to find the transfer flight that meets the user's needs. Through data query, the system can obtain the transfer information query results that meet the user's needs. These results will include a list of transfer flights that meet the conditions, as well as detailed information such as relevant flight information and transfer time. In the above process, by constructing the transfer query instruction, the system can accurately screen according to the specific needs of the user, reduce unnecessary data queries, and improve query efficiency. At the same time, by querying the intermediate data of flights, the intermediate statistical results of the transfer flight pair level can be aggregated to the actual statistical caliber, thereby reducing the amount of data for one-time query and improving data processing efficiency. By optimizing the data query process, the system load pressure can be reduced, the system stability and performance can be improved, and better support and guarantee can be provided for the data processing work of airlines.

[0043] Optionally, the method also includes: in the event that the flight itinerary information changes, updating the flight intermediate data based on the changed flight itinerary information to obtain updated flight intermediate data; in response to receiving query demand information, performing a data query on the updated flight intermediate data based on the query demand information to obtain a transit information query result.

[0044] In an optional embodiment, during the passenger data processing of the airline, when the flight itinerary information changes, the flight intermediate data can be updated. Specifically, when the flight itinerary information changes, the system can receive these change information, including flight number, take-off and landing time, flight status, etc. Based on the changed flight itinerary information, the system can update the flight intermediate data. It can include updating the take-off and landing time, status and other information of the flight to ensure the accuracy of the data. When the system receives query demand information, including the take-off and landing time, flight number and other information of the transfer flight. Based on the updated flight intermediate data, the system can perform data query to obtain the transfer information query result. This includes calculating various common statistical items of transfer passengers and luggage, such as the number of transfer passengers, luggage transfer time, etc. In the above process, by distributing the calculation pressure of statistical data to each time the passenger data is updated, the pressure caused by a one-time large amount of data query can be avoided. This can better control the load of the system and improve the performance and stability of the system. By updating the flight intermediate data in real time, the amount of subsequent one-time query data can be reduced, and the time and resource consumption of data query can be reduced. This will help improve the efficiency and accuracy of queries, allowing airlines to promptly understand the status of transfer passengers and baggage, make corresponding adjustments and decisions, improve service quality and efficiency, and provide airlines with more accurate and timely data support.

[0045] The relational database in this application may refer to a database system that uses a relational model to store organizational data in the form of row and column data. Structured Query Language (SQL) may be a standardized programming language for managing and operating relational databases. Composite index may refer to an indexing technology in a relational database that is composed of multiple column fields. Data aggregation may refer to the process of merging scattered data points or data sets into a more meaningful data set with a unified structure. Through this process, complex data can be simplified into a form that is easier to understand and analyze. This process usually merges multiple data points or data sets into a larger, more comprehensive whole, or condenses and simplifies a large data set into a data set with more classification characteristics, so as to better understand the overall characteristics, trends and patterns of the data.

[0046] The intermediate data in this application may refer to the data that needs to be carried out in stages in some complex statistical analyses. The analysis results of each stage may be used as input or reference for subsequent analysis, and these stage analysis results can be regarded as intermediate data. A transfer flight pair may refer to a combination of inbound and outbound flight itinerary information of several transfer passengers at a transfer airport in the civil aviation transfer business, which may be the key intermediate data used in the performance optimization process of statistical analysis of civil aviation inter-airline transfer passenger data. Transfer passenger identification may refer to the technology of extracting and matching passengers with multiple itineraries and whose itineraries are related to each other through the basic itinerary data of passengers, and reorganizing these itinerary information into transfer itinerary information.

[0047] The technical solution proposed in this application is described below in combination with an optional embodiment. This application proposes a performance improvement method for statistical analysis of civil aviation inter-airline transfer passenger data based on intermediate data, and provides an optimized intermediate statistical calculation method. Various common statistical items of transfer passengers and baggage are first aggregated to the intermediate data dimension at the transfer flight pair level, and the calculation pressure is dispersed to each time the passenger data is updated, reducing the amount of one-time query data, making it possible to calculate and query statistical data in real time.

[0048] The aggregation function in this application can be a calculation method for quickly obtaining statistical data, which can summarize and analyze the data. When calculating statistical data on the transit passenger service guarantee platform, the data can be grouped according to the required statistical caliber to obtain statistical data such as the total number of passengers, the total number of luggage, and the number of people checking in at one time in a certain time period and airport. The performance of the aggregation function is mainly determined by the following aspects: data volume, grouping conditions, and the database's own configuration and hardware performance. In the case of the transit passenger service platform, the grouping conditions are determined by the query requirements, and the update of the hardware configuration is limited by actual resources. Therefore, it is possible to optimize from the perspective of reducing the total amount of data and improve the query performance.

[0049] When calculating the statistical results of transfer passengers, this application uses the aggregation dimension of transfer flight pairs as the key intermediate data. The specific method is: first aggregate the passenger data to the dimension of transfer flight pairs, and then aggregate the intermediate statistical results of the transfer flight pair level to the actual required statistical caliber, so as to achieve the purpose of reducing the amount of data for one-time query. The reason why this application uses the data set of the aggregation dimension of transfer flight pairs as the key intermediate data is that most common statistical results of querying transfer passengers mainly rely on the characteristics of the passenger's departure airport, transfer airport, destination airport, time, etc., and these characteristics are also located in a transfer flight pair structure. Therefore, the statistical data of the dimension of transfer flight pairs can maintain the same atomicity as the passenger data, and can also be based on the statistical results of transfer flight pairs. Aggregate to obtain route, city or national statistical data, is a relatively stable and flexible intermediate result, its stability is reflected in the fact that the intermediate results will not change due to changes in the query target; its flexibility is reflected in that it can be further aggregated to various query targets based on this intermediate result.

[0050] The calculation of the intermediate results of the transfer flight pairs is also an operation with large data volume, large calculation volume, and high resource consumption. However, since the data of the transfer flight pairs is atomic, this large-scale and complex calculation can be decomposed into small-scale calculations for each step of passenger storage. As shown in the following flowchart, every time a passenger books a ticket to form a transfer passenger, a count is added to the corresponding transfer flight pair count; every time a passenger refunds a ticket and the passenger is no longer a transfer passenger, a count is reduced from the corresponding transfer flight pair count. After the transfer passenger identification, when the transfer passenger is obtained, the intermediate aggregation result of the transfer flight pair is also obtained. By transferring the calculation process of the first aggregation to the transfer passenger identification, the total calculation volume when querying statistical data is reduced, and the calculation pressure is dispersed by peak shaving. Compared with the one-time calculation of statistical results, the total data volume of the flight pair statistical results based on the second aggregation is much smaller than the total data volume of passenger data used in the one-time calculation, which reduces the algorithm complexity of the overall calculation process, thereby improving the performance of statistical queries and making it possible to calculate statistical results in real time.

[0051] Since the step of accumulating transfer flight pair data has flight information as a fixed query condition, by establishing a combined index of two pieces of flight information, the relational database can avoid additional sorting overhead when performing aggregate function operations, and also reduce the disk space occupied by the index. At the same time, because the transfer passenger identification calculation has the characteristic of high-frequency writing, the transfer flight pairs will have the same update frequency as the transfer passengers. The use of combined index technology can also significantly reduce the overhead of updating and maintaining the index, further improving the overall performance.

[0052] The existing transfer passenger data table mainly contains the basic information of transfer passengers, such as name, ticket number, etc., flight information of the previous and next two segments, flight number, flight date, etc.; airport information, departure airport, transfer airport, arrival airport; baggage information, baggage strip number, baggage through check-in; one-time check-in, handling type and other identification information. Since each transfer passenger's itinerary contains information about two flights, the two flight information of the passenger is extracted as the first aggregation field, and grouped statistics are performed according to the basic information of the flight to obtain the statistical data at the transfer flight pair level. First, according to the basic information of the flight pair of the transfer passenger, that is, the previous flight number, the previous flight date, the next flight number, the next flight date, the departure airport, the transfer airport, and the arrival airport are atomic identifiers, and the corresponding transfer flight pair intermediate result table is established. Therefore, after the first aggregation, the transfer flight pair intermediate result table can be obtained.

[0053] Since the data itself maintains atomicity, there is no need to frequently change the data structure. Different data statistical needs can be met based on the intermediate result table. For example, when we need to count the number of transfer passengers from Harbin (HRB) to Sanya (SYX) via any airport in 2023, if there is no intermediate result table for transfer flight pairs, the SQL query statement executed directly is as follows: select count(*)from transfer passenger table where flight date>='2023-01-01'and flight date<='2023-12-30'and departure airport='HRB'and arrival airport='SYX'; After adding the intermediate result table for transfer flight pairs, the SQL query statement executed is as follows: select sum(number of transfer passengers) from transfer flight table where flight date >= '2023-01-01' and flight date <= '2023-12-30' and departure airport = 'HRB' and arrival airport = 'SYX'; By comparing the two executed SQL statements, it can be found that the actual content that needs to be changed is limited, and the amount of code that needs to be modified for the system that actually executes the query is very small, but the data statistical range of the two is reduced from the number of passengers to the number of flights, reducing tens of millions or even hundreds of millions of data to millions, which not only avoids the high cost of large-scale updates and upgrades, but also significantly reduces the statistical caliber and breaks through the performance bottleneck.

[0054] At the same time, according to the frequency of actual statistical data needs, corresponding indexes can be created for commonly used statistical calibers to further improve query performance. For example, in actual work, a large number of statistical needs are found: statistics on the number of transfer passengers who transfer at a certain airport, the number of people who check in at one time, and other data. Then, according to this query condition, the following SQL statement is used to create a corresponding index in the transfer airport field. create index index name on transfer flight pair intermediate result table (transit airport); after adding this index, future queries with transfer airport as the dimension can use the database's own index function to avoid full data scanning. When querying the number of transfer passengers who transfer at a certain airport again, it is no longer necessary to scan the entire table of transfer flight pairs, but only the part of the transfer flight pair where the transfer airport is the airport. Through the database's own index mechanism, the query efficiency can be further optimized on the basis of this solution. Compared with indexing the full data of the transfer passenger table, not only the query performance is better, but also the disk space is saved.

[0055] The above steps solve the performance problem from the intermediate results of transfer flight pairs to the actual statistical data requirements, but calculating the intermediate results of transfer flight pairs is also a heavy calculation. If this intermediate result set is calculated based on the complete transfer passenger data, the data volume will return to the full transfer passenger data, which will cause the algorithm complexity to degenerate back to directly calculating the final result. Therefore, a solution is needed to circumvent this problem. Because transfer passengers have all the atomic characteristics of the intermediate results of transfer flight pairs, it is further possible to accumulate data immediately when identifying transfer passengers to skip the first aggregation and achieve a real overall reduction in algorithm complexity.

[0056] When a passenger booking event is received, if the passenger is identified as a transfer passenger, the flight pair information of the two flights of the transfer passenger with the corresponding key value is searched. If it does not exist, a new flight pair is created and counted according to the passenger characteristics; if it already exists, the count is directly increased according to the passenger characteristics. Correspondingly, if the transfer identification process no longer considers the passenger as a transfer passenger due to a ticket refund, the passenger count of the corresponding characteristics is subtracted from the flight pair.

[0057] For example, a passenger named Zhang San has booked flight CA2961 from Zhangjiajie to Changsha on November 6. At this time, the passenger only has a single flight itinerary and has not yet become a transfer passenger, so he does not involve transfer business. Then the passenger also booked flight MU7483 from Changsha to Beijing Capital on November 6. At this time, the two itineraries can constitute a transfer passenger, so the passenger data is saved in the transfer passenger table. At the same time, check whether there is a flight pair information of CA2961 on November 6 to MU7483 on November 6 in the intermediate table of transfer flights. If there is, the transfer passenger count of the flight pair is increased by one, and the other statistical items are calculated based on whether the passenger is a one-time check-in passenger and whether the baggage is checked through. Similarly, if passenger Zhang San has booked flight CA2961 from Zhangjiajie to Changsha on November 6, and flight MU7483 from Changsha to Beijing Capital on November 6, then the passenger has become a transfer passenger. When the passenger refunds one of the flight itineraries, the passenger is no longer a transfer passenger. Therefore, it is necessary to delete the passenger itinerary data in the transfer passenger table, and query the intermediate result table of transfer flight pairs to reduce the transfer passenger count on the flight pair information of November 6 CA2961 to November 6 MU7483 by one. If the number of transfer passengers on the flight pair has reached zero, the second half of the transfer pair can be directly removed to skip subsequent calculations; if it has not yet reached zero, calculate other statistical items and decide whether to reduce the count by one based on the characteristic information of the passenger.

[0058] Through the above implementation, the complete process from the transfer passenger set to the transfer flight pair intermediate result set, and then to the actual statistical query result can be realized, and efficient complex statistical report calculation and processing can be realized at a low cost, solving the problem of slow and time-consuming statistical data query. This application uses the combined index of the relational database to achieve index coverage, avoid the additional sorting of SQL, reduce the cost of maintaining the index, and improve the query performance of SQL aggregation. Defining the transfer flight pair as the intermediate result of statistical aggregation storage avoids the repeated storage of various complex statistical results, improves the universality of the intermediate statistical results, ensures that the intermediate results can be applied to a variety of statistical reports, and reduces the repetitive process. Through the above technical solution, a performance basis is provided for the statistical analysis of the transfer passenger service platform, making real-time transfer passenger data statistical processing possible, improving the statistical performance, avoiding the long waiting time of users when querying statistical results, and improving the overall real-time and smoothness of the transfer business guarantee. The intermediate data aggregation dimension selected in this application is set as the transfer flight pair, which is selected for the data statistics needs of the civil aviation cross-airline transfer passenger business. In other technical solutions or applications, different types of intermediate data aggregation dimensions may also exist, which are not limited here.

[0059] Figure 2FIG. 1 is a schematic diagram of data changes during passenger data processing of an optional airline according to an embodiment of the present invention. Figure 2 As shown, the flight itinerary information is aggregated to obtain the flight intermediate data, and the flight intermediate data is queried to obtain the transfer information query result.

[0060] According to another aspect of the embodiment of the present application, a passenger data processing device of an airline is also provided. The device can execute the passenger data processing method of the airline in the above embodiment. The specific implementation method and preferred application scenario are the same as those in the above embodiment and will not be repeated here.

[0061] Figure 3 is a schematic diagram of a passenger data processing device of an airline according to an embodiment of the present application, such as Figure 3 As shown, the device includes the following: an acquisition module 302 , an aggregation module 304 and a query module 306 .

[0062] Among them, the acquisition module is used to obtain the passenger's flight itinerary information; the aggregation module is used to aggregate the flight itinerary information to obtain the flight intermediate data, wherein the field information of the flight intermediate data at least includes a transfer flight pair, and the transfer flight pair is used to represent a data pair consisting of the front flight information and the back flight information of the passenger's flight transfer; the query module is used to respond to the query demand information received from the user for querying the flight transfer, and perform data query on the flight intermediate data based on the query demand information to obtain the transfer information query result.

[0063] Among them, the aggregation module is also used to filter the flight itinerary information to obtain the transfer flight information, wherein the transfer flight information is used to indicate the information of flight transfer in the flight itinerary information; the transfer flight information is aggregated to obtain the intermediate flight data.

[0064] Among them, the aggregation module is also used to obtain passenger identification information, airport information and time information in the flight itinerary information; determine the flight related information based on the passenger identification information, airport information and time information; based on the flight related information, filter the flight itinerary information to obtain the transfer flight information.

[0065] Among them, the aggregation module is also used to obtain the front flight number, front flight schedule information, rear flight number and rear flight schedule information in the transfer flight information; compose the front flight information based on the front flight number and the front flight schedule information, and compose the rear flight information based on the rear flight number and the rear flight schedule information; construct a transfer flight pair based on the front flight information and the rear flight information; based on the transfer flight pair, perform data aggregation on the transfer flight information to obtain flight intermediate data.

[0066] Among them, the query module is also used to construct a transfer query instruction based on the query demand information and the transfer flight pair; based on the transfer query instruction, the flight intermediate data is queried to obtain the transfer information query result.

[0067] Among them, the query module is also used to update the flight intermediate data based on the changed flight itinerary information to obtain updated flight intermediate data when the flight itinerary information changes; in response to receiving query demand information, perform data query on the updated flight intermediate data based on the query demand information to obtain transfer information query results.

[0068] An embodiment of the present application further provides an electronic device, comprising: a memory storing an executable program; and a processor for running the program, wherein the program executes the methods in various embodiments of the present invention when running.

[0069] The above-mentioned memory may refer to a device inside a computer for storing data and programs, and may include memory, hard disk, etc., wherein the memory may be used to temporarily store running programs and data, the hard disk may be used to store programs and data for a long time, and the memory may be used to enable the computer to read and write data, and execute programs; the above-mentioned processor may be responsible for executing instructions in computer programs and performing data processing, and may be responsible for controlling and executing various operations, including arithmetic operations, logical operations, data transmission, etc.

[0070] An embodiment of the present application further provides a computer-readable storage medium, which includes a stored executable program, wherein when the executable program is running, the device where the computer-readable storage medium is located is controlled to execute the methods in various embodiments of the present invention.

[0071] The above-mentioned computer storage medium may refer to a medium in a computer memory used to store certain discontinuous physical quantities. Computer storage media mainly include semiconductors, magnetic cores, magnetic drums, magnetic tapes, laser disks, etc.; the stored program included in the computer-readable storage medium may be a set of instructions that can be recognized and executed by a computer, running on an electronic computer, and is an information tool that meets certain needs of people.

[0072] An embodiment of the present application further provides a computer program product, including a computer program, which implements the methods in various embodiments of the present invention when executed by a processor.

[0073] The above-mentioned computer program product may refer to a software program that has been written, tested and released and can be run on a computer or other device. The computer program product may include an application, an operating system, tool software, etc., which is used to implement specific functions or solve specific problems.

[0074] An embodiment of the present application further provides a computer program product, including a non-volatile computer-readable storage medium, wherein the non-volatile computer-readable storage medium is used to store a computer program, and when the computer program is executed by a processor, the method in each embodiment of the present invention is implemented.

[0075] The above-mentioned non-volatile computer-readable storage medium may refer to a medium for storing data. The non-volatile computer-readable storage medium can keep the data from being lost when the power is off, and can be used to store long-term data, such as operating systems, applications, and user files. The non-volatile storage medium may include hard disk drives, solid-state drives, optical disks, and flash memory storage devices, etc.

[0076] The embodiments of the present application further provide a computer program, which implements the methods in the above-mentioned embodiments of the present invention when executed by a processor.

[0077] The above-mentioned computer program may refer to a collection of instructions used to tell a computer to perform a specific task or operation. A computer program may be written by a programmer using a specific programming language and may include algorithms, data structures, logic, and control flows. A computer program may be used for a variety of purposes, including application software, operating systems, and the like.

[0078] In the above embodiments of the present invention, the description of each embodiment has its own emphasis. For parts that are not described in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0079] In the several embodiments provided in this application, it should be understood that the disclosed technical content can be implemented in other ways. Among them, the device embodiments described above are only schematic. For example, the division of the units can be a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of units or modules, which can be electrical or other forms.

[0080] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple units. Some or all of the units may be selected according to actual needs to achieve the purpose of the present embodiment.

[0081] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0082] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, a server or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, magnetic disk or optical disk and other media that can store program codes.

[0083] The above is only a preferred embodiment of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principle of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.

Claims

1. A passenger data processing method for an airline company, characterized in that: include: Obtain passengers’ flight itinerary information; Aggregating the flight itinerary information to obtain intermediate flight data, wherein the field information of the intermediate flight data at least includes a transfer flight pair, and the transfer flight pair is used to represent a data pair consisting of the preceding flight information and the succeeding flight information of the flight transfer of the passenger; In response to receiving the query demand information of the user for querying the flight transfer, the flight intermediate data is queried based on the query demand information to obtain the transfer information query result.

2. The passenger data processing method of an airline according to claim 1, characterized in that: The flight itinerary information is aggregated to obtain intermediate flight data, including: Filtering the flight itinerary information to obtain transfer flight information, wherein the transfer flight information is used to indicate information about flight transfer in the flight itinerary information; The transfer flight information is aggregated to obtain the intermediate flight data.

3. The passenger data processing method of an airline according to claim 2, characterized in that: The flight itinerary information is screened to obtain transfer flight information, including: Obtaining passenger identification information, airport information and time information from the flight itinerary information; Determining flight-related information based on the passenger identification information, the airport information, and the time information; The flight itinerary information is screened based on the flight association information to obtain the connecting flight information.

4. The passenger data processing method of an airline according to claim 2, characterized in that: Aggregating the transfer flight information to obtain the intermediate flight data includes: Obtaining the preceding flight number, preceding flight schedule information, succeeding flight number and succeeding flight schedule information in the connecting flight information; The preceding flight information is formed based on the preceding flight number and the preceding flight time information, and the succeeding flight information is formed based on the succeeding flight number and the succeeding flight time information; constructing the transfer flight pair based on the preceding flight information and the succeeding flight information; Based on the transfer flight pairs, data aggregation is performed on the transfer flight information to obtain the flight intermediate data.

5. The passenger data processing method of an airline according to claim 1, characterized in that: In response to receiving the query demand information of the user for querying the flight transfer, the flight intermediate data is queried based on the query demand information to obtain the transfer information query result, including: Constructing a transfer query instruction based on the query demand information and the transfer flight pair; Based on the transfer query instruction, the intermediate data of the flight is queried to obtain the transfer information query result.

6. The passenger data processing method of an airline according to claim 1, characterized in that: The method further comprises: When the flight itinerary information is changed, the flight intermediate data is updated based on the changed flight itinerary information to obtain updated flight intermediate data; In response to receiving the query requirement information, a data query is performed on the updated flight intermediate data based on the query requirement information to obtain the transfer information query result.

7. A passenger data processing device for an airline company, characterized in that: include: The acquisition module is used to obtain the passenger's flight itinerary information; an aggregation module, configured to aggregate the flight itinerary information to obtain intermediate flight data, wherein the field information of the intermediate flight data at least includes a transfer flight pair, and the transfer flight pair is used to represent a data pair consisting of the preceding flight information and the succeeding flight information of the flight transfer of the passenger; The query module is used to respond to the query demand information received from the user for querying the flight transfer, perform data query on the flight intermediate data based on the query demand information, and obtain the transfer information query result.

8. An electronic device, characterized in that: include: A memory storing an executable program; A processor is used to run the program, wherein the program, when running, executes the airline passenger data processing method described in any one of claims 1 to 6.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium includes a stored executable program, wherein when the executable program is running, the device where the storage medium is located is controlled to execute the airline passenger data processing method described in any one of claims 1 to 6.

10. A computer program product, characterized in that It comprises a computer program, which, when executed by a processor, implements the passenger data processing method of an airline according to any one of claims 1 to 6.

Images