An industrial finished product warehouse full-service integrated processing method based on table value parameters

By designing a fully enclosed stored procedure and a unified TVP entry point, the fragmentation of business logic and security vulnerabilities in the industrial finished goods warehouse management system are resolved, achieving cross-database compatibility and controllable permissions, thus meeting the high security and localization requirements of industrial production.

CN122132471APending Publication Date: 2026-06-02HANDAN DINGSHENG DIGITAL INTELLIGENCE TECHNOLOGY CO LTD
View PDF 0 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
HANDAN DINGSHENG DIGITAL INTELLIGENCE TECHNOLOGY CO LTD
Filing Date
2026-03-18
Publication Date
2026-06-02

AI Technical Summary

Technical Problem

Existing industrial finished goods warehouse management systems suffer from fragmented business logic, security vulnerabilities, complex cross-system integration, incompatibility, and uncontrollable permissions, failing to meet the high security and domestic production requirements of industrial production.

Method used

The architecture design adopts fully enclosed stored procedures, a unified TVP entry point, pure standard SQL, and strong transaction verification to achieve minimum access control and full-process traceability of data access. All operations are encapsulated through unified stored procedures, cross-database compatibility is achieved using standard SQL syntax, and regular and bypass business processes are handled in layers.

Benefits of technology

It achieves the highest level of data security, system stability, and reduced maintenance costs, supports the migration of domestically produced databases, and meets the security and scalability requirements of industrial production.

✦ Generated by Eureka AI based on patent content.
Patent Text Reader

Abstract

This invention presents a unified processing method for eight business processes in an industrial finished goods warehouse based on table-valued parameters, relating to the fields of industrial MES and database security technology. This method encapsulates all eight processes—normal inbound, normal outbound, other inbound, other outbound, and corresponding queries—into stored procedures, using table-valued parameters as unified input parameters and standard SQL to achieve cross-database compatibility. A fully enclosed security architecture prevents direct front-end access to data tables, eliminating SQL injection and unauthorized operations at the source. Layered business logic, strong transactions, and pre-validation ensure data consistency, achieving controllable, secure, and standardized unified management of all finished goods warehouse business processes. This invention is applicable to industrial scenarios such as metallurgy and manufacturing, and can run seamlessly in databases such as SQL Server and GaussDB, improving system security, stability, and maintainability. This invention has been fully implemented in a real industrial ERP system, can run stably in real production environments for a long time, and possesses mature engineering value and industrial promotion capabilities.
Need to check novelty before this filing date? Find Prior Art