Cross-database paging querying method for multi-database table
The invention provides a cross-database paging querying method for a multi-database table, and belongs to the technical field of data query. The method is used for performing data query on the multi-database table in a plurality of databases, and comprises the following steps: firstly, judging wheth...
Gespeichert in:
Hauptverfasser: | , , , |
---|---|
Format: | Patent |
Sprache: | eng |
Schlagworte: | |
Online-Zugang: | Volltext bestellen |
Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
Zusammenfassung: | The invention provides a cross-database paging querying method for a multi-database table, and belongs to the technical field of data query. The method is used for performing data query on the multi-database table in a plurality of databases, and comprises the following steps: firstly, judging whether statistic information that reflects query record conditions and corresponds to query instructions is stored in a buffer; detaching the query tasks into a plurality of sub-tasks according to the instructions if the judgment is negative, and executing the plurality of sub-tasks in parallel so as to return the total quantity of the query records corresponding to the plurality of sub-tasks and generating the statistic information, and storing the statistic information into the buffer; informing the sub-tasks corresponding to the expected query records according to the statistic information and executing the corresponding sub-tasks in parallel if the judgment is positive. The method is high in query efficiency, high in security and suitable for cross-database paging query of the multi-database table. |
---|