Dirty Data Root Cause Tracing Through Database Conversion Relationships

Solution Overview

Problem

Existing methods for locating the root cause of dirty data in database systems are inefficient, as they rely on manual processes that do not effectively identify the source of dirty data generation.

Innovation Solution

A method and apparatus that utilize a first device to obtain conversion relationships between data storage files and sets within a database system, allowing for automated identification of the root cause of dirty data by tracing the conversion history and operations applied to these files and sets.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Productivity

If manual root cause locating is used, then device complexity is reduced, but productivity and measurement precision deteriorate

Engineering Contradiction:

Improveefficiency of locating root causeVSAvoidcomplexity of root cause locating system

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The database system automatically traces conversion relationships and identifies root causes of dirty data without requiring manual intervention. The system serves itself by using its own conversion relationship records to locate and report root causes, eliminating the need for external manual analysis while improving efficiency and precision.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The system implements feedback by automatically detecting dirty data, tracing back through conversion relationships to identify root causes, and reporting the results. This closed-loop feedback mechanism enables continuous improvement and automatic resolution of data quality issues without manual intervention.

Inventive Principle:

Principle #23Feedback

2Measurement precision

If manual root cause locating is used, then device complexity is reduced, but measurement precision of root cause identification deteriorates

Engineering Contradiction:

Improveaccuracy of root cause identificationVSAvoidcomplexity of root cause locating system

Core Design Contradiction:

Measurement precisionVSDevice complexity

Solution Approach 1:

The database system automatically traces conversion relationships and identifies root causes of dirty data without requiring manual intervention. The system serves itself by using its own conversion relationship records to locate and report root causes, eliminating the need for external manual analysis while improving efficiency and precision.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The patent replaces manual mechanical analysis with automated computational tracing of conversion relationships. The system uses algorithmic processing of conversion relationship records to precisely identify root causes, substituting human manual inspection with automated digital traceability for higher precision.

Inventive Principle:

Principle #28Mechanics substitution (Replace mechanical system)

3Productivity

If automated root cause locating is implemented, then productivity improves, but device complexity increases

Engineering Contradiction:

Improveefficiency of locating root causeVSAvoidcomplexity of root cause locating system

Core Design Contradiction:

ProductivityVSDevice complexity

Solution Approach 1:

The database system automatically traces conversion relationships and identifies root causes of dirty data without requiring manual intervention. The system serves itself by using its own conversion relationship records to locate and report root causes, eliminating the need for external manual analysis while improving efficiency and precision.

Inventive Principle:

Principle #25Self-service

Solution Approach 2:

The conversion relationship tracing mechanism serves multiple functions: it tracks data conversion history, identifies root causes of dirty data, and provides audit trails. This multi-functional approach consolidates multiple system functions into a single mechanism, improving productivity without proportionally increasing complexity.

Inventive Principle:

Principle #6Universality (Multi-functionality)

Data Source

PatentUS20250217226A1Root Cause Locating Method and Apparatus, and Storage Medium

Publication Date: 2025.07.03 HUAWEI CLOUD COMPUTING TECHNOLOGIES CO LTD

AI summary

A root cause locating method includes a first device that obtains a first conversion relationship between a plurality of data storage files and a first data storage file, where the first data storage file includes first dirty data, and the plurality of data storage files include the first data storage file. The first device determines, based on the first conversion relationship and the first data storage file, a root cause of generating the first dirty data.