Method and system for storing and updating leg parameters

Abstract

The invention discloses a leg parameter storage and updating method and system, and the method comprises the following steps: S1, starting, S2, single leg batch parameters including a calculated MD5 value, S3, querying leg parameters in a database, and storing the leg parameters in Redis, and S4, processing the parameters item by item. According to the method, leg parameter information from different sources can be effectively received, distinguished and integrated, centralized management and detailed change history tracking of parameters are realized, unnecessary repeated storage is avoided, database redundancy is remarkably reduced, efficient batch parameter storage and updating logic is designed, a processing flow is simplified by utilizing a queue structure, and the processing efficiency is improved. According to the method, high performance can still be kept when ten millions of level parameters are processed, the performance bottleneck during large-scale data processing is solved, detailed records of parameter changes can be recorded and displayed, a user can visually know the historical change conditions of the parameters conveniently, and transparency and traceability of data management are improved.

Description

Technical Field

[0001] The invention belongs to the technical field of route management, and specifically relates to a method and system for preserving and updating flight segment parameters. Background Art

[0002] In the aviation field, a flight segment refers to the flight process from takeoff to the next landing. The following is a detailed explanation and summary of the flight segment: Definition: A flight segment refers to the entire flight process of an aircraft starting from the takeoff point, flying in the air, and finally arriving and landing at the destination airport. This process may include multiple stages such as takeoff, cruising, descent and landing.

[0003] A study of the current airline segment parameter management system found that the existing system only implements a simple storage function for segment parameters, but does not provide comprehensive management and update record functions for parameters from multiple sources. This results in the system being unable to effectively track and integrate segment parameter changes from different sources. The traditional parameter update method is mechanical and inefficient. It copies the original parameters and modifies them before storing them in the database. This operation will cause a large amount of redundant data to appear in the database, which not only takes up a lot of storage space, but also makes data maintenance difficult. Due to the large number of segment parameters, when processing massive amounts of data, the existing system cannot simultaneously support efficient large-scale parameter storage and update operations, and cannot quickly reflect the differences before and after parameter changes, which seriously affects the system's response speed and overall performance. Summary of the invention

[0004] The technical solution adopted by the present invention is as follows: a method for saving and updating flight segment parameters, comprising the following steps: S1. Start.

[0005] S2, single-segment batch parameters, including the calculated MD5 value.

[0006] S3. Query the flight segment parameters in the database and store them in Redis.

[0007] S4. Process the parameters item by item according to steps S5 to S8.

[0008] S5. Search in Redis according to the MD5 of the parameter key field. If it exists, compare the MD5 value of the full field with the data in Redis to see if they are the same. If not, the parameter is added to the new parameter queue, and the parameter change record is added to the change record queue.

[0009] S6. If the MD5 value of the full field is the same as the data in Redis, loop to step 4.

[0010] S7. If the MD5 value of the full field is different from the data in Redis, the difference between the two data is compared to form a change record, and the change parameters are added to the change queue, and the change details are added to the change record queue.

[0011] S8. Save the data in the queue to MySOL.

[0012] S9. End.

[0013] Further, according to the operation steps in S8, the MySQL provides storage and query functions for relational data in the system.

[0014] Further, according to the operation steps in S5, the Redis is a cache database.

[0015] A computer-readable storage medium includes computer-executable instructions, which are used to execute any one of the above-mentioned methods for saving and updating flight segment parameters when the instructions are executed.

[0016] A system for storing and updating flight segment parameters, comprising: The application layer is used to directly face users, provide network services to users, process user requests and complete user tasks.

[0017] The business layer is responsible for processing business requirements in the software, implementing specific business logic, and interacting with other layers.

[0018] The data layer is used to ensure the correct storage, management and transmission of data, providing stable and reliable data support for upper-layer applications.

[0019] The application layer includes a parameter management module, a parameter change management module and a parameter file management module; the business layer includes parameter basic data management, parameter file data management, parameter and file association data management, file parsing and parameter batch processing; and the data layer includes MySQL and Redis.

[0020] Furthermore, the application layer, business layer and data layer are built based on SpringBoot and VUE.

[0021] Furthermore, the parameter management module includes the functions of searching, adding, modifying, deleting and viewing parameters.

