Invention Grant
- Patent Title: Auto unload
-
Application No.: US15945715Application Date: 2018-04-04
-
Publication No.: US10706035B2Publication Date: 2020-07-07
- Inventor: Klaus Otto Mueller , Thomas Legler
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Mintz, Levin, Cohn, Ferris, Glovsky and Popeo, P.C
- Agent Pedro Suarez; Paul Brockland
- Main IPC: G06F16/22
- IPC: G06F16/22 ; G06F16/23 ; G06F16/2458 ; G06F9/445

Abstract:
A system for unloading tables of a database is provided. In some aspects, the system performs operations including determining that a number of accesses to a table occurring within a time period has satisfied an access threshold. The operations may further include identifying, in response to the determining, a first timestamp indicating a most recent access to the table. The operations may further include determining whether a difference between a current timestamp and the first timestamp satisfies a first time threshold. The operations may further include comparing, in response to the difference satisfying the first time threshold, a ratio of the difference and a size of the table to a ratio threshold. The operations may further include unloading, in response to satisfying the ratio threshold, the table. The operations may further include adjusting, based on the feedback, the first time threshold and/or the ratio threshold.
Public/Granted literature
- US20190311052A1 Auto Unload Public/Granted day:2019-10-10
Information query