Check patentability & draft patents in minutes with Patsnap Eureka AI!

Cross-database paging querying method for multi-database table

A paging query and data query technology, applied in the field of data query, can solve the problems of too many database tables, cross-database access, etc., achieving the effect of strong versatility, ensuring security, and reducing access

Active Publication Date: 2015-04-29
CHINA UNIONPAY
View PDF5 Cites 19 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Even if nicknames are used in the field of data query with low security requirements, it can only solve the problem of cross-database access, and still face the problem of too many database tables

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Cross-database paging querying method for multi-database table
  • Cross-database paging querying method for multi-database table
  • Cross-database paging querying method for multi-database table

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0053]The following introduces some of the possible embodiments of the present invention, which are intended to provide a basic understanding of the present invention, but are not intended to identify key or decisive elements of the present invention or limit the scope of protection. It is easy to understand that, according to the technical solution of the present invention, those skilled in the art may propose other alternative implementation manners without changing the essence and spirit of the present invention. Therefore, the following specific embodiments and drawings are only exemplary descriptions of the technical solution of the present invention, and should not be regarded as the entirety of the present invention or as a limitation or restriction on the technical solution of the present invention.

[0054] figure 1 Shown is a schematic flowchart of a cross-database paging query method for multiple database tables according to an embodiment of the present invention. ...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

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.

Description

technical field [0001] The invention belongs to the technical field of data query and relates to a cross-database paging query method for multiple database tables. Background technique [0002] With the advent of the era of big data, it is becoming more and more difficult to query massive amounts of data, and its query efficiency has also attracted much attention. [0003] Taking the banking and financial industry as an example, with the rapid development of the bank card industry, the total number of daily cross-bank transactions has exceeded 30 million. The traditional method of a single database table is far from meeting the requirements of database operation and maintenance. Requirements, splitting database tables and splitting databases is an inevitable choice. Therefore, various transaction data will be stored in the form of multiple databases, and each database corresponds to multiple database tables. [0004] At present, in the query of multiple database tables loc...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
CPCG06F16/25
Inventor 唐真周继恩汤茂安李伟
Owner CHINA UNIONPAY
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com