Invention Grant
- Patent Title: Materializing internal computations in-memory to improve query performance
-
Application No.: US15146801Application Date: 2016-05-04
-
Publication No.: US10366083B2Publication Date: 2019-07-30
- 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 Palermo Becker Bingham LLP
- Main IPC: G06F17/30
- IPC: G06F17/30 ; 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
- US20170031976A1 MATERIALIZING INTERNAL COMPUTATIONS IN-MEMORY TO IMPROVE QUERY PERFORMANCE Public/Granted day:2017-02-02
Information query