Search International and National Patent Collections

1. (WO2017019881) MATERIALIZING EXPRESSIONS WITHIN IN-MEMORY VIRTUAL COLUMN UNITS TO ACCELERATE ANALYTIC QUERIES

Pub. No.:    WO/2017/019881    International Application No.:    PCT/US2016/044523
Publication Date: Fri Feb 03 00:59:59 CET 2017 International Filing Date: Fri Jul 29 01:59:59 CEST 2016
IPC: G06F 17/30
Applicants: ORACLE INTERNATIONAL CORPORATION
Inventors: MISHRA, Aurosish
CHAVAN, Shasank K.
HOLLOWAY, Allison L.
KAMP, Jesse
KUMAR, Ramesh
LIU, Zhen Hua
MUKHERJEE, Niloy
GANESH, Amit
LAHIRI, Tirthankar
MARWAH, Vineet
Title: MATERIALIZING EXPRESSIONS WITHIN IN-MEMORY VIRTUAL COLUMN UNITS TO ACCELERATE ANALYTIC QUERIES
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.