IP Library › Granted Patent US 10,671,625
Granted Patent B2
US 10,671,625 · App. 15/416,729 · Granted Jun 2, 2020

Processing a query primitive call on a value identifier set

Inventors: Robert Schulze (Walldorf, DE); Oliver Horn (Walldorf, DE); Klaus Otto Mueller (Karlsruhe, DE)
Assignee: SAP SE
G06F16/248G06F16/2455G06F16/258G06F16/24542
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 10,671,625
App. No.
15/416,729
Granted
Jun 2, 2020
Kind
B2
Abstract

In some example embodiments, a system is provided for executing a primitive call that implements a query operation. The system may include a data processor and a memory. The memory may store instructions that result in operations when executed by the data processor. The operations may include: executing, at an data management engine, the primitive call by at least performing a first operation with respect to a value identifier set, the value identifier set including one or more value identifiers, and the primitive call being configured to access a database storing a plurality of value identifiers; and generating, based at least on a result of the first operation, a result for the primitive call. Related methods and articles of manufacture, including computer program products, are also described.

Claims (37)

1. A system comprising:

at least one data processor; and

at least one memory storing instructions which, when executed by the at least one data processor, result in operations comprising:

converting a value identifier set from a first representation to a second representation, the value identifier set including one or more value identifiers, the first representation of the value identifier set comprising a bit vector including a first value to indicating one or more value identifiers present in the value identifier set and a second value indicating one or more value identifiers absent from the value identifier set, and the second representation comprising a ranges vector enumerating one or more ranges formed by the one or more value identifiers present in the value identifier set; and

executing a primitive call accessing a database storing a plurality of value identifiers mapped to a corresponding plurality of data values, the executing of the primitive call includes performing one or more operations on the converted value identifier set.

2. The system of claim 1 , wherein the value identifier set comprises at least one of an input and a result of the primitive call.

3. The system of claim 1 , further comprising:

converting the value identifier set from the second representation to a third representation comprising a vector, the vector indicating the one or more values identifiers present in the value identifier set by at least enumerating each of the one or more value identifiers.

4. The system of claim 1 , wherein the first representation is used at a query execution engine from which the data management engine receives the primitive call, and wherein the data management engine is configured to execute the primitive call based at least on the second representation of the value identifier set.

5. The system of claim 1 , further comprising:

iterating the value identifier set to at least retrieve, from the value identifier set, the one or more value identifiers present in the value identifier set.

6. The system of claim 1 , further comprising:

determining, based at least on an indicator associated with the value identifier set, whether the one or more value identifiers are included in the value identifier set is sorted.

7. The system of claim 1 , further comprising:

determining, based at least on a first indicator associated with the first representation of the value identifier set or a second indicator association with the second representation of the value identifier set, whether a specific value identifier is included in the value identifier set.

8. The system of claim 1 , further comprising:

determining, based at least on a first indicator associated with the first representation of the value identifier set or a second indicator association with the second representation of the value identifier set, a quantity of value identifiers included in the value identifier set.

9. The system of claim 1 , wherein the primitive call implements a query operation on data at a database coupled with the data management engine.

10. The system of claim 1 , wherein the ranges vector includes a lower bound and an upper bound associated with each of the plurality of ranges.

11. A computer-implemented method, comprising:

converting a value identifier set from a first representation to a second representation, the value identifier set including one or more value identifiers, the first representation of the value identifier set comprising a bit vector including a first value to indicating one or more value identifiers present in the value identifier set and a second value indicating one or more value identifiers absent from the value identifier set, and the second representation comprising a ranges vector enumerating one or more ranges formed by the one or more value identifiers present in the value identifier set; and

executing a primitive call accessing a database storing a plurality of value identifiers mapped to a corresponding plurality of data values, the executing of the primitive call includes performing one or more operations on the converted value identifier set.

12. The method of claim 11 , wherein the value identifier set comprises at least one of an input and a result of the primitive call.

13. The method of claim 11 , further comprising:

converting the value identifier set from the second representation to a third representation comprising a vector, the vector indicating the one or more values identifiers present in the value identifier set by at least enumerating each of the one or more value identifiers.

14. The method of claim 11 , further comprising:

iterating the value identifier set to at least retrieve, from the value identifier set, the one or more value identifiers present in the value identifier set.

15. The method of claim 11 , further comprising:

determining, based at least on an indicator associated with the value identifier set, whether the one or more value identifiers are included in the value identifier set is sorted.

16. The method of claim 11 , further comprising:

determining, based at least on a first indicator associated with the first representation of the value identifier set or a second indicator association with the second representation of the value identifier set, whether a specific value identifier is included in the value identifier set.

17. The method of claim 11 , further comprising:

determining, based at least on a first indicator associated with the first representation of the value identifier set or a second indicator association with the second representation of the value identifier set, a quantity of value identifiers included in the value identifier set.

18. The method of claim 11 , wherein the primitive call implements a query operation on data at a database coupled with the data management engine.

19. A non-transitory computer readable medium storing instructions, which, when executed by at least one data processor forming at least one computing system, results in operations comprising:

converting a value identifier set from a first representation to a second representation, the value identifier set including one or more value identifiers, the first representation of the value identifier set comprising a bit vector including a first value to indicating one or more value identifiers present in the value identifier set and a second value indicating one or more value identifiers absent from the value identifier set, and the second representation comprising a ranges vector enumerating one or more ranges formed by the one or more value identifiers present in the value identifier set; and

executing a primitive call accessing a database storing a plurality of value identifiers mapped to a corresponding plurality of data values, the executing of the primitive call includes performing one or more operations on the converted value identifier set.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Jan 26, 2017
From: SCHULZE, ROBERT; HORN, OLIVER; MUELLER, KLAUS OTTO
To: SAP SE
Reel/Frame 041096/0004 →
Continuity (1)
Related Publication 20180210926A1 · Jul 26, 2018
Cited By (3)
US 12,197,453 US 12,579,110 US 12,632,422