Memory-aware joins based in a database cluster

N Mukherjee, M Zait, J Loaiza, V Marwah… - US Patent …, 2018 - Google Patents
Techniques are described herein for distributing data from one or more partitioned tables
across the volatile memories of a cluster. In memory copies of data from partitioned tables …

Techniques for evaluating query predicates during in-memory table scans

D Das, J Yan, M Zait, N Vyas - US Patent 10,025,823, 2018 - Google Patents
Techniques are described herein for filtering data from a table during an in-memory scan.
Predicates are pushed to in-memory scan to avoid scanning unnecessary columnar units …

Core in-memory space and object management architecture in a traditional RDBMS supporting DW and OLTP applications

N Mukherjee, A Ganesh, V Marwah, J Kamp - US Patent 9,430,390, 2016 - Google Patents
Techniques are provided for managing in-memory space and objects. In one embodiment, a
set of in-memory objects are maintained within an area in volatile memory that is accessible …

Mirroring, in memory, data from disk to improve query performance

J Kamp, A Ganesh, V Marwah, V Raja, T Lahiri… - US Patent …, 2016 - Google Patents
Techniques are provided for maintaining data persistently in one format, but making that
data available to a database server in more than one format. For example, one of the formats …

Multi-version concurrency control on in-memory snapshot store of oracle in-memory database

V Raja, S Hase, A Ganesh, V Marwah, S Su… - US Patent …, 2015 - Google Patents
Techniques are provided for maintaining data persistently in one format, but making that
data available to a database server in more than one format. For example, one of the formats …

Methods and systems for fast set-membership tests using one or more processors that support single instruction multiple data instructions

SK Chavan, P Watanaprakornkul - US Patent 9,886,459, 2018 - Google Patents
Methods and apparatuses for determining set-membership using Single Instruction Multiple
Data (“SIMD”) architecture are presented herein. Specifically, methods and apparatuses are …

Framework for numa affinitized parallel query on in-memory objects within the RDBMS

N Mukherjee, A Ganesh, V Marwah - US Patent 9,378,232, 2016 - Google Patents
Techniques are provided for performing parallel processing on in-memory objects within a
database system. In one embodiment, a plurality of in-memory chunks are maintained on a …

Optimizing execution plans for in-memory-aware joins

D Das, M Zait, J Yan, N Mukherjee - US Patent 10,025,822, 2018 - Google Patents
Techniques are described herein for accurately estimating the cost of performing a join
against “mirror format” data that is at least partially located in volatile memory. Mirror format …

Multi-instance redo apply

A Srivastava, Y Li, MB Girkar - US Patent 9,767,178, 2017 - Google Patents
A method, apparatus, and system for multi-instance redo apply is provided for standby
databases. A multi-instance primary database generates a plurality of redo records, which …

Granular creation and refresh of columnar data

J Kamp, V Marwah, A Ganesh, M Gleeson… - US Patent …, 2017 - Google Patents
Techniques are provided for granular load and refresh of columnar data. In an embodiment,
a particular data object that contains particular data formatted different from column-major …