Oracle International Corporation

Kao Makino

Tirthankar Lahiri

Martin Reames

Anindya Chandra Patthak

Chi-Kim Hoang

Dina Thomas

Kirk Meredith Edson

Subhradyuti Sarkar

Neelam Goyal

Qingchun Jiang

Ananth Raghavan

Chih-Ping Wang

Mutsumi Kogawa

Jorge Luis Issa Garcia

Martin A Reames

Columns of a table are stored in either row-major format or column-major format in an in-memory DBMS. For a given table, one set of columns is stored in column-major format; another set of columns for a table are stored in row-major format. This way of storing columns of a table is referred to herein as dual-major format. In addition, a row in a dual-major table is updated 'in-place', that is, updates are made directly to column-major columns without creating an interim row-major form of the column-major columns of the row. Users may submit database definition language (“DDL”) commands that declare the row-major columns and column-major columns of a table.

Combined row and columnar storage for in-memory databases for OLTP and analytics workloads

In an in-memory database management system, non-volatile random access memories (NVRAMs) are used to store database data and control data. Because this data is stored in NVRAM, the data survives system failures. Recovery from a system failure may be accomplished more quickly by, at least in part, modifying the surviving data in NVRAM, rather than loading an entire checkpoint image and applying uncheckpointed transactions needed to synchronize the database. Because in this form of recovery the database state that serves as the starting point for applying change records is the database as stored in the NVRAM, this form of recovery is referred to herein as in-memory-based recovery. Recovery, where the database state that serves as the starting point for applying change records is a checkpoint image, is referred to herein as checkpointed-based recovery. In-memory-based recovery eliminates or reduces the need to perform certain operations that are performed for checkpointed-based recovery.

Using non-volatile memory to improve the availability of an in-memory database

Columns of a table are stored in either row-major format or column-major format in an in-memory DBMS. For a given table, one set of columns is stored in column-major format; another set of columns for a table are stored in row-major format. This way of storing columns of a table is referred to herein as dual-major format. In addition, a row in a dual-major table is updated 'in-place', that is, updates are made directly to column-major columns without creating an interim row-major form of the column-major columns of the row. Users may submit database definition language ('DDL') commands that declare the row-major columns and column-major columns of a table.

Growing community of inventors

San Carlos, CA, United States of America

Kao Makino