Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

Sub-library and sub-table detection method and device, computer equipment and storage medium

A technology of sub-database sub-table and detection method, applied in the field of data processing, can solve the problems of business error reporting, low accuracy and low efficiency, etc.

Active Publication Date: 2020-09-15
微民保险代理有限公司
View PDF5 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

A problem with any of the above risks will lead to business errors, and may even lead to serious consequences
[0004] In the prior art, the manual method is usually used to check whether there is a leakage table through the pre-configured rules, which has low efficiency and low accuracy.

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
  • Sub-library and sub-table detection method and device, computer equipment and storage medium
  • Sub-library and sub-table detection method and device, computer equipment and storage medium
  • Sub-library and sub-table detection method and device, computer equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] In order to make the purposes, technical solutions and advantages of the embodiments of the present application clearer, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments It is a part of the embodiments of this application, but not all of them. Based on the embodiments in the present application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present application.

[0032] figure 1 It is an application environment diagram of the sub-database and sub-table detection method in an embodiment. refer to figure 1 , the sub-database and sub-table detection method is applied to the sub-database and sub-table detection system. The sub-database and sub-table detection system includes a terminal 110 and a ...

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 relates to a sub-library and sub-table detection method and device, computer equipment and a storage medium. The sub-library and sub-table detection method comprises the steps of obtaining to-be-detected sub-table and sub-library information; according to the to-be-detected sub-library sub-table information, obtaining to-be-detected sub-library sub-table features; obtaining the typeof the to-be-detected sub-library sub-table according to the characteristics of the to-be-detected sub-library sub-table; generating an expected sub-library sub-table list according to the type of theto-be-detected sub-library sub-table; comparing the to-be-detected sub-library sub-table with the expected sub-library sub-table list; and if each sub-library sub-table in the expected sub-library sub-table list exists in the to-be-detected sub-library sub-table, determining that the to-be-detected sub-library sub-table has no missing table. According to the sub-library and sub-table detection method provided by the embodiment of the invention, automatic detection of the sub-libraries and sub-meters can be realized; manual intervention is not needed; the sub-libraries and sub-meters detectionefficiency is improved; and the sub-libraries and sub-meters detection accuracy can also be improved.

Description

technical field [0001] The present application relates to the field of data processing, and in particular to a sub-database and sub-table detection method, device, computer equipment and storage medium. Background technique [0002] With the development of the Internet, the use of databases is increasing. At present, the Internet generally uses MySQL as database storage software, because Internet business has the characteristics of high concurrency and large data volume, and MySQL itself also has performance and inconvenient management problems for large tables. The library sub-table is used to solve the above-mentioned performance and management problems. [0003] Generally, there are many kinds of rules for sub-databases and tables, and the number of sub-databases and tables in the entire system may range from tens to tens of millions. Under a large number of sub-tables, as time goes by and version changes, there will be various risks. One is that a series of sub-tables ...

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 Applications(China)
IPC IPC(8): G06F16/22G06F16/2457G06F16/28
CPCG06F16/2282G06F16/2457G06F16/284Y02D10/00
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
Eureka Blog
Learn More
PatSnap group products