CN103886022A - Paging-query querying device and method based on primary key fields - Google Patents
Paging-query querying device and method based on primary key fields Download PDFInfo
- Publication number
- CN103886022A CN103886022A CN201410062355.3A CN201410062355A CN103886022A CN 103886022 A CN103886022 A CN 103886022A CN 201410062355 A CN201410062355 A CN 201410062355A CN 103886022 A CN103886022 A CN 103886022A
- Authority
- CN
- China
- Prior art keywords
- page
- query
- group
- condition
- querying
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a paging-query querying device and method based on primary key fields in a querying database. The querying method includes acquiring relevant parameters, including a primary key field, the page number contained by each data packet displayed on pages, the displayed record number of each page and the page number of a selected page in a current set, of each data packet displayed on pages; acquiring initial querying conditions of paging query; judging the querying type of user querying operation; generating matching querying conditions corresponding to the initial querying conditions and primary key values containing initial records of each page in storing sets according to the querying type. Compared with the prior art, the responding time of the querying method is not associated with data quantity in the database and is only associated with matching querying conditions and sizes of result sets, and accordingly records meeting querying conditions can be queried rapidly in large data quantity and can be displayed in a paging manner rapidly and efficiently.
Description
Technical field
The present invention relates to data base querying technology, relate in particular to a kind of query facility and querying method thereof that carries out paging query based on major key field in Query Database.
Background technology
Along with the development of IT application in enterprises, be used for representing that the data volume of various information is also more and more huger.To this, enterprise tends to these data to be stored in various databases, for example, and local data base, network data base etc.But, when the data of having stored are represented or analyzed, must relate to the query display of mass data, thereby the paging query of data is problems that engineers unavoidably can run into.
A solution of the prior art is to be, for the Pagination Display of data, all data bulks that meet querying condition in database is all got, and then calculates number of pages altogether according to the data number of every page of demonstration, and generates paging link.In addition,, for Web database, Tabbed browsing function is also very important.But, for very large data model, in the time of paging query, if be to waste very much resource according to traditional each method that all loads whole data source, although existing paging method is improved to only searching page size Kuai district data, but not retrieve all data, then current line is carried out in single step.But, above-mentioned solution still can cause the speed of paging query slower, and the data that cannot meet inquiring user show demand.
In view of this, how to design a kind of solution of carrying out paging query in Query Database, even when the data volume in database obviously increases, also can not affect speed and the efficiency of paging query, be a person skilled problem urgently to be resolved hurrily in the industry.
Summary of the invention
For Query Database of the prior art existing above-mentioned defect in the time carrying out paging query, the invention provides a kind of query facility and method thereof of carrying out paging query based on major key field in Query Database.
According to one aspect of the present invention, a kind of querying method that carries out paging query based on major key field in Query Database is provided, comprise the following steps:
Obtain the correlation parameter of every group of packet showing on the page, what described correlation parameter comprised point number of pages (GROUP_SIZE) that every group of packet showing on a major key field (PRI_KEY), the page contain, every page of demonstration records number (PAGE_SIZE), the page number (PAGE_NUM) of choosing page of current group;
Obtain the initial query condition (WHERE_SQL) of paging query;
Judge the query type of user's query manipulation; And
Generate the Major key that comprises every start of Page record in the matching inquiry condition corresponding with described initial query condition and storage sets (PAGE_ID[GROUP_SIZE+2]) according to query type.
In an embodiment therein, query type in inquiring about first, organizing, skip inquiry or across group polling.
In an embodiment therein, when described query manipulation is while inquiring about first, described initial query condition (WHERE_SQL) and the described major key field (PRI_KEY) of specifying according to user, the value of searching one group of major key field;
The value of this group major key field is extracted to described every start of Page according to described point of number of pages (GROUP_SIZE) and record corresponding Major key in storage array;
Increase condition in described initial query condition (WHERE_SQL), PRI_KEY<=PAGE_ID[PAGE_NUM] and PRI_KEY>=PAGE_ID[PAGE_NUM+1]; And
Return to the Major key that comprises every start of Page record in described matching inquiry condition and storage sets.
In an embodiment therein, this querying method also comprises: carry out inquiry and the demonstration of query note using returned matching inquiry condition as final querying condition.
In an embodiment therein, when described query manipulation is that while skipping inquiry in group, increase condition in described initial query condition, returns to described matching inquiry condition, the condition of this increase is:
PRI_KEY<=PAGE_ID[PAGE_NUM]and
PRI_KEY>=PAGE_ID[PAGE_NUM+1]。
In an embodiment therein, skip inquiry in described query type is not inquired about first and organized time, determine that across group polling operation be a upper group polling or next group polling.Preferably, when described while being a upper group polling across group polling operation, according to described initial query condition (WHERE_SQL) and described major key field (PRI_KEY), search the value of upper one group of major key field according to the first querying condition, this first querying condition is PRI_KEY>=PAGE_ID[0].When described while being next group polling across group polling operation, according to described initial query condition (WHERE_SQL) and described major key field (PRI_KEY), the value of searching next group major key field according to the second querying condition, this second querying condition is PRI_KEY>=PAGE_ID[GROUP_SIZE+1].
According to another aspect of the present invention, a kind of query facility that carries out paging query based on major key field in Query Database is provided, comprising:
Parameter acquiring unit, for obtaining the correlation parameter of every group of packet showing on the page, what described correlation parameter comprised point number of pages (GROUP_SIZE) that every group of packet showing on a major key field (PRI_KEY), the page contain, every page of demonstration records number (PAGE_SIZE), the page number (PAGE_NUM) of choosing page of current group;
Querying condition acquiring unit, for obtaining the initial query condition (WHERE_SQL) of paging query;
Judging unit, for judging the query type of user's query manipulation; And
Output unit, for generate according to query type with the corresponding matching inquiry condition of described initial query condition and storage sets in the Major key that comprises every start of Page record (PAGE_ID[GROUP_SIZE+2]).
In an embodiment therein, query type in inquiring about first, organizing, skip inquiry or across group polling.When described query manipulation is while inquiring about first, described initial query condition (WHERE_SQL) and the described major key field (PRI_KEY) of described output unit for specifying according to user, the value of searching one group of major key field; The value of this group major key field is extracted to described every start of Page according to described point of number of pages (GROUP_SIZE) and record corresponding Major key in storage array; Increase condition in described initial query condition (WHERE_SQL); And return to the Major key that comprises every start of Page record in described matching inquiry condition and storage sets, wherein, the condition newly increasing is
PRI_KEY<=PAGE_ID[PAGE_NUM]and
PRI_KEY>=PAGE_ID[PAGE_NUM+1]。
Adopt query facility and method thereof of carrying out paging query based on major key field in Query Database of the present invention, obtain the correlation parameter of every group of packet showing on the page, this correlation parameter comprises a major key field (PRI_KEY), point number of pages (GROUP_SIZE) that every group of packet showing on the page contains, every page of demonstration record number (PAGE_SIZE), the page number (PAGE_NUM) of choosing page of current group, and obtain the initial query condition (WHERE_SQL) of paging query, then judge the query type of user's query manipulation, thereby generate the Major key that comprises every start of Page record in the matching inquiry condition corresponding with described initial query condition and storage sets (PAGE_ID[GROUP_SIZE+2]) according to query type.Than prior art, data volume in response time length and the database of querying method of the present invention is irrelevant, only relevant with matching inquiry condition and final result set size, thereby can fast finding under big data quantity meet the record of querying condition, and record is carried out fast and Pagination Display efficiently.
Brief description of the drawings
Reader, after having read the specific embodiment of the present invention with reference to accompanying drawing, will become apparent various aspects of the present invention.Wherein,
Fig. 1 illustrates the querying method process flow diagram that carries out paging query based on major key field in Query Database according to an embodiment of the present invention;
Fig. 2 illustrates and uses the querying method of Fig. 1 to carry out the process flow diagram of query manipulation first;
Fig. 3 illustrates and uses skip in the organizing process flow diagram of inquiry of the querying method of Fig. 1;
Fig. 4 illustrates and uses the querying method of Fig. 1 to carry out the process flow diagram across group polling operation; And
Fig. 5 illustrates the query facility structured flowchart that carries out paging query based on major key field in Query Database according to another embodiment of the present invention.
Embodiment
For the technology contents that the application is disclosed is more detailed and complete, can be with reference to accompanying drawing and following various specific embodiments of the present invention, in accompanying drawing, identical mark represents same or analogous assembly.But those of ordinary skill in the art should be appreciated that the embodiment that hereinafter provided is not used for limiting the scope that the present invention is contained.In addition, accompanying drawing, only for being schematically illustrated, is not drawn according to its life size.
With reference to the accompanying drawings, the embodiment of various aspects of the present invention is described in further detail.
Fig. 1 illustrates the querying method process flow diagram that carries out paging query based on major key field in Query Database according to an embodiment of the present invention.
With reference to Fig. 1, in this querying method, first perform step S11, obtain the correlation parameter of every group of packet showing on the page, what this correlation parameter comprised point number of pages GROUP_SIZE that every group of packet showing on a major key field PRI_KEY, the page contain, every page of demonstration records number PAGE_SIZE, the page number PAGE_NUM that chooses page of current group.For example, the paging information that the page is shown comprises: upper one group the 1st page the 2nd page ... next group of GROUP_SIZE page.
Then, perform step S13, obtain the initial query condition WHERE_SQL of paging query.The order that it will be understood by those of skill in the art that step S11 and S13 can be exchanged.Then,, in step S15, judge the query type of user's query manipulation.For example, this query type in inquiring about first, organizing, skip inquiry or across group polling.Finally, execution step S17, generates the Major key PAGE_ID[GROUP_SIZE+2 that comprises every start of Page record in the matching inquiry condition corresponding with initial query condition and storage sets according to query type].
From the above, data volume in response time length and the database of querying method of the present invention is irrelevant, only relevant with matching inquiry condition and final result set size, thereby can fast finding under big data quantity meet the record of querying condition, and record is carried out fast and Pagination Display efficiently.Show through data test, the condition of inquiry is more, and net result collection is larger, and the response time is just longer.In test run, if the number of correlation parameter is less than 50, net result collection size is, in the situation of 100,000 grades, to use the average response time of this querying method to be less than 1 second.
Fig. 2 illustrates and uses the querying method of Fig. 1 to carry out the process flow diagram of query manipulation first.With reference to Fig. 2, when query manipulation is while inquiring about first, in step S21, the initial query condition WHERE_SQL and the major key field PRI_KEY that specify according to user, the value of searching one group of major key field.In step S23, the value of this group major key field is extracted to every start of Page according to a point number of pages GROUP_SIZE and record corresponding Major key in storage array.In step S25, suppose that Query Result is according to the descending sequence of major key, increase condition in initial query condition WHERE_SQL,
PRI_KEY<=PAGE_ID[PAGE_NUM]and
PRI_KEY>=PAGE_ID[PAGE_NUM+1]，
If the ascending sequence of major key, the condition increasing is transformed to accordingly:
PRI_KEY<=PAGE_ID[PAGE_NUM+1]and
PRI_KEY>=PAGE_ID[PAGE_NUM]。
Finally, in step S27, return to the Major key that comprises every start of Page record in matching inquiry condition and the storage sets after change.Preferably, this querying method also can carry out using returned matching inquiry condition as final querying condition inquiry and the demonstration of query note.
Fig. 3 illustrates and uses skip in the organizing process flow diagram of inquiry of the querying method of Fig. 1.With reference to Fig. 3, in the time that user's query manipulation is not inquired about first but is skipped inquiry in group, in step S31, increase condition in initial query condition, PRI_KEY<=PAGE_ID[PAGE_NUM] and PRI_KEY>=PAGE_ID[PAGE_NUM+1], then in step S33, return to matching inquiry condition.
Fig. 4 illustrates and uses the querying method of Fig. 1 to carry out the process flow diagram across group polling operation.With reference to Fig. 4, when query manipulation inquiry neither inquiry is first skipped in neither organizing of user,, during across group polling, by step S41 and S45, in the time being a upper group polling across group polling operation, according to initial query condition WHERE_SQL and major key field PRI_KEY, search the value of upper one group of major key field according to the first querying condition, this first querying condition is PRI_KEY>=PAGE_ID[0].By step S43 and S47, in the time being next group polling across group polling operation, according to initial query condition WHERE_SQL and major key field PRI_KEY, the value of searching next group major key field according to the second querying condition, this second querying condition is PRI_KEY>=PAGE_ID[GROUP_SIZE+1].
Fig. 5 illustrates the query facility structured flowchart that carries out paging query based on major key field in Query Database according to another embodiment of the present invention.
With reference to Fig. 5, this query facility comprises parameter acquiring unit 50, querying condition acquiring unit 52, judging unit 54 and output unit 56.
Be similar to the querying method of Fig. 1, parameter acquiring unit 50 is obtained the correlation parameter of every group of packet showing on the page, and what this correlation parameter comprised point number of pages GROUP_SIZE that every group of packet showing on a major key field PRI_KEY, the page contain, every page of demonstration records number PAGE_SIZE, the page number PAGE_NUM that chooses page of current group.Querying condition acquiring unit 52 obtains the initial query condition WHERE_SQL of paging query.
Judging unit 54 judges the query type of user's query manipulation, such as in inquiring about first, organizing, skip inquiry or across group polling.Output unit 56 according to query type generate with the corresponding matching inquiry condition of initial query condition and storage sets in the Major key PAGE_ID[GROUP_SIZE+2 that comprises every start of Page record].
In one embodiment, when query manipulation is while inquiring about first, initial query condition WHERE_SQL and major key field PRI_KEY that output unit 56 is specified according to user, search the value of one group of major key field, and the value of this group major key field is extracted to every start of Page according to a point number of pages GROUP_SIZE and record corresponding Major key in storage array, then increase condition in initial query condition WHERE_SQL, finally return to the Major key that comprises every start of Page record in matching inquiry condition and storage sets, wherein, the condition newly increasing is PRI_KEY<=PAGE_ID[PAGE_NUM] and PRI_KEY>=PAGE_ID[PAGE_NUM+1].
Adopt query facility and method thereof of carrying out paging query based on major key field in Query Database of the present invention, obtain the correlation parameter of every group of packet showing on the page, this correlation parameter comprises a major key field (PRI_KEY), point number of pages (GROUP_SIZE) that every group of packet showing on the page contains, every page of demonstration record number (PAGE_SIZE), the page number (PAGE_NUM) of choosing page of current group, and obtain the initial query condition (WHERE_SQL) of paging query, then judge the query type of user's query manipulation, thereby generate the Major key that comprises every start of Page record in the matching inquiry condition corresponding with described initial query condition and storage sets (PAGE_ID[GROUP_SIZE+2]) according to query type.Than prior art, data volume in response time length and the database of querying method of the present invention is irrelevant, only relevant with matching inquiry condition and final result set size, thereby can fast finding under big data quantity meet the record of querying condition, and record is carried out fast and Pagination Display efficiently.
Above, describe the specific embodiment of the present invention with reference to the accompanying drawings.But those skilled in the art can understand, without departing from the spirit and scope of the present invention in the situation that, can also do various changes and replacement to the specific embodiment of the present invention.These changes and replacement all drop in the claims in the present invention book limited range.
Claims (10)
1. a querying method that carries out paging query based on major key field in Query Database, is characterized in that, this querying method comprises the following steps:
Obtain the correlation parameter of every group of packet showing on the page, what described correlation parameter comprised point number of pages (GROUP_SIZE) that every group of packet showing on a major key field (PRI_KEY), the page contain, every page of demonstration records number (PAGE_SIZE), the page number (PAGE_NUM) of choosing page of current group;
Obtain the initial query condition (WHERE_SQL) of paging query;
Judge the query type of user's query manipulation; And
Generate the Major key that comprises every start of Page record in the matching inquiry condition corresponding with described initial query condition and storage sets (PAGE_ID[GROUP_SIZE+2]) according to query type.
2. querying method according to claim 1, is characterized in that, described query type in inquiring about first, organizing, skip inquiry or across group polling.
3. querying method according to claim 2, is characterized in that, when described query manipulation is while inquiring about first,
Described initial query condition (WHERE_SQL) and the described major key field (PRI_KEY) of specifying according to user, the value of searching one group of major key field;
The value of this group major key field is extracted to described every start of Page according to described point of number of pages (GROUP_SIZE) and record corresponding Major key in storage array;
Increase condition in described initial query condition (WHERE_SQL), PRI_KEY<=PAGE_ID[PAGE_NUM] and PRI_KEY>=PAGE_ID[PAGE_NUM+1]; And
Return to the Major key that comprises every start of Page record in described matching inquiry condition and storage sets.
4. querying method according to claim 3, is characterized in that, this querying method also comprises: carry out inquiry and the demonstration of query note using returned matching inquiry condition as final querying condition.
5. querying method according to claim 2, it is characterized in that, when described query manipulation is while skipping inquiry in group, increase condition in described initial query condition, PRI_KEY<=PAGE_ID[PAGE_NUM] and PRI_KEY>=PAGE_ID[PAGE_NUM+1], return to described matching inquiry condition.
6. querying method according to claim 2, is characterized in that, while skipping inquiry, determines that across group polling operation be a upper group polling or next group polling in described query type is not inquired about first and organized.
7. querying method according to claim 6, it is characterized in that, when described while being a upper group polling across group polling operation, according to described initial query condition (WHERE_SQL) and described major key field (PRI_KEY), search the value of upper one group of major key field according to the first querying condition, this first querying condition is PRI_KEY>=PAGE_ID[0].
8. querying method according to claim 6, it is characterized in that, when described while being next group polling across group polling operation, according to described initial query condition (WHERE_SQL) and described major key field (PRI_KEY), the value of searching next group major key field according to the second querying condition, this second querying condition is PRI_KEY>=PAGE_ID[GROUP_SIZE+1].
9. a query facility that carries out paging query based on major key field in Query Database, is characterized in that, this query facility comprises:
Parameter acquiring unit, for obtaining the correlation parameter of every group of packet showing on the page, what described correlation parameter comprised point number of pages (GROUP_SIZE) that every group of packet showing on a major key field (PRI_KEY), the page contain, every page of demonstration records number (PAGE_SIZE), the page number (PAGE_NUM) of choosing page of current group;
Querying condition acquiring unit, for obtaining the initial query condition (WHERE_SQL) of paging query;
Judging unit, for judging the query type of user's query manipulation; And
Output unit, for generate according to query type with the corresponding matching inquiry condition of described initial query condition and storage sets in the Major key that comprises every start of Page record (PAGE_ID[GROUP_SIZE+2]).
10. query facility according to claim 9, is characterized in that, described query type in inquiring about first, organizing, skip inquiry or across group polling,
When described query manipulation is while inquiring about first, described initial query condition (WHERE_SQL) and the described major key field (PRI_KEY) of described output unit for specifying according to user, the value of searching one group of major key field; The value of this group major key field is extracted to described every start of Page according to described point of number of pages (GROUP_SIZE) and record corresponding Major key in storage array; Increase condition in described initial query condition (WHERE_SQL); And return to the Major key that comprises every start of Page record in described matching inquiry condition and storage sets, wherein, the condition newly increasing is
PRI_KEY<=PAGE_ID[PAGE_NUM]and
PRI_KEY>=PAGE_ID[PAGE_NUM+1]。
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410062355.3A CN103886022B (en) | 2014-02-24 | 2014-02-24 | A kind of query facility and its method carrying out paging query based on major key field |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410062355.3A CN103886022B (en) | 2014-02-24 | 2014-02-24 | A kind of query facility and its method carrying out paging query based on major key field |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103886022A true CN103886022A (en) | 2014-06-25 |
| CN103886022B CN103886022B (en) | 2019-01-18 |
Family
ID=50954914
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410062355.3A Active CN103886022B (en) | 2014-02-24 | 2014-02-24 | A kind of query facility and its method carrying out paging query based on major key field |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103886022B (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105159941A (en) * | 2015-08-07 | 2015-12-16 | 小米科技有限责任公司 | Data record searching method and device |
| CN105426449A (en) * | 2015-11-09 | 2016-03-23 | 小米科技有限责任公司 | Method and device for massive data query and server |
| CN105653537A (en) * | 2014-11-13 | 2016-06-08 | 阿里巴巴集团控股有限公司 | Paging query method and device for database application system |
| CN106227894A (en) * | 2016-08-24 | 2016-12-14 | 中国农业银行股份有限公司 | A kind of data page querying method and device |
| CN106874326A (en) * | 2016-07-05 | 2017-06-20 | 阿里巴巴集团控股有限公司 | A kind of item list obtains request processing method and device |
| CN107193822A (en) * | 2016-03-14 | 2017-09-22 | 阿里巴巴集团控股有限公司 | For the method for paging query, device and equipment |
| CN108228663A (en) * | 2016-12-21 | 2018-06-29 | 杭州海康威视数字技术股份有限公司 | A kind of paging search method and device |
| CN110569259A (en) * | 2019-07-26 | 2019-12-13 | 苏宁云计算有限公司 | Method and device for processing mass data |
| CN110928901A (en) * | 2019-10-28 | 2020-03-27 | 武大吉奥信息技术有限公司 | Map layer joint query method, device and storage device based on MapServer service protocol |
| CN112148731A (en) * | 2020-08-13 | 2020-12-29 | 新华三大数据技术有限公司 | Data paging query method, device and storage medium |
| CN112650779A (en) * | 2021-01-12 | 2021-04-13 | 浪潮云信息技术股份公司 | Cloud auditing method based on ElasticSearch supporting deep page jump query |
| CN113590623A (en) * | 2021-07-28 | 2021-11-02 | 上海万物新生环保科技集团有限公司 | Method, device and equipment for data deep paging query |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1866251A (en) * | 2005-12-08 | 2006-11-22 | 华为技术有限公司 | Method and apparatus for reducing paging data retrieve time |
| CN101216840A (en) * | 2008-01-21 | 2008-07-09 | 金蝶软件（中国）有限公司 | Data enquiry method and data enquiry system |
| US7761451B2 (en) * | 2005-06-17 | 2010-07-20 | Microsoft Corporation | Efficient querying and paging in databases |
| CN103020151A (en) * | 2012-11-22 | 2013-04-03 | 用友软件股份有限公司 | Large data quantity batch processing system and large data quantity batch processing method |
| CN103530378A (en) * | 2013-10-15 | 2014-01-22 | 福建榕基软件股份有限公司 | Data paging query method and device and data base construction method and device |
-
2014
- 2014-02-24 CN CN201410062355.3A patent/CN103886022B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7761451B2 (en) * | 2005-06-17 | 2010-07-20 | Microsoft Corporation | Efficient querying and paging in databases |
| CN1866251A (en) * | 2005-12-08 | 2006-11-22 | 华为技术有限公司 | Method and apparatus for reducing paging data retrieve time |
| CN101216840A (en) * | 2008-01-21 | 2008-07-09 | 金蝶软件（中国）有限公司 | Data enquiry method and data enquiry system |
| CN103020151A (en) * | 2012-11-22 | 2013-04-03 | 用友软件股份有限公司 | Large data quantity batch processing system and large data quantity batch processing method |
| CN103530378A (en) * | 2013-10-15 | 2014-01-22 | 福建榕基软件股份有限公司 | Data paging query method and device and data base construction method and device |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105653537A (en) * | 2014-11-13 | 2016-06-08 | 阿里巴巴集团控股有限公司 | Paging query method and device for database application system |
| CN105159941B (en) * | 2015-08-07 | 2019-02-19 | 小米科技有限责任公司 | Data record lookup method and device |
| CN105159941A (en) * | 2015-08-07 | 2015-12-16 | 小米科技有限责任公司 | Data record searching method and device |
| CN105426449A (en) * | 2015-11-09 | 2016-03-23 | 小米科技有限责任公司 | Method and device for massive data query and server |
| CN107193822A (en) * | 2016-03-14 | 2017-09-22 | 阿里巴巴集团控股有限公司 | For the method for paging query, device and equipment |
| CN106874326A (en) * | 2016-07-05 | 2017-06-20 | 阿里巴巴集团控股有限公司 | A kind of item list obtains request processing method and device |
| CN106227894B (en) * | 2016-08-24 | 2019-11-26 | 中国农业银行股份有限公司 | A kind of data page querying method and device |
| CN106227894A (en) * | 2016-08-24 | 2016-12-14 | 中国农业银行股份有限公司 | A kind of data page querying method and device |
| CN108228663A (en) * | 2016-12-21 | 2018-06-29 | 杭州海康威视数字技术股份有限公司 | A kind of paging search method and device |
| CN110569259A (en) * | 2019-07-26 | 2019-12-13 | 苏宁云计算有限公司 | Method and device for processing mass data |
| CN110928901A (en) * | 2019-10-28 | 2020-03-27 | 武大吉奥信息技术有限公司 | Map layer joint query method, device and storage device based on MapServer service protocol |
| CN110928901B (en) * | 2019-10-28 | 2022-05-31 | 武大吉奥信息技术有限公司 | Map layer joint query method, device and storage device based on MapServer service protocol |
| CN112148731A (en) * | 2020-08-13 | 2020-12-29 | 新华三大数据技术有限公司 | Data paging query method, device and storage medium |
| CN112148731B (en) * | 2020-08-13 | 2022-05-27 | 新华三大数据技术有限公司 | Data paging query method, device and storage medium |
| CN112650779A (en) * | 2021-01-12 | 2021-04-13 | 浪潮云信息技术股份公司 | Cloud auditing method based on ElasticSearch supporting deep page jump query |
| CN113590623A (en) * | 2021-07-28 | 2021-11-02 | 上海万物新生环保科技集团有限公司 | Method, device and equipment for data deep paging query |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103886022B (en) | 2019-01-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103886022A (en) | Paging-query querying device and method based on primary key fields | |
| CN102880687B (en) | Based on individual interactive data retrieval method and the system thereof of label technique | |
| US9753960B1 (en) | System, method, and computer program for dynamically generating a visual representation of a subset of a graph for display, based on search criteria | |
| CN105138312B (en) | A kind of table generation method and device | |
| CN110515896B (en) | Model resource management method, model file manufacturing method, device and system | |
| CN102193798B (en) | Method for automatically acquiring Open application programming interface (API) based on Internet | |
| CN105354256A (en) | Data pagination query method and apparatus | |
| CN107194007A (en) | A kind of integrated management system of spacecraft isomery test data | |
| CN111125086A (en) | Method, device, storage medium and processor for acquiring data resources | |
| US10789277B2 (en) | Systems methods, and apparatuses for creating, linking and discovering business navigation maps for analyzing data | |
| JP2004220215A (en) | Operation guide and support system and operation guide and support method using computer | |
| CN110955646A (en) | Data storage and query method, device, equipment and medium | |
| CN107066509A (en) | Information providing method, processing server and merging server | |
| CN104036035A (en) | Historical searching suggestion prompting method and device | |
| CN103425490B (en) | Based on the management method running object data in crm system | |
| CN104142952A (en) | Method and device for showing reports | |
| CN113515610A (en) | File management method based on object-oriented language processing | |
| CN105184550B (en) | Manage method, server and the system of waiting data | |
| CN111143356B (en) | Report retrieval method and device | |
| CN111625570B (en) | List data resource retrieval method and device | |
| CN106250477A (en) | A kind of paging method of point of table data | |
| CN103324640A (en) | Method and device for determining search result file, as well as equipment | |
| CN103164468A (en) | Patent sort management method and management system | |
| CN112328837A (en) | Data display method, device, equipment and storage medium | |
| JP2015075919A (en) | File management device and system, and program |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |