Patent · US Active

Optimizing database queries

US11475004B2 · kind B2 · utility

0Cited by

2References

20Claims

0Family size

Assignee

SAP SE · DE

Inventors

Maik Goergens · Jena, DE
Jonathan Dees · Karlsruhe, DE

Key dates

Filing date	Sep 12, 2017
Grant date	Oct 18, 2022
Priority date	—
Expiry date	Jul 30, 2038

Classification

Technology area (CPC G)Physics
CPC primaryG06F16/24524
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

Various examples are directed to systems and methods optimizing database queries. A database management system may receive a first query comprising a plurality of query expressions. The database management system may determine that a first expression of the first query is nullable and that the first expression is null preserving. The database management system may generate optimized query code for the first query. The optimized query code may comprise a first code segment and a conditional jump instruction. The first code segment that, when executed by a processor, may cause the processor to perform operations comprising determining a value of the first expression. The conditional jump instruction may, when executed by the processor, cause the processor to perform operations comprising: skipping execution of at least a portion of the first code segment and returning null for the first expression.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.