127 results about "Stored procedure" patented technology

The invention relates to the technical field of archive storage, and discloses an archive storage system and method based on a digital object architecture, and the system comprises a unique identification and relation analysis assembly which is used for generating a globally unique object identifier; the digital object warehouse is used for constructing digital objects; the digital object registry is used for establishing a metadata index which can be retrieved; the distributed account book module is used for forming an on-chain record; and a policy-driven engine for monitoring and receiving the broadcasted structured transactions and determining the affected context scope to execute the embedded lifecycle policy. According to the technical scheme, the electronic original text is constructed into the digital object containing the Merkel tree integrity verification data, and all key operations are recorded in the distributed account book module, so that full-chain trust guarantee of archive data from content to process is realized; therefore, the integrity of the data in the long-term storage process can be effectively verified.

The invention provides a source database storage process migration method and device, electronic equipment and a storage medium, and the method comprises the steps: carrying out the grammar analysis of an original storage process in a source database, and generating a corresponding abstract syntax tree; based on a preset rewriting rule set, performing semantic equivalent transformation on the flow control syntax structure in the abstract syntax tree to generate a transformed abstract syntax tree; and generating a target script in a target execution environment from the converted abstract syntax tree, executing the target script in a script running engine, dynamically generating a standard SQL statement corresponding to the business logic defined by the original storage process, and submitting the standard SQL statement to one or more target data platforms for execution. And the business logic of the original storage process is reproduced. By introducing the target script as the intermediate execution layer, the flexibility of the migration scheme is greatly improved, so that the migration scheme is suitable for various big data platforms without the native storage process capability.

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 invention relates to the field of data processing, in particular to a data query method and system based on data de-duplication storage, and the method comprises the steps: firstly receiving a high-concurrency query request in a query process, and then calling out corresponding storage data from a database according to the high-concurrency query request. After a high-concurrency query request is sent out, the method also executes a concurrency step about a storage process, which comprises the following steps: firstly receiving heterogeneous event streams of a plurality of different data sources in real time, carrying out normalization processing on the heterogeneous event streams to obtain standard data streams, then carrying out attribution analysis on the standard data streams to obtain corresponding and unique ID-Offset mapping, and then, carrying out storage processing on the ID-Offset mapping. According to the method, the standard data stream and the ID-Offset mapping corresponding to the standard data stream are aggregated to obtain an aggregation event, and finally, the aggregation event is de-duplicated by utilizing the ID-Offset mapping based on a preset Bitmap de-duplication mechanism to obtain storage data and write the storage data into a database. The method solves the problem that the prior art is not suitable for high-concurrency storage and query.

A graphical, hierarchical document stream browser and environment for semantic (e.g. framing) and performance data analysis and interactive visualization integrates three scales: entities (competitive), entity (diachronic), and document (linguistic). The document level includes annotation and computational linguistics facilities; the entity level has calendrical and time-series focus. All levels emphasize deep linkage and network (i.e. connective / relational space) view of objects, with user-configurable connectivity. Large language model (LLM) integrations provide synthetic advisories, public opinions, reports, plot insights, comparisons; traditional natural language processing techniques and neural models are also employed. A smart plot system includes a “plot cart” and interpreter with an analysis snippet library. Graph structure may arise via adjustable blending or perceptual optimization of canned attribute-related distance functions or via link-induction query language with deep “semantic stored procedure” subexpressions, or feed into graph neural network-style inference for predictions. Most non-LLM ongoing computational load is client-side, using precomputed hierarchical summary files.

The embodiment of the invention provides a credential reconstruction method, device and equipment. In the embodiment of the invention, the non-functional middleware of the transaction system can be subjected to localized replacement and deployment to obtain a first transaction system, and the non-functional middleware comprises an application server container, a cache cluster, a load balancer and a service monitoring component; migrating a database corresponding to the first transaction system from a non-domestic database to a domestic database, and converting SQL statements and storage processes, related to the non-domestic database, of the first transaction system into codes compatible with the domestic database to obtain a second transaction system; and distributing a service request to the transaction system and the second transaction system at the same time to enable the transaction system and the second transaction system to run in parallel, and switching the service request to the second transaction system when the transaction system and the second transaction system run in parallel to a preset stability switching condition.

This application proposes a method, apparatus, electronic device, and storage medium for converting database stored procedures. The method includes: a data bus responding to a received data processing request from a first database; determining and loading a first stored procedure contained in the data processing request; then determining a second stored procedure called by the first stored procedure, the execution order and dependencies between the first and second stored procedures, and converting the first and second stored procedures based on the execution order and dependencies to generate a directed graph; converting the first and second stored procedures based on the directed graph to generate a first conversion program; and finally, executing the first conversion program in the second database. This improves the accuracy of stored procedure conversion.

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.

