11 results about "Sql server" patented technology

This invention discloses a method and system for processing the entire lifecycle of procurement contracts based on a unified stored procedure with multiple TVPs and AI protection verification, belonging to the field of industrial software MES / ERP technology. This invention uses three sets of table-valued parameters (TVPs) as a unified data entry point, integrating six core operations—adding, modifying, deleting, appending details, modifying details, and deleting details—in a single stored procedure, and returning unified exception information through a single output parameter. The system incorporates a two-level centralized parameter verification mechanism. The first level performs a one-time empty table check on the three sets of TVP tables; if any table is empty, the transaction is immediately rolled back and an exception is returned. The second level performs centralized integrity and legality verification on all business parameters, achieving security protection for AI and external calls, effectively intercepting dirty data and illegal requests. This invention features a simple architecture, high execution efficiency, and comprehensive business coverage. The transaction mechanism ensures strong consistency of master-slave table data, supports compatible operation with both SQL Server and GaussDB databases, and can securely integrate into the AI ​​ecosystem without business restructuring. It is particularly suitable for the high-stability and high-security procurement contract business processing of complex factories with more than 11 production lines. This invention has been fully implemented in a real industrial ERP system and can run stably in a real production environment for a long time, demonstrating mature engineering value and industrial promotion capabilities.

This invention discloses an integrated method and system for the entire lifecycle processing of spot contracts in the industrial sector, relating to the field of industrial MES / ERP technology. This invention uses a single database stored procedure as a unified entry point to centrally realize all lifecycle operations of spot contracts, including creation, modification, addition / deletion of product batches, and cancellation. Batch data transmission is achieved through table-valued parameters, with contract hash values ​​serving as unique identifiers. This is combined with automatic contract number generation, pre-emptive centralized verification, and database transaction control. Furthermore, it uses standard SQL syntax to support cross-database compatibility (SQL Server, GaussDB, DMDB). This invention solves the problems of fragmented business logic, cumbersome operations, data chaos, and poor cross-platform adaptability in traditional spot contract management. It achieves fully automated and standardized processing of spot contracts, reducing system maintenance costs by over 80% and improving data processing efficiency by 90%. It is suitable for large-volume, high-frequency business scenarios in industrial spot trading and meets the needs of enterprises for domestic transformation. This invention has been fully implemented in actual industrial MES systems and can operate stably in real production environments for a long time, demonstrating mature engineering value and industrial promotion capabilities.

This invention discloses a paperless, systematic, and mobile-based collaborative management method for the entire industrial production process, belonging to the fields of industrial manufacturing execution systems and industrial digital management technology. Based on an integrated underlying architecture, this invention completely eliminates the paper-based document circulation model. Using the plan number / material number as the unique core identifier for the entire process, it builds a digital management system comprising a back-end management terminal and a lightweight mobile terminal. This enables systematic input of information across all stages of industrial production, including production planning, process quality inspection, equipment inspection, and anomaly handling; real-time mobile operation; and full lifecycle data linkage. The system automatically generates tamper-proof digital logs for all operations based on the underlying architecture, supports one-click full-link traceability by plan number / material number, and can seamlessly integrate with modules such as production planning management and intelligent reminders to form a closed-loop, systematic management system for the entire process. This invention addresses industry pain points such as information transmission failures, traceability difficulties, low efficiency, and data disconnection under traditional architectures, significantly improving the precision and intelligence of production management. Moreover, this method can only be implemented based on an integrated underlying architecture, which cannot be adapted to traditional modular architectures, forming a unique technical barrier. All database operations adopt standard SQL basic syntax, are compatible with both SQL Server and GaussDB platforms, have strong implementation and high scalability, and can be widely applied to various industrial production line management scenarios.

This invention discloses an integrated automated processing method and system for sales settlement across all scenarios, featuring AI-based pre-parameter verification, belonging to the field of financial settlement technology for industrial ERP / MES systems. Based on a unified stored procedure architecture, this invention incorporates an AI-based pre-parameter verification module, supporting settlement of spot and futures contracts, as well as real-time price locking and post-pricing modes. It achieves batch parameter transmission through table-valued parameters, combined with automatic settlement number generation, transaction-level atomicity guarantees, multi-table automatic updates, financial auditing and access control, automatic generation and printing of settlement documents, and full-link operation tracking, realizing automated and standardized management of the entire sales settlement process. This invention solves the problems of traditional settlement systems, such as limited scenario adaptability, fragmented operations, low efficiency, data error susceptibility, lack of traceability, and inability to integrate with AI. It adopts standard SQL syntax to adapt to multiple database platforms such as SQL Server and GaussDB, possessing cross-database compatibility and independent controllability. This invention has been fully implemented in actual industrial MES systems and can operate stably in real production environments for a long time, demonstrating mature engineering value and industrial-scale promotion capabilities.

