547 results about "Primary Key" patented technology

The invention discloses a hyper-converged server resource pooling method and system, and belongs to the technical field of resource scheduling, and the method comprises the steps: collecting spatial information, generating a multi-dimensional resource topological graph, abstracting edge node and core node resources into virtual units with position labels, constructing a virtual resource pool, and generating a three-dimensional metadata table; constructing an independent double-queue architecture, configuring a token bucket, triggering a queue clearing mechanism based on a control period, and performing micro-batch merging on edge node short transactions; binding adjacent virtual units by taking the physical position of the equipment as a fragmentation primary key, monitoring cross-virtual unit access traffic, migrating a high-frequency data copy and redirecting a write request, and adjusting fragmentation granularity according to data relevance; the virtual unit closest to the equipment group is selected as a main node in the data fragments, write operations are combined, low-delay paths are selected for synchronization, an asynchronous confirmation mechanism is adopted to respond to edge nodes, the local resource hit rate and the task processing efficiency are improved, and the real-time performance and reliability of industrial control are guaranteed.

The invention relates to the technical field of pipeline monitoring and artificial intelligence, in particular to a multi-source data fusion pipeline monitoring method and system. The method comprises the steps of performing field sorting, structure unification and risk segmentation processing by obtaining pipeline line data, historical operation archives and strategy update configuration records, and generating a session primary key configuration table; a multi-source acquisition time window is configured, an acquisition task is issued, time anchor point registration and field aperture unification are completed, and a multi-source session data packet set is generated; performing session and risk unit association, performing multi-modal feature extraction and cleaning aggregation based on artificial intelligence, and constructing a pipe network risk map structure by using a map structure data model; and calling a multi-task reasoning model and a rule component based on the atlas, and performing risk type reasoning and grade judgment to obtain a risk assessment result and a strategy updating record. According to the invention, intelligent fusion of multi-source data and closed-loop optimization based on machine learning can be realized, and intelligence and reliability of pipeline safety management are effectively enhanced.

The invention discloses a product full-life-cycle traceability after-sales service system based on multi-source heterogeneous data, and relates to the technical field of product traceability after-sales management. Manufacturing resumes, work orders, spare part warehouse-in and warehouse-out and equipment logs are accessed, mapping of product instances, parts and software primary keys is established, and the product traceability after-sales service system is established. And normalizing the configuration change event into a configuration change event containing double time axes of effective time and warehousing time, and writing the configuration change event carrying differential operation, an evidence packet and an idempotent event identifier into an immutable event library. And constructing a conflict set for the same configuration target, executing uniqueness, causality and compatibility constraint verification, determining an effective event based on evidence packet arbitration, and outputting an arbitration record and confidence. And deriving a configuration version chain according to the effective event and generating a snapshot, performing incremental playback on the late or error correction event and generating an influence propagation list. And when any time point configuration is queried, playback restoration is performed, an evidence chain and confidence are output, an active verification backflow error correction event is triggered if the confidence is insufficient, and the accuracy of quality guarantee judgment and spare part matching is improved.

The invention relates to a food traceability method based on a block chain, and the method comprises the steps: collecting production data, generating a unique data major key and an identifier, encrypting and uploading the data, and binding the data with a food batch; associating production link data, collecting processing data, performing secondary hash to generate a processing link data link, and binding a food unit after the processing link data link is linked; identifying a processing link identifier, collecting transportation data, carrying out chain association and timestamp progressive encryption and then carrying out uplink, generating a transportation link identifier and recording handover information; after full-link data are verified, sales data are collected, a full-link Merkel tree is formed through closed-loop association, a sales link identifier is generated after uplink encryption, and multi-node confirmation is triggered; a permission verification request is initiated through a query terminal, and after block chain type verification and local hash verification are carried out, a complete traceability link containing handover nodes, persons in charge and equipment information is displayed according to a time axis. According to the invention, full-life-cycle traceability of food is realized.

The invention provides a method, system and device for data encryption transmission between isolation networks based on a two-dimensional code and a medium, and belongs to the technical field of data transmission. The method comprises the steps that a form needing to be transmitted is acquired from an intranet, and key fields are extracted; converting the primary key field into a short code by using a mapping table, splicing the short code with the basic field and the service field, and adding a check code to obtain source data; after encrypting and encoding the source data, converting the source data into a two-dimensional code, and transmitting the two-dimensional code to an external network system through a physical medium; scanning the two-dimensional code by using a terminal device in an extranet, decoding and decrypting the two-dimensional code, and then splitting the two-dimensional code to obtain a short code, a basic field, a service field and a check code; and performing data verification by using the verification code, restoring the short code into the main key field by using the mapping table after the verification is passed, and restoring the original form according to the main key field, the basic field and the service field. According to the invention, a complete process from internal network data extraction to external network data restoration is realized based on the two-dimensional code.

The invention relates to the technical field of data import, in particular to an intelligent Excel data import method and system based on dynamic mapping, and the method comprises the steps that the system traverses all Excel fields for each database field, calculates the feature similarity and field matching degree of the Excel fields, and generates a field mapping template set according to all field matching results; reading the Excel content according to rows, cleaning each row of content into a standard value, performing quality scoring, and outputting a target format data structure set; screening a structure alignment data row and a field structure exception record set which conform to a threshold value; the system reads the structure alignment data rows line by line, processes the extraction value of each field and outputs a legal data set; and extracting a field sequence set, searching whether fields marked as primary keys or unique keys exist in the field sequence set, and combining the fields into a uniqueness judgment set to judge whether the currently written Excel data exists in the target database table.

The invention discloses a switch secure communication encryption method based on quantum key distribution. The method comprises the following steps: a service party submits a'security-delay-bandwidth 'intention to a zero-trust brain through a quantum policy intention description language; evaluating the real-time quality, key margin and topology accessibility of an optical fiber quantum channel, a classical ultra-high-speed channel and a radio frequency space channel according to intention requirements; triggering a QKD transmitting end and a receiving end to perform quantum state transmission of polarization and OAM coding along the optimal quantum path, completing basis vector comparison, error code verification and privacy amplification, generating a root quantum key, and injecting the root quantum key into an on-chip quantum memory; when a data packet arrives at a switch port, the assembly line takes out Kroot from the first-level key pool, and derives a one-time session key through the HMAC-SHA3; continuously monitoring a quantum channel bit error rate, a key pool margin and an AI abnormal score; and the transmitting and receiving parties synchronously confirm and destroy the session key, write all key life cycle events into a quantum invariant account book, and realize second-level auditing evidence obtaining through block chain hash anchoring.

The invention relates to the technical field of distributed data storage, and discloses a database cluster partition operation method and device under a network partition scene and a medium, and the method comprises the steps that a multi-master distributed database cluster is constructed, and each node continuously captures a database native transaction log; obtaining change event data, and performing unified data storage; analyzing the original log into structured data, and executing uniform fragmentation and parallelization processing; processing the block log change record, and arranging change events of the primary key according to a rule; executing conflict processing and data synchronization, and synchronizing all nodes after the conflict is solved; through exception handling and fault tolerance, self-healing is realized and data consistency is maintained. According to the method, millisecond conflict identification and data consistency convergence after network disconnection can be realized, continuous and stable operation of a cluster in a partition state is ensured, and self-healing and continuous availability of a system are realized.

The embodiment of the invention provides a column storage method and device, a computer program product and a storage medium. On the premise that the online service is normally provided according to the line storage, the stock flow and the increment flow can be pulled in parallel. A column storage file and a first primary key index can be generated by pulling the stock stream. By synchronizing the data operations occurring on the target data table monitored during the pulling period to pull the incremental stream, an incremental file and a second primary key index can be generated, and it can be ensured that column storage can be kept consistent with row storage in the aspect of increment. Recording the primary key needing to be deleted for the first primary key index based on the data operation monitored during the pulling period; and in response to the ending of the pulling, combining the first primary key index and the second primary key index into a target primary key index, and correcting the target primary key index and the column storage file on the basis of the primary key needing to be deleted, so that the consistency of the column storage and the row storage in the aspect of stock can be ensured.

