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

Data quality inspection method, device and equipment and storage medium

A data quality inspection and data technology, applied in the database field, can solve the problems of long time consumption and low quality inspection efficiency, and achieve the effect of simple operation, reduced quality inspection cost, and improved user experience

Pending Publication Date: 2021-06-29
BANK OF CHINA
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the data quality inspection process usually takes a long time and the quality inspection efficiency is low

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
  • Data quality inspection method, device and equipment and storage medium
  • Data quality inspection method, device and equipment and storage medium
  • Data quality inspection method, device and equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0045] Normally, the database may include different database tables, and different database tables can be used to store data from different sources, for example, database table 1 can be used to store the data of various business systems in the existing group, and database table 2 can be used to store the data of the group External data collected and used internally, etc. Therefore, when performing quality inspection on the data in the database, for the same quality inspection task, the user usually needs to customize a special database statement for each database table, which makes the data quality inspection process slow because the user customizes different database statements. It takes a long time, resulting in low quality inspection efficiency and high cost.

[0046] Based on this, an embodiment of the present application provides a data quality inspection method to improve data quality inspection efficiency and reduce quality inspection costs. During specific implementat...

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 discloses a data quality inspection method and device, equipment and a storage medium, and specifically, the method comprises the steps: obtaining a target quality inspection rule template in response to a template selection operation of a user for a candidate quality inspection rule template, and obtaining a parameter value of a template parameter in response to a parameter value input operation of the user for the template parameter in the candidate quality inspection rule template; and automatically splicing the obtained target quality inspection rule template and the parameter value to generate a database statement, and executing the generated database statement to perform quality inspection on data in a database. Therefore, on one hand, the efficiency of automatically generating the database statement is generally higher than the efficiency of manually developing the database statement by a user, so that the overall data quality inspection efficiency can be improved, and the quality inspection cost is reduced; and on the other hand, the operation needing to be executed by the user is simpler and more convenient, the requirement for the technical level of the user is lowered, and the user experience is improved.

Description

technical field [0001] The present application relates to the technical field of databases, in particular to a data quality inspection method, device, equipment and storage medium. Background technique [0002] In the era of big data, the storage and management of massive data has become an important issue that people pay more and more attention to. For example, when storing relevant data of an enterprise group, the database not only stores the data of various business systems within the existing group, but also includes external data collected and used within the group, as well as various unstructured data with value for use and analysis. data. Since these data usually come from different systems, and the records of the same data in multiple systems may also be different, and the quality of some data may be low. Usually, the data stored in the database may have "data inaccuracy, data unreachable, incomplete data” and other issues. [0003] Therefore, in practical applica...

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/215G06F16/22G06F16/242G06F16/25
CPCG06F16/215G06F16/2282G06F16/2433G06F16/25Y02P90/30
Inventor 周允
Owner BANK OF CHINA
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