161 results about "Stored procedure" patented technology

The invention relates to the technical field of data processing, and provides a cloud data archiving method and system, and the method comprises the steps: obtaining a source data set of to-be-archived data, carrying out the grade division, obtaining a data grade label, dividing the source data set into a plurality of data blocks, carrying out the data encryption of different grades, obtaining a plurality of encrypted data blocks, and storing the encrypted data blocks in a database; analyzing and coding to obtain a multi-dimensional data storage structure, uploading the multi-dimensional data storage structure to a preset cloud storage node, and generating a storage index information set based on multiple data blocks in the uploading process; and when a data recovery request is received, acquiring the data block from the cloud storage node according to the storage index information set, and performing decryption and data recombination. Through the scheme, classification, hierarchical encryption and structured archiving of the source data set are realized, the security and management efficiency of the data in a cloud storage process are improved, and the problem that the encryption level cannot be dynamically adjusted by data sensitivity or content features when a large-scale heterogeneous data source is used is solved.

The embodiment of the invention discloses an Oracle compatible method and equipment based on a database driving program, and belongs to the technical field of database migration. The problem that in the prior art, comprehensive compatibility of Oracle characteristics is difficult to achieve on the driver level is solved. Comprising the following steps: when a database is in an Oracle compatible mode, receiving a calling statement in an Oracle form at a driving layer; in the SQL statement generation and execution stage, a corresponding grammar conversion strategy is determined according to the type of a calling statement; based on a grammar conversion strategy, performing grammar conversion on the calling statement to obtain a statement supported by a target database kernel, and sending the statement to the target database kernel; in the stage of obtaining the result set, the result set returned by the kernel of the target database is analyzed, and a function return value and / or an out parameter value obtained through analysis are / is transmitted to a corresponding binding variable, so that compatibility of an Oracle function, a storage process and an anonymous block is achieved.

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.

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.

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.

A data platform for managing an application as a first-class database object. The data platform includes at least one processor and a memory storing instructions that cause the at least one processor to perform operations including detecting a data request from a browser for a data object located on the data platform, executing a stored procedure, the stored procedure containing instructions that cause the at least one processor to perform additional operations including instantiating a User Defined Function (UDF) server, an application engine, and the application within a security context of the data platform based on a security policy determined by an owner of the data object. The data platform then communicates with the browser using the application engine as a proxy server.

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 invention discloses a database object manager and a management method, the manager realizes operation on a database object through interface design, and the manager comprises a database object creating module for creating and modifying the database object, the database object comprises one or more of a library, a mode, a table, an index, a partition, a constraint, a view, a sequence value, a storage process, a function, a packet, a user and a role; the database object management module is used for checking and modifying a database object, operating data, editing SQL (Structured Query Language), checking a table structure, and importing and exporting the table structure and table data; and the database object maintenance module is used for realizing table statistical analysis, index reconstruction, view compilation and modification, trigger compilation and modification, storage process and function compilation of database objects. Through the interface operation, the user can better use the database.

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 relates to a dynamic routing control method and system based on a storage process return value, and belongs to the field of process control and industrial automation. The system comprises an RET rule configuration module, a routing controller and a business process execution module. A mapping rule between a return value and a target flow is defined in a configuration module, and a routing controller receives a real-time return value of a storage process, performs dynamic matching according to a preset rule, and quickly determines a flow jump path. And the business process execution module executes the corresponding process logic according to the matching result. The rule supports accurate matching, regular matching and default paths, and has a hot update capability and a priority analysis mechanism. The method has the advantages of flexible configuration, high response speed, simple deployment, low maintenance cost and the like, and is suitable for dynamic production process control in multiple industries such as manufacturing, energy, food, electronics and the like.

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 invention discloses a high-security data collection method and a medium, and the method comprises the following steps: carrying out the edge-end desensitization encryption of data inputted by a user through a localized federated learning framework in a data collection process, uploading a model parameter obtained through the processing after encryption to a cloud end for model training, and carrying out the data collection. Original data is not uploaded; according to the method, edge-end desensitization encryption can be performed on data input by a user in a data collection process by adopting a localized federated learning framework, and only model parameters instead of original data are uploaded to the cloud for training, so that the risk of sensitive information leakage of the user is greatly reduced; the data is desensitized and encrypted at the local end, so that the privacy of the user is protected from the source; and the model training can be completed without uploading the original data in the federated learning mode, so that the problem of privacy leakage possibly occurring in the data transmission and storage process is avoided.

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.

An embodiment initiates, by a sensitive stored procedure identification engine, a periodic discovery process on a database server to identify a stored procedure and assign a first sensitivity score to the stored procedure based on a searching of a sensitive data pattern in the stored procedure. The embodiment assigns in real-time, by the sensitive stored procedure identification engine responsive to receiving a stored procedure call by a client over a network, a second sensitivity score to the stored procedure based on a searching of a sensitive data pattern in a response to the stored procedure call. The embodiment compares, by the sensitive stored procedure identification engine, the first sensitivity score and the second sensitivity score. The embodiment determines, by the sensitive stored procedure identification engine based on the comparison, to allow a response to the stored procedure call to the client.

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.

The application belongs to the technical field of analysis, application and management of revisit data, and specifically discloses a revisit tracking data management method based on big data, which comprises the following steps: based on user purchase attributes, clustering analysis is used to stratify users, and the priority of different users in revisit research is distinguished according to revisit application types, so as to ensure the adaptability and representativeness of users with different purchase attributes in various revisit research scenarios; by analyzing the historical research records of users in each user layer, the distribution effect of historical revisit methods is evaluated, and the revisit methods and revisit time of different users are differentially configured and targeted optimized accordingly, so as to maximize the response rate of users in the revisit process; by evaluating the structural data stability of different user layers, the encryption storage scheme of the user layer is dynamically optimized, so as to ensure the security and integrity of user data in the storage process, thereby meeting the technical requirements of data security protection.