The invention discloses an intelligent database switching method and device, computer equipment and a storage medium, belongs to the technical field of big data, and is applied to a financial database downtime processing scene. According to the method, the node state of the database is monitored in real time, multi-dimensional load evaluation is combined, the optimal main and standby database combination is automatically selected, second-level fault sensing and rapid switching are achieved, and a minute-level time window needed by traditional database recovery is remarkably shortened. The database identifier is embedded in the service main key, so that the request can accurately position the corresponding database node, complex cross-database query and routing overhead are avoided, and the system response efficiency is improved. In addition, through data seamless transmission and automatic abnormal switching between the main database and the standby database, the risk of service interruption caused by database faults is reduced. According to the scheme, the high availability and the fault recovery speed of the database are improved, repeated construction of a multi-product-line database cluster is reduced through resource integration, and a large amount of hardware and operation and maintenance cost are saved.

A computer-implemented method of registering a user identifier in a public key infrastructure comprising a trusted device and a server is provided. The method includes the steps: receiving the user identifier as an input to the trusted device; obtaining a hash value of the user identifier; the trusted device obtaining biometric data comprising a facial image of the user; generating a public key and a privacy preserving data structure using the biometric data, encrypting the user identifier using the public key, and storing the encrypted user identifier as metadata in the privacy preserving data structure, wherein a private key for decrypting the encrypted user identifier can be generated from the privacy preserving data structure using subsequently acquired biometric data comprising the facial image of the user; generating a device token corresponding to the trusted device and obtaining a hash value of the device token, the server storing the privacy preserving data structure uniquely indexed by the hash value of the device token while using the hash value of the user identifier as a primary key, and the trusted device storing the device token.

The invention belongs to the technical field of big data, is applied to a business operation data acquisition and completion scene, and relates to a business processing risk control method, device and equipment and a storage medium thereof. Obtaining a target primary key as an index field, and performing business operation data supplementation in combination with a pre-generated three-layer storage structure; and executing the target business operation task by using the supplemented business operation data. Therefore, when the current business operation data is identified as the updated redundant data, data screening does not need to be directly carried out from the basic database with the maximum storage pressure, the processing pressure of the basic database is reduced, the data supplementing efficiency is improved, and the business risk control crisis caused by incomplete data of a subsequent business operation task is avoided. When the business processing risk control method is applied to an insurance issuing business scene under big data, risk control crisis caused by incomplete business operation data can be effectively avoided.

Apparatuses, methods, and computer-readable media infer a graph model from a semantic model that describes source tables and relationships among the source tables. The apparatus identifies at least one primary key for each relationship of a plurality of relationships defined in the semantic model based on whether the relationship is a m:1 relationship or a 1:1 relationship, each relationship defining at least one from-table and one to-table. The apparatus creates a vertex table in the graph model for each source table having a primary key. The apparatus creates an edge table in the graph model for each from-table defined in a m:1 relationship of the semantic model and creates an edge table in the graph model for one of the from-table or the to-table in a 1:1 relationship of the semantic model. Each edge of the edge table is labeled with a source or destination vertex table and a foreign-key.

The invention relates to the technical field of information security, in particular to a data governance sensitive data desensitization method, which comprises the following steps of: performing hash fragmentation on a primary key of a database, generating semantic, statistical and topological fused enhanced vectors, and obtaining risk form fingerprints through a classification model; splicing the fingerprint and the vector in the homomorphic encryption domain to calculate a risk score, and decrypting in the trusted execution environment to obtain a high-risk feature tensor when a threshold value is met; training a volumetric neural rendering network according to the feature tensor, generating a proxy record under the constraint of a matrix product state tensor chain, and writing the proxy record into a proxy data lake by combining random salt with primary key hash; after query is received, a query hypergraph is constructed to calculate incremental mutual information, leakage indexes are obtained based on persistent coherence, Groth16 zero-knowledge proof is generated in combination with risk fingerprints, a result is returned after verification is passed by deducting privacy budget, and an aggregation value of Laplacian noise disturbance is output when the budget is insufficient. The method has the advantages of high-accuracy desensitization and verifiable privacy budget control.

The invention discloses a total-factor integrated large Token data management system, and the system comprises an identity credential collection unit which is used for obtaining an identity label and associated business data from a plurality of social subjects; the identifier abstraction unit is used for mapping the identity identifier into a standardized Token primary key according to a main body type and structuring the associated business data into a corresponding digital asset package; the total element aggregation unit is used for aggregating and packaging the digital asset package into a single verifiable large Token data structure, and the large Token comprises a Token primary key and a dynamic trust level; the dynamic trust engine is used for calculating and updating the trust level of each main body in real time and binding the trust level to the corresponding large Token; and the intelligent service execution unit is used for responding to an external business instruction and calling the large Token to realize intelligent service.

