公开(公告)号：US10534771B2

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

申请号：US15411043

申请日：2017-01-20

Applicant: Huawei Technologies Co., Ltd.

Inventor： Zhenfeng Li ,  Zhongchu Zhu ,  Jianxun Zhang

IPC: G06F16/2453

Abstract: The present invention provides a database access method, where the method includes the following steps: receiving an access request input by a client, where the access request includes at least one command statement; performing rule matching between the command statement included in the access request and a rule in a preset rule set, and performing transformation processing on a statement that is included in the access request and that matches the rule, so as to generate a sinking statement that satisfies an execution requirement of a data source, where the sinking statement is a statement that is delivered to a database and executed by the data source; and transmitting the sinking statement to the database to which the sinking statement points. The present invention further provides a database access apparatus and a database system to which the foregoing method is applied.

公开(公告)号：US20170132280A1

公开(公告)日：2017-05-11

申请号：US15411043

申请日：2017-01-20

Applicant: Huawei Technologies Co., Ltd.

Inventor： Zhenfeng Li ,  Zhongchu Zhu ,  Jianxun Zhang

IPC: G06F17/30

Abstract: The present invention provides a database access method, where the method includes the following steps: receiving an access request input by a client, where the access request includes at least one command statement; performing rule matching between the command statement included in the access request and a rule in a preset rule set, and performing transformation processing on a statement that is included in the access request and that matches the rule, so as to generate a sinking statement that satisfies an execution requirement of a data source, where the sinking statement is a statement that is delivered to a database and executed by the data source; and transmitting the sinking statement to the database to which the sinking statement points. The present invention further provides a database access apparatus and a database system to which the foregoing method is applied.

公开(公告)号：US11829260B2

公开(公告)日：2023-11-28

申请号：US17525415

申请日：2021-11-12

Applicant: HUAWEI TECHNOLOGIES CO., LTD.

Inventor： Chuanting Wang ,  Zhongchu Zhu ,  Yuhui Xing

IPC: G06F16/21 ,  G06F11/14

CPC classification number: G06F11/1469 ,  G06F11/1425 ,  G06F11/1471 ,  G06F16/21

Abstract: The present disclosure relates to fault repair methods for a database system. In one example method, when working normally, a master node backs up, to a global buffer pool (GBP) node by using a data transmission protocol with a low latency and a high throughput (for example, a remote direct memory access (RDMA) protocol), a modified page generated because of transaction modification. When the master node is faulty, a standby node does not need to replay all remaining replay logs that are not replayed, but only needs to replay redo logs corresponding to a page that does not exist on the GBP node and pages that are not sequentially arranged and obtain the pages.

公开(公告)号：US20160328445A1

公开(公告)日：2016-11-10

申请号：US15214906

申请日：2016-07-20

Applicant: Huawei Technologies Co., Ltd.

Inventor： Wenqi Zhu ,  Yidong Yang ,  Qing Zhang ,  Li Yao ,  Zhongchu Zhu

IPC: G06F17/30

CPC classification number: G06F16/24544 ,  G06F16/2456 ,  G06F16/2471

Abstract: Embodiments provide a data query method and apparatus. The method includes receiving a query request, where the query request includes a query condition, and the query condition relates to N different databases. The method also includes calculating a query cost of each cross-database join processing manner of M cross-database join processing manners, where the query cost of each cross-database join processing manner is a cost for performing, using each cross-database join processing manner, in the N different databases, data query corresponding to the query condition, and M is an integer greater than or equal to 2. The method also includes determining, in the M cross-database join processing manners, a cross-database join processing manner for current use according to the query cost of each cross-database join processing manner, and performing, using the cross-database join processing manner for current use, in the N different databases, data query corresponding to the query condition.

Abstract translation: 实施例提供了一种数据查询方法和装置。 该方法包括接收查询请求，其中查询请求包括查询条件，查询条件与N个不同的数据库有关。 该方法还包括计算M跨数据库连接处理方式的每个跨数据库连接处理方式的查询成本，其中每个跨数据库连接处理方式的查询成本是执行成本，使用每个跨数据库连接处理 在N个不同的数据库中，对应于查询条件的数据查询，M是大于或等于2的整数。该方法还包括在M跨数据库连接处理方式中确定跨数据库连接处理 根据每个跨数据库连接处理方式的查询成本，当前使用的方式，并且使用针对当前使用的跨数据库连接处理方式，在N个不同的数据库中，对应于查询条件的数据查询。

公开(公告)号：US20160034582A1

公开(公告)日：2016-02-04

申请号：US14883288

申请日：2015-10-14

Applicant: Huawei Technologies Co., Ltd.

Inventor： Qiang Li ,  Zhongchu Zhu

IPC: G06F17/30 ,  G06F17/27 ,  G06F21/62

CPC classification number: G06F16/951 ,  G06F16/24553 ,  G06F17/2705 ,  G06F21/6218

Abstract: The present invention relates to the field of databases, and discloses a computing device and a method for executing a database operation command. In the present invention, whether an operation requested by an operation command is a read operation is determined; and if the operation requested by the operation command is a read operation, the operation command is executed via authorized access to database server process memory and a query result is obtained, thereby improving data reading performance; or if the operation requested by the operation command is not a read operation, the operation command is forwarded to a database server for executing the operation command, thereby improving reliability of a non-read operation.

Abstract translation: 本发明涉及数据库领域，并且公开了一种用于执行数据库操作命令的计算设备和方法。 在本发明中，确定由操作命令请求的操作是否为读取操作; 如果操作命令所请求的操作是读取操作，则通过对数据库服务器处理存储器的授权访问来执行操作命令，并且获得查询结果，从而提高数据读取性能; 或者如果由操作命令请求的操作不是读取操作，则将操作命令转发到数据库服务器以执行操作命令，从而提高非读取操作的可靠性。