公开(公告)号：US20250086176A1

公开(公告)日：2025-03-13

申请号：US18638931

申请日：2024-04-18

Applicant: Oracle International Corporation

Inventor： Lawrence Lim ,  Laleh Aghababaie Beni ,  Garret F. Swart

IPC: G06F16/2453 ,  G06F11/34 ,  G06F16/2452

Abstract: In a computer, each of many statement plan trees respectively represents a distinct database statement in a database workload. Each statement plan tree contains a distinct set of tree nodes. A first statement plan tree contains a first subtree and represents a first statement. A second statement plan tree contains a second subtree, and a third statement plan tree contains a third subtree. By agglomeration, a first cluster subplan is generated that represents the first subtree of the first statement plan tree and the second subtree of the second statement plan tree. By subsequent agglomeration, a second cluster subplan is generated that represents the third subtree of the third statement plan tree and the first cluster subplan. Execution of the first database statement uses the second cluster subplan for acceleration. Agglomeration may be decided based on novel net benefit estimation, novel inter-cluster distance, and a novel and tunable compilation cost.