The invention discloses an abnormal risk prediction method and device based on an assembly knowledge graph, equipment and a medium, and relates to the technical field of data processing. The method comprises the steps of obtaining multi-source heterogeneous data, performing association and alignment through a unified primary key set, and performing segmentation to generate a time slice data set; and constructing an assembly domain ontology and an assembly knowledge graph mode layer, instantiating the assembly domain ontology by using the time slice data set, and constructing an assembly knowledge graph snapshot sequence. And based on the assembly knowledge graph snapshot sequence, modeling and updating the influence relationship between variables in the assembly process to obtain an assembly process influence relationship structure. And in combination with the assembly knowledge graph snapshot sequence and the assembly process influence relation structure, coding is carried out, the state representation of the next time window is predicted based on the embedding representation of the historical time window, and an abnormal risk score is calculated. When the risk exceeds a threshold value, influence path tracking is carried out, controllable decision variables are screened, candidate intervention schemes are generated, the effects of the candidate intervention schemes are evaluated, and decision suggestions are output.

The invention relates to a method and a device for realizing synchronization of an oversized transaction to an openGauss database based on Debezium. The method comprises the following steps: configuring the size of a file cache slice; starting an incremental synchronization service, and obtaining a data change record (EVENT) by analyzing an Oracle source library log; dividing the EVENT into an independent file cache queue according to the transaction ID, and triggering dynamic segmentation (the storage capacity exceeds the standard or is overtime); when the service is abnormal, positioning a site through an index to realize breakpoint resume; after the transactions are submitted, the file cache queue is read in sequence and pushed to the downstream, and incomplete transactions are rolled back when the transactions are abnormal; events containing LOB / XML columns are combined into DML statements, and the DML statements are issued according to a primary key strategy; and converting the downstream system into a standard format for the consumer to subscribe. According to the scheme, memory caching is replaced by file caching, OOM is avoided, dynamic segmentation and breakpoint resume improve the large transaction processing capacity, the LOB / XML merging strategy guarantees the data consistency, general transaction optimization is supported, and the oversized transaction synchronization efficiency and stability are remarkably improved.

The embodiment of the invention provides a data retrieval method and device. The method comprises the following steps: receiving an initiated retrieval task, wherein the retrieval task comprises dimension constraint condition information and a retrieval vector of information to be retrieved; in response to the retrieval task, the retrieval task is executed asynchronously, and the step of asynchronously executing the retrieval task comprises the substeps that specified dimension constraint condition information in the retrieval task is transmitted to a column database, and metadata in the range of the dimension constraint condition information and a corresponding primary key list are screened in the column database; and transmitting the primary key list and a specified retrieval vector in the retrieval task to a vector database, and performing vector similarity retrieval in the vector database to obtain a retrieval result.

Aspects of the disclosure generate independent encryption keys for objects (e.g., virtual machine disks (VMDKs)) without requiring the management of multiple keys. An encryption manager obtains a primary encryption key, an object identifier (ID) comprising a globally unique ID (GUID) for an object, a data salt comprising the object ID and a data salt string, and a metadata salt comprising the object ID and a metadata salt string. A data encryption key is generated using the primary encryption key, the data salt, and a one-way function. A metadata encryption key is generated using the primary encryption key, the metadata salt, and the one-way function. Because the data salt string and metadata salt string differ, the data encryption and metadata encryption keys differ. Object IDs for different objects differ, so each object and its metadata have globally unique keys. Key generation (other than the primary key) is deterministic, simplifying key management.

The invention belongs to the technical field of artificial intelligence and big data, and relates to a database retrieval method which comprises the following steps: in response to an update request for a target field in a user data table, obtaining an initial primary key number of the user data table; acquiring a preset initial step parameter, and establishing a retrieval range according to the initial primary key number and the initial step parameter; retrieving a target field in the user data table according to the retrieval range to obtain a retrieval hit result; and extracting an updating strategy from the updating request, and performing data updating on the target field in the retrieval hit result according to the updating strategy. The invention further provides a database retrieval device, computer equipment and a storage medium. The method can be applied to business management program systems of financial science and technology, medical treatment and the like, and the problems that the retrieval process time is prolonged and the retrieval updating efficiency is low in existing database retrieval can be solved.

