Freight Rate Calculation Groups for Multi-Leg Query Timeouts
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In the aviation industry, system transaction timeouts frequently occur due to performance constraints, leading to the return of low-priced products that fail to meet diverse content display needs, resulting in a poor user experience.
Innovation Solution
A freight rate determination method and apparatus that constructs freight rate calculation groups for each leg of a flight route, filters data based on limit and agent information, and combines data using a Column algorithm to provide multiple freight rate options.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If the system returns only low-priced products due to performance constraints, then the system can handle transactions within timeout limits, but the user experience deteriorates and diverse content display needs cannot be met
Solution Approach 1:
The patent segments the freight rate calculation process by dividing flight routes into multiple legs and creating separate calculation groups for each leg. This allows the system to process complex multi-leg routes efficiently by breaking them down into manageable segments, thereby improving system performance while maintaining the ability to provide diverse pricing options for different route combinations.
Solution Approach 2:
The patent implements preliminary action by pre-calculating and caching freight rate data in a database before actual queries. The system pre-processes rate information, filters it based on limit and agent information, and stores it in an optimized format. When a query arrives, the system retrieves pre-computed results rather than calculating everything in real-time, thus meeting timeout requirements while providing comprehensive pricing options.
2Adaptability or versatility
If the system calculates comprehensive freight rates for multiple legs, then diverse content display needs are met, but system transaction timeouts increase due to performance constraints
Solution Approach 1:
The patent divides complex multi-leg route calculations into separate calculation groups, one for each leg. This segmentation allows the system to process and cache results for individual legs independently, then combine them efficiently during queries. The Column algorithm further optimizes this by selectively combining pre-computed leg results, reducing the computational burden and query time while maintaining comprehensive coverage of routing options.
Solution Approach 2:
The system performs preliminary calculations for each flight leg and caches the results in a database before actual user queries occur. This pre-computation includes filtering freight rate data based on limit information and agent information. During runtime, the system only needs to retrieve and combine pre-computed data using the Column algorithm, dramatically reducing transaction time while preserving the ability to provide diverse freight rate options.
3Measurement precision
If the system filters and combines freight rate data for multiple calculation groups, then the accuracy of freight rate calculations improves, but the complexity of the calculation process increases
Solution Approach 1:
The patent structures the complex filtering and combination process into distinct, manageable components: individual calculation groups for each leg, separate filtering operations for limit and agent information, and a systematic combination process using the Column algorithm. This modular segmentation makes the complex process more manageable and maintainable while ensuring accurate freight rate calculations through systematic data processing.
Data Source
AI summary
A freight rate determination method and a related apparatus. The method may include: constructing at least one freight rate calculation group based on the freight rate query request; obtaining freight rate data corresponding to each of the at least one freight rate calculation group by querying from a database; filtering each piece of the freight rate data based on limit information and agent information in the freight rate query request, as well as a rule identifier and a freight rate protocol identifier of each piece of the freight rate data in the freight rate calculation group, to obtain at least one piece of target freight rate data corresponding to the freight rate calculation group; and obtaining at least one freight rate combination by combining each piece of the target freight rate data corresponding to each freight rate calculation group based on a Column algorithm.