US 11,947,543 B2
Method for querying tables with different partition information
Seonggyu Choi, Seoul (KR); Yonghwa Kim, Seongnam-si (KR); Joohyun Lee, Namyangju-si (KR); and Sangyoung Park, Seoul (KR)
Assigned to TmaxTibero Co., Ltd., Seongnam-si (KR)
Filed by TmaxTibero Co., Ltd., Seongnam-si (KR)
Filed on Nov. 10, 2022, as Appl. No. 17/985,034.
Claims priority of application No. 10-2022-0032482 (KR), filed on Mar. 16, 2022.
Prior Publication US 2023/0297576 A1, Sep. 21, 2023
Int. Cl. G06F 16/20 (2019.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01)
CPC G06F 16/24557 (2019.01) [G06F 16/2282 (2019.01)] 15 Claims
OG exemplary drawing
 
1. A method for processing a query related to a plurality of partitions included in a plurality of tables having different partition information, which is performed by a computing device including one or more processors, the method comprising:
acquiring, by the one or more processors, the plurality of partitions for processing the query;
acquiring, by the one or more processors, global partition indexes for encompassing the acquired partitions and acquiring local partition indexes corresponding to the acquired partitions, respectively; and
processing, by the one or more processors, the query at least partially based on the global partition indexes and the local partition indexes;
wherein the plurality of tables includes a first table and a second table, and
a first number of partitions included in the first table and a second number of partitions included in the second table are different from each other,
wherein a first range of the partitions included in the first table and a second range of the partitions included in the second table are different from each other;
wherein the global partition indexes are generated based on the ranges allocated to the acquired partitions, respectively, and
wherein the global partition indexes are generated so that the total number of the global partition indexes is reduced based on the ranges of the respective local partition indexes.