Relational Database Writing Through Filtered Views and Auto-Generated Records
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 predefined criteria, display filtered data sets in an output view with input fields, and automatically assign values to attributes, reducing the number of entries needed by utilizing a user-configurable or system-determined output view.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If a user manually types all x entries for each new data set, then complete data set information can be entered, but the process becomes cumbersome and time-consuming
Solution Approach 1:
The system performs preliminary actions by automatically generating data sets based on filter criteria before the user needs to enter them. The computer system creates data sets by applying filters to existing data, so the user only needs to make minor adjustments rather than typing all entries from scratch.
Solution Approach 2:
The system serves itself by automatically generating and populating data sets based on user-defined filter criteria. The computer system independently performs the complex task of creating data sets, and the user only needs to provide simple filter criteria rather than manually entering all data fields.
2Manufacturing precision
If a user enters values for all x attributes, then complete data set information is provided, but the complexity and effort increase significantly
Solution Approach 1:
The system extracts only the necessary information from existing data sets based on user-defined filter criteria. Instead of requiring the user to provide all x attributes, the system extracts relevant attributes from the filtered data, reducing the complexity of data entry while maintaining completeness.
Solution Approach 2:
The system uses a universal approach where the same filter-based mechanism can generate data sets for different attributes and scenarios. The computer system adapts to different data requirements by applying filters, making the data entry process universally applicable without increasing complexity for different data types.
3Productivity
If filter criteria are applied to display specific data sets, then relevant information is highlighted, but the system complexity increases
Solution Approach 1:
The system segments the data entry process into simple filter criteria definition and automatic data set generation. The filtering mechanism is segmented from the data generation process, allowing the system to handle complexity internally while presenting a simple interface to the user for defining filters.
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).