公开(公告)号：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个不同的数据库中，对应于查询条件的数据查询。

公开(公告)号：US11249972B2

公开(公告)日：2022-02-15

申请号：US16718638

申请日：2019-12-18

Applicant: Huawei Technologies Co., Ltd.

Inventor： Yidong Yang ,  Chenghua Liu ,  Yong Deng ,  Wenqi Zhu ,  Bingjian Hou

IPC: G06F16/22 ,  G06F16/27 ,  G06F16/23

Abstract: An index update method, including: receiving an index update request, where the index update request is used to instruct to create or delete a target index that is associated with a field in a logic table of a tenant; updating metadata information of the logic table in a database in response to the index update request; notifying a coordination service, where the coordination service is used to notify a second data access node to perform a local synchronization update; and after all second data access nodes finish local synchronization updates, performing a data asynchronization update. After the metadata information is updated in the database, an index is updated in two steps. In a first step, a local synchronization update is performed. In a second step, after all data access nodes finish local synchronization updates, a data asynchronization update is performed.

公开(公告)号：US20200272614A1

公开(公告)日：2020-08-27

申请号：US16718638

申请日：2019-12-18

Applicant: Huawei Technologies Co., Ltd.

Inventor： Yidong Yang ,  Chenghua Liu ,  Yong Deng ,  Wenqi Zhu ,  Bingjian Hou

IPC: G06F16/22 ,  G06F16/27 ,  G06F16/23

Abstract: An index update method, including: receiving an index update request, where the index update request is used to instruct to create or delete a target index that is associated with a field in a logic table of a tenant; updating metadata information of the logic table in a database in response to the index update request; notifying a coordination service, where the coordination service is used to notify a second data access node to perform a local synchronization update; and after all second data access nodes finish local synchronization updates, performing a data asynchronization update. After the metadata information is updated in the database, an index is updated in two steps. In a first step, a local synchronization update is performed. In a second step, after all data access nodes finish local synchronization updates, a data asynchronization update is performed.

公开(公告)号：US11308062B2

公开(公告)日：2022-04-19

申请号：US16718638

申请日：2019-12-18

Applicant: Huawei Technologies Co., Ltd.

Inventor： Yidong Yang ,  Chenghua Liu ,  Yong Deng ,  Wenqi Zhu ,  Bingjian Hou

IPC: G06F16/22 ,  G06F16/27 ,  G06F16/23

Abstract: An index update method, including: receiving an index update request, where the index update request is used to instruct to create or delete a target index that is associated with a field in a logic table of a tenant; updating metadata information of the logic table in a database in response to the index update request; notifying a coordination service, where the coordination service is used to notify a second data access node to perform a local synchronization update; and after all second data access nodes finish local synchronization updates, performing a data asynchronization update. After the metadata information is updated in the database, an index is updated in two steps. In a first step, a local synchronization update is performed. In a second step, after all data access nodes finish local synchronization updates, a data asynchronization update is performed.