Flight information storage method and device and readable storage medium

Abstract

The invention discloses a flight information storage method and device and a readable storage medium. The method comprises the following steps: acquiring a query state of flight information; obtaining log data of the flight information in response to the query state being a query change state; on the basis of the log data, change data corresponding to the flight information is determined, and the change data is used for indicating that the flight information is modified; the change data is matched with historical flight data corresponding to flight information stored in a database to obtain a matching result, and the matching result is used for indicating the matching degree of the change data and the historical flight data; the change data is stored based on the matching result. The technical problem that flight information cannot be accurately stored is solved.

Description

Technical Field

[0001] The present invention relates to the technical field of electronic information storage, and in particular to a method, device and readable storage medium for storing flight information. Background Art

[0002] At present, the electronic ticket sales system is responsible for storing ticket sales information. When the user automatically refunds or changes the electronic ticket from the front end, the ticket automatic refund and change system will be called. The ticket automatic refund and change system needs to obtain the ticket face information from the electronic ticket management system, then call the electronic ticket sales system to obtain the ticket sales data, and then call the fare system to calculate the fee, and finally return the calculation result to the user. However, if there is no corresponding flight data in the ticket sales data, the automatic refund and change system will report an error "No query results for flight information", causing the system to be unable to complete the user's request.

[0003] In related technologies, when a user receives an error report, he or she submits a work order to the back-end technician through the online work order system. After receiving the work order, the back-end technician checks the message sent by the automatic refund and change system to the electronic ticket sales system, and then compares the database of the electronic ticket sales system to supplement the missing flights. The existing solution is prone to human errors through manual comparison and supplementary data, resulting in inaccurate flight information, which further affects subsequent operations. Therefore, there is a technical problem of being unable to accurately store flight information.

[0004] With respect to the above-mentioned technical problem of being unable to accurately store flight information, no effective solution has been proposed so far. Summary of the invention

[0005] The embodiments of the present invention provide a method, device and readable storage medium for storing flight information, so as to at least solve the technical problem that the flight information cannot be accurately stored.

[0006] According to one aspect of an embodiment of the present invention, a method for storing flight information is provided. The method may include: obtaining a query status of the flight information; in response to the query status being a query change status, obtaining log data of the flight information; determining change data corresponding to the flight information based on the log data, wherein the change data is used to indicate that the flight information has been modified; matching the change data with historical flight data corresponding to the flight information stored in a database to obtain a matching result, wherein the matching result is used to indicate the matching degree between the change data and the historical flight data; based on the matching result, storing the change data.

[0007] Optionally, in response to the query status being a query change status, obtaining log data of the flight information includes: in response to the query status being a query change status, extracting keywords from the flight information; and determining the log data based on the keywords.

[0008] Optionally, the method for storing flight information further includes: verifying and / or formatting the changed data to obtain the changed data corresponding to the verified and / or formatted flight information.

[0009] Optionally, based on the matching result, storing the changed data includes: in response to the matching result being that the changed data fails to match the historical flight data, verifying the changed data to obtain a verification result; in response to the verification result being that the verification passes, storing the changed data.

[0010] Optionally, the method for storing flight information further includes: in response to the verification result being verification failure, outputting the verification result.

[0011] Optionally, based on the matching result, storing the changed data includes: in response to the matching result being that the changed data successfully matches the historical flight data, converting the changed data into storage data; and storing the storage data in a database.

[0012] According to another aspect of an embodiment of the present invention, a device for storing flight information is also provided. The device may include: a first acquisition unit, used to acquire the query status of the flight information; a second acquisition unit, used to acquire the log data of the flight information in response to the query status being the query change status; a determination unit, used to determine the change data corresponding to the flight information based on the log data, wherein the change data is used to indicate that the flight information has been modified; a matching unit, used to match the change data with the historical flight data corresponding to the flight information stored in the database to obtain a matching result, wherein the matching result is used to indicate the matching degree between the change data and the historical flight data; and a storage unit, used to store the change data based on the matching result.

[0013] According to another aspect of an embodiment of the present invention, a computer-readable storage medium is further provided. The computer-readable storage medium includes a stored program, wherein when the program is executed by a processor, the device where the storage medium is located is controlled to execute the flight information storage method in the embodiment of the present invention.

[0014] According to another aspect of an embodiment of the present invention, a processor is further provided, wherein the processor is used to run a program, wherein when the program is run, the method for storing flight information in the embodiment of the present invention is executed.

