Invention Grant
- Patent Title: Materializing expressions within in-memory virtual column units to accelerate analytic queries
-
Application No.: US15146799Application Date: 2016-05-04
-
Publication No.: US10204135B2Publication Date: 2019-02-12
- Inventor: Aurosish Mishra , Shasank K. Chavan , Allison L. Holloway , Jesse Kamp , Ramesh Kumar , Zhen Hua Liu , Niloy Mukherjee , Amit Ganesh , Tirthankar Lahiri , Vineet Marwah
- 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

Abstract:
Techniques are described for materializing pre-computed results of expressions. In an embodiment, a set of one or more column units are stored in volatile or non-volatile memory. Each column unit corresponds to a column that belongs to an on-disk table within a database managed by a database server instance and includes data items from the corresponding column. A set of one or more virtual column units, and data that associates the set of one or more column units with the set of one or more virtual column units, are also stored in memory. The set of one or more virtual column units includes a particular virtual column unit storing results that are derived by evaluating an expression on at least one column of the on-disk table.
Public/Granted literature
- US20170031975A1 MATERIALIZING EXPRESSIONS WITHIN IN-MEMORY VIRTUAL COLUMN UNITS TO ACCELERATE ANALYTIC QUERIES Public/Granted day:2017-02-02
Information query