公开(公告)号：US11030045B2

公开(公告)日：2021-06-08

申请号：US14811739

申请日：2015-07-28

Applicant: Futurewei Technologies, Inc.

Inventor： Bai Yang ,  Guogen Zhang

IPC: G06F11/14 ,  G06F11/20 ,  G06F11/16

Abstract: An apparatus and method are provided for utilizing different data storage types to store primary and replicated database directories. Included is a first data storage of a first data storage type including a direct-access storage type. The first data storage is configured to store a primary database directory. Also included is a second data storage of a second data storage type including a share type. The second data storage is configured to store a replicated database directory that replicates at least a portion of the primary database directory.

公开(公告)号：US20180205672A1

公开(公告)日：2018-07-19

申请号：US15408206

申请日：2017-01-17

Applicant: Futurewei Technologies, Inc.

Inventor： Yu Dong ,  Qingqing Zhou ,  Guogen Zhang

IPC: H04L12/931 ,  H04L29/08 ,  G06F17/30

Abstract: A computer-implemented method and system are provided, including executing an application programming interface (API) in a network switch to define at least one of one or more database functions, performing, using one or more processors, the one or more database functions on at least a portion of data contained in a data message received at the switch, to generate result data, and routing the result data to one or more destination nodes. A database function-defined network switch includes a network switch and one or more processors to perform a pre-defined database function on query data contained in data messages received at the switch, to produce result data, wherein the pre-defined database function is performed on the query data in a first mode of operation to a state of full completion, generating complete result data and no skipped query data, or to a state of partial completion, generating partially completed result data and skipped query data.

公开(公告)号：US09779128B2

公开(公告)日：2017-10-03

申请号：US14249558

申请日：2014-04-10

Applicant: Futurewei Technologies, Inc.

Inventor： Le Cai ,  Guogen Zhang

IPC: G06F7/00 ,  G06F17/30 ,  G06F11/14

CPC classification number: G06F17/30377 ,  G06F11/1446 ,  G06F11/1451 ,  G06F11/1474 ,  G06F17/30088 ,  G06F17/30445 ,  G06F2201/80 ,  G06F2201/835

Abstract: In one embodiment, a method of performing point-in-time recovery (PITR) in a massively parallel processing (MPP) database includes receiving, by a data node from a coordinator, a PITR recovery request and reading a log record of the MPP database. The method also includes determining a type of the log record and updating a transaction table when the type of the log record is an abort transaction or a commit transaction.

公开(公告)号：US20170206234A1

公开(公告)日：2017-07-20

申请号：US15475990

申请日：2017-03-31

Applicant: Futurewei Technologies, Inc.

Inventor： Guogen Zhang

IPC: G06F17/30

Abstract: System and method embodiments are provided for multi-version support in indexes in a database. The embodiments enable substantially optimized multi-version support in index and avoid backfill of commit log sequence number (LSN) for a transaction identifier (TxID). In an embodiment, a method in a data processing system for managing a database includes determining with the data processing system whether a record is deleted according to a delete indicator in an index leaf page record corresponding to the record; and determining with the data processing system, when the record is not deleted, whether the record is visible according to a new record indicator in the index leaf page record and according to a comparison of a system commit TxID at the transaction start with a record commit TxID obtained from the index leaf page record.

公开(公告)号：US20160364484A1

公开(公告)日：2016-12-15

申请号：US14736050

申请日：2015-06-10

Applicant: FUTUREWEI TECHNOLOGIES, INC.

Inventor： Yu Dong ,  Qingqing Zhou ,  Guogen Zhang

IPC: G06F17/30 ,  H04L29/08

CPC classification number: G06F16/951 ,  G06F16/217 ,  G06F16/27 ,  H04L67/1097 ,  H04L67/28

Abstract: Data messages having different priorities may be stored in different communication buffers of a network node. The data messages may then be forwarded from the communication buffers to working buffers as space becomes available in the working buffers. After being forwarded to the working buffers, the data messages may be available to be processed by upper-layer operations of the network node. Priorities may be assigned to the data messages based on a priority level of a query associated with the data messages, a priority level of an upper-layer operation assigned to process the data messages, or combinations thereof.

