公开(公告)号：WO2013086384A1

公开(公告)日：2013-06-13

申请号：PCT/US2012/068531

申请日：2012-12-07

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： ELLISON, Lawrence J. ,  GANESH, Amit ,  MARWAH, Vineet ,  KAMP, Jesse ,  PATTHAK, Anindya C. ,  CHAVAN, Shasank K. ,  GLEESON, Michael J. ,  HOLLOWAY, Allison L. ,  BHATTACHARYYA, Manosiz

IPC: G06F17/30

CPC classification number: G06F17/30315 ,  G06F9/3887 ,  G06F17/30339 ,  G06F17/30595

Abstract: Techniques are provided for more efficiently using the bandwidth of the I/O path between a CPU and volatile memory during the performance of database operation. Relational data from a relational table is stored in volatile memory as column vectors, where each column vector contains values for a particular column of the table. A binary-comparable format may be used to represent each value within a column vector, regardless of the data type associated with the column. The column vectors may be compressed and/or encoded while in volatile memory, and decompressed/decoded on-the-fly within the CPU. Alternatively, the CPU may be designed to perform operations directly on the compressed and/or encoded column vector data. In addition, techniques are described that enable the CPU to perform vector processing operations on the column vector values.

Abstract translation: 在执行数据库操作期间，提供了技术来更有效地使用CPU和易失性存储器之间的I / O路径的带宽。 来自关系表的关系数据作为列向量存储在易失性存储器中，其中每个列向量包含表的特定列的值。 可以使用二进制可比较的格式来表示列向量中的每个值，而不管与列相关联的数据类型如何。 列向量可以在易失性存储器中被压缩和/或编码，并且在CPU内部实时解压缩/解码。 或者，CPU可以被设计为直接对压缩和/或编码的列向量数据执行操作。 另外，描述使CPU能够对列向量值执行向量处理操作的技术。

公开(公告)号：WO2013086380A1

公开(公告)日：2013-06-13

申请号：PCT/US2012/068526

申请日：2012-12-07

Applicant: ORACLE INTERNATIONAL CORPORATION

Inventor： ELLISON, Lawrence J. ,  GANESH, Amit ,  MARWAH, Vineet ,  KAMP, Jesse ,  PATTHAK, Anindya C. ,  CHAVAN, Shasank K. ,  GLEESON, Michael J. ,  HOLLOWAY, Allison L. ,  BHATTACHARYYA, Manosiz

IPC: G06F17/30

CPC classification number: G06F17/30315 ,  G06F9/3887 ,  G06F17/30339 ,  G06F17/30595

Abstract: Techniques are provided for more efficiently using the bandwidth of the I/O path between a CPU and volatile memory during the performance of database operation. Relational data from a relational table is stored in volatile memory as column vectors, where each column vector contains values for a particular column of the table. A binary-comparable format may be used to represent each value within a column vector, regardless of the data type associated with the column. The column vectors may be compressed and/or encoded while in volatile memory, and decompressed/decoded on-the-fly within the CPU. Alternatively, the CPU may be designed to perform operations directly on the compressed and/or encoded column vector data. In addition, techniques are described that enable the CPU to perform vector processing operations on the column vector values.

Abstract translation: 在执行数据库操作期间，提供了技术来更有效地使用CPU和易失性存储器之间的I / O路径的带宽。 来自关系表的关系数据作为列向量存储在易失性存储器中，其中每个列向量包含表的特定列的值。 可以使用二进制可比较的格式来表示列向量中的每个值，而不管与列相关联的数据类型如何。 列向量可以在易失性存储器中被压缩和/或编码，并且在CPU内部实时解压缩/解码。 或者，CPU可以被设计为直接对压缩和/或编码的列向量数据执行操作。 另外，描述使CPU能够对列向量值执行向量处理操作的技术。

公开(公告)号：EP2788902B1

公开(公告)日：2019-04-17

申请号：EP12809436.4

申请日：2012-12-07

Applicant: Oracle International Corporation

Inventor： ELLISON, Lawrence J. ,  GANESH, Amit ,  MARWAH, Vineet ,  KAMP, Jesse ,  PATTHAK, Anindya C. ,  CHAVAN, Shasank K. ,  GLEESON, Michael J. ,  HOLLOWAY, Allison L. ,  BHATTACHARYYA, Manosiz

IPC: G06F17/30

公开(公告)号：EP2788902A1

公开(公告)日：2014-10-15

申请号：EP12809436.4

申请日：2012-12-07

Applicant: Oracle International Corporation

Inventor： ELLISON, Lawrence J. ,  GANESH, Amit ,  MARWAH, Vineet ,  KAMP, Jesse ,  PATTHAK, Anindya C. ,  CHAVAN, Shasank K. ,  GLEESON, Michael J. ,  HOLLOWAY, Allison L. ,  BHATTACHARYYA, Manosiz

IPC: G06F17/30

CPC classification number: G06F17/30315 ,  G06F9/3887 ,  G06F17/30339 ,  G06F17/30595

Abstract: Techniques are provided for more efficiently using the bandwidth of the I/O path between a CPU and volatile memory during the performance of database operation. Relational data from a relational table is stored in volatile memory as column vectors, where each column vector contains values for a particular column of the table. A binary-comparable format may be used to represent each value within a column vector, regardless of the data type associated with the column. The column vectors may be compressed and/or encoded while in volatile memory, and decompressed/decoded on-the-fly within the CPU. Alternatively, the CPU may be designed to perform operations directly on the compressed and/or encoded column vector data. In addition, techniques are described that enable the CPU to perform vector processing operations on the column vector values.

公开(公告)号：EP2788901A1

公开(公告)日：2014-10-15

申请号：EP12809022.2

申请日：2012-12-07

Applicant: Oracle International Corporation

Inventor： ELLISON, Lawrence J. ,  GANESH, Amit ,  MARWAH, Vineet ,  KAMP, Jesse ,  PATTHAK, Anindya C. ,  CHAVAN, Shasank K. ,  GLEESON, Michael J. ,  HOLLOWAY, Allison L. ,  BHATTACHARYYA, Manosiz

IPC: G06F17/30

CPC classification number: G06F17/30315 ,  G06F9/3887 ,  G06F17/30339 ,  G06F17/30595

Abstract: Techniques are provided for more efficiently using the bandwidth of the I/O path between a CPU and volatile memory during the performance of database operation. Relational data from a relational table is stored in volatile memory as column vectors, where each column vector contains values for a particular column of the table. A binary-comparable format may be used to represent each value within a column vector, regardless of the data type associated with the column. The column vectors may be compressed and/or encoded while in volatile memory, and decompressed/decoded on-the-fly within the CPU. Alternatively, the CPU may be designed to perform operations directly on the compressed and/or encoded column vector data. In addition, techniques are described that enable the CPU to perform vector processing operations on the column vector values.