Polling access method and device for sub-database and sub-table

A technology of sub-database sub-table and polling access, applied in the information field, can solve the problems of low business execution efficiency, low efficiency of sub-database and sub-table access, etc.

Active Publication Date: 2020-06-26
蚂蚁(杭州)基金销售有限公司
View PDF6 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0009] The embodiment of the present application provides a polling access method and device for sub-database and sub-table, which is used to solve the problem in the prior art that the access efficiency of sub-database and sub-table is low, resulting in low efficiency of business execution

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
  • Polling access method and device for sub-database and sub-table
  • Polling access method and device for sub-database and sub-table
  • Polling access method and device for sub-database and sub-table

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] In this embodiment of the application, for a thread that needs to poll and access sub-databases and sub-tables, first determine the current globally unique cursor of the thread, then determine the corresponding sub-library ID and sub-table ID according to the cursor, and finally the sub-library ID and the sub-table identifier are returned to the thread, so that the thread accesses the corresponding sub-library and sub-table according to the sub-database identifier and the sub-table identifier. And when the thread polls to access the sub-library and sub-table, update the cursor of the thread, and re-determine the sub-library ID and sub-table ID that the thread needs to access through the same method, and finally make the thread poll to access all sub-libraries sub table. It can be seen that the method described in this application does not establish a fixed mapping relationship between threads and sub-databases and tables under the premise of ensuring data security in su...

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 method and device for polling access to sub-libraries and sub-meters. According to the method, a vernier of a thread of the sub-libraries and the sub-meters needing polling access is determined, only one vernier exists, according to the vernier, the corresponding sub-library identifier and the corresponding sub-meter identifier are determined, and the sub-library identifier and the sub-meter identifier are returned to the thread, so that the thread has access to the corresponding sub-library identifier and the corresponding sub-meter. Moreover, the thread requires polling access to the sub-libraries and the sub-meters, so the vernier of the thread can be updated, new sub-library identifiers and new sub-meter identifiers are returned to the thread by adopting the same method, and updating is repeated as such until the thread has access to all the sub-libraries and all the sub-meters. By means of the method, it is ensured that the same data can not be read by multiple threads, the threads can access the sub-libraries and the sub-meters, whether the threads are changed or databases are changed, a large amount of complex operation is not required, the operation efficiency of the sub-libraries and the sub-meters is increased, and the business execution efficiency is improved.

Description

technical field [0001] The present application relates to the field of information technology, in particular to a polling access method and device for sub-database and sub-table. Background technique [0002] With the development of the information society, people are becoming more and more accustomed to using the network for business, so that the number of business through the network is increasing, and the method of storing a large amount of data in a database or data table will make the database The operating efficiency of the system is greatly reduced, so people began to adopt the sub-database and sub-table technology, that is, split a data table in the database into multiple sub-tables in multiple databases according to preset rules, which has solved the problem of single database, data table performance bottlenecks. [0003] However, due to the fact that in actual application, there are situations where threads need to retrieve data from sub-databases and tables perio...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/22G06F16/21
CPCG06F16/21G06F16/2282
Inventor 董诗秉
Owner 蚂蚁(杭州)基金销售有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap