Patent · US Active

On-demand access of database table partitions

US12118003B2 · kind B2 · utility

1Cited by

1References

19Claims

0Family size

Assignee

SAP SE · DE

Inventors

Till Merker · Sandhausen, DE
Paul Willems · Heidelberg, DE
Manuel Mayr · Walldorf, DE

Key dates

Filing date	Mar 2, 2022
Grant date	Oct 15, 2024
Priority date	—
Expiry date	Mar 2, 2042

Classification

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

Abstract

A method for on-demand access to table partitions may include receiving, at a data execution engine, a query accessing a database table divided into a first partition and a second partition stored at different nodes of the database. The data execution engine may respond to the query by acquiring a lock on the database table and instantiating data structures to support the execution of the query without loading any of the partitions of the database table into a main memory. Instead, the loading of the individual partitions of the database table may be delegated to the operators tasked with performing the operations included in the execution plan for the query. Each operator may refrain from loading those partitions of the database table that are determined to be unnecessary for performing the individual operations. Related systems and computer program products are also provided.

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