[0015] According to another aspect of the embodiment of the present invention, a computer program product is provided, which includes computer instructions, and when the computer instructions are executed by a processor, the method for storing flight information in the embodiment of the present invention is implemented.

[0016] In an embodiment of the present invention, the query status of the flight information is obtained; in response to the query status being a query change status, the log data of the flight information is obtained; based on the log data, the change data corresponding to the flight information is determined, wherein the change data is used to indicate that the flight information has been modified; the change data is matched with the historical flight data corresponding to the flight information stored in the database to obtain a matching result, wherein the matching result is used to indicate the degree of matching between the change data and the historical flight data; based on the matching result, the change data is stored. That is to say, the embodiment of the present invention queries the flight information, and when the flight information changes, the change data is determined according to the log data corresponding to the flight system, thereby matching, verifying and storing the change data. Since the present invention can automatically complete the process of querying flight information, matching and storing change data, etc., it avoids the problem of erroneous storage caused by human intervention, thereby solving the technical problem of not being able to accurately store flight information, and achieving the technical effect of accurately storing flight information. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] 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:

[0018] Figure 1 is a flow chart of a method for storing flight information according to an embodiment of the present invention;

[0019] Figure 2 is a schematic diagram of an intelligent flight data completion system according to an embodiment of the present invention;

[0020] Figure 3 is a flow chart of a smart flight data completion method according to an embodiment of the present invention;

[0021] Figure 4 4 is a schematic diagram of a device for storing flight information according to an embodiment of the present invention. DETAILED DESCRIPTION

[0022] 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.

[0023] 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, functional component or device that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, functional components or devices.

[0024] According to an embodiment of the present invention, an embodiment of a method for storing flight information is provided. It should be noted 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.

[0025] Figure 1 is a flow chart of a method for storing flight information according to an embodiment of the present invention. Figure 1 As shown, the method may include the following steps:

[0026] Step S101, obtaining the query status of flight information.

[0027] In the technical solution provided in the above step S101 of the present invention, the flight information may also be referred to as flight data.

[0028] In this embodiment, the query status of flight information is obtained. For example, the query status of flight information is obtained through a business operation and maintenance platform, wherein the business operation and maintenance platform is a platform for executing flight information services. This is only an illustrative example, and does not limit the specific method for obtaining the query status of flight information.

[0029] Optionally, the flight information includes at least information such as the airline, flight number, flight start date, flight end date, weekly flight conditions, aircraft type, departure point, departure time, arrival point, arrival time, cabin layout, flight distance, etc.

[0030] For example, the flight information includes the ticket face information. Optionally, the ticket automatic refund and change system calls the electronic ticket management system to obtain the ticket face information.

[0031] Step S102, in response to the query status being a query change status, obtaining log data of flight information.

[0032] In the technical solution provided in the above step S102 of the present invention, the log data may also be referred to as log information.

[0033] In this embodiment, after the query status of the flight information is obtained in step S101, when the query status is a query change status, it means that the flight information has changed, based on which the log data of the flight information is obtained. For example, the log data is collected through the collection module, which is only an illustrative example and does not limit the specific method of obtaining the log data of the flight information.

[0034] For example, when an error occurs when calling the electronic ticket sales system to obtain ticket sales data: TRR-6126-70: stc flights error: No result of query {STC-FLIGHT error: No query result for flight information}, the business operation and maintenance platform obtains log data related to flight information through the collection module.

[0035] Step S103, determining the change data corresponding to the flight information based on the log data.

[0036] In the technical solution provided in the above step S103 of the present invention, the change data is used to indicate that the flight information is modified.

[0037] In this embodiment, after the log data of the flight information is obtained in step S102, the change data corresponding to the flight information is determined according to the log data. The change data may be information about the user's ticket change or refund, and the change data may also be referred to as missing flight information.

[0038] For example, after receiving the log information transmitted by the alarm module, the business operation and maintenance platform interacts with the flight inventory control system through API requests to obtain the missing flight information.

[0039] Step S104, matching the changed data with the historical flight data corresponding to the flight information stored in the database to obtain a matching result.

[0040] In the technical solution provided in the above step S104 of the present invention, the matching result can be used to indicate the matching degree between the change data and the historical flight data. The matching process can also be understood as a system verification process.

