Computer-implemented database method for storing basic data in data table

1 . A computer-implemented database method comprising:

storing basic data to be stored (S 1 ) in a multi-column and multi-row data table ( 14 ) of a database ( 13 ) in data columns ( 17 ) provided for this purpose, and

assigning at least one dimension to the basic data of at least some fields, the at least one dimension indicating that the basic data are related to one another (S 2 ),

wherein the assignment of the at least one dimension the basic data takes place by storing dimension IDs belonging to the at least one dimension in rows in which the at least some fields of the basic data are located, in another column which is not a data column of the data columns and which is provided for the assignment of the at least one dimension, a dimension column ( 20 ), wherein dimension IDs of the dimension IDs belonging to a same dimension of the at least one dimension differ from one another,

wherein objects are stored in the database ( 13 ),

wherein the basic data from one or more of the fields from one or more of the data columns ( 17 ) of the data table ( 14 ) belong to each of the objects,

wherein an object ID is assigned to each of the objects,

wherein data for at least one object is stored in several rows in the data table,

wherein a matching master ID is assigned to several rows of the at least one object,

wherein the matching master ID is stored in a master ID column of the data table in the several rows to which the matching master ID is assigned,

wherein for data column fields with the basic data to which a dimension is assigned, it applies that in other data columns ( 17 ) which are provided for the basic data to which this dimension is not assigned, the fields in a same row remain empty or comprise empty entries, and/or wherein for data column fields with the basic data to which no dimension is assigned, it applies that no dimension IDs are stored in the dimension column ( 20 ) in the fields in the same row,

wherein data is retrieved from the data table ( 14 ), and

wherein the retrieval of data from the data table ( 14 ) is carried out using a function which returns a largest of values stored in a selected column.

2 . The database method according to claim 1 , wherein all the basic data to be stored are stored in the data table ( 14 ).

3 . The database method according to claim 1 , wherein the matching master ID is assigned to a plurality of basic data, wherein the matching master ID is stored in those rows of the data table ( 14 ) in which the fields of the basic data are located, in another column which is not a data column of the data columns, master ID column ( 19 ).

4 . The database method according to claim 1 , wherein information about the at least one dimension is stored in an object table ( 15 ), wherein the object table ( 15 ) comprises an ID column ( 21 ) in which an ID associated with the at least one dimension is listed, and a name column ( 22 ) in which a name associated with the at least one dimension is listed.

5 . The database method according to claim 4 , wherein information about all objects stored in the data table ( 14 ) and all dimensions associated with basic data of the objects is stored in the object table ( 15 ), wherein the object IDs assigned to the objects are stored in the ID column ( 21 ) of the object table ( 15 ), and/or a row is provided in the object table ( 15 ) for each object and each dimension, and/or the object table ( 15 ) comprises a column in which it is indicated whether it is a dimension, dimension column ( 23 ).

6 . The database method according to claim 1 , wherein information about the structure of the objects is stored in a further table, field table ( 16 ), wherein the field table ( 16 ) comprises the information in which data column ( 17 ) or which data columns ( 17 ) of the data table ( 14 ) the basic data of the respective object are stored.

7 . The database method according to claim 6 , wherein the field table ( 16 ) comprises a column in which the names used in the data table ( 14 ) of those data columns ( 17 ) are specified in which basic data relating to the respective object are stored, field name column ( 25 ), and/or in that the field table ( 16 ) comprises a column in which it is specified basic data of which type are stored in the data column or the data columns of the respective object, label column ( 26 ), and/or in that the field table ( 16 ) comprises a column in which it is specified whether the basic data belonging to the object in the data columns ( 17 ) listed in the field name column ( 25 ) each have a dimension or not, dimension column ( 27 ), and/or in that the field table ( 16 ) comprises a column in which the object ID assigned to the respective object is specified, object ID column ( 28 ).

8 . The database method according to claim 1 , wherein relations existing between different objects are stored in a further table, relation table, wherein a relation ID and/or a relation type and/or an object ID and/or an object field ID are stored in the relation table for the respective relation.

9 . The database method according to claim 1 , wherein different instances are stored in a further table, instance table, and wherein an instance ID and/or an instance name and/or an instance license and/or a secret code are stored in the instance table for the respective instance.

10 . The database method according to claim 1 , wherein a dynamic script and/or a dynamic script generator is used for retrieving data from the data table ( 14 ).

11 . A system for data processing comprising at least one processor and at least one memory devices, wherein the at least one processor is configured to perform the steps of the method according to claim 1 .

12 . A computer program product comprising instructions which, when the computer program product is executed by at least one computer, cause the at least one computer to perform the steps of the method according to claim 1 .

13 . A non-transitory computer-readable storage medium comprising instructions which, when executed by at least one computer, cause the at least one computer to perform the steps of the method according to claim 1 .

14 . The database method according to claim 2 , wherein for data column fields with the basic data to which a dimension is assigned, it applies that in other data columns ( 17 ) which are provided for the basic data to which this dimension is not assigned, the fields in a same row remain empty or comprise empty entries, and/or that for data column fields with the basic data to which no dimension is assigned, it applies that no dimension IDs are stored in the dimension column ( 20 ) in the fields in the same row, but these in particular remain empty or comprise empty entries.

15 . The database method according to claim 2 , wherein the matching master ID is assigned to a plurality of basic data, wherein the matching master ID is stored in the rows of the data table ( 14 ) in which the fields of the basic data are located, in another column which is not a data column of the data columns, master ID column ( 19 ).

16 . The database method according to claim 1 , wherein the matching master ID is assigned to a plurality of basic data, wherein the matching master ID is stored in those the rows of the data table ( 14 ) in which the fields of the basic data are located, in another column which is not a data column of the data columns, master ID column ( 19 ).