Optimizing data access based on data aging

US10346418B2 · kind B2 · utility

Assignee

• SAP SE · DE

Inventors

• Ralf Dentzer · Hockenheim, DE
• Axel Herbst · Eppingen, DE

Key dates

• Filing date: Dec 16, 2016
• Grant date: Jul 9, 2019
• Expiry date: Nov 7, 2037

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F16/2291
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

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.