212 results about "Stored procedure" patented technology

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.

A system, apparatus and method for contract classification processes both primary contracts and their associated documents using context window marshalling. The computing device receives and segments each contract document into contextual chunks based on semantic boundaries, maintaining coherent meaning. A marshalling queue processes chunks sequentially, storing processed data within defined context windows, cross-references between chunks, and a running context buffer of key elements. This chunking and storing process repeats until all associated contract documents are processed. The system identifies parties and contract categories by aggregating information across processed chunks from all related documents, then determines risk parameters using a classifier that considers contractual elements, cross-document relationships, and contextual importance weights. Risk recommendations are calculated based on these parameters, identified parties, class categories, and aggregate metrics computed across document and chunk boundaries. The system ranks contracts by evaluating both individual chunk risks and whole-contract assessment, weighting risks based on contextual significance and inter-chunk dependencies across all related documents. Change recommendations are generated that correlate contractual elements with risk levels, identify high-risk chunks and their relationships, and suggest modifications considering cross-document impacts. This approach enables processing of contracts and their associated documents that exceed single context window limitations while maintaining semantic coherence and relationship preservation throughout the entire document collection.

The invention relates to the technical field of data transmission, and particularly discloses a block chain-based data security storage and verification method, which comprises the following steps: collecting biological characteristics, generating a first dynamic key, the first dynamic key being used for encrypting first data, and updating during each access to ensure the key timeliness; dividing the first data into a plurality of segments according to logic, generating segmented hash values, and storing the segmented hash values on a chain; dynamically loading the corresponding fragment according to the user permission, and realizing anonymous verification through a homomorphic encryption technology; based on the Internet of Things technology, the first positioning parameter and the first state parameter are combined, the access permission is dynamically adjusted, and a self-destruction mark is set to avoid the overtime access risk; and in the storage process of the data fragments, dynamic security scoring and path adjustment are performed through distributed storage. According to the method, the static problem in data storage and access control is solved, and a more flexible and reliable security guarantee can be provided in a dynamic access scene.

The invention relates to the technical field of product data management, in particular to a food package printing material batch traceable management method and system, and the method comprises the following steps: collecting the production time of each production batch, constructing time data which comprises year, month, day, hour, minute and second, and creating a time code based on the time data; the time code is combined with the data of the production batch. According to the method, the time data of each production batch, which is accurate to second, is collected, the unique time code is constructed, and the time code and the batch production data are closely combined, so that a traceable time stamp data packet is formed, accurate correspondence between production information and time is ensured, and more efficient information integration and storage management are realized. In the storage process, classification and indexing are carried out in combination with batch time marking data packets, a data retrieval mechanism capable of rapidly responding is established, the information positioning speed and accuracy are improved, and the efficiency and reliability of batch query and tracking are improved.

The invention provides a data query method, system and device and a storage medium, and the method comprises the steps: defining access connection information of a new database, and adding the new database into a connection pool; defining corresponding relations between tables and fields among different databases in the connection pool, and storing the corresponding relations between the tables and the fields among the different databases in a centralized warehouse; according to a preset business requirement, a preset query statement corresponding to each table in each database is disassembled, and the preset query statement is packaged in a storage process corresponding to the table, and the storage process is a pre-compiled SQL statement; searching a data mapping rule corresponding to the query entity data in the warehouse according to the user query request, and matching a target table of at least one target database in the connection pool according to the data mapping rule; and returning a query result based on a preset query statement corresponding to the target table. Data in different databases can be integrated, and the data management efficiency is effectively improved.

Embodiments of this specification provide a shard storage method and apparatus for a graph and a subgraph sampling method and apparatus for a graph. In a distributed storage process of a graph, local identifiers of a vertex and an edge are implicitly stored, and data is stored in an ordered manner, so that the local identifiers of the vertex and the edge can be implicitly calculated. A connecting edge is stored in a CSR format, to ensure that a first-order neighbor of a node is contiguously stored in a memory. In this way, there can be a higher data loading speed and lower memory occupation.

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.

