Relational Database Entry via Filtered Views and Auto-Filled Attributes
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Writing data sets into a relational database is cumbersome, requiring users to type x entries for each new data set, especially when the data set consists of multiple attributes.
Innovation Solution
A method that allows users to filter data sets based on criteria, display filtered data sets in a user-configurable or system-assisted output view, and enter values in input fields to generate new data sets, reducing the number of entries needed by leveraging pre-defined attributes and automatic assignment of values.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Manufacturing precision
If a user types x entries for each new data set with x attributes, then complete data sets can be written into the relational database, but the process becomes cumbersome and time-consuming
Solution Approach 1:
The system performs preliminary actions by automatically generating data sets based on template structures and pre-defined attributes. The relational database schema is pre-configured with templates that specify required attributes and data types, allowing the system to automatically create complete data sets without requiring users to manually enter all x attributes.
Solution Approach 2:
The system enables self-service data entry by allowing users to provide only essential information while the system automatically fills in remaining attributes based on templates and existing data patterns. The relational database automatically validates and completes data sets according to pre-defined structural rules, reducing manual entry effort while maintaining completeness.
2Reliability
If a user manually enters all x attributes for each data set, then data integrity is maintained, but the time required for data entry increases significantly
Solution Approach 1:
The system performs preliminary actions by pre-configuring the relational database with templates that define required attributes, data types, and validation rules. These templates are established in advance, allowing the system to automatically generate and validate complete data sets without requiring time-consuming manual verification of all x attributes.
Solution Approach 2:
The system implements feedback mechanisms where the relational database automatically validates entered data against pre-defined templates and constraints. The system provides immediate feedback on data integrity issues and automatically corrects or rejects entries that do not conform to required patterns, maintaining reliability while reducing manual checking time.
3Adaptability or versatility
If the relational database structure is complex with multiple relations and attributes, then data organization is improved, but the difficulty of data entry increases
Solution Approach 1:
The system segments the complex relational database structure into manageable templates that represent specific data sets or records. Each template breaks down the complex multi-attribute structure into discrete, user-friendly entry forms, allowing users to interact with simplified interfaces while the underlying complex relational structure remains intact for efficient data organization.
Solution Approach 2:
The system introduces templates as intermediary structures between the user and the complex relational database. These templates act as mediators that translate simple user inputs into complex multi-attribute data sets, hiding the complexity of the underlying relational structure while maintaining its organizational capabilities.
Data Source
AI summary
A method for writing data sets (DS) into a relational database (13), wherein each data set (DS) comprises at least two attributes (A), includes the steps of: determining at least one value for at least one of the attributes (A1) as criterion for filtering the data sets (DS) by the attribute value; computer implemented outputting data sets (DS) filtered by the attribute value in an output view (AS) and providing an input field (EF) in the output view (AS) for entering a value for another one of the attributes (A4); in response to entering a value in the input field (EF) of the output view (AS) computer implemented generating a complete data set (DS4) including the value set as filter criterion for the corresponding attribute (A1) and the entered value for the other attribute (A4); and storing the generated dataset (DS4) in the relational database (13).