Optimierung des Datenzugriffs auf Basis von Datenalterung

Details

Veröffentlichungs-Nr.

EP3336720

Aktenzeichen

EP17001958

Anmeldetag

29. November 2017

Veröffentlichung

21. Januar 2026

Erteilung

21. Januar 2026

Rechtsraum

EP

IPC

G06F16/22G06F16/21G06F16/2458

Abstract

A database includes a plurality of partitions with respective partition dates. A query is received for data from a view of the database, the query containing a filtering parameter for retrieval of the data. A definition of the view is analyzed to determine a table of the database that contributes to the view and an aging object associated with the table. A restriction rule associated with the aging object is identified, for example, based on an annotation in the definition of the view. A restriction date for the aging object is determined based on the restriction rule. A partition, from the plurality of partitions, is selected based on the partition date of the partition being equal to or later than the restriction date. The queried data is retrieved from the selected partition according to the filtering parameter and a response to the query is generated based on the retrieved data.

Anmelder

Firma

SAP SE

Land

🇩🇪 Deutschland

Fachgebiete