Invention Grant
- Patent Title: Materializing internal computations in-memory to improve query performance
-
Application No.: US16365271Application Date: 2019-03-26
-
Publication No.: US11238039B2Publication Date: 2022-02-01
- Inventor: Shasank K. Chavan , Aurosish Mishra , Amit Ganesh
- Applicant: Oracle International Corporation
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Hickman Becker Bingham Ledesma LLP
- Main IPC: G06F16/245
- IPC: G06F16/245 ; G06F16/2453 ; G06F16/23 ; G06F16/22 ; G06F16/2455 ; G06F12/0802

Abstract:
Techniques are described for materializing computations in memory. In an embodiment, responsive to a database server instance receiving a query, the database server instance identifies a set of computations for evaluation during execution of the query. Responsive to identifying the set of computations, the database server instance evaluates at least one computation in the set of computations to obtain a first set of computation results for a first computation in the set of computations. After evaluating the at least one computation, the database server instance stores, within an in-memory unit, the first set of computation results. The database server also stores mapping data that maps a set of metadata values associated with the first computation to the first set of computation results.
Public/Granted literature
- US20190220461A1 MATERIALIZING INTERNAL COMPUTATIONS IN-MEMORY TO IMPROVE QUERY PERFORMANCE Public/Granted day:2019-07-18
Information query