Dynamic Entity Identifier Release Time Management
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing systems that manage entity identifiers (EIDs) in databases face limitations due to a limited pool of possible EIDs, leading to restricted scalability and increased resource usage, as they employ static time intervals to prevent interference events.
Innovation Solution
A computerized method dynamically determines the release time of an EID based on interaction data associated with the deactivated data record entity, allowing for a shorter restricted time interval and reducing the average time EIDs are restricted, thereby improving resource management.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If a static time interval is used to restrict EID reassignment after deactivation, then interference events are prevented, but the quantity of available EIDs is limited and scalability is reduced
Solution Approach 1:
The patent applies dynamics by transitioning from a static fixed time interval to a dynamic variable time interval for EID restriction. The restriction period is adjusted based on interaction data analysis, allowing the system to adapt the restriction duration to actual risk levels. This enables longer restrictions for high-risk EIDs and shorter or no restrictions for low-risk EIDs, thereby increasing the pool of available EIDs and improving scalability while maintaining interference prevention.
2Reliability
If a static time interval is used to restrict EID reassignment, then interference events are prevented, but the average time EIDs are restricted increases
Solution Approach 1:
The patent applies parameter changes by modifying the restriction time parameter from a fixed value to a variable value based on interaction data. The system analyzes interaction patterns and adjusts the restriction duration parameter accordingly, changing it from a static system parameter to a dynamic one that adapts to specific EID risk profiles. This reduces the average restriction time across the EID pool while maintaining adequate protection against interference events.
3Quantity of substance
If a limited pool of EIDs is used, then resource usage is controlled, but the quantity of new data record entities that can be assigned EIDs is limited
Solution Approach 1:
The patent applies dynamics by making the EID restriction period dynamic rather than static. By analyzing interaction data and adjusting restriction durations based on actual risk levels, the system increases the turnover rate of restricted EIDs. This dynamic approach effectively enlarges the available EID pool over time, enabling higher productivity in creating new data record entities without expanding the actual EID pool size.
Data Source
AI summary
A computerized method manages entity identifiers (EIDs) of data records in a database, including restricting and releasing EIDs associated with deactivated data record entities. An EID uniquely identifies the deactivated data record entity among a group of data record entities. The obtained EID is restricted from being assigned to another data record entity, and interaction data associated with the EID and deactivated data record entity is obtained. The interaction data is associated with interactions of the deactivated data record entity prior to deactivation. A release time of the EID is determined using the obtained interaction data. The EID is later released for assignment based on the determined release time and then assigned to a new data record entity. The dynamic calculation of the release time reduces the time intervals during which EIDs are restricted, and increases the rate at which EIDs can be reused with new data record entities.