The invention discloses a multi-terminal collaborative enterprise management system and method, and relates to the technical field of intelligent management, and the method comprises the following steps: dividing port data, obtaining a login verification result, executing a first operation, setting a verification rule of the port data, verifying ownership, executing a second operation, and storing encrypted data to a cloud data storage center. The enterprise data is reasonably divided into different port data, fine management of the data is facilitated, the efficiency and the safety of data processing are improved, it is ensured that only authorized users can access the system, the safety is enhanced, data leakage and unauthorized access are prevented by setting verification rules and performing ownership verification, and the safety of the system is improved. According to the method, the data cannot be read by unauthorized persons even if the data is intercepted and captured in the transmission or storage process, and users at different places and devices share and update the data in real time due to the characteristic of multi-terminal collaboration, so that the collaboration efficiency of a team is improved.

The invention relates to a method and a device for debugging a visual storage process of an openGauss database. The method comprises the following steps: displaying a storage process source code on a graphical interface; debugging of the storage process is started, parameter information is input, server-side connection and client-side connection are obtained, the server-side connection obtains the storage process oid, and then a debugging plug-in is called to start debugging; the client connects and calls the debugging plug-in to be associated to the storage process for debugging, and obtains debugging information in real time; and presetting a breakpoint, triggering a breakpoint event by a graphical interface, and directly debugging to a line where the breakpoint is located to view information needing breakpoint debugging. According to the method, a DBEPLDEBUGGE plug-in related interface in an openGauss database is called, a graphical interface is combined to realize visual debugging of a storage process, an efficient and accurate debugging tool is provided, developers are helped to monitor parameter and variable changes in real time, and an execution process is clearly displayed, so that the debugging efficiency is improved, the error checking time is shortened, and the debugging efficiency is improved. And the development productivity and the system reliability are improved.

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.

The invention relates to the technical field of large model processing, in particular to a fault tolerance method and device based on asynchronous storage check points in a large model training scenario, and the method comprises the steps: obtaining the state data of the asynchronous storage check points; converting the state data into serialized data by using a serialization tool of a deep learning framework; the serialized data is written into persistent storage through asynchronous I / O operation, the serialized data of the persistent storage is used for recovering the training task in the large model training scene, and the serialized data of the persistent storage allows data writing operation to be executed in the background. Therefore, the problems that in the related technology, in the large model training data storage process, the storage overhead is large due to frequent storage operation, the overall training progress is affected if hardware breaks down, and the training efficiency is low are solved.

The invention is suitable for the technical field of data management, and particularly relates to an AI-based government affair data management method and system, and the method comprises the steps: obtaining government affair data, defining a storage position, uploading the government affair data to the storage position, configuring a composition unit of the government affair data, creating a fingerprint number, and storing the fingerprint number in the storage position; wherein the fingerprint number is composed of numbers, the fingerprint number is divided into a plurality of sub-numbers, characters corresponding to the sub-numbers are found in each composition unit and integrated to generate unique identifiers, whether two same unique identifiers exist or not is judged, and if yes, the fingerprint number is corrected. By constructing the comparison identifier, whether the registrant has the calling permission of the target unit or not can be judged, so that private storage and anonymous calling of the government affair data are achieved, meanwhile, the government affair data can be prevented from being tampered in the storage process, and the government affair data management efficiency is further improved.

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 invention discloses an online transparent encryption replacement method for dynamic application data, and relates to the technical field of encryption. And calling a file system transparent encryption and decryption module deployed in an operating system of the service system to encrypt the dynamic application data plaintext under the original data directory in the storage device, thereby realizing encryption replacement from the dynamic application data plaintext under the original data directory to the dynamic application data ciphertext under the target data directory. And after encryption replacement, the service system can subsequently run on the dynamic application data ciphertext through the transparent encryption and decryption module of the file system, and the method realizes real non-perceptual switching from the plaintext to the ciphertext on the basis of effectively preventing the leakage risk of the dynamic application data of the service system in the storage process, so that the security of the dynamic application data is improved. The service continuity of the service system is kept, and the service system is free from being transformed.

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.