公开(公告)号：WO2013033030A1

公开(公告)日：2013-03-07

申请号：PCT/US2012/052547

申请日：2012-08-27

Applicant: ORACLE INTERNATIONAL CORPORATION ,  LAHIRI, Tirthankar ,  HOANG, Chi-Kim ,  THOMAS, Dina ,  EDSON, Kirk Meredith ,  SARKAR, Subhradyuti ,  MCAULIFFE, Mark ,  NEIMAT, Marie-Anne ,  WANG, Chih-Ping

Inventor： LAHIRI, Tirthankar ,  HOANG, Chi-Kim ,  THOMAS, Dina ,  EDSON, Kirk Meredith ,  SARKAR, Subhradyuti ,  MCAULIFFE, Mark ,  NEIMAT, Marie-Anne ,  WANG, Chih-Ping

IPC: G06F17/30 ,  H03M7/42 ,  H03M7/30 ,  G06F7/00

CPC classification number: H03M7/42 ,  G06F17/30315 ,  H03M7/3088

Abstract: In column domain dictionary compression, column values in one or more columns are tokenized by a single dictionary. The domain of the dictionary is the entire set of columns. A dictionary may not only map a token to a tokenized value, but also to a count ("token count") of the number of occurrences of the token and corresponding tokenized value in the dictionary's domain. Such information may be used to compute queries on the base table.

Abstract translation: 在列域字典压缩中，一个或多个列中的列值由单个字典进行标记化。 字典的域是整个列的集合。 字典不仅可以将令牌映射到标记值，还可以映射令牌的出现次数和字典域中相应的标记值的计数（“令牌计数”）。 此类信息可用于计算基表上的查询。

公开(公告)号：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”）命令，声明表的行主列和列主列。

公开(公告)号：EP3047398A1

公开(公告)日：2016-07-27

申请号：EP14781740.7

申请日：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

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: 表的列存储在行主要格式要么或列优先格式在内存中的DBMS。 对于给定的表，一组列的存储在列优先格式; 另一组为表列存储在行主要格式。 存储表的列的这种方式被称为双大格式输入。 此外，在双主表中的一行被更新“就地”，也就是，更新直接向列为主列，而无需创建临时到行主行的列为主列的形式。 用户可以提交数据库定义语言（“DDL”）命令没有申报行主柱和一个表的列主列。

公开(公告)号：EP3047398B1

公开(公告)日：2019-11-13

申请号：EP14781740.7

申请日：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: G06F16/21