The invention relates to the technical field of geographic information systems, and discloses a chemical mineral geographic information system, comprising: a geographic information database module for constructing a structured data table based on a relational database, establishing an index according to multi-dimensional classification, setting a joint primary key, and ensuring data retrieval efficiency and uniqueness; the data informatization processing module is used for converting the unstructured historical geological data into a standard field format, importing the unstructured historical geological data into a database through an interface and generating a unique number to identify each piece of mineral information; the content management platform module is used for realizing newly adding, editing, auditing and publishing of information, is internally provided with an authority distribution mechanism and is linked with the database through a rear-end interface; and the user authentication and authority control module is used for receiving the login request, generating a token and performing authority control through role identification. According to the method, the security, flexibility and stability of function hot update are improved through module dependency analysis, upgrade scheduling control and a version backspacing mechanism.

The invention discloses a global-oriented multi-language multi-time-zone power station management method and system, and relates to the technical field of electric power digital management, and the method comprises the steps: collecting power station data, carrying out the standardized identification, and constructing a power station multistage coding identification main key; a multi-language mapping system is constructed by taking a multi-level coding identification main key of a power station as a drive, and time zone offset logic is constructed by using standardized identification; and performing hierarchical authority control based on the power station multi-level coding identification primary key prefix and generating a localized alarm prompt. According to the method, standardized identification of power station data is realized by constructing a unified power station multi-level coding main key; based on primary key driving multi-language mapping and time zone offset processing, accurate presentation and time consistency of data in a multi-language environment are guaranteed; authority control is achieved through primary key prefix division, multi-language alarm prompts are triggered in combination with signal coding, and a power station event management mechanism which is clear in alarm semantics, timely in response and controllable in boundary is achieved.

The invention discloses a nursing information online management system based on multi-source data fusion, which belongs to the field of nursing and comprises modules of data acquisition, access, standardization, compatible processing, storage, privacy protection, intelligent fusion and the like. The system collects multi-protocol data through edge nodes, uniformly converts the multi-protocol data into an intermediate format and performs standardized processing, so that semantic consistency and structure unification are realized. A structure mapping and primary key synchronization mechanism is adopted, and a heterogeneous system data barrier is broken through. Nursing information storage is based on a column database, and performance and reliability are enhanced by combining cold and hot stratification and replica redundancy. The encryption module supports field-level encryption and auditing traceability, and data privacy is guaranteed. The fusion engine utilizes a graph neural network and time sequence modeling to aggregate multi-maintenance information and predict risks. Asynchronous communication and a Protobuf protocol are adopted among the modules, so that low-delay and high-throughput data flow is realized. The intelligent nursing management system has the beneficial effects that the intelligence, precision and safety of nursing management are remarkably improved.

The invention discloses a database partition table processing method, device and system and a medium, and the method comprises the steps: distributing a unique identifier for each partition in a partition table according to a preset identifier distribution strategy, and storing the unique identifier of each partition in metadata of the partition table; constructing a global index of the partition table according to the primary key of the partition table and the unique identifier of each partition; when an operation of removing all data of a specified partition in the partition table is received, obtaining a current unique identifier of the specified partition from the metadata, recording the current unique identifier as an old identifier, and updating the metadata; and updating the corresponding record in the global index in the background according to the old identifier. The unique identifier of each partition is introduced into the metadata and the global index of the partition table, and the old identifier is recorded to distinguish the new history and the old history when the partition data removal operation is executed, so that the global index is still kept effective while the related operation is efficiently executed, the data uniqueness is ensured not to be influenced, and the efficiency and the usability of the partition table operation are improved.

