The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.

The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.

Date of Patent:
Oct. 29, 2019

Filed:

Jun. 06, 2017
Applicant:

Sap SE, Walldorf, DE;

Inventors:

Jaeyun Noh, Seoul, KR;

Taesik Yoon, Seoul, KR;

Eun Kyung Chi, Seoul, KR;

Assignee:

SAP SE, Walldorf, DE;

Attorney:
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/00 (2019.01); G06F 16/176 (2019.01); G06F 16/242 (2019.01); G06F 16/2453 (2019.01); G06F 16/2455 (2019.01); G06F 16/2452 (2019.01);
U.S. Cl.
CPC ...
G06F 16/176 (2019.01); G06F 16/244 (2019.01); G06F 16/24524 (2019.01); G06F 16/24534 (2019.01); G06F 16/24539 (2019.01); G06F 16/24557 (2019.01);
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.


Find Patent Forward Citations

Loading…