Application data quality detecting method

A quality detection method and data detection technology, applied in the computer field, can solve problems such as adverse effects of enterprise decision-making analysis, and achieve the effect of convenient operation and strong adaptability

Inactive Publication Date: 2008-02-06
INSPUR SOFTWARE CO LTD
View PDF0 Cites 9 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, there are a lot of illegal data and garbage data in these systems,

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

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0011] The method of the present invention is realized by J2EE, and current mainstream databases such as ORACLE, SQLSERVER and DB2 all support the use of the SQL generator tool.

[0012] An application data quality detection method of the present invention is used to detect and compare and analyze the data of multiple business systems. It detects illegal data in multiple business systems specifying different business rules and corrects them, so as to improve The data quality of each business system, the specific steps are as follows:

[0013] 1) Abstract complex data detection and analysis into specific data detection rules, and provide a SQL generator suitable for different database detection, and automatically or manually generate SQL statements required for data detection rules through the SQL generator;

[0014] 2) In the process of data detection and comparative analysis, the SQL generator performs single, multiple or automatic detection of the detection rules, and automa...

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 present invention aims at providing an applied data quality test method, the method is mainly used in testing and comparative analysis for a plurality of business systems, and can be used to check out illegal data appointed in a plurality of business systems of different business rules and correct the illegal data to improve the data quality of each business system. The specific steps are as follows: firstly, the complex data testing and analysis can be abstracted into concrete data testing rules, and a SQL generator which is adapted to different database testings is provided, through the SQL generator, the SQL sentences required by data testing rules can be automatically or manually generated; secondly, during the process of data testing ad comparative analysis, the SQL generator executes a single item, a plurality of items or an automatic testing to the testing rules, the testing is automatically executed to formulate an execution plan for the periodical and timing execution; thirdly, the SQL generator makes various comparative analysis for the tested out result and provides query for the tested out but not corrected data.

Description

1. Technical field [0001] The invention relates to the computer field, and is a system for realizing data quality detection of various databases. 2. Technical background [0002] With the strengthening of informatization in various industries, there are more and more application information systems. However, there are a lot of illegal data and garbage data in these systems, which have a negative impact on the decision-making analysis of enterprises. 3. Contents of the invention [0003] The purpose of the present invention is to provide a method for detecting the quality of application data. The method uses user-defined detection rules to detect different database systems and compares and analyzes the detected data. Illegal data in the system is detected, and then corrected to improve the data quality of each business system, the specific steps are as follows: [0004] 1) Abstract complex data detection and analysis into specific data detection rules, and provide a SQL g...

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
Inventor 李红雷刘金贵
Owner INSPUR SOFTWARE CO LTD
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