US 12,339,843 B2
Apparatus, method and storage medium for database pagination
Chao Xie, San Francisco, CA (US); Xuan Yang, Shanghai (CN); Xiaofan Luan, Shanghai (CN); and Enwei Jiao, Shanghai (CN)
Assigned to Starlord (Cayman) Limited, Grand Cayman (KY)
Filed by Starlord (Cayman) Limited, Grand Cayman (KY)
Filed on Nov. 21, 2022, as Appl. No. 18/057,575.
Claims priority of provisional application 63/403,572, filed on Sep. 2, 2022.
Prior Publication US 2024/0078234 A1, Mar. 7, 2024
Int. Cl. G06F 16/2453 (2019.01)
CPC G06F 16/24542 (2019.01) [G06F 16/24539 (2019.01)] 17 Claims
OG exemplary drawing
 
1. An apparatus comprising:
a memory for storing database data; and
a processor configured to perform the following processes, including:
acquiring a pagination request from a user;
determining a query parameter based on the pagination request;
determining a corresponding pagination pattern and a requested data amount based on the query parameter;
determining a target query mode based on the requested data amount;
generating a query task;
obtaining at least one first query result based on the query task;
determining a target result set based on the at least one first query result;
paging the target result set based on the pagination pattern and the target query mode to obtain multiple pages of pagination data; and
wherein, when the target query mode comprises a first query mode, the generating the query task comprises:
determining the first query mode;
selecting a target paging parameter and a target sorting parameter based on the pagination pattern and the first query mode;
loading database data based on the target paging parameter and the target sorting parameter;
determining the database data that was loaded; and
generating a query task according to the target paging parameter and the target sorting parameter.