[0022] The parameter change module includes the initial source record of the parameter and the parameter change record, and can view and delete the above records. The parameter change module can be entered through the parameter management module.

[0023] The parameter file management module provides the function of parsing parameters in the flight segment configuration file, parameters in Excel and parameters in the parameter template file. The user enters the file upload page by clicking the corresponding button. After the file is uploaded, the system background starts to parse the data in the file. After the file parsing is completed, the user can see the latest parsed file basic information in the parameter file list, including file name, size and upload time. Click the parameter details button to view the parameters parsed from the file, and you can also query the latest parsed parameters on the parameter management page.

[0024] Furthermore, the business layer mainly provides detailed management methods for parameters, parameter change records, and parameter files, including the addition, deletion, modification, and query of functions, as well as file upload and parsing functions, and provides efficient processing methods for complex business logic in parameter batch updates.

[0025] Furthermore, the data layer includes two types of databases, the relational database MySQL and the in-memory database Redis.

[0026] Furthermore, the parameter data is stored in MySQL partition format, and the parameter data of each flight segment is stored in a partition to improve database query. Redis is used for storage and query of single-segment parameter data. The parameter data exists in memory, reducing the number of database IO times and improving the overall efficiency of the system.

[0027] In summary, due to the adoption of the above technical solution, the beneficial effects of the present invention are: In the present invention, it is possible to effectively receive, distinguish and integrate flight segment parameter information from different sources, realize centralized management of parameters and detailed change history tracking, introduce MD5 value as key field identifier, and compare the key field and full field MD5 value of the newly imported parameter with that of the existing parameter to decide whether to add or update the parameter, thereby avoiding unnecessary repeated storage and significantly reducing database redundancy. In addition, an efficient batch parameter preservation and update logic is designed, and the processing flow is simplified by using a queue structure to ensure high performance when processing tens of millions of parameters, thereby solving the performance bottleneck in large-scale data processing, and being able to record and display detailed records of parameter changes, so that users can intuitively understand the historical changes of parameters and improve the transparency and traceability of data management. BRIEF DESCRIPTION OF THE DRAWINGS

[0028] Figure 1 is a flow chart of the method of the present invention; Figure 2 It is a schematic diagram of the overall system of the present invention.

[0029] Markings in the figure: 1, application layer; 2, business layer; 3, data layer. DETAILED DESCRIPTION

[0030] In order to make the purpose, technical solution and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention. Example

[0031] Reference Figure 1 - Figure 2 :A method for preserving and updating flight segment parameters, comprising the following steps: S1, start, S2, batch parameters of a single flight segment, including a calculated MD5 value, S3, query the flight segment parameters in the database and store them in Redis, S4, process the parameters item by item according to steps S5-S8, S5, search in Redis according to the parameter key field MD5, if it exists, compare the full field MD5 value with the data in Redis to see if it is the same, if it does not exist, then the parameter is added to the new parameter queue, and the parameter change record is added to the change record queue, Redis is a cache database, S6, compare the full field MD5 value with the data in Redis, if the same, then loop to step four, S7, compare the full field MD5 value with the data in Redis, if it is not the same, compare the difference between the two data, form a change record, add the change parameter to the change queue, and add the change details to the change record queue, S8, save the data in the queue to MySQL, MySQL provides the storage and query functions of relational data in the system, S9, end.

[0032] Reference Figure 1 - Figure 2 : A computer-readable storage medium, comprising computer-executable instructions, which, when executed, are used to execute any one of the above-mentioned methods for saving and updating flight segment parameters.

