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...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: ZHOU JIEN, TANG MAOAN, LI WEI, TANG ZHEN
Format: Patent
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
Beschreibung
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.