利索-全球专利检索

  1. 登录
  2. 注册
发明授权
CN105653537B 一种数据库应用系统的分页查询方法和装置 有权 转让

一种数据库应用系统的分页查询方法和装置
摘要：
本申请实施例提供了一种数据库应用系统的分页查询方法和装置，所述数据库应用系统中包括一个或多个数据分表；所述的方法包括：接收分页查询请求；所述分页查询请求中包括分页查询条件，分页标识和分页查询条数S；从所述一个或多个数据分表中，分别提取出满足所述分页查询条件的第一相关数据；分别判断所述一个或多个数据分表是否存在对应的分页查询辅助数据；若所述一个或多个数据分表存在对应的分页查询辅助数据，则采用所述分页查询辅助数据，分页查询条数S和分页标识从所述第一相关数据中，筛选出作为分页查询结果的第二相关数据。本申请实施例用以节省在分页查询时所需的查询时间。
摘要（英）：

The embodiment of the invention provides a paging query method and device for a database application system. The database application system includes one or a plurality of sub-tables. The method includes: receiving a paging query request, wherein the paging query request includes a paging query condition, a paging identification, and a paging query number S; respectively extracting first relevant data meeting the paging query condition from the one or plurality of data sub-tables; respectively determining whether the one or plurality of data sub-tables have corresponding paging query auxiliary data or not; and adopting the paging query auxiliary data if the one or plurality of data sub-tables have the corresponding paging query auxiliary data, screening the paging query number S and the paging identification from the first relevant data, and serving the paging query number S and the paging identification as second relevant data. The method and the device can save the required query time of paging query.

公开/授权文献
0/0