Data Quality Management System for Datasheet Redundancy Control

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

As databases and datasheets in data centers grow rapidly, issues arise such as disordered storage of datasheets, redundancy, inconsistency, and unclear data flow, making it difficult to manage and control data quality effectively.

Innovation Solution

A method and apparatus for data quality management that involves receiving application information from service sub-systems, resolving datasheet operation trigger information to obtain flow information, querying history information to determine datasheet names and consistency, and instructing the data center to store or update datasheets accordingly, ensuring proper naming conventions and reducing redundancy.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Quantity of substance

If multiple sub-systems store datasheets in a shared tablespace without centralized management, then data storage capacity increases, but datasheet searching becomes difficult and data quality deteriorates

Engineering Contradiction:
Improvedata storage capacityVSAvoiddatasheet searching
Core Design Contradiction:
Quantity of substanceVSEase of operation

Solution Approach 1:

The patent introduces a data center as an intermediary layer between multiple sub-systems and the shared tablespace. The data center implements centralized management mechanisms including automatic naming conventions, deduplication algorithms, and metadata indexing, which resolve the contradiction by enabling both large-scale storage and efficient retrieval through centralized coordination

Inventive Principle:
Principle #24Intermediary (Mediator)

2Adaptability or versatility

If datasheets are stored in multiple tablespaces across different sub-systems, then data accessibility improves, but redundancy increases and storage efficiency decreases

Engineering Contradiction:
Improvedata accessibilityVSAvoiddata redundancy
Core Design Contradiction:
Adaptability or versatilityVSQuantity of substance

Solution Approach 1:

The patent implements a selective copying mechanism where the data center creates standardized copies of datasheets only when necessary for specific sub-systems, rather than allowing uncontrolled duplication. The system uses naming conventions and deduplication algorithms to identify when copies are needed versus when references to existing data suffice, thus maintaining accessibility while minimizing redundancy

Inventive Principle:
Principle #26Copying

3Speed

If datasheets are updated in place without version control, then update speed increases, but data consistency deteriorates with old and new versions coexisting

Engineering Contradiction:
Improveupdate speedVSAvoiddata consistency
Core Design Contradiction:
SpeedVSReliability

Solution Approach 1:

The patent implements preliminary versioning actions before updates occur. The data center automatically creates versioned copies of datasheets before modifications, assigns unique version identifiers, and maintains a version history. This preliminary structuring enables fast updates while preventing consistency issues, as the system is pre-configured to handle versioning rather than attempting to manage it during the update process

Inventive Principle:
Principle #10Preliminary action

4Adaptability or versatility

If each sub-system manages its own datasheets independently, then sub-system autonomy is maintained, but data flow transparency decreases and quality control becomes difficult

Engineering Contradiction:
Improvesub-system autonomyVSAvoiddata flow transparency
Core Design Contradiction:
Adaptability or versatilityVSLoss of information

Solution Approach 1:

The patent implements a feedback mechanism where the data center continuously monitors and records datasheet operations across all sub-systems. Metadata about data creation, modification, and access is automatically captured and fed back to the data center, which maintains a centralized view of data flow. This feedback loop preserves sub-system autonomy for local operations while providing transparent visibility into overall data quality and flow patterns

Inventive Principle:
Principle #23Feedback

Data Source

PatentUS10248674B2Method and apparatus for data quality management and control
Publication Date: 2019.04.02 INFORMATION & COMMNUNICATION BRANCH STATE GRID JIANGXI ELECTRIC POWER CO
  • US10248674B2 patent drawing
  • US10248674B2 patent drawing
  • US10248674B2 patent drawing

AI summary

Embodiments of the present invention provide a method and an apparatus for data quality management and control. The method includes: receiving application information transmitted by a service sub-system; resolving datasheet operation trigger information to obtain datasheet flow information; receiving user information transmitted by the service sub-system and a target datasheet transmitted by the service sub-system; if a name of the target datasheet is different from a plurality of datasheet names corresponding to the service sub-system identifier, then instructing the service sub-system to store the target datasheet into a data center; if the datasheet operation information is updating a datasheet, instructing the data center to replace datasheet contents corresponding to the datasheet name with contents of the target datasheet.