Comprehensive systems and methods manage software lifecycle processes in an enterprise environment, and ensures consistent, secure, and efficient handling of software applications, packages, and distribution methods. The system features a web application interface that validates user input, enforces multi-level authentication, and manages user roles and permissions. A directory system dynamically selects stored procedures based on input data and current database structure, executing operations entirely within the database. Stored procedures enforce business logic, manage complex data relationships, support data encryption, and anonymize sensitive information. Hierarchical data structures organize records with multi-level granularity, temporal tracking, and partitioning. The database management system optimizes operations, implements automatic failover, and supports real-time data synchronization. The system also includes advanced error handling, real-time monitoring with predictive alerts, a secure audit trail, and a reporting module integrating with external business intelligence tools. Automated maintenance and disaster recovery ensure scalable, secure software lifecycle management.

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.

The application discloses a transformer area time and phase line loss monitoring method and device, computer equipment and a computer readable storage medium, relates to the field of power enterprise transformer area line loss monitoring, and realizes intuitive visual monitoring by automatically analyzing transformer area files, collecting and power information data, and presenting monitoring information in a graphical manner, accurately positioning transformer area line loss abnormal occurrence time and phase, improving transformer area line loss management level, transformer area line loss checking and management efficiency, and assisting in transformer area line loss management. The method comprises the following steps: establishing a data connection with a database; sending a query instruction to the database and executing a stored procedure in the database, the stored procedure being used for obtaining line loss analysis results of transformer area time and phase line loss data; receiving the line loss analysis results and closing the data connection with the database; based on the line loss analysis results, drawing a transformer area time and phase line loss curve diagram, and sending the line loss analysis results and the transformer area time and phase line loss curve diagram to a display terminal for display.

The invention discloses a method, a system and a terminal for generating a dynamic report through visual configuration, and the method comprises the following steps: metadata configuration: defining a report name and a code through a visual interface, and establishing a mapping relation between a query condition attribute name and a display name; engine binding is executed, wherein an SQL mode and a storage process mode are included; the SQL mode comprises the step of automatically replacing an SQL script containing an attribute name placeholder with an actual parameter value; the storage process mode comprises the steps of performing standardization processing on an interface attribute name and a storage process parameter name, and matching parameters by adopting an editing distance algorithm allowing 1-2 character differences; and multi-table rendering: independently rendering the master table and the slave table according to the bound query result serial number, and configuring a column display rule and an exclusive script. According to the method, the development efficiency and the parameter matching accuracy are improved, and complex structures such as listing are supported; configuration takes effect in real time, and the operation and maintenance cost of restarting service in a traditional scheme can be avoided.

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.

The embodiment of the invention provides a software authorization management method and device based on post-quantum encryption, equipment and a medium, and the method comprises the steps: obtaining to-be-authorized data, encrypted authorization data and a decryption public key, the encryption authorization data is generated by performing hybrid encryption according to a preset configuration file, a preset first encryption algorithm, a preset second encryption algorithm and an encryption private key; the preset first encryption algorithm comprises an asymmetric encryption algorithm, and the preset second encryption algorithm comprises a post-quantum encryption algorithm; the to-be-authorized data comprises a to-be-authorized software identifier and to-be-verified data; determining a target verification parameter according to the encryption authorization data and the decryption public key; according to the target verification parameter and the to-be-verified data, determining whether the to-be-verified data passes verification; according to the technical scheme, under the condition that the to-be-verified data passes verification, the software corresponding to the to-be-authorized software identifier is authorized, the authorization information is prevented from being tampered or forged in the transmission and storage process, and the real source and non-tampering of the data are effectively guaranteed.

The invention provides a configurable automatic data archiving method and system based on a storage process, and belongs to the technical field of database data life cycle management.The method comprises the following processes that firstly, an archiving task is initialized, and a configuration table archiving rule is loaded; automatically judging and creating an archiving history table; secondly, dynamically calculating an archiving reference date; archiving conditions are generated, and data archiving and source table cleaning are executed in batches; abnormities are processed through log and transaction control, and data archiving and source table cleaning are completed; and finally, task circulation and exception handling are performed, and configurable and automatic historical data management is realized. The method solves the problems that an existing data archiving scheme is high in hard coding dependency, lacks unified configuration, is high in batch processing risk, is weak in fault tolerance and traceability, and is disordered in historical table management, is suitable for batch backup and archiving of historical data and source table cleaning in a core business system, guarantees the performance of a core table, and meets the requirements of data retention compliance.

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.

