29 results about "Stored procedure" patented technology

An abnormal irregularity cause identifying device includes a process data acquisition unit that reads, from a storage device storing process data, the pieces of process data, an abnormality determination unit that calculates an abnormality degree representing an extent of an irregularity of process data of the pieces of process data read by the process data acquisition unit, and a cause diagnosis unit that obtains accuracy of a cause of the irregularity based on a proportion of process data having the abnormality degree calculated by the abnormality determination unit satisfying a predetermined criterion to the plurality of types of pieces of process data, by using causal relation information defining a combination between the cause and the irregularity, which appears as an influence resulting from the cause, of each of the plurality of types of pieces of process data.

The application discloses a data bloodline collection method and device based on a Gbase stored procedure, and the method comprises the following steps: removing fixed keywords of a stored procedure definition process body; capturing a stored procedure variable through a regular expression and converting the stored procedure variable into a Key-Value form; replacing a variable name with a variable value according to the Key; processing a loop structure and a branch structure, and processing a self-defined label; and performing syntax compatibility and replacing or removing SQL statements according to some keywords. The application processes some general keywords of the stored procedure, removes redundant information irrelevant to the data bloodline, processes some syntaxes specific to the Gbase in a compatible manner, so that the syntaxes can be parsed by open-source SQL tools, and the application is adapted to the stored procedure of the Gbase, so that the application can help some manufacturers using the Gbase stored procedure to process data in an automatic form to the data bloodline, and the application is convenient for data warehouse construction.

This invention discloses an automatic statistical method for three-dimensional product structure analysis across multiple production lines based on stored procedures. It encapsulates statistical logic through database stored procedures and utilizes GROUP BY and CASE WHEN interval judgments to achieve automatic aggregation by steel type, thickness range, and width range. This method supports unified processing of data from 14 or more production lines and allows for flexible simplification of statistical dimensions. It solves the problems of complexity and inefficiency in traditional multi-production-line product structure analysis, and features high efficiency, stability, and ease of maintenance. This invention has been practically implemented in state-owned steel plants for many years.

This invention discloses a data acquisition and storage method and system based on blockchain and multiple data tags. The method includes: a client determining the source data file to be uploaded, a core metadata tag set, and an extended metadata tag set; deduplicating and merging the two tag sets to obtain a tag set; calculating the hash value of the tag set as its identifier; dividing the source data file into N file fragments, calculating their hash values, and constructing a Merkle tree; using the root hash value of the Merkle tree and the tag set identifier to construct another Merkle tree and obtaining the root hash value as a global integrity identifier; and uploading the source data file, its tag set, and the global integrity identifier to an application server, which then submits the data to the blockchain network as a notarization transaction to achieve tamper-proof notarization. This invention aims to ensure the security of source data files and tag sets during the acquisition and storage process, as well as the traceability of the acquisition and storage process, in distributed, geographically dispersed data acquisition and storage scenarios.

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 a method and system for generating integrated sales, delivery, and payment reconciliation reports in the industrial sector, relating to the fields of industrial MES / ERP report generation and financial reconciliation technology. This invention uses a single database stored procedure plus table-value parameters as a unified entry point, achieving full coverage of futures / spot contracts and self-owned / outsourced warehousing delivery scenarios. It achieves accurate alignment of payment and delivery records through a contract number partitioning and sorting algorithm, constructing a two-tiered automatic balance accounting system for contracts and customers, and automatically generating standardized reconciliation reports. This invention solves the problems of cumbersome manual operation, inaccurate data, and untimely report updates in traditional reconciliation methods, improving reconciliation efficiency by over 90% and achieving 100% data accuracy. It is compatible with existing ERP / MES systems in industrial enterprises, has low implementation costs, and is suitable for daily reconciliation, data statistics, and business analysis scenarios in the industrial sector. This invention has been fully implemented in actual industrial ERP systems and can operate stably in real production environments for a long time, possessing mature engineering value and industrial promotion capabilities.