[0033] Reference Figure 1 - Figure 2 :A system for preserving and updating flight segment parameters, including: application layer 1, which is used to directly face users, provide network services to users, process user requests and complete user tasks, business layer 2, which is responsible for processing business needs in the software, realizing specific business logic, and interacting with other layers, data layer 3, which is used to ensure the correct storage, management and transmission of data, and provide stable and reliable data support for upper-level applications. Application layer 1 includes parameter management module, parameter change management module and parameter file management module. Business layer 2 includes parameter basic data management, parameter file data management, parameter and file association data management, file parsing and parameter batch processing. Data layer 3 includes MySQL and Redis. Reference Figure 1 - Figure 2:Application layer 1, business layer 2 and data layer 3 are built based on SpringBoot and VUE. The parameter management module includes the functions of searching, adding, modifying, deleting and viewing parameters. The parameter change module includes the initial source record of the parameters and the parameter change record, and can view and delete the above records. This module can be entered through the parameter management module. The parameter file management module provides the function of parsing the parameters in the flight segment configuration file, the parameters in Excel and the parameters in the parameter template file. The user enters the file upload page by clicking the corresponding button. After the file upload is completed, the system background starts to parse the data in the file. After the file parsing is completed, the user can see the latest parsed file basic information in the parameter file list, including The file name, size and upload time. Click the parameter details button to view the parameters parsed from the file. You can also query the latest parsed parameters on the parameter management page. The business layer mainly provides detailed management methods for parameters, parameter change records, and parameter files, including the addition, deletion, modification, and query of the above functions, as well as file upload and parsing functions, and provides efficient processing methods for complex business logic in parameter batch updates. The data layer includes two types of databases, relational database MySQL and memory database Redis. Parameter data is stored in the form of MySQL partitions. The parameter data of each flight segment is stored in a partition to improve database query. Redis is used for storage and query of single-segment parameter data. The data exists in memory. It can reduce the number of database IO times and improve the overall efficiency of the system. The application layer includes three modules: parameter management, parameter change management and parameter file management. The specific information is as follows: Parameter management module: Parameter management includes the functions of searching, adding, modifying, deleting and viewing parameters. Parameter change module: Parameter change management includes the initial source record of parameters and parameter change record, and the above records can be viewed and deleted. This module can be entered through the parameter management module. Parameter file management module: This module provides the function of parsing parameters in the flight segment configuration file, parameters in Excel and parameters in the parameter template file. Users enter the file upload page by clicking the corresponding button. After completing the file upload, the system background starts to parse the file. After the data file is parsed, the user can see the latest parsed file basic information in the parameter file list, including file name, size, upload time, etc. Click the parameter details button to view the parameters parsed from the file, or query the latest parsed parameters on the parameter management page. The business layer mainly provides detailed management methods for parameters, parameter change records, and parameter files, including the addition, deletion, modification, and query of the above functions, as well as file upload and parsing functions, and provides efficient processing methods for complex business logic in parameter batch updates. The processing logic of parameter batch updates is as follows: A parameter contains multiple fields. When several specific parameters are the same, they are identified as the same parameter. At this time, the parameter library is queried through these specific parameters. If the result is not found,The parameter is identified as a new parameter, saved in the database, and the snapshot of the parameter is recorded and stored in the snapshot library. If the parameter is found in the parameter library, when the other fields of the query result are exactly the same as the newly added parameter, the parameter is determined to exist and no processing is done on the parameter at this time; if the other fields in the search result are different, the parameter is determined to be an updated parameter, and the changed item of the entered parameter is overwritten on the corresponding field of the parameter in the original parameter library, and the snapshot of the entered parameter and the details of the change are recorded. Due to the large number of flight segment parameters, after the system has been running for a long time, there are tens of millions of parameters in the parameter library. In order to improve the efficiency of batch processing parameters, two additional fields are added to all parameter items in the parameter library, namely the MD5 value of the key field and the MD5 value of the full field. When importing parameters, the MD5 values ​​of the imported parameters are calculated in batches. After the calculation is successful, the parameters are processed one by one. Therefore, the logic of processing parameters is as follows: Check whether there is an MD5 value of the key field in the parameter library. If not, the current parameter is determined to be newly added, and the parameter is added to the new queue, and its snapshot is added to the snapshot queue; when the key field is found, the MD5 value of the key field is calculated. When the MD5 value of the key field is determined, the MD5 value of the full field is determined to be the same. If the MD5 value is the same, the parameter is considered to exist and no processing is performed. When the MD5 value of the key field is the same and the MD5 value of the full field is different, the parameter is considered to be an updated parameter, and the fields are compared item by item. The change result is added to the change record queue, and the change field overwrites the original parameter library parameter field, and then added to the change queue, and the snapshot record of the parameter is added to the snapshot queue. After all parameters are processed, save all the data in the queue to the corresponding database. Data layer: The data layer mainly includes two types of databases, relational database MySQL and memory database Redis. MySQL: Provides storage and query functions for relational data in the system. In order to cope with a large amount of parameter data in this system, MySQL partitioning is used to store data. The parameter data of each flight segment is stored in a partition to improve database query. Redis is used for storage and query of single flight segment parameter data. The data exists in memory, which can reduce the number of database IO times and improve the overall efficiency of the system. ,