The application discloses a kind of industrial finished material contract cancellation full-process automation processing methods, belong to industrial ERP / MES sales and inventory management field.The application uses front and rear independent research and development deep fusion architecture, seamlessly connects through self-research front end interface and rear storage process, realizes multi-mode contract cancellation automation processing;Through front and rear double check intercepts illegal operation, automatically corrects attribute according to material type, resets inventory, updates contract hash value;Whole transaction control, exception automatically rolls back, and complete record traces information, forms end-to-end closed loop.The application is compatible with SQL Server and Gauss DB, has actually landed in industry, can standardize process, avoid data confusion, improve management automation level, and has strong expansibility and maintainability.

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.

A method of conversion of mapping formats into OpenDrive HD map formats is provided. The method includes retrieving geodatabase data to form a SQL Server or a PostgreSQL database. The method also includes reading one or more shapefiles and one or more OpenStreetMap (OSM) files for extracting relevant road network data. The method also includes checking for one or more missing tables or one or more fields in the database or shapefiles to ensure that one or more required fields are non-null. The method also includes processing the relevant road network data and preparing for conversion. The method also includes creating an OpenDrive (.XODR) file from the relevant road network data, tailored to meet one or more regional traffic simulation specifications for generating an OpenDrive map. The method also includes rendering the OpenDrive map via a user interface to a user, wherein the user is allowed to specify one or more input parameters for editing one or more map elements in the OpenDrive map.

The application discloses an ERP&MES integrated data fusion method based on a material full-dimension wide table, and relates to the technical field of industrial production information integration.The application takes a unique product code as a primary key, constructs a material wide table covering the whole life cycle as a core base, matches TVP standardized interaction, double-layer mistake-proofing verification, AI access reservation capability, is compatible with SQL Server and Gauss DB dual databases, and accurately retrieves fields according to requirements in the core design of each business module.The application realizes homology, unified caliber, efficient operation, safety controllability and intelligent scalability of ERP-MES-finance data, solves problems such as data island, inconsistent caliber, difficult business linkage and high development and maintenance cost in the traditional architecture, supports complex business and intelligent upgrading, and is suitable for integrated management in multiple industrial production fields.The application has been completely applied in actual industrial system ERP&MES, can be long-term and stable in real production environment, and has mature engineering value and industrialization popularization capability.

This invention discloses an integrated method for dynamic contract modification based on a unified stored procedure, achieving deep integration of ERP and MES. Belonging to the field of intelligent manufacturing, it is applicable to continuous production industries such as metallurgy and steel. This invention uses a unified table type as the parameter entry point, integrating eight operations into a single stored procedure to construct a closed-loop process of application-review-execution-lock-off. Through dual-review interlocking and intelligent identification of production status, it prevents tampering with completed products. During modification execution, it achieves one-click synchronization of multiple tables in ERP and MES. Full-process operation traceability, critical data locking, and transaction control ensure security, and it is compatible with SQL Server and GaussDB. This invention breaks down the barriers between dual systems, solving pain points such as data asynchrony, non-closed-loop processes, and chaotic permissions. It has been practically applied and possesses mature engineering and promotional value.

The application discloses a device and method for constructing a protocol based on an SQLSERVER database, and relates to the technical field of industrial automation and data communication, which comprises a protocol meta-database module, a protocol engine module, a dynamic node generator module, a version and audit module, a cross-protocol mapper module and a management configuration interface module, wherein the protocol meta-database module is connected with the protocol engine module, the protocol engine module is connected with the dynamic node generator module, the dynamic node generator module is connected with the version and audit module, the version and audit module is connected with the cross-protocol mapper module, and the cross-protocol mapper module is connected with the management configuration interface module. Through efficient cooperation among the protocol engine, an OPC server and a client, real-time processing and dynamic updating of data flow in the field of industrial automation are realized.

The application discloses an industrial material production whole-process intelligent memo reminding and forced confirmation method and system, and belongs to the technical field of industrial ERP / MES production management.The application realizes automatic generation of memo through presetting whole-process key nodes, and realizes active intervention, prevention of omission, prevention of error, and prevention of delay of a production process from a system level through combination of intelligent hierarchical reminding, overtime upgrade early warning, important operation forced confirmation, a unified memo workbench and a whole-process tracing mechanism; meanwhile, the application is designed by using a standard SQL grammar, is compatible with SQL Server and Gauss DB double database platforms, does not depend on special functions and specific grammar, and realizes self-controllable database layer.The application can be widely applied to various industrial enterprise production execution standardized management scenes, is adapted to domestication transformation needs, and guarantees data safety and business controllability.The application has been completely applied in an actual industrial MES system, can be long-term and stable in real production environment, and has mature engineering value and industrialization popularization ability.