This invention discloses a unified data interaction and standardized interface method for industrial software, relating to the fields of industrial software system integration, cross-language and cross-platform data interaction, and automated invocation of intelligent systems. The core of this invention is a design of "single-business-specific table type + unified interaction rules." It customizes a dedicated Table Value Parameter (TVP) table type for each business segment, adds a core field for operation type as the basis for business action judgment, encapsulates all add, subtract, delete, modify, and query operation logic for a single business into a unique dedicated stored procedure, and exposes a unified standardized interface, thus constructing a universal data interaction paradigm of "dedicated table type, unified rules, and single interface entry point." This invention completely eliminates the technical barriers to interoperability across systems and development languages. It seamlessly adapts to all development languages / systems, including Java, C#, .NET MAUI, Web development, and ARKTS. Different business logics pass parameters using dedicated table types and call according to unified rules, reducing cross-system connectivity and development difficulty to a minimum. Simultaneously, it achieves vulnerability closure through full front-end verification, perfectly adapting to AI automated call requirements. This significantly reduces the costs of multi-system integration, development, and maintenance of industrial software. It can be widely applied in various manufacturing industries such as metallurgy, machinery, chemicals, automobiles, and electronics, as well as in all fields with system data interaction needs, including smart IoT, enterprise digital management, and e-government. It is a set of industrial software data interaction standards that is practical, universal, and intelligent. This invention has been fully implemented in actual industrial ERP and MES systems, and can run stably in real production environments for a long time, demonstrating mature engineering value and industrial promotion capabilities.

The application provides a kind of intelligent file cabinet data exchange management and control method, belongs to intelligent file cabinet technical field, the intelligent file cabinet data exchange management and control method, it includes the following steps: data standardization and protocol formulation: standardized format: the data model of international or industry standard (such as ISO / IEC 23081-1 archive metadata standard) is adopted, ensure the consistency of archive description, classification and index;Guarantee the security and compatibility of data transmission, solve the interoperability problem caused by the non-uniform data format, sensitive data is encrypted by using AES, RSA encryption technology, ensure the safety of data in the process of transmission and storage, combined with biometric identification and traditional password two-factor authentication mode, greatly improve the security level of user identity verification, plus the deployment of firewall and intrusion monitoring system, form a multi-level network security protection system, effectively resist external attack, solve the problem of insufficient data transmission security measures.

This application discloses a method, apparatus, and system for intelligently generating visual reports for distributed relational databases. It connects to the target database and parses its stored procedures, publishing them as callable data interfaces. It receives natural language indicator descriptions input by the user and, based on the published data interfaces, maps them to corresponding calling parameters using natural language processing technology. Reports are generated based on the calling parameters, and predictive dataset caching and updates are performed based on the user's historical access patterns and database source data change information. This application achieves deep integration with distributed databases, intelligent report configuration with zero code, and efficient data caching and updates, significantly improving report development efficiency, system response speed, and operation and maintenance management capabilities.

This application relates to a data processing method that replaces stored procedures. The method includes: acquiring data processing request information, including a target script identifier, a target data source identifier, and request parameters; parsing the target script based on the target script identifier, determining the set of sensitive fields participating in branch determination, and generating a branch semantic fingerprint based on the sensitive field set; querying the original result set from the corresponding database based on the target data source identifier, and converting the original result set into a standardized result object according to a preset heterogeneous field mapping rule; comparing the actual semantic features corresponding to the sensitive field set in the standardized result object with the branch semantic fingerprint to obtain a branch release result; when the branch release result representation passes, inputting the standardized result object into the target script to execute the corresponding data processing logic; when the branch release result representation fails, outputting a semantic mismatch identifier. This application is applicable to data processing in a storage-compute separation scenario.

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.

The present application relates to the technical field of data integrity, in particular to a computer science data tamper-proofing processing method and system based on block chain, comprising the following steps: capturing original logs and calculating feature fingerprints through a special interface, combining time stamps and parent hashes to build a time sequence verification unit, assembling a dynamic Merkle tree, synchronizing it to a distributed network, using a consensus engine for network-wide verification, and if the verification is passed, writing the tree root information into a new block and linking it to the main chain database.In the present application, by constructing a Merkle tree storage structure based on dynamic time sequence characteristics, the original data fingerprint is bound to the generation timestamp through nonlinear mapping, realizing the full life cycle of non-tamperable traceability, using a lightweight consensus verification mechanism between distributed nodes to replace traditional centralized authentication, combining smart contracts with automatic rollback and locking logic for differential data, ensuring the absolute consistency of multi-source heterogeneous data during storage.

This invention discloses a method, apparatus, and medium for allocating business data of securities institutions based on directed links, relating to the field of data storage technology. By acquiring directed links, this invention transforms the complex flow of historical processed data within the securities institution's business data platform into structured information, simplifying the information representation. Simultaneously, it acquires the data to be processed and constructs incremental links based on the data processing procedure of the data to be processed, enabling the use of the directed link update process to reflect the pre-storage process of the data. An incremental evaluation score is obtained by weighted fusion of a first evaluation score and a second evaluation score. By fully considering the changes in complexity and information completeness of the directed links, the impact of the data to be processed on historical processed data is fully considered, thereby making the judgment process of the incremental evaluation score more accurate. Finally, the data is allocated to storage space suitable for the data reading and retrieval method, thus improving the accuracy of the securities institution's business data allocation process.

