Database Uniqueness Control via Data-Storage Mapping
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data uniqueness control methods lack flexibility and cannot accommodate different uniqueness control requirements for various types of data, leading to inefficient data management in service systems.
Innovation Solution
A method and apparatus that map data storage spaces to specific control information based on their contents, combining data with control information to check for uniqueness, and either reject or modify data to ensure uniqueness, allowing for flexible control of data uniqueness across different types of data.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If the same determination program is used for all data types, then the system is simple to implement, but it cannot accommodate different uniqueness control requirements for different types of data
Solution Approach 1:
The patent applies local quality by assigning different uniqueness control policies to different data types. Each data type (e.g., login password, payment password, mobile phone number) has its own uniqueness determination program with specific control requirements. The system determines the data type first, then applies the corresponding localized control policy, allowing each data field to have tailored uniqueness requirements rather than a blanket approach.
Solution Approach 2:
The patent segments the uniqueness control mechanism into multiple independent determination programs, each dedicated to a specific data type. Instead of one monolithic control system, the patent divides the control logic into separate modules (login password uniqueness determination, payment password uniqueness determination, mobile phone number uniqueness determination, etc.), allowing independent configuration and management of each segment's uniqueness rules.
2Adaptability or versatility
If different uniqueness control policies are implemented for different data types, then adaptability improves, but the system complexity increases
Solution Approach 1:
The patent implements universality by creating a unified uniqueness control system that handles multiple data types through a common framework. The system includes a universal data type determination module that identifies the type of data being processed, then routes it to the appropriate uniqueness determination program. This multi-functional approach allows a single system to serve multiple purposes (controlling uniqueness for passwords, phone numbers, emails, etc.) without requiring completely separate systems for each data type.
3Reliability
If data uniqueness is strictly enforced, then data quality improves, but data writing efficiency decreases due to frequent rejections and modifications
Solution Approach 1:
The patent applies preliminary action by performing uniqueness verification before data is written to the database. The system determines the data type, applies the corresponding uniqueness determination program, and checks for conflicts before the write operation occurs. If a conflict is detected, the system rejects or modifies the data in advance, preventing the need for post-write corrections and reducing the overall number of write operations required.
Data Source
AI summary
Techniques for flexibly controlling data uniqueness which are applicable to different types of data that require different data uniqueness control. Control information mapped by a data storage space of a database is determined. The control information and data to be written into the data storage space is combined to obtain a combination result. The techniques of the present disclosure determine whether there is another combination result that is the same as the combination result. The techniques of the present disclosure, in response to determining that there is another combination result that is the same as the combination result, reject to write into the data storage space the data to be written into the data storage space of the database; or modify the another data in the database.