388 results about "Primary Key" patented technology

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 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 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 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 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 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 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.

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.

Systems and methods are described for batch materialization of an incremental change data capture (CDC) changeset. The primary keys are extracted from the incremental CDC changeset and are broadcast to a plurality of executors. By iteratively broadcasting the extracted primary keys in groups, each being a size that is less than a broadcast limitation, the full dataframe of extracted primary keys is broadcast to the executors. Each executor filters a baseline data table based on the extracted primary keys to generate a baseline match dataframe with all primary keys matching the extracted primary keys, and a baseline unmatched dataframe with all primary keys not matching the extracted primary keys. Each executor receives a partitioned incremental CDC changeset and applies the changes to the baseline match dataframe to produce a baseline change dataframe, which is merged with the baseline unmatched dataframe to produce a final changed baseline data table.

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.

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.

The invention discloses a supply chain auditing risk monitoring and early warning system based on artificial intelligence, which relates to the technical field of supply chain auditing and comprises the following steps of: packaging a multi-service system receipt change into an event packet containing a source identifier, an event type, a service primary key set, event time, lake entering time and an aperture version; idempotent duplicate removal is additionally written into an event account book, and an alarm entity is generated; when an alarm is about to be bound, a consistent slice definition is generated, a pointer type snapshot or a materialized snapshot and a seal object are formed, a verification value is calculated in a normalized and serialized mode, and two-stage submission binding is carried out to form an evidence packet; the evidence integrity is calculated according to a risk type template, and the double-threshold alarm gate state machine migrates an alarm state and distributes an evidence repair task; and performing deterministic playback according to the evidence packet and outputting a difference attribution report for closed-loop processing, thereby realizing reproducible and verifiable alarm, supporting third-party verification, reducing false alarm outgoing, and shortening re-checking positioning time and proof.

The invention provides a multi-keyword private information retrieval method and system based on inverted indexes, and belongs to the field of information security and privacy computing. The method comprises the following steps that: a server splits an original database into a reverse index part of a keyword-index set and a key value pair part of an index-data value; mapping the index set into an integer by utilizing Godel coding; processing the data by adopting probability batch coding and binary random linear coding and publishing a hash function; the client maps a multi-keyword query into a bucket by using a hash function to generate a query vector, and the query vector is sent to the server after being subjected to fully homomorphic encryption; the server performs homomorphic calculation on a matching result in a ciphertext state and returns the result; and the client obtains a matching index set after decryption verification, and then initiates a second round of query to obtain final data. According to the method, symmetric privacy protection of multi-keyword non-primary key query in a single-server environment is realized, leakage of query content and database information is effectively prevented, and private information retrieval security is improved.

This invention relates to the field of data processing technology, specifically providing a data query method, apparatus, device, and medium, aiming to solve the problem of slow performance in the total number of records query and sorting process during data querying, especially with large volumes of data. To this end, the method of this invention includes: calculating the number of digits *i* of the primary key element required for fuzzy matching of the primary key column in the table containing the data to be queried using the SQL LIKE operator; constructing an SQL statement based on the number of digits *i*: `select * from tablename where uuid like 'specified pattern'`; and iterating through all possible *i* digit primary key elements to execute the SQL statement k... i The For loop iterates through the data retrieved in each iteration, loading the data into memory as a separate batch. This implementation reduces performance overhead and improves work efficiency.

The application provides a replication identifier configuration method and device, equipment, storage medium and program product, and relates to the technical field of databases. The method comprises the following steps: obtaining table structure information of a target table in a database, wherein the table structure information comprises a primary key field and a unique non-empty index field; the primary key field is a field for uniquely identifying a row of records in the table; determining a replication identifier field of the target table according to a user configuration parameter and the table structure information, wherein the user configuration parameter is used to control the generation rule of the replication identifier field; and caching the replication identifier field and the table structure information as metadata information. The method is used to improve the accuracy and stability of data synchronization.