The application provides a storage procedure performance tracking method under a distributed database, comprising the following steps: defining a tracking element; tracking sql execution based on the tracking element to obtain a sql_history table; defining a show_procedure interface; recursively tracking the sql_history table based on the show_procedure interface to track the execution of a storage procedure and obtain a tracking statistical table of the storage procedure; based on an enable_track_sql parameter, starting or stopping the tracking function of the sql and the storage procedure; based on the tracking statistical table of the storage procedure, determining the id of the sql affecting the performance of the storage procedure; and based on the id of the sql, analyzing the time consumption distribution of the sql. The application has the beneficial effects of adding statistical information at key nodes of a sql engine, adding parent-child relationship statistical information of the sql and the storage procedure, providing an interface to sort the statistical information of each sub-sql of the storage procedure, and providing a switch to track and avoid affecting the performance.

The application provides a multi-end authorization file management method, system and medium, and relates to the field of file encryption, which comprises the following steps: a service end and at least one use end perform software authorization and / or hardware authorization at a manufacturer; the service end encrypts a file to obtain an encrypted file and sends the encrypted file to the at least one use end; the use end receiving the encrypted file decrypts the encrypted file in any authorization corresponding manner to obtain a decrypted file; and the use end receiving the encrypted file processes the decrypted file by using software corresponding to the decrypted software type. In this way, through the multi-end authorization mechanism, the service end can manage the file access rights of different use ends and ensure the security of the file in the transmission and storage process. Meanwhile, after receiving the encrypted file, the use end performs identity authentication through software authorization or hardware authorization, and can decrypt the file after the authentication, thereby improving the convenience of file management and effectively preventing file leakage and illegal access.

A computer-implemented method for generic tenant data replication for disaster recovery, includes regularly checking, by a primary replication agent on a primary site, for changes to a primary change log on the primary site. Based on an insert of a new change record in a secondary change log on a secondary site, triggering a stored procedure from secondary stored procedures on the secondary site, that extracts a change operation and data from the secondary change log and performs the changed operation on a secondary tenant table on the secondary site. By a secondary replication agent on the secondary site and from the primary replication agent, receiving a call not containing a sequence id for a change record marked as completed in the secondary change log, and deleting the change record. Using a replication agents control plane, providing central monitoring for the primary replication agent and the secondary replication agent.

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 kind of industrial raw material warehouse full-service big unified processing method based on table value parameter belongs to industrial MES and database security technical field.This method will raw material warehouse, modification, warehouse, move, query and dynamic warehouse position planar graph synchronization, pound house weight accounting unified encapsulation as stored procedure, with table value parameter as only entrance, with standard SQL It is realized that cross-library compatibility is realized;Through fully closed architecture, data access is fully controlled and audited;Through dynamic warehouse position engine, warehouse position is automatically updated, and through pound house linkage algorithm, weight is automatically allocated and state is closed loop;Full process strong transaction and strong check ensure that raw material roll, warehouse position, weight, batch data are accurate and consistent.The present application is suitable for hot rolling raw material warehouse management, has high security level, strong business integrity and outstanding industrial value.The present application has been applied in actual industrial ERP system, can be long-term stable operation in real production environment, has mature engineering value and industrialization popularization ability.

This invention discloses a universal unique identifier generation method and system based on table-valued parameters and stored procedures, belonging to the field of data identifier technology. This invention employs a parent volume retrieval sequence incrementing algorithm, combined with a four-segment strongly readable encoding combination, to achieve unique, readable, and flexibly configurable identifiers. When there is no matching parent volume, the main sequence increments while the sub-sequences are reset; when there is a matching parent volume, the sub-sequences increment. This method, implemented through table-valued parameters and stored procedures, has been stably running for 8 months in the MES system of 12 units in a steel plant, generating over 6000 identifiers with no duplicates or gaps. This invention has strong versatility and has been practically implemented in industrial ERP and MES systems, possessing mature engineering value and promotion potential.

Embodiments of the present application provide a temporary table processing method, device, medium and program product, relating to the technical field of data processing. The method comprises: for any stored procedure, generating stored procedure identification information, and generating a target temporary table name of a temporary table of any stored procedure according to the stored procedure identification information and a table name input by a user; in the case of receiving an access request for accessing the temporary table of any stored procedure, determining an access path for accessing the temporary table according to requestor stored procedure identification information and the target temporary table name through an access path matching rule; and in the case of ending execution of any stored procedure, automatically deleting the temporary table of any stored procedure according to an association relationship between the stored procedure identification information and the target temporary table name. Based on the method, non-transactional life cycle processing of the temporary table can be implemented, the dependence of the temporary table on transactions is reduced, and the flexibility of life cycle management and control of the temporary table is improved.