[0041] In this embodiment, after the change data corresponding to the flight information is determined in step S103, the change data is matched with the historical flight data corresponding to the flight information stored in the database to obtain a matching result.

[0042] Optionally, the changed data is matched with the historical flight data corresponding to the flight information stored in the database, so as to ensure that the changed data and the historical flight data corresponding to the stored flight information are data under the same flight information.

[0043] Step S105: storing the changed data based on the matching result.

[0044] In the technical solution provided in the above step S105 of the present invention, after the matching result is determined in step S104, the changed data is stored according to the matching result.

[0045] In this embodiment, the changed data is stored according to the matching result, wherein the matching result may also be referred to as the system verification result.

[0046] For example, if the changed data matches the historical flight data, the changed data will be sent to the formatting module. If the match fails, the EDS flight supplementary recording tool will record the verification failure and send an alarm to the business operation and maintenance platform to notify the operation and maintenance personnel to manually check the changed data.

[0047] Optionally, by matching and storing the changed data according to the matching result, the situation where the changed data does not correspond to the stored flight information is avoided, thereby improving the accuracy of storing the changed data.

[0048] It should be noted that the above embodiments can be executed through a business operation and maintenance platform.

[0049] In the above steps S101 to S105 of the present invention, in an embodiment of the present invention, the query status of the flight information is obtained; in response to the query status being a query change status, the log data of the flight information is obtained; based on the log data, the change data corresponding to the flight information is determined, wherein the change data is used to indicate that the flight information has been modified; the change data is matched with the historical flight data corresponding to the flight information stored in the database to obtain a matching result, wherein the matching result is used to indicate the degree of matching between the change data and the historical flight data; based on the matching result, the change data is stored. That is to say, the embodiment of the present invention queries the flight information, and when the flight information changes, the change data is determined according to the log data corresponding to the flight system, thereby matching, verifying and storing the change data. Since the present invention can automatically complete the process of querying flight information, matching and storing change data, etc., it avoids the problem of erroneous storage caused by human intervention, thereby solving the technical problem of not being able to accurately store flight information, and achieving the technical effect of accurately storing flight information.

[0050] The above method of this embodiment is further introduced below.

[0051] As an optional implementation manner, in response to the query state being a query change state, obtaining log data of the flight information includes: in response to the query state being a query change state, extracting keywords from the flight information; and determining the log data based on the keywords.

[0052] In this embodiment, when the query state is a query change state, it means that the user has modified the flight information, based on which, keywords are extracted from the flight information. For example, the business operation and maintenance platform extracts keywords from error information in the flight information.

[0053] Optionally, the specific error cause of the flight information is determined based on the extracted keywords, thereby determining the log data.

[0054] For example, when the automatic refund or change of a ticket generates an error flight information TRR-6126-70:stc flights error:No result ofquery, the business operation and maintenance platform detects the keyword, that is, the business operation and maintenance platform extracts the keyword from the flight information; the business operation and maintenance platform obtains relevant logs.

[0055] As an optional implementation manner, the method for storing flight information further includes: verifying and / or formatting the changed data to obtain the changed data corresponding to the verified and / or formatted flight information.

[0056] In this embodiment, the changed data is verified and / or formatted to obtain the changed data corresponding to the verified and / or formatted flight information. For example, the changed data is verified by a verification module.

[0057] For example, the verification module will verify the data, and the formatting module will format the data after receiving the verified data to ensure the uniformity and compatibility of the data.

[0058] Optionally, by checking and formatting the changed data, erroneous data can be effectively filtered out.

[0059] As an optional implementation method, based on the matching result, the changed data is stored, including: in response to the matching result being that the changed data fails to match the historical flight data, the changed data is verified to obtain a verification result; in response to the verification result being that the verification passes, the changed data is stored.

[0060] In this embodiment, when the matching result is that the changed data fails to match the historical flight data, it means that the changed data is inconsistent with the historical flight data. Based on this, the changed data is verified to obtain a verification result.

[0061] For example, if the verification of the changed data fails, the re-entry tool will record the verification failure and send an alarm to the business operation and maintenance platform, notifying the operation and maintenance personnel to conduct manual investigation, that is, manual verification.

[0062] Optionally, when the verification result is verification passed, it means that the changed data has passed the inspection, based on which the changed data can be stored.

[0063] As an optional embodiment, the method for storing flight information further includes: in response to the verification result being verification failure, outputting the verification result.

