Engineering Database Lookup Table Segmentation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Generating engineering databases using lookup tables becomes complex and time-consuming as the number of independent variables increases, requiring separate databases for different types of variables, which limits flexibility.
Innovation Solution
A method involving multiple table sets, control information, and lookup tables that allow flexible configuration of independent and dependent variables, enabling sorting and efficient data management by aggregating input information hierarchically and using a table lookup method.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If the number of independent variables is increased, then the database can represent more complex engineering relationships, but the lookup table structure becomes more complicated and generation becomes time-consuming
Solution Approach 1:
The patent divides the lookup table into multiple sub-tables, each handling a specific independent variable. This segmentation reduces the complexity of individual table structures while maintaining the ability to represent complex relationships through the combination of multiple simpler tables.
Solution Approach 2:
The patent introduces a hierarchical structure with multiple levels of independent variables. By organizing variables across different hierarchical levels rather than flattening all variables into a single level, the system can represent complex relationships without creating a single overly complex lookup table.
2Reliability
If separate databases are generated for various kinds of independent variables, then each database can be optimized for its specific variable type, but the overall process becomes more time-consuming and less flexible
Solution Approach 1:
The patent merges multiple separate database generation processes into a single unified process. By using a common template-based approach that can handle different variable types within one framework, the system eliminates the need to generate separate databases for each variable type while maintaining optimization for specific variable characteristics.
Solution Approach 2:
The patent creates a universal database generation template that can accommodate different kinds of independent variables. This multi-functional template allows the same generation process to handle various variable types (temperature, pressure, flow rate, etc.) without requiring separate specialized databases for each type.
3Quantity of substance
If the amount of data in the database increases, then the database can provide more detailed engineering information, but the data management and processing becomes more complex
Solution Approach 1:
The patent segments the large dataset into multiple smaller sub-datasets organized in sub-tables. Each sub-table contains data for a specific independent variable, making the data more manageable and easier to process while maintaining the total quantity of information needed for comprehensive engineering analysis.
Data Source
AI summary
A method for generating an engineering database using lookup tables includes creating multiple table sets for generating the engineering database, inputting multiple pieces of control information for controlling respective ones of the multiple datasets, and inputting multiple lookup tables corresponding to each of the multiple pieces of control information.