Multidimensional Effectivity Model for Aeronautical Data Management
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database systems face challenges in efficiently managing and processing time-varying aeronautical feature information, particularly in maintaining data applicability across different dimensions such as time, customer-specific tailoring, and durability, which is essential for navigation data products.
Innovation Solution
The implementation of a multidimensional effectivity model that uses a baseline-delta method to record changes with effectivity parameters, allowing for precise representation and management of time-varying data, including permanent and temporary changes, tailored data for specific customers, and accommodating additional effectivity dimensions like durability and product-specific extensions.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If traditional database systems are used to manage aeronautical feature information, then data storage and retrieval can be performed, but the system cannot efficiently handle multiple effectivity dimensions (time, customer tailoring, durability) simultaneously
Solution Approach 1:
The patent introduces multiple effectivity dimensions (time, customer tailoring, durability) to transform the traditional single-dimension database structure. Each data record is enhanced with effectivity parameters that span multiple dimensions, allowing the system to efficiently query and manage aeronautical data across different contexts simultaneously without sacrificing processing speed.
2Loss of information
If all changes to navigational data are recorded in detail, then complete data history is maintained, but storage space is wasted due to redundant information
Solution Approach 1:
The patent extracts and stores only the effectivity parameters (time validity, customer applicability, durability status) that are essential for maintaining data history across multiple dimensions. By separating these key effectivity attributes from the full data records, the system preserves complete change history information while minimizing redundant storage of identical data across different effectivity contexts.
3Reliability
If the database system processes and analyzes all navigational information thoroughly, then accurate navigation products are created, but the processing time and computational resources increase significantly
Solution Approach 1:
The patent performs preliminary organization of navigational data by pre-tagging records with effectivity parameters (time validity periods, customer-specific applicability, durability status) during data ingestion. This preliminary structuring allows the database to quickly filter and retrieve only the relevant subset of data needed for specific navigation products, avoiding the need to process and analyze the entire dataset each time, thus maintaining accuracy while reducing processing time.
Data Source
AI summary
An apparatus having a computer-implemented database controller module, a computer-implemented database module, and a computer-implemented database query module. Software and/or firmware that is/are included in computer-implemented database controller module is/are configured to enter baseline data into the computer-implemented database module and to enter changes into the computer-implemented database module using an extensible multidimensional effectivity method of recording only an indicated change with its effectivity parameters. The computer-implemented database query module is configured to retrieve answers to queries relating to the baseline data and the changes and to return the answers in response to the queries.