[0064] In this embodiment, when the verification result is that the verification fails, it indicates that an error occurs in the changed data, and based on this, the verification result is output.

[0065] For example, the verification results that failed the verification are displayed on the display of the business operation and maintenance platform for output.

[0066] As an optional embodiment, based on the matching result, storing the changed data includes: in response to the matching result being that the changed data successfully matches the historical flight data, converting the changed data into storage data; and storing the storage data in a database.

[0067] In this embodiment, when the matching result is that the changed data matches the historical flight data successfully, it means that the changed data and the historical flight data corresponding to the stored flight information are data under the same flight information. Based on this, the changed data is converted into storage data, and the storage data is stored in the database.

[0068] For example, the processed flight information is converted into appropriate SQL statements through internal logic, and the flight information is added to the database of the electronic ticket sales system through SQL.

[0069] It should be noted that the above embodiments can be executed through a business operation and maintenance platform.

[0070] In this embodiment, in the embodiment of the present invention, the query status of the flight information is obtained; in response to the query status being the query change status, the log data of the flight information is obtained; based on the log data, the change data corresponding to the flight information is determined, wherein the change data is used to indicate that the flight information has been modified; the change data is matched with the historical flight data corresponding to the flight information stored in the database to obtain a matching result, wherein the matching result is used to indicate the degree of matching between the change data and the historical flight data; based on the matching result, the change data is stored. That is to say, the embodiment of the present invention queries the flight information, and when the flight information changes, the change data is determined according to the log data corresponding to the flight system, thereby matching, verifying and storing the change data. Since the present invention can automatically complete the process of querying flight information, matching and storing change data, etc., it avoids the problem of erroneous storage caused by human intervention, thereby solving the technical problem of not being able to accurately store flight information, and achieving the technical effect of accurately storing flight information.

[0071] The technical solution of the embodiment of the present invention is illustrated below in conjunction with preferred implementation modes.

[0072] At present, the electronic ticket sales system is responsible for storing ticket sales information. When the user automatically refunds or changes the electronic ticket from the front end, the ticket automatic refund and change system will be called. The ticket automatic refund and change system needs to obtain the ticket face information from the electronic ticket management system, then call the electronic ticket sales system to obtain the ticket sales data, and then call the fare system to calculate the fee, and finally return the calculation result to the user. However, if there is no corresponding flight data in the ticket sales data, the automatic refund and change system will report an error "No query results for flight information", causing the system to be unable to complete the user's request.

[0073] Generally speaking, when a ticket is issued, the sales data will be written into the database of the electronic ticket sales system, and the flight data will not be missing. When a ticket is exchanged, the electronic ticket sales system will extract the flight information in the current message and check whether there is such flight information in the database. If not, a piece of data will be inserted. If so, it will determine whether the content is consistent. If not, it will be updated to the latest one. Flight data will not be missing, but in the following scenarios, flight data will be missing in the electronic ticket sales system because the new flight has not been issued: 1. The ticket has been voluntarily rescheduled: The voluntary rescheduling of the ticket uses the original ticket number and will not be reissued. Therefore, no new sales data will be written into the database of the electronic ticket sales system, and the database may be missing new flight information. 2. The ticket has been involuntarily changed: When a flight is cancelled due to reasons not voluntary to the passenger, the passenger will be assigned to another flight through the passenger protection control system. If there is no sales record for the flight, the new flight information may be missing in the database of the electronic ticket sales system. 3. The ticket has been delayed: When a flight is delayed to the next day due to heavy fog, thunderstorm or other reasons, and there is a flight with the same flight number on the next day, the delayed flight will generally change the flight number by adding a suffix. If there is no ticket sales record for the flight with the suffix, the flight information will be missing in the database of the electronic ticket sales system.

[0074] In related technologies, when a user receives an error report, he or she submits a work order to the back-end technician through the online work order system. After receiving the work order, the back-end technician checks the message sent by the automatic refund and change system to the electronic ticket sales system, and then compares the database of the electronic ticket sales system to supplement the missing flights. The existing solutions have the following problems: 1. The process is cumbersome: users need to submit work orders through the online work order system and wait for back-end technicians to process them. The whole process involves multiple steps and the user experience is poor. 2. Low efficiency: back-end technicians need to compare the database one by one and manually supplement the flight information. The processing time is long, which affects the timeliness of user operations. 3. Error-prone: Manual comparison and supplementary data entry are prone to human errors, resulting in inaccurate flight information, which further affects subsequent operations. Therefore, there is a technical problem that flight information cannot be accurately stored.