The application discloses a general unified storage process multi-operation type packaging method and system for a general unified industrial software architecture, and belongs to the technical field of databases and industrial software. The application adopts three groups of TVP unified entrances, six types of operations packaged by a single storage process, two-level centralized verification, transaction atomicity guarantee, and unified exception return, so that business logic is highly cohesive, data is safe and reliable, and calling is simple and unified. As a core implementation layer of the general unified architecture, the application can greatly reduce the number of interfaces, improve safety, and reduce maintenance costs, and naturally supports AI and front-end standardized calling. The application has been implemented in industrial ERP / MES systems and has the characteristics of high stability, high efficiency and high adaptability.

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 present disclosure provides techniques and solutions for managing feature activation across different software versions for clients in a distributed environment. Upon receiving a request to activate a feature of a software application, a flag is set indicating the feature's availability. For clients operating with an older version of the software, the feature identifier is different than an identifier of the activated feature, which temporarily prevents feature activation for such clients. When a client's software version is updated to a compatible version, the identifier associated with the client is replaced with an identifier enabling the feature. The system maintains version-specific content, including data schemas and stored procedures, for both old and new software versions during transitions. Additionally, external client requests are routed through appropriate interfaces based on the client's software version, supporting seamless feature updates and continuity in operations across different versions, such as within a multi-tenant computing environment.

This application discloses a subnet-aware distributed data partitioning management method, system, medium, and device. The method includes: during the field deployment phase of a high-temperature reactor (HTGR), various hardware devices at the HTGR site are designated as field hard points. These hard points are then integrated based on business logic affiliation. A subnet is constructed based on field hard points belonging to the same business logic affiliation. The subnet is stored as an independent management unit in a nuclear industry distributed control system database. During storage, a weighted round-robin algorithm dynamically calculates the real-time capacity load of each partition in the nuclear industry distributed control system database. Based on the calculated real-time capacity load of each partition, each subnet is pre-allocated. This ensures that when the HTGR enters the operational phase, the real-time data generated by the field hard points within the subnet is stored in the pre-allocated partitions of the subnet. This method enables intelligent matching between subnets and partitions, balances capacity load, and ensures efficient and reliable storage of real-time data from the HTGR.

This invention relates to the field of industrial MES (Manufacturing Execution System) production management technology. Addressing industry pain points such as the need for manual volume number differentiation in traditional production history queries, cumbersome operations, rigid query conditions, unstable system architecture, and difficulties in full-process traceability, this invention proposes a flexible full-link production history query method based on a unified plan number. This invention uses the plan number and volume number as unique identifiers for the entire production process. It achieves integrated front-end and back-end interaction through universal table-value parameters. The front-end only collects parameters, without business logic or SQL concatenation; the back-end uses stored procedures to complete intelligent volume number recognition, automatic data calibration, flexible multi-condition filtering, and full-history data query. Users do not need to distinguish between raw material and finished product volume numbers; they can perform queries based on any combination of unit, time, and volume number, automatically skipping null conditions, and obtaining full-process production history data with one click. This invention features a unified architecture, stable operation, extremely simple operation, high query efficiency, and strong adaptability. It can be widely applied to industrial manufacturing scenarios such as metallurgy and sheet metal processing, significantly improving production traceability efficiency and system stability.

Disclosed are techniques for identifying software defects in source code. Initially, a defect detection engine analyzes the source code to identify a list of defects. In some configurations, multiple defect detection engines are applied, such as a source code linter or a machine learning-based tool, and the results are merged into a single list. Then, each defect is re-evaluated based on calling contexts. Specifically, code that calls the defective code is identified and analyzed to determine if the calling code mitigates the defect. For example, client code that calls a database stored procedure may be analyzed to determine if constraints applied by the client code mitigate a defect found in the stored procedure.

The application discloses a data transmission method between servers, and belongs to the technical field of communication and computers. The method can analyze response data of stored data in a subserver in a storage process and parameters of the data itself, so that the participation coefficient of each split data group is judged to represent the interaction degree of each split data group with a user in the storage process. The application also analyzes operation data of each subserver and stored split data groups, so that the aging coefficient and the re-capturing value of each subserver are obtained. In a subsequent data transmission and storage process, the split data group with a larger participation coefficient is transmitted to the subserver with a smaller re-capturing value, so that the split data group with a lower overall importance is stored in the server with a higher fault risk, thereby reducing the risk caused by data loss, loss and the like due to damage, fault and the like of the subserver.