US 12,475,094 B2
Method for writing data sets into a relational database
Martin Gossweiler, Wollerau (CH)
Assigned to BASICS SOFTWARE SOLUTIONS AG, Wollerau (CH)
Filed by BASICS SOFTWARE SOLUTIONS AG, Wollerau (CH)
Filed on Oct. 30, 2023, as Appl. No. 18/497,544.
Claims priority of application No. 001285/2022 (CH), filed on Oct. 31, 2022.
Prior Publication US 2024/0152497 A1, May 9, 2024
Int. Cl. G06F 16/28 (2019.01); G06F 16/22 (2019.01)
CPC G06F 16/22 (2019.01) [G06F 16/284 (2019.01)] 10 Claims
OG exemplary drawing
 
1. A method for writing data sets into a relational database, the method comprising:
one of providing and generating multiple relations in the database including a primary relation, each relation comprising at least one attribute, and the primary relation comprising at least four attributes,
wherein at least one of the attributes of the primary relation requires values of a non-discrete data type, which the non-discrete data type requires the corresponding attribute to accept values out of a non-finite, non-predefined set of values,
wherein all other attributes of the primary relation require values of a discrete data type, which the discrete data type requires the corresponding attribute to exclusively accept values out of a finite, predefined set of values,
wherein the data sets each comprises values for all attributes of the primary relation of the relational database;
by means of a graphical user interface (GUI), determining at least one value for at least one of the attributes as criterion for filtering the data sets by this attribute value,
wherein the attribute serving as filter criterion is an attribute for values of the discrete data type;
computer implemented outputting data sets filtered by the attribute value in an output view and providing an input field in the output view for entering a value for another one of the attributes of the primary relation,
wherein the output view is a matrix view,
wherein the values of a further of the attributes of the discrete data type define columns of a matrix in the output view,
wherein the values of a third of the attributes of discrete data type define rows of the matrix in the output view,
wherein the attribute values of the non-discrete data type of the filtered data sets are output in cells of the matrix assigned to the value of the data set defining a column and assigned to the value of the data set defining a row,
wherein all cells of the matrix not occupied by values of the non-discrete data type of the corresponding attribute serve as input fields,
wherein the output view is editable by means of an editor for assigning the values of the further attributes to the columns of the matrix and the values of the third of the attributes to the rows of the matrix;
in response to entering a value in the input field of the output view, computer implemented generating a complete data set including the value set as filter criterion for the corresponding attribute and the entered value for the corresponding attribute; and
storing the generated complete dataset in the relational database.