Table Data Deletion Using Blank Records for Stable Operation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Deletion of data sets in a system can lead to stability issues, particularly when data is used across multiple instances, causing severe problems during system operation.
Innovation Solution
A method for deleting data sets from a table system involves reading, checking for specified properties, deleting data sets with those properties, and substituting their contents with blank data sets in another section, ensuring system stability by maintaining operational functionality even with blank data sets.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If data sets are deleted from the table system, then data storage space is freed and data consistency is maintained, but system stability deteriorates and operational errors occur
Solution Approach 1:
The patent creates a copy of the data set structure in the second table section, replacing the actual data with a blank data set that maintains the original structure. This allows the system to preserve the data footprint and operational interfaces while freeing the actual data for deletion in the first table section, thus maintaining system stability during deletion operations.
2Quantity of substance
If data sets are deleted to free storage space, then storage efficiency is improved, but system operation stability deteriorates
Solution Approach 1:
The patent divides the data storage system into two separate table sections: the first table section for actual data storage and the second table section for structural placeholder storage. This segmentation allows independent management of data and structure, enabling deletion of actual data while maintaining structural integrity in the second section, thus resolving the contradiction between storage efficiency and operational stability.
3Reliability
If data sets are deleted from the first table section, then data consistency is improved, but system functionality deteriorates due to missing data references
Solution Approach 1:
The second table section acts as an intermediary between the deletion operation in the first table section and the system's operational requirements. By maintaining structural placeholders in the second section, it mediates between the need for data consistency (through deletion) and the need for continuous system functionality (through preserved structure), allowing operations to proceed without direct access to deleted data.
Data Source
AI summary
A method for deleting data sets contained in a data list from a table system comprises the following steps, said steps being carried out for all data sets of said data list:reading one data set;checking whether said read data set has a specified property;if said data set has said specified property:deleting said data set in said first table; andsubstituting the contents of said data set in said second table by a blank data set.Furthermore, there is provided a computer program product and a device.