The invention discloses a large packet anomaly detection method and device based on a dynamic baseline, a medium and a product, and relates to the technical field of data security. The method comprises the following steps: determining a target log record; extracting a service group identifier and a uniform resource locator of each target log record, and constructing to obtain each primary key; determining the first target log records with the same first primary key as a first group, and determining a dynamic baseline parameter based on historical first target log records in the first group; in response to a processing instruction of a second target log record, determining a current dynamic baseline parameter matched with a second primary key based on the second primary key of the second target log record, and comparing the length of the second target log record with the current dynamic baseline parameter, and determining whether the second target log record is an abnormal log record based on the comparison result. According to the scheme provided by the invention, the big packet data can be quickly and accurately detected, attack behaviors are effectively avoided, and help is provided for equipment security.

This invention discloses a method, apparatus, device, and computer-readable storage medium for analyzing vintage-like indicators, relating to the field of risk data analysis technology. The method includes: acquiring underlying raw data; for each key value under the detailed primary key in the underlying raw data, calculating the wide table row information corresponding to each key value based on the detailed data corresponding to each key value in the underlying raw data, to obtain a target wide table composed of the wide table row information of each key value; upon receiving a statistical instruction for a vintage-like indicator, searching in the target wide table for each target key value corresponding to the target statistical dimension indicated by the statistical instruction, and calculating the vintage-like indicator value under the target statistical dimension according to the intermediate data corresponding to each target key value. This invention proposes an analysis scheme for vintage-like indicators, reducing the complexity of vintage indicator analysis operations and improving analysis efficiency.

This invention relates to the field of text processing technology and discloses a dynamic template generation system for test data of mobile maintenance of pumped storage power stations. The system includes: generating process activity degrees; dividing into stages; combining and generating stage feature vectors; generating a mask matrix; generating a set of patterns and stage grouping; constructing a two-dimensional rectangular grid and row mapping rules; generating a semantic dictionary; and generating acquisition results. This invention avoids structural redundancy caused by mechanism-selective column cluster holes by dynamically generating a two-dimensional rectangular grid template without complex topology. The strong binding between the globally unique primary key and the semantic dictionary ensures that semantic anchors remain stable during cross-platform conversion, preventing the loss of data physical meaning due to layout reflow. Simultaneously, the system can flexibly adapt to different test conditions and unit types, reducing manual template adjustments and providing convenient data acquisition support for mobile maintenance of pumped storage power stations, improving the standardization and efficiency of test data acquisition.

A computer-implemented method that causes data processing hardware to perform operations including generating, at a first device, a message having a header including a message type and a service ID, receiving, at a second device, the message including the header and a key serial number (KSN) of the first device, determining, based on the header, the message type of the message, verifying, at a high performance crypto accelerator (HPCA) of the second device, a message authentication code (MAC) of the message based on the determined message type being the service event, obtaining, based on the KSN from the message, a key slot from a message authentication code table (MACT), identifying, based on the key slot, a key associated with the key slot obtained from the MACT, the key including at least one of a primary key and a secondary key, and verifying, using the key and the key slot obtained from the MACT, the MAC.

The invention discloses a cross-platform power grid data conversion synchronization method and device, a terminal and a medium. According to the method, a master table in a source database is synchronized to a target database according to master-slave table dependency sequence information; in the synchronization process, an ID mapping table is constructed to record the mapping relation between a first primary key ID and a second primary key ID of each piece of primary table data, the second primary key ID corresponding to a foreign key field is dynamically calculated to be used for updating the foreign key field based on the foreign key field of the slave table in combination with foreign key mapping relation information and the ID mapping table, and the secondary table data is synchronized. Finally, after all the foreign key fields of the slave table are updated, the data synchronization action of the slave table is executed in combination with ORM data synchronization logic, dynamic remapping of the primary key ID is achieved by constructing the ID mapping table, the foreign key fields of the slave table are updated based on the foreign key mapping relation information, the foreign key reference integrity during cross-database synchronization is ensured, and the synchronization efficiency is improved. The problem of foreign key reference integrity caused by inconsistent primary key IDs in the cross-database synchronization process is effectively solved.

The application relates to a primary key generation method and an electronic device, and belongs to the technical field of databases. The method comprises the following steps: when storage processing is performed, a first identification sequence is generated based on current system timestamp information processing; a second identification sequence is generated based on creation date information processing of obtained to-be-stored data records; and splicing processing is performed based on the first identification sequence and the second identification sequence, and a third identification sequence obtained through the processing is taken as a primary key of the to-be-stored data records. According to the technical scheme, the generated primary key contains timestamp information and creation date information of the data records. The primary key generated in this way can guarantee the global uniqueness and global monotonicity of the primary key, and can extract sharding information for table sharding according to dates from the primary key, so that in a database application scenario of time storage and table sharding, the sharding table can be accurately positioned when the primary key is queried.