[0034] The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the protection scope of the present invention.

Claims

1. A method for preserving and updating flight segment parameters, characterized in that: The following steps are involved: S1, start; S2, single-segment batch parameters, including the calculated MD5 value; S3, query the flight segment parameters in the database and store them in Redis; S4, process the parameters item by item according to steps S5 to S8; S5. Search in Redis based on the MD5 of the parameter key field. If it exists, compare the MD5 value of all fields with the data in Redis to see if they are the same. If it does not exist, add the parameter to the new parameter queue and the parameter change record to the change record queue. S6. If the MD5 value of the full amount field is the same as the data in Redis, loop to step 4; S7. If the MD5 values ​​of all fields are different from those in Redis, the difference between the two data is compared to form a change record. The change parameters are added to the change queue, and the change details are added to the change record queue. S8, save the data in the queue to MySOL; S9. End.

2. A method for storing and updating flight segment parameters according to claim 1, characterized in that: The following steps are involved: According to the operation steps in S8, MySQL provides storage and query functions for relational data in the system.

3. A method for storing and updating flight segment parameters according to claim 1, characterized in that: The following steps are involved: According to the operation steps in S5, the Redis is a cache database.

4. A computer-readable storage medium, comprising computer-executable instructions, which, when executed, are used to execute the method for saving and updating flight segment parameters as described in any one of claims 1 to 3.

5. A system for storing and updating flight segment parameters, characterized in that: include: The application layer (1) is used to directly face users, provide network services to users, process user requests, and complete user tasks; Business layer (2), which is responsible for handling business requirements in the software, implementing specific business logic, and interacting with other layers; The data layer (3) is used to ensure the correct storage, management and transmission of data, providing stable and reliable data support for upper-layer applications; The application layer (1) includes a parameter management module, a parameter change management module and a parameter file management module; the business layer (2) includes parameter basic data management, parameter file data management, parameter and file association data management, file parsing and parameter batch processing; and the data layer (3) includes MySQL and Redis.

6. A system for storing and updating flight segment parameters as claimed in claim 5, characterized in that: The application layer (1), business layer (2) and data layer (3) are built based on SpringBoot and VUE.

7. A system for storing and updating flight segment parameters as claimed in claim 5, characterized in that: The parameter management module includes the functions of searching, adding, modifying, deleting and viewing parameters; The parameter change module contains the initial source record of the parameter and the parameter change record, and can view and delete the above records. The parameter change module can be entered through the parameter management module; The parameter file management module provides the function of parsing parameters in the flight segment configuration file, parameters in Excel and parameters in the parameter template file. The user enters the file upload page by clicking the corresponding button. After the file is uploaded, the system background starts to parse the data in the file. After the file parsing is completed, the user can see the latest parsed file basic information in the parameter file list, including file name, size and upload time. Click the parameter details button to view the parameters parsed from the file, and you can also query the latest parsed parameters on the parameter management page.

8. A system for storing and updating flight segment parameters as claimed in claim 5, characterized in that: The business layer mainly provides detailed management methods for parameters, parameter change records, and parameter files, including the addition, deletion, modification, and query of functions, as well as file upload and parsing functions, and provides efficient processing methods for complex business logic in parameter batch updates.

9. A system for storing and updating flight segment parameters as claimed in claim 5, characterized in that: The data layer includes two types of databases, relational database MySQL and in-memory database Redis.

10. A system for storing and updating flight segment parameters as claimed in claim 5, characterized in that: The parameter data is stored in the form of MySQL partitions. The parameter data of each flight segment is stored in a partition to improve database query. Redis is used for storage and query of single-segment parameter data. The parameter data exists in memory, which reduces the number of database IO times and improves the overall efficiency of the system.

Images