Abstract translation: 具有不同优先级的数据消息可以存储在网络节点的不同通信缓冲器中。 然后，当工作缓冲区中的空间变得可用时，数据消息可以从通信缓冲器转发到工作缓冲区。 在转发到工作缓冲区之后，数据消息可以被网络节点的上层操作处理。 可以基于与数据消息相关联的查询的优先级，分配用于处理数据消息的上层操作的优先级或其组合，将优先级分配给数据消息。

公开(公告)号：US20150278281A1

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

申请号：US14229519

申请日：2014-03-28

Applicant: FUTUREWEI TECHNOLOGIES, INC.

Inventor： Guogen Zhang

IPC: G06F17/30 ,  G06F9/46

CPC classification number: G06F17/30353 ,  G06F9/466 ,  G06F17/30008 ,  G06F17/30088 ,  G06F17/30327 ,  G06F17/30336 ,  G06F17/30339 ,  G06F17/30348 ,  G06F17/30377

Abstract: System and method embodiments are provided for consistent read in a record-based multi-version concurrency control (MVCC) in database (DB) management systems. In an embodiment, a method in a record-based multi-version concurrent control (MVCC) database (DB) management system for a snapshot consistent read includes copying a system commit transaction identifier (TxID) and a current log record sequence number (LSN) from a transaction log at a start of a reader without backfilling of a commit LSN of a transaction to records that are changed and without copying an entire transaction table by the reader; and determining whether a record is visible according to a record TxID, the commit TxID and a current LSN, wherein a transaction table is consulted only when the record TxID is equal to or larger than a commit TxID at a transaction start.

Abstract translation: 提供了系统和方法实施例，用于在数据库（DB）管理系统中的基于记录的多版本并发控制（MVCC）中的一致性读取。 在一个实施例中，用于快照一致性读取的基于记录的多版本并发控制（MVCC）数据库（DB）管理系统中的方法包括复制系统提交事务标识符（TxID）和当前日志记录序列号（LSN） 从读写器的开始处的事务日志中，没有将交易的提交LSN重新填充到已经改变的记录，并且读者没有复制整个事务表; 以及根据记录TxID，提交TxID和当前LSN来确定记录是否可见，其中只有当事务开始时记录TxID等于或大于提交TxID时才查阅事务表。

公开(公告)号：US20140280031A1

公开(公告)日：2014-09-18

申请号：US13798680

申请日：2013-03-13

Applicant: FUTUREWEI TECHNOLOGIES, INC.

Inventor： Qingqing Zhou ,  Guogen Zhang

IPC: G06F17/30

CPC classification number: G06F17/30463

Abstract: System and method embodiments are provided for adaptive vector size selection for vectorized query execution. The adaptive vector size selection is implemented in two stages. In a query planning stage, a suitable vector size is estimated for a query by a query planner. The planning stage includes analyzing a query plan tree, segmenting the tree into different segments, and assigning to the query execution plan an initial vector size to each segment. In a subsequent query execution stage, an execution engine monitors hardware performance indicators, and adjusts the vector size according to the monitored hardware performance indicators. Adjusting the vector size includes trying different vector sizes and observing related processor counters to increase or decrease the vector size, wherein the vector size is increased to improve hardware performance according to the processor counters, and wherein the vector size is decreased when the processor counters indicate a decrease in hardware performance.

Abstract translation: 为向量化查询执行的自适应向量大小选择提供了系统和方法实施例。 自适应向量大小选择分两个阶段实现。 在查询计划阶段，由查询计划器为查询估计合适的向量大小。 规划阶段包括分析查询计划树，将树分割成不同的段，并将查询执行计划分配给每个段的初始向量大小。 在随后的查询执行阶段，执行引擎监视硬件性能指标，并根据监视的硬件性能指标调整向量大小。 调整矢量大小包括尝试不同的矢量大小并观察相关的处理器计数器以增加或减少矢量大小，其中根据处理器计数器增加矢量大小以提高硬件性能，并且其中当处理器计数器指示 硬件性能下降。