The invention relates to the field of network and host data dynamic protection, in particular to a dynamic protection method fusing network and host data. The method comprises the following steps: acquiring a strategy version recording structure, a network acquisition node list and a host end acquisition agent list, performing session number registration, acquisition task issuing and timestamp alignment registration processing, and generating a two-dimensional acquisition data packet structure; performing data packet primary key alignment, field normalization and missing detection marking processing to generate a structured log record set structure; performing score item registration, protocol risk annotation generation, weighted score synthesis and grading rule matching processing, and generating an abnormal judgment score record structure; and finally, performing firewall rule write-in registration, object group binding registration of the deny, rollback condition verification and audit log filing processing, and generating a policy version recording structure. According to the invention, by fusing the network and the host data, dynamic and accurate anomaly detection and automatic protection can be realized, and the real-time performance and reliability of safety response are improved.

The present disclosure belongs to the technical field of network security, and particularly relates to a network anomaly monitoring method, device and program product based on traffic fingerprint learning, which comprises the following steps: extracting metadata irrelevant to encryption of a target network; the metadata comprises five-tuple, timestamp, length and protocol flag information of a data packet; the metadata is aggregated with a source IP address as a primary key to define a network entity; session feature extraction is performed on a session of the target network entity and other network entities; the extracted session features comprise timing features, operation sequence features and scale distribution features; the operation sequence features comprise Shannon entropy of a continuous request and response type pair; an action fingerprint of the target network entity is constructed according to the session features; and whether the target network and the target network entity are abnormal is judged according to a deviation degree of a current action fingerprint of the target network entity and a fingerprint baseline. The present disclosure can realize accurate identification of network anomalies.

The application relates to a data migration method and device, a computer readable storage medium and computer equipment. The method comprises the following steps: obtaining corresponding original full data in a source database; inserting the identifier of the source data table corresponding to the data according to the data position in the original full data to obtain target full data; modifying the original primary key corresponding to the data in the target full data into an updated primary key, wherein the updated primary key is determined by the original primary key corresponding to the data and the identifier of the source data table corresponding to the data; migrating the target full data to a target data table in a target database; obtaining incremental data of the source database, migrating the incremental data to the target data table, and inserting the identifier of the source data table corresponding to the data according to the data position in the incremental data. The scheme provided by the application can reduce the influence of the database migration process on normal access operations of the database.

The invention discloses a method and device for improving the read-write performance of a database, and relates to the technical field of database optimizing.The method comprises the following steps that firstly, a database read-write request initiated by a service system is intercepted, and query conditions in the request are analyzed; 2, performing shunt query according to the type of the query condition: if the query is single primary key or primary key list query, routing the request to a key value pair database and reading data; and if the query is composite condition query. According to the method, the database request is intercepted, and the original query of a relational database is converted into the query of a key value pair database or a full-text retrieval database, so that the respective advantages of the key value pair database in a single key value query scene and the full-text retrieval database in a complex query scene are fully exerted; the problem that an existing relational database is large in data volume and slow in query is solved, and the problem that all data cannot be queried at a time due to data separation caused by an existing data fragmentation scheme is solved.

The invention discloses a method and equipment for processing meteorological grid point data based on a database, and the method comprises the steps: analyzing original meteorological grid point data, and extracting metadata information; the metadata information is grouped and coded according to at least two dimensions, and binary bit streams corresponding to coded values obtained after information of each dimension is coded serve as input data; starting from the most significant bit of the binary bit stream, sequentially extracting one bit from each dimension according to a preset sequence for interlacing, and generating a primary key corresponding to the original meteorological grid point data; the main keys are written into a database for storage, and the database sorts the main keys according to the sizes of the main keys. According to the method provided by the invention, through a multi-dimensional joint index construction method, efficient and flexible support for multi-dimensional range query of the type is realized, complex multi-dimensional range query is converted into efficient one-dimensional continuous interval scanning of a data storage engine, and the meteorological service data retrieval performance is improved.