DATABASE SYSTEM TRANSACTION MANAGEMENT
    1.
    发明申请
    DATABASE SYSTEM TRANSACTION MANAGEMENT 有权
    数据库系统交易管理

    公开(公告)号:US20130262424A1

    公开(公告)日:2013-10-03

    申请号:US13435281

    申请日:2012-03-30

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30351

    摘要: Systems, methods, and products for database system transaction management are provided herein. One aspect provides for annotating via a computing device at least one data object residing on the computing device utilizing at least one transaction tag, the at least one transaction tag being configured to indicate a status of an associated data object; processing at least one database transaction utilizing a transactional memory process, wherein access to the at least one data object is determined based on the status of the at least one data object; and updating the status of the at least one data object responsive to an attempted access of the at least one data object by the at least one database transaction. Other embodiments and aspects are also described herein.

    摘要翻译: 本文提供了数据库系统事务管理的系统,方法和产品。 一个方面提供了一种使用至少一个交易标签通过计算设备对位于所述计算设备上的至少一个数据对象的注释,所述至少一个交易标签被配置为指示相关联的数据对象的状态; 使用事务性存储器处理来处理至少一个数据库事务,其中基于所述至少一个数据对象的状态来确定对所述至少一个数据对象的访问; 以及响应于所述至少一个数据库事务对所述至少一个数据对象的尝试访问来更新所述至少一个数据对象的状态。 本文还描述了其它实施例和方面。

    Hardware-accelerated relational joins
    3.
    发明授权
    Hardware-accelerated relational joins 有权
    硬件加速关系连接

    公开(公告)号:US08805850B2

    公开(公告)日:2014-08-12

    申请号:US13478507

    申请日:2012-05-23

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30498

    摘要: Techniques are provided for hardware-accelerated relational joins. A first table comprising one or more rows is processed through a hardware accelerator. At least one join column in at least one of the one or more rows of the first table is hashed to set at least one bit in at least one bit vector. A second table comprising one or more rows is processed through a hardware accelerator. At least one join column in at least one of the one or more rows of the second table is hashed to generate at least one hash value. At least one bit vector is probed using the at least one hash value. A joined row is constructed responsive to the probing step. The row-construction step is performed in the hardware accelerator.

    摘要翻译: 为硬件加速的关系连接提供了技术。 通过硬件加速器处理包括一行或多行的第一表。 在第一表的一行或多行中的至少一行中的至少一个连接列被散列以在至少一个位向量中设置至少一个位。 通过硬件加速器处理包括一行或多行的第二表。 第二表的一行或多行中的至少一行中的至少一个连接列被散列以生成至少一个散列值。 使用至少一个哈希值来探测至少一个比特向量。 响应于探测步骤构建连接的行。 行结构步骤在硬件加速器中执行。

    HARDWARE-ACCELERATED RELATIONAL JOINS
    4.
    发明申请
    HARDWARE-ACCELERATED RELATIONAL JOINS 有权
    硬件加速关系

    公开(公告)号:US20130318067A1

    公开(公告)日:2013-11-28

    申请号:US13478507

    申请日:2012-05-23

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30498

    摘要: Techniques are provided for hardware-accelerated relational joins. A first table comprising one or more rows is processed through a hardware accelerator. At least one join column in at least one of the one or more rows of the first table is hashed to set at least one bit in at least one bit vector. A second table comprising one or more rows is processed through a hardware accelerator. At least one join column in at least one of the one or more rows of the second table is hashed to generate at least one hash value. At least one bit vector is probed using the at least one hash value. A joined row is constructed responsive to the probing step. The row-construction step is performed in the hardware accelerator.

    摘要翻译: 为硬件加速的关系连接提供了技术。 通过硬件加速器处理包括一行或多行的第一表。 在第一表的一行或多行中的至少一行中的至少一个连接列被散列以在至少一个位向量中设置至少一个位。 通过硬件加速器处理包括一行或多行的第二表。 第二表的一行或多行中的至少一行中的至少一个连接列被散列以生成至少一个散列值。 使用至少一个哈希值来探测至少一个比特向量。 响应于探测步骤构建连接的行。 行结构步骤在硬件加速器中执行。

    Encoded data processing
    5.
    发明授权
    Encoded data processing 有权
    编码数据处理

    公开(公告)号:US08832046B2

    公开(公告)日:2014-09-09

    申请号:US13617614

    申请日:2012-09-14

    IPC分类号: G06F17/00 G06F17/30 H03M7/30

    摘要: Techniques are provided for encoded data processing which allows for continuous data processing as encoded data changes. Data is decomposed into one or more blocks with each block containing at least one data record. At least one data record within a given block is encoded with a first encoding process selected from one or more encoding processes. The first encoding process is associated with the given data block. Techniques evaluate whether or not to implement an encoding change for a given block when updating a given data record in the given block. Responsive to the evaluation, the given block is re-encoded with a second encoding process. Responsive to the re-encoding, the association of the given block is updated. A map is formed to convert the given data record encoded with the first encoding process to the second encoding process so as to preserve comparative relationships of the given data record.

    摘要翻译: 为编码数据处理提供技术,其允许作为编码数据变化的连续数据处理。 数据被分解为一个或多个块,每个块包含至少一个数据记录。 使用从一个或多个编码过程中选择的第一编码过程对给定块内的至少一个数据记录进行编码。 第一编码过程与给定的数据块相关联。 技术评估在给定块中更新给定数据记录时是否实现给定块的编码更改。 响应于评估,给定的块用第二编码过程重新编码。 响应于重新编码,给定块的关联更新。 形成地图以将用第一编码处理编码的给定数据记录转换为第二编码处理,以便保持给定数据记录的比较关系。

    ACCELERATED ROW DECOMPRESSION
    7.
    发明申请
    ACCELERATED ROW DECOMPRESSION 有权
    加速方式解压缩

    公开(公告)号:US20140032516A1

    公开(公告)日:2014-01-30

    申请号:US13556648

    申请日:2012-07-24

    IPC分类号: G06F17/30

    摘要: An apparatus comprises a hardware accelerator coupled to a memory. The hardware accelerator comprises one or more decompression units. The one or more decompression units are reconfigurable. The hardware accelerator may be a field-programmable gate array. The hardware accelerator may also comprise one or more reconfigurable scanner units. The one or more decompression units, in the aggregate, are operative to decompress one or more rows of a database at a bus speed of the coupling between the hardware accelerator and the memory. Two or more decompression units are operative to decompress two or more rows of a database in parallel. The apparatus allows for hardware accelerated row decompression.

    摘要翻译: 一种装置包括耦合到存储器的硬件​​加速器。 硬件加速器包括一个或多个减压单元。 一个或多个减压单元是可重新配置的。 硬件加速器可以是现场可编程门阵列。 硬件加速器还可以包括一个或多个可重新配置的扫描器单元。 总的来说,一个或多个解压缩单元用于以硬件加速器和存储器之间的耦合的总线速度对数据库的一行或多行进行解压缩。 两个或更多个解压缩单元用于并行地解压缩数据库的两行或更多行。 该设备允许硬件加速行解压缩。

    Scan sharing for query predicate evaluations in column-based in-memory database systems
    8.
    发明授权
    Scan sharing for query predicate evaluations in column-based in-memory database systems 有权
    基于列的内存数据库系统中的查询谓词评估扫描共享

    公开(公告)号:US08631000B2

    公开(公告)日:2014-01-14

    申请号:US12894370

    申请日:2010-09-30

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30587

    摘要: A plurality of queries of an in-memory column-oriented database are obtained. Each of the queries has at least one column predicate. For each of the queries, it is determined which of a plurality of columns in the in-memory column-oriented database need to be scanned. The plurality of queries are grouped into a plurality of scan groups, based at least in part on the determining step. The column predicates are evaluated for those of the queries in a given one of the scan groups in accordance with a scheduling scheme. The grouping step and the scheduling scheme take into account real time scan information.

    摘要翻译: 获得存储器内列的数据库的多个查询。 每个查询至少有一个列谓词。 对于每个查询,确定需要扫描存储器中的列内数据库中的多个列中的哪一列。 至少部分地基于确定步骤,将多个查询分组为多个扫描组。 根据调度方案,对给定的一个扫描组中的查询的列的谓词进行评估。 分组步骤和调度方案考虑实时扫描信息。

    Database table look-up
    9.
    发明授权
    Database table look-up 有权
    数据库表查找

    公开(公告)号:US08359316B2

    公开(公告)日:2013-01-22

    申请号:US12714617

    申请日:2010-03-01

    IPC分类号: G06F7/00

    CPC分类号: G06F17/30584

    摘要: Techniques for database table look-up are provided. The techniques include storing one or more column attributes of a database table in a data structure, wherein the data structure also comprises a record identification (RID) column of a table, one or more predicate columns corresponding to the RID column, and a sequence number column that is associated with one or more updated records, generating a key using one or more portions from one or more of the one or more predicate columns, using the key to partition the data structure, wherein partitioning the data structure comprises partitioning the one or more predicate columns for evaluation, and evaluating the one or more predicate columns against the data structure for each matching predicate column-data structure partition.

    摘要翻译: 提供数据库表查找技术。 这些技术包括将数据库表的一个或多个列属性存储在数据结构中,其中数据结构还包括表的记录标识(RID)列,对应于RID列的一个或多个谓词列,以及序列号 列,其与一个或多个更新的记录相关联,使用所述密钥对所述数据结构进行分区,使用所述一个或多个谓词列中的一个或多个的一个或多个部分生成密钥,其中分割所述数据结构包括将所述一个或多个 用于评估的更多谓词列,并针对每个匹配谓词列数据结构分区的数据结构评估一个或多个谓词列。

    SCAN SHARING FOR QUERY PREDICATE EVALUATIONS IN COLUMN-BASED IN-MEMORY DATABASE SYSTEMS
    10.
    发明申请
    SCAN SHARING FOR QUERY PREDICATE EVALUATIONS IN COLUMN-BASED IN-MEMORY DATABASE SYSTEMS 有权
    基于列的内存数据库系统扫描查询预测评估

    公开(公告)号:US20120084278A1

    公开(公告)日:2012-04-05

    申请号:US12894370

    申请日:2010-09-30

    IPC分类号: G06F17/30

    CPC分类号: G06F17/30587

    摘要: A plurality of queries of an in-memory column-oriented database are obtained. Each of the queries has at least one column predicate. For each of the queries, it is determined which of a plurality of columns in the in-memory column-oriented database need to be scanned. The plurality of queries are grouped into a plurality of scan groups, based at least in part on the determining step. The column predicates are evaluated for those of the queries in a given one of the scan groups in accordance with a scheduling scheme. The grouping step and the scheduling scheme take into account real time scan information.

    摘要翻译: 获得存储器内列的数据库的多个查询。 每个查询至少有一个列谓词。 对于每个查询,确定需要扫描存储器中的列内数据库中的多个列中的哪一列。 至少部分地基于确定步骤,将多个查询分组为多个扫描组。 根据调度方案,对给定的一个扫描组中的查询的列的谓词进行评估。 分组步骤和调度方案考虑实时扫描信息。