Ergebniscache mit Hierarchiefunktion und Dynamischen Bedingungen

Details

Veröffentlichungs-Nr.

EP4811158

Anmeldetag

21. Oktober 2025

Veröffentlichung

23. September 2026

Rechtsraum

EP

IPC

G06F16/2453, G06F16/2455

Abstract

Methods, systems, and computer-readable storage media for a hierarchy function result cache that supports dynamic conditions. An example method includes identifying, in a database system, a request to execute a query that includes a hierarchy function. Dependency objects of the hierarchy function are collected. In response to determining that each dependency object is cacheable, dynamic condition information is collected that includes dynamic conditions of the collected dependency objects and corresponding objects of the dynamic conditions. A cache key is generated based on the collected dependency objects and collected dynamic condition information. A hierarchy function result cache is searched for a cache result that matches the cache key. In response to locating the cache result that matches the cache key, the cache result is identified as a hierarchy function result without executing the hierarchy function. The hierarchy function result us used to generate a query result for the query.

Anmelder

Firma

SAP SE

Land

🇩🇪 Deutschland

Fachgebiete