公开(公告)号：US20130117307A1

公开(公告)日：2013-05-09

申请号：US13309603

申请日：2011-12-02

Applicant: Surendra Kumar VISHNOI ,  Colin FLORENDO

Inventor： Surendra Kumar VISHNOI ,  Colin FLORENDO

IPC: G06F17/30

CPC classification number: G06F17/30362

Abstract: System, method, computer program product embodiments and combinations and sub-combinations thereof for snapshot isolation support for distributed query processing in a shared disk database cluster are provided. The embodiments include the forming of object identification data in a leader node of query execution in the shared disk database cluster. At least one fragment of the query execution is distributed to at least one worker node in the shared disk database cluster, and the object identification data is utilized for multiversion concurrency control during query execution by the leader node and at least one worker node.

Abstract translation: 提供了用于共享磁盘数据库集群中的分布式查询处理的快照隔离支持的系统，方法，计算机程序产品实施例及其组合和子组合。 实施例包括在共享磁盘数据库集群中的查询执行的前导节点中形成对象标识数据。 查询执行的至少一个片段被分发到共享磁盘数据库集群中的至少一个工作节点，并且对象标识数据被用于在由前导节点和至少一个工作节点执行查询期间的多版本并发控制。

公开(公告)号：US20150019516A1

公开(公告)日：2015-01-15

申请号：US13937769

申请日：2013-07-09

Applicant: David WEIN ,  Anil GOEL ,  Colin FLORENDO

Inventor： David WEIN ,  Anil GOEL ,  Colin FLORENDO

IPC: G06F17/30

CPC classification number: G06F16/221 ,  G06F16/215

Abstract: Embodiments described herein generally relate to providing durability of in memory columnar datastores using multiple logs. A computer-implemented method is described. The method includes receiving a request to perform a transaction involving multiple tables in a column-oriented database system. The method further includes performing the transaction on each of the two or more database tables. Performance of the transaction generates two or more commit fragments corresponding to each of the two or more database tables. The method further includes writing each commit fragment to a transaction log for each of the two or more database tables. The method also includes writing a commit record for the transaction to a commit log after all commit fragments have been written.

Abstract translation: 本文描述的实施例通常涉及使用多个日志提供存储器柱状数据存储的耐久性。 描述了计算机实现的方法。 该方法包括在面向列的数据库系统中接收执行涉及多个表的事务的请求。 该方法还包括在两个或多个数据库表中的每一个上执行事务。 事务的性能生成与两个或多个数据库表中的每一个相对应的两个或更多个提交片段。 该方法还包括将每个提交片段写入两个或多个数据库表中的每一个的事务日志。 该方法还包括在写入所有提交片段之后，将事务的提交记录写入提交日志。

公开(公告)号：US20160012089A1

公开(公告)日：2016-01-14

申请号：US14328511

申请日：2014-07-10

Applicant: Reza SHERKAT ,  Guenter RADESTOCK ,  Ivan SCHRETER ,  Colin FLORENDO ,  Mihnea ANDREI ,  Anil Kumar GOEL

Inventor： Reza SHERKAT ,  Guenter RADESTOCK ,  Ivan SCHRETER ,  Colin FLORENDO ,  Mihnea ANDREI ,  Anil Kumar GOEL

IPC: G06F17/30

CPC classification number: G06F17/30324 ,  G06F17/30153 ,  G06F17/30315

Abstract: A compression manager may store, within an index vector, a plurality of value identifiers (IDs), each value ID representing a value within a database. A page generator may designate a number of the value IDs as defining a page within the index vector, so that the index vector includes a plurality of pages, each page including the number of value IDs. The page generator may store the index vector in a secondary memory of a main memory database. An iterator may access a requested value ID, and a page loader may load a corresponding page of the index vector that contains the requested value ID into the main memory database.

Abstract translation: 压缩管理器可以在索引向量内存储多个值标识符（ID），每个值ID表示数据库内的值。 页面生成器可以将多个值ID指定为在索引向量内定义页面，使得索引向量包括多个页面，每个页面包括值ID的数量。 页面生成器可以将索引矢量存储在主存储器数据库的辅助存储器中。 迭代器可以访问请求的值ID，并且页面加载器可以将包含所请求的值ID的索引向量的相应页面加载到主存储器数据库中。