The invention relates to a code enhancement retrieval method, device and equipment and a computer readable storage medium. In the storage process, on one hand, hierarchical storage is carried out, on the other hand, corresponding summary information is added to the code snippets and is added into the upper-layer storage structure layer by layer from bottom to top, and layer-by-layer search is correspondingly carried out in the retrieval process from top to bottom; therefore, the required target code snippets are accurately positioned in a large number of codes according to the code retrieval requirements, the understanding ability of the large number of codes is improved, the retrieval accuracy is guaranteed, meanwhile, the model does not need to learn and understand the whole codes, and a large amount of cost is saved.

The application discloses a kind of graph database storage procedure parameter constantization optimization method and device, belong to graph database management technical field, which method includes: receiving the storage procedure call request containing calling parameter;Before logical planning starts, the actual value of calling parameter is obtained, and the actual value is stored in the storage area accessible in query optimization stage;The storage procedure body is logically planned, and the initial execution plan containing the variable expression corresponding to calling parameter is generated;In query optimization stage, the actual value is read from the storage area, and the variable expression in the initial execution plan is replaced with the constant expression corresponding to the actual value, to generate the execution plan after constantization;The execution plan after constantization is optimized and executed.This application can generate a highly customized, efficient execution plan, thereby significantly improving the execution efficiency of storage procedure.

The invention discloses a performance evaluation method and device of a storage process, electronic equipment and a storage medium, and relates to the technical field of big data or other related fields, the method comprises the following steps: using a preset parser generator to carry out grammar parsing on a target storage process code to obtain a grammar parsing result; according to the unfavorable operation condition list, simulating unfavorable operation conditions according to the database table field information and the variable information to obtain a simulated operation parameter set; executing the SQL statements by using the simulation operation parameter set, and obtaining execution plan information and performance data corresponding to each SQL statement in the execution process; the execution plan information and the performance data are analyzed, a performance evaluation report is obtained, and SQL statements with performance scores lower than a standard threshold value are identified in the performance evaluation report. Through the method and the device, the technical problem that performance evaluation of an existing storage process depends on actual production operation parameters and cannot test and evaluate performance influence conditions in advance in the prior art is solved.

The invention discloses a style storage method and device, equipment and a storage medium, and the method comprises the steps: obtaining a cascading style sheet rule, and disassembling the cascading style sheet rule into atomic-scale style blocks; performing combination optimization processing on each atomic-scale style block to form each target style block; respectively generating each hash code corresponding to each target style block; constructing a style-code index table based on the Hash code of each target style block; and storing each target style block by utilizing the style-code index table. According to the method, the cascading style sheet rule is disassembled into the atomic-scale style blocks, so that the accuracy and the high efficiency of the subsequent storage process can be ensured, the size of the atomic-scale style blocks needing to be stored can be reduced through combined optimization processing, the hash codes are directly utilized for storage during subsequent storage, the size of a memory needing to be stored is reduced, and the storage efficiency is improved. By means of the mode, efficient storage optimization is achieved, pattern data redundancy is avoided, the loading performance is improved, and normal use of the page is guaranteed.

The present disclosure provides a database stored procedure gray release method, device, electronic equipment, medium and computer program product. The above method and device can be used in the field of big data and financial technology. The database stored procedure gray release method comprises: creating a gray mode which is a mirror of an original mode in a database, wherein the original mode and the gray mode are logically isolated; releasing a new version of the database stored procedure on the gray mode; configuring a search path for an account determined as a gray user to obtain a gray search path, wherein the search priority of the gray search path is that the gray mode is higher than the original mode; obtaining a test result in response to a test performed by the gray user according to the configured search path, wherein the test result is a test pass or test error information feedback; and taking a release strategy according to the test result.

A computer server receives, from a remote user device, information about a new potential risk relationship customer (including at least one new user parameter). Based on the new user parameter, the computer server accesses third-party data and utilizes a stored procedure to read data about the new potential risk relationship customer from an internal table of cloud data. The data read from the internal table is processed to dynamically evolve a schema and create an incremental view of cloud data. The computer server uses the incremental view to read and output a current batch of cloud data. A user interface workflow is then customized via a machine learning algorithm that processes the information about the new potential risk relationship customer, the third-party data, and the current batch of cloud data. A user information data store can then be updated based on information collected via user interface displays.