[0075] With respect to the above-mentioned technical problem of being unable to accurately store flight information, no effective solution has been proposed so far.

[0076] However, the embodiment of the present invention proposes a method for intelligent flight data completion, which detects error information of missing flight data, automatically obtains relevant logs and transmits log information, interacts with the flight inventory control system through API requests, obtains missing flight information, verifies and formats the obtained flight information, and supplements the flight information to the database of the electronic ticket sales system through SQL. The technical problem of being unable to accurately store flight information is solved, and the technical effect of improving the efficiency of determining reply information in the departure scenario is achieved.

[0077] The embodiments of the present invention are further described below.

[0078] Figure 2 is a schematic diagram of an intelligent flight data completion system according to an embodiment of the present invention. Figure 2 As shown, the intelligent flight data completion system 200 includes: an alarm module 201 , a data collection module 202 , a data processing module 203 and a data completion module 204 .

[0079] Alarm module 201: configure specific alarm keywords through the business operation and maintenance platform to achieve real-time monitoring of flight data missing during automatic refund and change. Once the error message of flight data missing is detected, the system will automatically obtain the relevant logs and transmit them to the data collection module 202 for further processing.

[0080] Data collection module 202: receives the log information transmitted by alarm module 201, interacts with the flight inventory control system through API request, and obtains the missing flight information. This module can obtain complete flight data and provide necessary information support for data processing module 203.

[0081] Data processing module 203: Verify and format the flight information obtained by data acquisition module 202 to ensure the accuracy and integrity of the data. Through the collaborative work of the verification module and the formatting module, the system can effectively filter out erroneous data and transmit the data that meets the requirements to the data completion module 204.

[0082] Data completion module 204: converts the processed flight information into appropriate SQL statements through internal logic, and records the flight information into the database of the electronic ticket sales system through SQL. The data completion module 204 is responsible for ensuring the correctness and consistency of the data during the recording process.

[0083] Optionally, the alarm module 201 is deployed on the business operation and maintenance platform to detect the situation where data is missing in the electronic ticket sales system when the user performs automatic rescheduling or automatic refund and change. The module configures keywords on the business operation and maintenance platform to detect the error of missing flight data, obtain relevant logs and push them to the application operation and maintenance platform.

[0084] Optionally, add an alarm: Select the intelligent alarm function on the business operation and maintenance platform to monitor the logs. The rule name is STC-FLIGHT error: No query results for flight information. Select the data table tappss_prod_error corresponding to the automatic refund and change system in the data table, configure the corresponding keyword in the search content: "TRR-6126-70", and select the application operation and maintenance system in the sending channel.

[0085] Optionally, trigger an alarm: When the automatic refund or change of ticket generates an error TRR-6126-70: stc flights error: No result of query, the business operation and maintenance platform will detect the keyword, obtain the relevant logs and automatically push them to the flight re-entry tool in the application operation and maintenance system, triggering its data collection module.

[0086] Optionally, the data collection module 202 is deployed on a flight supplementary recording tool of the application operation and maintenance platform, receives the log information pushed by the alarm module 201, interacts with the flight inventory control system through API requests, and obtains the missing flight information.

[0087] Optionally, receiving log information: the data collection module 202 receives the log pushed by the business operation and maintenance platform, including the original content of the log, pod name, transaction_id, ns_name and other information.

[0088] Optionally, constructing an API request: the data collection module 202 constructs a request based on the received log information using information such as AirlineCode and FlightNumber, and sends the request to the flight inventory control system.

[0089] Optionally, obtain flight information: the flight inventory control system receives the API request and returns the corresponding flight information, including airline, flight number, flight start date, flight end date, weekly flight status, aircraft type, departure point, departure time, arrival point, arrival time, cabin layout, flight distance and other information.

[0090] Optionally, the data processing module 203 is deployed on the flight supplementary recording tool of the application operation and maintenance platform to verify and format the flight information obtained by the data collection module to ensure the accuracy and completeness of the data. The specific steps include:

[0091] Optionally, data verification: The verification module verifies the obtained flight information to ensure that the airline, flight number, flight start date, flight end date, weekly flight information, aircraft type, departure point, departure time, arrival point, and arrival time can be correctly obtained. If the above data is missing, the verification fails, the verification failure log is recorded, and an alarm message is sent to the business operation and maintenance platform to notify the operation and maintenance personnel to conduct manual investigation.

[0092] Optionally, data formatting: the verified data will be sent to the formatting module for formatting and converted into a format such as JD (airline) 5103 (flight number) XIY (departure place) TNA (arrival place) 2024 / 02 / 12 (date) / 19:50 (departure time) / 21:30 (arrival time) / 320 (aircraft model).

[0093] Optionally, the data completion module 204 is deployed on a flight supplementary recording tool of the application operation and maintenance platform, converts the formatted flight information into appropriate SQL statements, and supplements the flight information into the database of the electronic ticket sales system through SQL.

[0094] Optionally, data judgment: execute a query statement to determine whether the data already exists in the database. If the query result does not exist, prepare to execute an INSERT statement; if the query result exists, prepare to execute an UPDATE statement.

[0095] Optionally, data update: Based on the result of data judgment, execute corresponding SQL operations to insert or update flight information into the database.

[0096] Optionally, data verification: After data completion is completed, use the SELECT statement to verify whether the data is successfully inserted or updated. If the query result exists, it is recorded as a successful supplement; if the query result does not exist, it is marked as a failure to supplement, and the failure information is recorded and sent to the business operation and maintenance platform to notify the operation and maintenance personnel to intervene manually.

[0097] Figure 3 is a flow chart of a smart flight data completion method according to an embodiment of the present invention. Figure 3 As shown, the intelligent flight data completion method includes the following steps:

[0098] Step S301: user request processing.

[0099] In this embodiment, the user initiates an automatic refund and ticket change request at the front-end channel, and the front-end system calls the ticket automatic refund and ticket change system for processing.

[0100] Step S302, detecting and recording error information.

[0101] In this embodiment, the automatic ticket refund and change system first calls the electronic ticket management system to obtain the ticket information, and then calls the electronic ticket sales system to obtain the ticket sales data, and an error occurs: TRR-6126-70: stc flightserror: No result of query{STC-FLIGHT error: No query result for flight information}.

[0102] Step S303: data collection.

[0103] In this embodiment, log information is received and required flight information is obtained from the flight inventory control system through an API request.

[0104] Step S304, data verification.

[0105] In this embodiment, the data is verified. If the verification passes, the data is sent to the formatting module. If the verification fails, the flight supplementary recording tool records the verification failure and sends an alarm to the business operation and maintenance platform to notify the operation and maintenance personnel to conduct manual investigation.

[0106] Step S305: data formatting.

[0107] In this embodiment, the verified data will be formatted to ensure the uniformity and compatibility of the data.

[0108] Step S306, data re-recording.

[0109] In this embodiment, the formatted data is converted into appropriate SQL statements, and the flight information is added to the database of the electronic ticket sales system through SQL. If the corresponding record does not exist in the database, an insert operation is performed; if the corresponding record exists in the database, an update operation is performed to ensure the correctness and completeness of the flight information.

[0110] Step S307, system feedback.

[0111] In this embodiment, after the flight information is automatically detected and completed, when the user initiates an automatic refund or change request again, the flight information in the electronic ticket sales system database has been completed, and the user can perform the automatic refund or change operation normally.

[0112] Optionally, through the above detailed system module description and processing flow, the present invention can effectively solve the problem of missing flight data, ensure the integrity and accuracy of the electronic ticket sales system, and improve the user experience.

[0113] The embodiments of the present invention are further described below through examples.

[0114] Case background: NX Airlines' NX5 flight from PEK to MFM on May 18, 2024 was cancelled for some reason. The airline created a temporary flight 321T. There was no sales record for the new flight. At this time, a passenger wanted to refund the ticket. The airline used the automatic refund instruction TRFD:Z and an error message TRR-6126-70: stc flights error: No result of query {STC-FLIGHT error: No query result for flight information} was reported.

[0115] Implementation steps: The alarm module monitors error information.

[0116] The alarm module monitors such error information through the business operation and maintenance platform, records relevant logs and pushes them to the EDS flight re-recording tool SaaS of the application operation and maintenance system.

[0117] Optionally, the data collection module obtains flight information, the collection module of the EDS flight supplementary recording tool receives log information, and obtains the required flight information from the flight inventory control system through an API request.

