Invention Grant
- Patent Title: Multi-user database execution plan caching
-
Application No.: US15615504Application Date: 2017-06-06
-
Publication No.: US10459889B2Publication Date: 2019-10-29
- Inventor: Jaeyun Noh , Taesik Yoon , Eun Kyung Chi
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Klarquist Sparkman, LLP
- Main IPC: G06F16/00
- IPC: G06F16/00 ; G06F16/176 ; G06F16/242 ; G06F16/2453 ; G06F16/2455 ; G06F16/2452

Abstract:
Technologies are provided for using a multi-user execution plan cache to process database queries. A database query processor can be configured to store execution plans in a multi-user execution plan cache. The query processor can determine whether an execution plan is shareable by multiple database users. If the execution plan is shareable, it can be stored in the cache in association with a sharing user identifier. When a database query is received, the query processor can determine that the query can be performed using the cached execution plan. If the cached execution plan is shareable, the database query can determine whether the cached execution plan is valid for a database user associated with the received database query. If the cached execution plan is valid for the database user, the query processor uses the cached execution plan to perform the query for the associated database user.
Public/Granted literature
- US20180349404A1 MULTI-USER DATABASE EXECUTION PLAN CACHING Public/Granted day:2018-12-06
Information query