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 …
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
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 …
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 …
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 …
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 …
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 …
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 …
database system. In one embodiment, a plurality of in-memory chunks are maintained on a …
Optimizing execution plans for in-memory-aware joins
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 …
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 …
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 …
a particular data object that contains particular data formatted different from column-major …