[0118] Optionally, the data processing module verifies and formats the data.

[0119] Optionally, data verification: The verification module of the data processing module will verify the data to ensure all necessary data items, namely airline: NX, flight number: 321T, flight start date: May 18, flight end date: May 19, weekly flight situation: Saturday and Sunday, aircraft type: 320, departure point PEK, departure time 13:00, arrival point MFM, arrival time 15:00. If the verification passes, the data will be sent to the formatting module; if the verification fails, the flight supplementary recording tool will record the verification failure and send an alarm to the business operation and maintenance platform to notify the operation and maintenance personnel to conduct manual investigation.

[0120] Optionally, data formatting: The formatting module formats the verified data to ensure that it is compatible with the storage format of the system. The specific format is: airline-flight number-departure-destination-departure date-departure time-arrival time-aircraft model, for example: NX321TPEKMFM2024 / 05 / 18 / 13:00 / 15:00 / 320; NX321TPEKMFM2024 / 05 / 19 / 13:00 / 15:00 / 320.

[0121] Optionally, the data completion module determines and updates the data.

[0122] Optionally, data judgment: the data completion module generates appropriate SQL statements based on the formatted data.

[0123] Optionally, data verification: After data completion is completed, the data completion module verifies whether the data is successfully inserted or updated through a SELECT statement. If the query result exists, it is recorded as a successful completion; if the query result does not exist, it is marked as a failure to complete the completion, and the failure information is recorded and sent to the business operation and maintenance platform.

[0124] Optionally, the system feedback: the airline company uses the automatic refund instruction TRFD:Z to initiate the automatic refund again, and the system can process the user's request normally.

[0125] Through this implementation case, we can clearly see the specific implementation process and advantages of the intelligent flight data completion method of the present invention in detecting and processing the problem of missing flight data. This system can automatically obtain and process missing flight data, ensure the data integrity in the electronic ticket sales system, thereby improving the user experience and reducing the need for manual intervention.

[0126] In this implementation, the error message of missing flight data is detected, the relevant logs are automatically obtained and transmitted, the missing flight information is interacted with the flight inventory control system through API requests, the obtained flight information is verified and formatted, and the flight information is supplemented into the database of the electronic ticket sales system through SQL. The technical problem of not being able to accurately store flight information is solved, and the technical effect of improving the efficiency of determining the reply information in the departure scenario is achieved.

[0127] According to an embodiment of the present invention, a device for storing flight information is also provided. It should be noted that the device for storing flight information can be used to execute the method for storing flight information in the method embodiment.

[0128] Figure 4 FIG. 1 is a schematic diagram of a device for storing flight information according to an embodiment of the present invention. Figure 4 As shown, the flight information storage device 400 may include: a first acquisition unit 401 , a second acquisition unit 402 , a determination unit 403 , a matching unit 404 and a storage unit 405 .

[0129] The first acquisition unit 401 is used to acquire the query status of the flight information.

[0130] The second acquiring unit 402 is configured to acquire log data of flight information in response to the query status being the query change status.

[0131] The determination unit 403 is used to determine the change data corresponding to the flight information based on the log data, wherein the change data is used to indicate that the flight information is modified.

[0132] The matching unit 404 is used to match the changed data with the historical flight data corresponding to the flight information stored in the database to obtain a matching result, wherein the matching result is used to indicate the matching degree between the changed data and the historical flight data.

[0133] The storage unit 405 is used to store the changed data based on the matching result.

[0134] Optionally, the second acquisition unit 402 may include: an extraction module, configured to extract keywords from the flight information in response to the query state being a query change state; and a first determination module, configured to determine the log data based on the keywords.

[0135] Optionally, the flight information storage device 400 may further include: a processing unit, configured to verify and / or format the changed data to obtain the changed data corresponding to the verified and / or formatted flight information.

[0136] Optionally, the storage unit 405 may include: a verification module for verifying the changed data to obtain a verification result in response to a matching result that the changed data fails to match the historical flight data; and a first storage module for storing the changed data in response to a verification result that the verification passes.

[0137] Optionally, the flight information storage device 400 may further include: an output unit, configured to output the verification result in response to the verification result being verification failure.

[0138] Optionally, the storage unit 405 may further include: a conversion module for converting the change data into storage data in response to a matching result that the change data successfully matches the historical flight data; and a second storage module for storing the storage data in a database.

