Metadata-Based Table and Program Specification Method
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
In information processing systems, users face difficulties in generating a new table with designated items from existing tables and programs, especially when the number of tables and programs is large, as existing solutions lack effective methods for selecting the appropriate input table and generation program.
Innovation Solution
A method that involves specifying an existing table and a program based on metadata to generate a new table with designated output items, by identifying matching items and conditions in metadata storage units, and executing the program to create the new table.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Productivity
If users manually select input tables and generation programs from a large number of existing tables and programs, then the system can generate new tables with designated items, but the time and complexity required for selection increases significantly
Solution Approach 1:
The system performs preliminary actions by automatically specifying the input table and generation program based on metadata analysis before the user needs to generate a new table. The metadata storage units contain pre-organized information about table structures and program capabilities, allowing the system to quickly match requirements with appropriate resources without manual searching or selection.
Solution Approach 2:
The system serves itself by automatically identifying and selecting the appropriate input table and generation program through metadata comparison and analysis. Instead of requiring user intervention to select from numerous options, the system autonomously determines the best match based on the designated output items and metadata characteristics, reducing user workload and selection time.
2Measurement precision
If the system stores detailed metadata for each table and program to enable automatic specification, then the accuracy of table and program selection improves, but the complexity and storage requirements of the system increase
Solution Approach 1:
The system extracts only the essential and relevant metadata characteristics needed for table and program specification, rather than storing and processing all possible attributes. By focusing on key metadata elements that directly relate to table structure and program functionality, the system achieves accurate specification while avoiding unnecessary complexity in metadata management.
3Ease of operation
If the system automatically specifies input tables and generation programs based on metadata, then the ease of operation improves, but the risk of selecting incorrect tables or programs may increase
Solution Approach 1:
The system incorporates feedback mechanisms where the automatic specification process continuously validates its selections by comparing metadata characteristics against the requirements for generating the designated output items. This feedback loop ensures that the selected input table and generation program are appropriate and correct, maintaining high reliability while preserving ease of operation through automation.
Data Source
AI summary
A method includes receiving a designation of one or more first items that are to be included in a new table from a user, specifying, based on metadata related to second items included in each of a plurality of existing tables, an existing table from among the plurality of existing tables, the existing table including at least one of the designated one or more first items in the second items, specifying, based on other metadata related to an input item and an output item accompanied with execution of each of a plurality of programs, a program from among the plurality of programs, the program causing the designated one or more first items to be output as the output item when one of the second items included in the specified existing table is input as the input item, and outputting the specified existing table and the specified program.