公开(公告)号：US20170109384A1

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

申请号：US15394242

申请日：2016-12-29

Applicant: HUAWEI TECHNOLOGIES CO., LTD.

Inventor： Zhongchu ZHU ,  Li YAO ,  Kesong WU

IPC: G06F17/30

CPC classification number: G06F16/2228 ,  G06F16/00 ,  G06F16/22 ,  G06F16/2282 ,  G06F16/23

Abstract: The present disclosure discloses an online index rebuilding method and apparatus, where the method includes: receiving an online index rebuilding request; adding a schema shared lock to a data table corresponding to an identifier of the data table; obtaining a latch and obtaining a structure control right of the data table; reserving storage space of a shadow index for an original index, allocating an entry address of the shadow index, and adding the entry address of the shadow index to a root page of the data table; releasing the latch; building the shadow index in the storage space of the shadow index; updating an index entry address on the root page of the data table to the entry address of the shadow index after the latch is obtained again; and releasing the latch obtained again and the schema shared lock. Therefore, efficiency of online index rebuilding is improved.

公开(公告)号：US20180039671A1

公开(公告)日：2018-02-08

申请号：US15783483

申请日：2017-10-13

Applicant: HUAWEI TECHNOLOGIES CO., LTD.

Inventor： Yidong YANG ,  Wenqi ZHU ,  Qing ZHANG ,  Li YAO ,  Zhongchu ZHU

IPC: G06F17/30

CPC classification number: G06F16/2456 ,  G06F16/24549 ,  G06F16/256 ,  G06F16/278

Abstract: The present invention discloses a method and an apparatus for querying data in cross-shard databases. The method includes: receiving a query request; querying statistics information of respective shard databases in which two tables used in an association operation are located; sending, according to the statistics information and the query condition, a driving table query request to a shard database in which a driving table is located, and receiving a first query result set returned by the shard database in which the driving table is located; deduplicating association field values in the first query result set, and sending a result set delivery request and deduplicated association field values to a shard database in which the non-driving table is located; and sending a non-driving table query request to the shard database; and receiving a second query result set returned by the shard database. Efficiency of querying data in cross-shard databases is improved.