Back to results
US 11,113,261 B2Granted
Data locking
AssigneeSap SE
InventorsRichard Pilz, Adrian Mocan, Katja Pfeifer, Tom Spiegler
Life of this patent
Estimating the term…
Abstract
A system and method to query, update, and reduce a size of locking data for a dataset including a fixed plurality of dimensions each having a fixed plurality of members comprising index tables for the dimensions and a locks table specifying one of a fixed plurality of lock states for the plurality of members, where the fixed plurality of members each have an associated index.
Claims15
A computer-implemented method to query a dataset, the method comprising:
- receiving, by a processor, a query to be executed against a dataset, the dataset comprising database data tables including a fixed plurality of dimensions each having a fixed plurality of members and a locks table specifying one of a fixed plurality of lock states for the plurality of members, the fixed plurality of members each having an associated index value defined by a database index table for each of the plurality of dimensions, and the query specifying a combination of at least two of the members;
- determining, by the processor, the associated index value for each of the members specified in the query based on an index table defined for each dimension;
- determining, by the processor and based on a combination of values for the indices associated with the members specified in the query, a lock state specified in the locks table for the combination of the at least two members specified in the query;
- generating a query result based on the lock state for the combination of the at least two members specified in the query;
- and
- storing a record of the query result in a memory.
3 more elements
A computing system to query a dataset, the system comprising:
- a storage device a dataset, the dataset comprising database data tables including a fixed plurality of dimensions each having a fixed plurality of members and a locks table specifying one of a fixed plurality of lock states for the plurality of members, the fixed plurality of members each having an associated index value defined by a database index table for each of the plurality of dimensions;
- a memory storing processor-executable program code;
- and
- a processor to execute the processor-executable program code in order to cause the computing system to:
- receive a query to be executed against the dataset, the query specifying a combination of at least two of the members;
- determine the associated index value for each of the members specified in the query based on an index table defined for each dimension;
- determine, based on a combination of values for the indices associated with the members specified in the query, a lock state specified in the locks table for the combination of the at least two members specified in the query;
- generate a query result based on the lock state for the combination of the at least two members specified in the query;
- and
- store a record of the query result in a memory.
7 more elements
A non-transitory computer readable medium having executable instructions stored thereon, that when executed by a processor, cause the processor to:
- receive a query to be executed against a dataset, the dataset comprising database data tables including a fixed plurality of dimensions each having a fixed plurality of members and a locks table specifying one of a fixed plurality of lock states for the plurality of members, the fixed plurality of members each having an associated index value defined by a database index table for each of the plurality of dimensions, and the query specifying a combination of at least two of the members;
- determine the associated index value for each of the members specified in the query based on an index table defined for each dimension;
- determine, based on a combination of values for the indices associated with the members specified in the query, a lock state specified in the locks table for the combination of the at least two members specified in the query;
- generate a query result based on the lock state for the combination of the at least two members specified in the query;
- and
- store a record of the query result in a memory.
3 more elements
Dependencies are inferred from the claim text.