The invention relates to the technical field of food quality safety, and discloses a food quality safety traceability method based on big data, which comprises the following steps: step 1, binding a unique batch identification code for each food batch, and deploying Internet of Things sensing equipment to collect environmental parameters and geographical location information, after the environment parameters and the geographical location information are associated with the batch identification codes, a data packet with an identity label is formed; and 2, the cloud big data platform receives and gathers the data packets with the identity labels, integrates preset static basic data and node event data, and constructs a dynamic digital file for recording a complete life cycle process by taking batch identification codes as main keys. According to the technical scheme of binding unique identification codes for food batches and deploying Internet of Things sensing equipment to automatically collect and associate uploaded data to a cloud platform for convergence and fusion, automatic and integrated management of whole-course data of a supply chain is realized.

The invention relates to the technical field of intelligent community data governance and main identity normalization management, and discloses a future community member architecture intelligent building method and system, and the method comprises the steps: carrying out the field semantic standardization of structured resident data; fusing the unstructured data; generating a ciphertext identifier; executing cross-system identity matching in combination with a field similarity function; and generating a unique main identity file. Compared with the prior art, the technical problems that data of multiple departments are independently managed, field structures are heterogeneous, a unified identity primary key is lacked, and particularly, high-precision identity fusion and normalization management cannot be realized under the complex data conditions of name duplication, different address expressions, field missing or untrusted sources and the like of residents are solved. According to the method, cross-system multi-source data fusion and identity uniqueness determination are realized through semantic hash slot construction, image-text joint recognition, multi-source fuzzy matching and a credible main file generation mechanism, and the uniqueness and credibility of future community resident identity data are improved.

The invention relates to the technical field of computers, and provides a graphic editing revocation and redoing method and system, and the method comprises the steps: creating a revocation stack and a redoing stack based on a graphic layer object; storing the layer object through a relational database, and taking the self-added ID as a primary key ID corresponding to the layer object; the revocation stack and the redo stack are used for storing an operation record, correspondingly popping the operation record when a revocation instruction or a redo instruction is received, recording a new primary key ID of the current operation record in the relational database when the revocation instruction or the redo instruction is completed, traversing the revocation stack and the redo stack, and storing the new primary key ID of the current operation record in the relational database; and searching the operation record which is the same as the current operation record, and changing the primary key ID of the operation record into a new primary key ID. According to the method, the defect that the IDs of the primary keys in the database are inconsistent when the graph is edited is overcome.

The present disclosure provides methods, devices, apparatus, and storage medium for data migration. One method includes obtaining source table structure information of a source data table, changing the source table structure information, and creating a target data table based on changed table structure information; determining a plurality of source primary keys in the source data table; successively migrating the source primary keys and the source data in the source data table to the target data table, each migration starting after previous migration succeeds; generating a migration progress record of each migration; determining a migration progress record at migration interruption when the migration interruption occurs, and determining a source primary key at the migration interruption in the source data table; and continuing to successively migrate, starting from the source primary key at the migration interruption in the source data table, an unmigrated source primary key and unmigrated source data.

The invention discloses a method for optimizing an incremental migration mode of a database synchronization tool, which comprises the following steps of: acquiring a batch of data change events from a message queue, and grouping according to primary keys of the events; sequencing events in each primary key group according to a time sequence rule, simulating a data state change mode, and performing multiple operations on the same record to obtain a single target operation of a final state; all single target operations are distributed to different data fragments according to the hash values of the primary keys, so that all changes of the same primary key are processed in the same fragment; starting a thread pool, performing parallel processing on each data fragment by an independent database transaction, and writing the data into a target database; according to the method, through a strategy of first merging and second parallelization, redundant database I / O operation is effectively eliminated, multi-core CPU resources are utilized, on the premise of ensuring data consistency, the overall throughput of data synchronization and the utilization rate of system resources are improved, and the stability and efficiency of the synchronization process are enhanced.

A method for generating self-serve integrations includes receiving a network address of a configuration file that includes parameters to interface with a server. The method extracts, from the configuration file, endpoints and operation(s) available to manipulate each endpoint. The method displays a first table having a rows displaying (a) a given endpoint and (b) a menu for selecting a given operation to manipulate the given endpoint. The method, upon selection of a given row, displays input field(s) that accept a parameter, authorization, header, body, and / or response data. The method gathers, from the server, a data fields available at the given endpoint. The method displays a second table having rows that have data field(s), and input(s) for a data type, column type, a display name, unit, description, primary key, secondary key, and / or an indexing toggle.