Invention Grant
- Patent Title: Efficiently accessing shared operators in database query plans
-
Application No.: US17985294Application Date: 2022-11-11
-
Publication No.: US12135713B2Publication Date: 2024-11-05
- Inventor: Yinghua Ouyang
- Applicant: SAP SE
- Applicant Address: DE Walldorf
- Assignee: SAP SE
- Current Assignee: SAP SE
- Current Assignee Address: DE Walldorf
- Agency: Fish & Richardson P.C.
- Main IPC: G06F16/2453
- IPC: G06F16/2453 ; G06F11/34

Abstract:
The present disclosure involves systems, software, and computer implemented methods for efficiently accessing shared operators in database query plans. One example method includes identifying a query plan tree that represents a query plan for a database query. A node identifier of each node of the query plan tree is initialized to a default node identifier value and a global node identifier counter for the query plan tree is initialized. The query plan tree is traversed including determining whether a node identifier of a current node equals the default node identifier value. If the node identifier of the current node equals the default node identifier value, the current node is processed, the node identifier of the current node is set to a current value of the global node identifier counter, and the global node identifier counter is incremented. Otherwise processing of the current node is skipped.
Public/Granted literature
- US20240160627A1 EFFICIENTLY ACCESSING SHARED OPERATORS IN DATABASE QUERY PLANS Public/Granted day:2024-05-16
Information query