[0139] In this embodiment, in the embodiment of the present invention, the query status of the flight information is obtained; in response to the query status being the query change status, the log data of the flight information is obtained; based on the log data, the change data corresponding to the flight information is determined, wherein the change data is used to indicate that the flight information has been modified; the change data is matched with the historical flight data corresponding to the flight information stored in the database to obtain a matching result, wherein the matching result is used to indicate the degree of matching between the change data and the historical flight data; based on the matching result, the change data is stored. That is to say, the embodiment of the present invention queries the flight information, and when the flight information changes, the change data is determined according to the log data corresponding to the flight system, thereby matching, verifying and storing the change data. Since the present invention can automatically complete the process of querying flight information, matching and storing change data, etc., it avoids the problem of erroneous storage caused by human intervention, thereby solving the technical problem of not being able to accurately store flight information, and achieving the technical effect of accurately storing flight information.

[0140] According to an embodiment of the present invention, a computer-readable storage medium is further provided, the storage medium comprising a stored program, wherein the program executes the method for storing flight information in the method embodiment.

[0141] According to an embodiment of the present invention, a processor is further provided, the processor being used to run a program, wherein the flight information storage method in the method embodiment is executed when the program is run.

[0142] According to an embodiment of the present invention, a computer program product is further provided. The computer program product includes computer instructions. When the computer instructions are executed by a processor, the method for storing flight information in the method embodiment is implemented.

[0143] The serial numbers of the above embodiments of the present invention are only for description and do not represent the advantages or disadvantages of the embodiments.

[0144] 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.

[0145] 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 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.

[0146] 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 over multiple units. Some or all of the units may be selected according to actual needs to achieve the purpose of the present embodiment.

[0147] 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.

[0148] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent functional component, 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 functional component, which is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, server or network device, etc.) to perform all or part of the steps of the methods of 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, disk or optical disk, etc., which can store program codes.

[0149] The above are only preferred embodiments 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 principles of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.

Claims

1. A method for storing flight information, characterized in that: include: Get the query status of flight information; In response to the query status being a query change status, obtaining log data of the flight information; Determining, based on the log data, change data corresponding to the flight information, wherein the change data is used to indicate that the flight information has been modified; Matching the changed data with historical flight data corresponding to the flight information stored in a database to obtain a matching result, wherein the matching result is used to indicate the matching degree between the changed data and the historical flight data; Based on the matching result, the change data is stored.

2. The method according to claim 1, characterized in that In response to the query status being a query change status, obtaining log data of the flight information includes: In response to the query state being a query change state, extracting keywords from the flight information; Based on the keyword, the log data is determined.

3. The method according to claim 1, characterized in that The method further comprises: The changed data is verified and / or formatted to obtain the changed data corresponding to the flight information after verification and / or formatting.

4. The method according to claim 1, characterized in that Based on the matching result, storing the changed data includes: In response to the matching result being that the changed data fails to match the historical flight data, verifying the changed data to obtain a verification result; In response to the verification result being a passed verification, the changed data is stored.

5. The method according to claim 4, characterized in that The method further comprises: In response to the verification result being verification failure, outputting the verification result.

6. The method according to any one of claims 1 to 5, characterized in that Based on the matching result, storing the changed data includes: In response to the matching result being that the changed data successfully matches the historical flight data, converting the changed data into storage data; The stored data is stored in the database.

7. A storage device for flight information, characterized in that: include: A first acquisition unit, used to acquire the query status of flight information; A second acquiring unit, configured to acquire log data of the flight information in response to the query state being a query change state; a determining unit, configured to determine, based on the log data, change data corresponding to the flight information, wherein the change data is used to indicate that the flight information is modified; a matching unit, configured to match the changed data with historical flight data corresponding to the flight information stored in a database to obtain a matching result, wherein the matching result is used to indicate a matching degree between the changed data and the historical flight data; A storage unit is used to store the changed data based on the matching result.

8. A computer-readable storage medium, characterized in that: The computer-readable storage medium includes a stored program, wherein when the program is executed by a processor, the device where the storage medium is located is controlled to execute the method according to any one of claims 1 to 6.

9. A processor, characterized in that: The processor is used to run a program, wherein the program executes the method according to any one of claims 1 to 6 when running.

10. A computer program product, characterized in that The computer program product comprises computer instructions, which implement the method according to any one of claims 1 to 6 when executed by a processor.

Images