A production record safe deletion method and system based on serial number control

Abstract

The application discloses a production record security deletion method and system based on serial number control, and relates to the technical field of production data security and business process control.The application prohibits record deletion of records that have entered downstream processes or have been warehoused through business forbidden area verification, allows only reverse sequence deletion of the same batch through serial number verification, forms an unalterable audit track through automatic full-quantity archiving, guarantees the atomicity of deletion, rollback and recalculation through a transaction mechanism, and automatically completes state recovery and statistical index correction, thereby realizing rigid security control from the process level.The application can completely eliminate malicious deletion, misoperation and data disorder, has the characteristics of traceability, high consistency, high stability, strong versatility and the like, has been implemented in an industrial ERP / MES system, and is suitable for production and warehousing data security management of various manufacturing enterprises.The application has been completely implemented and applied in an actual industrial ERP system, can be stably operated in a real production environment for a long time, and has mature engineering value and industrialization popularization capability.

Description

Technical Field

[0001] This invention relates to the fields of industrial production data security, rigid control of business processes, database transaction management, and production management systems. Specifically, it relates to a method and system for securely deleting production records based on sequence number control, restricted area verification, automatic archiving, and transaction protection. Background Technology

[0002] In manufacturing enterprises' production management systems, ERP systems, and MES systems, the deletion of production records is a high-frequency and high-risk operation. Traditional deletion methods generally suffer from the following technical shortcomings: The lack of a business restricted area verification mechanism allows production records that have entered downstream processes, been put into storage, settled, or reported to be deleted at will, resulting in a break in the business chain and data distortion. The lack of batch number control rules allows for skipping and random deletion, resulting in logical confusion in the production data of the same batch and unreliable statistical results. There is no automatic full archiving before deletion, the operation leaves no trace and is not auditable, and problems cannot be traced. After deletion, there is no automatic status rollback or statistical indicator recalculation, resulting in inconsistencies in data such as inventory, output, yield rate, pass rate, and total weight. Without the atomicity guarantee of database transactions, abnormal interruption of the deletion process can easily lead to data corruption or a partially deleted state. Relying on manual review and access control cannot achieve rigid security constraints at the system process level.

[0003] Existing technologies cannot fundamentally solve the data security problems caused by accidental deletion, malicious deletion, and unauthorized deletion, and are insufficient to meet the high reliability, high security, and traceability management requirements of industrial production. Summary of the Invention

[0004] The purpose of this invention is to overcome the shortcomings of existing technologies and provide a method and system for securely deleting production records based on serial number control. Through multi-layer rigid verification, reverse deletion mandatory rules, full automatic archiving, transaction atomicity guarantee, and automatic state repair, the entire process of deleting production records is secure, controllable, traceable, and data consistent.

[0005] I. Overall Technical Solution A method for securely deleting production records based on sequence number control includes: Record information parsing: Obtain the unique identifier of the record to be deleted, and parse out the batch, batch number, process status, and related business data; Business restricted area verification: Determine whether the record has entered the downstream process, has been put into storage, has been settled, or has been reported. If it has entered the restricted area, delete it directly and return an exception. Sequence number rule validation: Only records with the highest current sequence number within the same batch are allowed to be deleted; skipping sequences, deleting in the middle, or deleting in random order are not allowed. Full record archiving: Before deletion is executed, the original records are automatically written to the deletion history table to form an immutable snapshot; Atomic execution of transactions: Archiving and deletion are completed within a database transaction, and any failure in any step immediately results in a complete rollback; Post-data repair: Based on whether it is the first record in the same batch, automatically perform upstream status rollback or recalculate statistical indicators; The results are returned uniformly: the reason for successful or failed deletion is returned, and the entire process is auditable and traceable.

[0006] II. System Composition A production record secure deletion system based on sequence number control includes: Record parsing module: Obtains and extracts the unique identifier, batch, sequence number, and business status of the record to be deleted; Restricted Area Verification Module: Determines whether the business is in a restricted area that cannot be deleted; Serial number verification module: Verifies whether it is the current maximum serial number in the same batch; Resume archiving module: Automatically saves original data to deleted resume tables; Transaction control module: Ensures the atomicity of archiving, deletion, rollback, and recalculation; Status repair module: Automatically performs status rollback and recalculations of statistical indicators; Audit log module: Records the operator, time, address, result, and raw data. Beneficial effects

