公开(公告)号：WO2015042072A1

公开(公告)日：2015-03-26

申请号：PCT/US2014/055946

申请日：2014-09-16

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： LAHIRI, Tirthankar ,  REAMES, Martin, A. ,  EDSON, Kirk ,  GOYAL, Neelam ,  MAKINO, Kao ,  PATTHAK, Anindya ,  THOMAS, Dina ,  SARKAR, Subhradyuti ,  HOANG, Chi-Kim ,  JIANG, Qingchun

IPC: G06F17/30

CPC classification number: G06F17/30292 ,  G06F17/30289 ,  G06F17/30584

Abstract: 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.

Abstract translation: 表的列以存储器内DBA中的行主格式或列主格式存储。 对于给定的表，一列列以列主格式存储; 表的另一组列以行主格式存储。 这种存储表的​​列的方式在本文中被称为双主格式。 此外，双主表中的一行更新为“就地”，即直接对列主列进行更新，而不创建该行的主列列的主要行。 用户可以提交数据库定义语言（“DDL”）命令，声明表的行主列和列主列。