Master Data List Verification via Segmented Repositories

Resolve Bottlenecks,
Find Innovative Solutions
Generate Solutions

Solution Overview

Problem

Centralized data lists, such as software inventories, often rely on cumbersome collaboration tools that are insecure, allowing unauthorized access and tampering, and fail to properly collate data from multiple users with different access permissions.

Innovation Solution

A system that uses separate, access-restricted repositories and forms for different user groups to collect and verify data, ensuring secure and accurate compilation of a master list by restricting access and automating error-checking and public version generation.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Adaptability or versatility

If centralized data lists rely on collaboration tools allowing multiple users to access and edit, then data collation from multiple users is enabled, but security and prevention of unauthorized access and tampering deteriorates

Engineering Contradiction:
Improvedata collation capabilityVSAvoidsecurity
Core Design Contradiction:
Adaptability or versatilityVSReliability

Solution Approach 1:

The system divides the data collection process into separate segments: a first repository for initial data entry, a second repository for additional data, and a master repository for the final compiled list. Each repository has restricted access permissions assigned to specific user groups, allowing data collation while preventing unauthorized tampering. The verification process further segments responsibilities by assigning different users to verify different aspects of data accuracy.

Inventive Principle:
Principle #1Segmentation

2Reliability

If multiple users with different access permissions need to contribute and verify data, then comprehensive data validation is achieved, but system complexity increases

Engineering Contradiction:
Improvedata validation accuracyVSAvoidsystem complexity
Core Design Contradiction:
ReliabilityVSDevice complexity

Solution Approach 1:

The system introduces an intermediary verification process that automatically checks data consistency between the first and second repositories before adding entries to the master repository. This intermediary verification layer simplifies the overall system by automating the complex task of coordinating multiple users with different permissions, ensuring data validation accuracy without requiring complex manual coordination protocols.

Inventive Principle:
Principle #24Intermediary (Mediator)

3Measurement precision

If manual verification processes are used to ensure data accuracy, then error-checking is performed, but time consumption and productivity reduction occurs

Engineering Contradiction:
Improvedata accuracyVSAvoiddata entry efficiency
Core Design Contradiction:
Measurement precisionVSProductivity

Solution Approach 1:

The system implements automated feedback mechanisms where the verification process automatically checks data consistency between repositories and provides immediate feedback on data accuracy. This automated feedback loop eliminates the need for manual verification while maintaining high data accuracy standards, thereby improving productivity without sacrificing measurement precision.

Inventive Principle:
Principle #23Feedback

Solution Approach 2:

The verification process is designed to be self-service, automatically checking data consistency and generating notifications without requiring manual intervention. The system self-verifies data accuracy by comparing entries across repositories and automatically identifies discrepancies, eliminating time-consuming manual verification while maintaining high data quality standards.

Inventive Principle:
Principle #25Self-service

Data Source

PatentUS12079188B2Automatic building, verifying, and securing of a master data list
Publication Date: 2024.09.03 CAPITAL ONE SERVICES LLC
  • US12079188B2 patent drawing
  • US12079188B2 patent drawing
  • US12079188B2 patent drawing

AI summary

In some implementations, a system may receive, from a first user, data associated with a new database entry to be added to a master database that is associated with multiple sets of users having different access permissions to entries in the master database. The system may write the data to a first repository, write an entry including the data to a master repository, and generate a record of the entry. The system may receive, from a second user, additional data associated with the new database entry. The system may write the additional data to a second repository, modify the entry in the master repository based on the additional data, and generate a record of the modified entry. The system may perform verifications and output a notification based on the verifications. The system may further output, to a public repository, the modified entry with at least one data value removed.