The application discloses a wind power time sequence data storage management method based on a PostgreSQL relational database. In the PostgreSQL relational database, operation data related to a wind farm is organized together to form a wind farm schema; the schema of different wind farms is replaced by corresponding wind farm IDs, namely, a special schema of a wind farm, and data storage tables corresponding to wind turbine units are replaced by corresponding wind turbine IDs, namely, corresponding wind turbine historical operation data storage tables; for the management of wind turbine operation historical data, corresponding PG storage procedures are written to complete the creation of historical data tables and the addition of measuring points in the wind turbine historical data tables. The application stores full wind turbine operation data, the time granularity of the wind turbine operation data reaches a second level, and the relational database design is used, so that the database design difficulty is not increased.

This disclosure provides a method, apparatus, and computer device for executing stored procedures in a database. The method includes: acquiring data to be executed and determining execution parameters of the data to be executed; invoking a judgment condition corresponding to the stored procedure and determining a target branch corresponding to the execution parameters in the stored procedure based on the judgment condition; and executing the data to be executed through the target branch. This improves the efficiency of data execution by allowing multiple data items to be executed to be executed in parallel through different branches of the stored procedure without occupying the entire stored procedure.

The invention relates to the technical field of artificial intelligence, and provides a data caching method and device, equipment, a medium and a product, and the method comprises the steps: receiving data submitted by a content creator and metadata of the data; generating a digital signature based on the private key of the content creator and the metadata; packaging the metadata and the digital signature into a transaction, and sending the transaction to a block chain for evidence storage; evaluating the economic value of the data, and determining the importance score of the data according to the economic value; formulating a cache excitation strategy of data and sending the data to the cache device, wherein the cache excitation strategy is used for calculating a reward needing to be paid to the cache device; the cache device is used for determining whether to cache the data and metadata of the data based on the cache excitation strategy. Therefore, evaluation can be performed according to the importance of the data content, a cache excitation strategy is formulated, the cache device is effectively excited to store hot content, the content access speed is improved, the user experience is optimized, and the security of the data in the transmission and storage process can be ensured by using the characteristics of the block chain.

The application provides an outbound task minute-level fine-grained monitoring method and system of a database stored procedure, comprising: obtaining a current system time, calculating a previous 5-minute time point and normalizing to 0 seconds of a minute start to obtain a time window boundary; based on the time window boundary, using an interpolation method to capture original call data in the time window through a stored procedure to generate a call detail table; performing aggregation calculation on the original data in the call detail table according to a minute time slice and multiple dimensions to construct a minute-level summary table; based on the minute-level summary table, performing directional update through a substitution method to realize real-time refreshing of minute-level monitoring indicators; and connecting the minute-level summary table through a configuration tool data source to construct a visual chart and form a multi-dimensional real-time monitoring dashboard. The application can solve the technical problems of coarse monitoring granularity, large resource consumption and weak diagnosis capability of an existing outbound system.

The application discloses a method, system and device for generating database code through visual configuration and a storage medium. The method comprises the following steps: obtaining a structured configuration file corresponding to a visual configuration operation of a user through a client in response to the visual configuration operation of the user; sending the structured configuration file to a server; generating target stored procedure data according to the structured configuration file after the server receives the structured configuration file; storing the target stored procedure data in a target database through the server; determining a scheduling task corresponding to the target stored procedure data; triggering execution of basic business code according to an execution rule corresponding to the scheduling task, and generating structured log data through log code in the execution process. It can be seen that the database code is generated through visual configuration of business, scheduling tasks and log functions for data link management, and the maintainability of the system is improved.

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.

In some embodiments, there is provided a computer-implemented method including receiving a call to a stored procedure that includes a first table value parameter corresponding to a first external table and a second table value parameter corresponding to a second external table; and passing, to the called stored procedure, a first bit stream of parameters from the first external table passed using the first table value parameter and a second bit stream of parameters from the second external table passed using the second table value parameter. Related systems, methods, and articles of manufacture are also disclosed.

The application relates to the field of financial technology, and provides a data operation permission authorization script automatic generation method and related equipment, the data operation permission authorization script automatic generation method obtains all business data tables related to a storage process through a target interface of the storage process, so that all data operations performed on each business data table are obtained through matching processing of the business data tables in the storage process, and finally, a data control script template is preset to automatically generate permissions for granting a user of a business system to perform related data operations on the business data tables, so that in the conversion process from the storage process to a java program code, the authorization script of the related data operation permission on the business data table can be automatically generated, the human consumption in the conversion process is reduced, and the efficiency of converting the storage process is improved.