[0007] Rigid restricted area protection: Prohibit the deletion of records that have been transferred or entered into the database, blocking unauthorized operations at the source; Forced reverse deletion: Ensures the logical integrity of batch data and prevents disordered skipping order; Full automatic archiving: Deletion leaves a trace, enabling full traceability and auditability; Automatic data repair: Automatically rolls back the status and recalculates metrics after deletion to maintain data consistency; Transaction atomicity guarantee: exceptions do not dirty data or cause partial deletion, resulting in a more stable system; Extremely versatile: suitable for various production and warehousing systems in industries such as steel, metallurgy, equipment manufacturing, chemicals, and electronics; Mature engineering: It has been implemented in industrial ERP / MES systems and is running stably for a long time. Detailed Implementation

[0008] Input to be received: ID of the record to be deleted, operator, terminal address, and operation time.

[0009] Data parsing: The query retrieves the batch number, the sequence number within the batch, the current process, whether it has been put into storage, and whether it has been settled.

[0010] Restricted Area Verification: The message has been sent to downstream processes → Do not delete. Already in inventory / Settled / Reported → Do not delete Serial number verification: Query the maximum serial number in the same batch Record number to be deleted ≠ maximum number → Deletion prohibited Automatic archiving: Write all fields from the original record into the deletion history table. Record the person who deleted the data, the time, the IP address, the reason for deletion, and the original data. Start a database transaction: Execution record deletion Determine if it is the first record in the same batch: Yes → Roll back the upstream document status to unprocessed or incomplete. No → Recalculate yield rate, pass rate, weight, and total quantity. Commit the transaction; otherwise, roll back all transactions and return an error message.

[0011] Returning the operation result completes the entire safe deletion process.

Claims

1. A method for securely deleting production records based on serial number control, characterized in that, include: (1) Obtain the unique identifier of the record to be deleted, and parse it to obtain the corresponding batch identifier, batch number and business status; (2) Perform business restricted area verification on the records. If the records have entered the downstream process, have been put into the warehouse, have been settled, or have been reported, deletion is prohibited. (3) Perform serial number verification on the records and only allow deletion of the record with the highest current serial number in the same batch; (4) Before deletion, all original data of the records will be automatically archived to the deletion history table; (5) Execute the deletion operation in the database transaction, and automatically perform upstream status rollback or recalculate statistical indicators based on whether it is the first record in the same batch; (6) If any part of the process fails, the entire transaction is rolled back to ensure data atomicity and consistency.

2. The method according to claim 1, characterized in that, The batch number is an automatically generated, continuously increasing number within the same production batch.

3. The method according to claim 1, characterized in that, The deletion history table stores the operator, operation time, operation address, deletion reason, and the original full data of the record.

4. The method according to claim 1, characterized in that, When the record to be deleted is the first record in the same batch, the corresponding upstream production document will be automatically restored to the unprocessed or initial state.

5. The method according to claim 1, characterized in that, When the record to be deleted is not the first record, the yield rate, pass rate, total quantity, and total weight will be automatically recalculated.

6. The method according to claim 1, characterized in that, Restricted area verification, sequence number verification, data archiving, record deletion, status rollback, and indicator recalculation are all performed within the same transaction.

7. A production record secure deletion system based on serial number control, characterized in that, include: The record parsing module is used to obtain the unique identifier, batch identifier, batch sequence number, and business status; The restricted area verification module is used to determine whether a record is in a non-deletable state; The serial number verification module is used to verify whether it is the current maximum serial number in the same batch; The resume archiving module is used to automatically save the original data before deletion; The transaction execution module is used to perform deletion, rollback, and recalculation within a transaction; The status repair module is used to perform status rollback or statistical indicator correction.

8. The system according to claim 7, characterized in that, The system is applicable to production management systems, ERP, MES, warehouse management systems, and industrial data management platforms.