Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Completeness checking method and device for sub-table data

A data inspection and completeness technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as missing data entries and incomplete data entries, and achieve the effect of reducing the probability of omissions

Active Publication Date: 2017-08-11
ANT WEALTH (SHANGHAI) FINANCIAL INFORMATION SERVICES CO LTD
View PDF3 Cites 11 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, although the bottleneck of data processing performance of the server can be alleviated by sub-database sub-table, after sub-database sub-table for a single database, the data entries to be processed in the single database will usually be scattered on different databases. Therefore, if it is necessary to perform unified processing on all data entries in the single database through a scheduled task, there may be cases where data entries to be processed are missed due to incomplete data entries in some data sub-tables question

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
  • Completeness checking method and device for sub-table data
  • Completeness checking method and device for sub-table data
  • Completeness checking method and device for sub-table data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] In related technologies, in order to solve the problem that the data processing performance of the server encounters a bottleneck due to the large amount of business data carried in a single database and the limited processing resources of the server, it is usually possible to use sub-database and sub-table technology to convert a single The business data in the database is split and stored in several different data sub-tables. For example, a single database can be split into multiple data sub-databases, and each data sub-database can be further split into multiple data sub-tables.

[0029] Although the technology of sub-database and sub-table can alleviate the bottleneck problem of server data processing performance to some extent, in practical applications, after a single database is split into multiple data sub-tables through sub-database and sub-table technology, there is usually still There is a need for unified processing of business data in each data sub-table th...

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 completeness checking method and device for sub-table data. The completeness checking method and device are applied to a distributed server cluster. The device comprises a control server and a business server. Business data in the business server is split and stored in a plurality of different data sub-tables. The method comprises the steps that the control server collects the business data in all the data sub-tables into a local preset data table; before a timing processing task against the preset data table is triggered, a data checking request for all the data sub-tables is sent to the business server in a timing mode; the business server executes data completeness checking on all the data sub-tables responding to the data checking request and supplements and sends business data to the control server; and the control server supplements the business data collected in the preset data table. Through the completeness checking method and device, the completeness of the business data in all the data sub-tables when the timing task is triggered can be ensured to the maximum extent, and the probability of omission of to-be-processed business data is effectively lowered.

Description

technical field [0001] The present application relates to the field of computer applications, in particular to a method and device for checking the completeness of sub-table data. Background technique [0002] Sub-database sub-table refers to a data splitting method that stores data with the same structure in blocks into multiple data sub-tables on multiple databases. By sub-database and sub-table, it can solve the problem that the data processing performance of the server encounters a bottleneck due to the large amount of data carried in a single database and the limited processing resources of the server. [0003] However, although the bottleneck of data processing performance of the server can be alleviated by sub-database sub-table, after sub-database sub-table for a single database, the data entries to be processed in the single database will usually be scattered on different databases. Therefore, if it is necessary to perform unified processing on all data entries in ...

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/2282
Inventor 张腾杜涛薛中亚周剑
Owner ANT WEALTH (SHANGHAI) FINANCIAL INFORMATION SERVICES CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products