12 results about "Referential integrity" patented technology

In some examples, computer-implemented systems and processes deploy securely de-risked elements of confidential data within a distributed computing environment. For example, an apparatus may obtain configuration data associated with a source data table. The configuration data may specify an identifier of a column of the source data table that includes elements of confidential data, and based on the configuration data, the apparatus perform operations that anonymize the elements of confidential data within the column of the source data table and generate an anonymized column within the source data table. The apparatus may also perform operations that provision an anonymized data table that includes the anonymized column to at least one computing system, which may process the anonymized data table and generate an output data table that includes the anonymized column and maintains a referential integrity between the source data table and the output data table.

Various embodiments described herein provide for systems, methods, devices, instructions, and like for generating synthetic data. According to various embodiments, synthetic data generation comprises receiving input specifying one or more source tables and join key columns, and generating synthetic data that preserves statistical similarity and referential integrity among columns of the source data.

A method of encrypting information provided to a large language model (“LLM”) can include receiving first unencrypted information, identifying a first word within the first unencrypted information that is to be encrypted, replacing the first word within the first unencrypted information with an automatically generated first key to create first encrypted information, automatically replacing all instances of the first word with the first key to maintain referential integrity amongst the first word and the first encrypted information, and providing the first encrypted information to the LLM along with a first prompt requesting that the LLM generate a first encrypted output dependent upon the first encrypted information. The example method can further include receiving, from the LLM, the first encrypted output dependent upon the first encrypted information and replacing, using the first word-key pair database, all instances of the first key with the first word to create a first unencrypted output.

The subject technology generates a nested object based on a set of metadata, the set of metadata including information linking the nested object to a table object associated with a base table. The subject technology generates a second table object associated with the nested object, the second table object representing a secondary index of the base table, the second table object including information linking the second table object to the nested object. The subject technology generates a second nested object based on a particular set of metadata, the particular set of metadata including information linking the second nested object to the table object. The subject technology generates a third table object associated with the second nested object, the third table object representing a particular secondary index of the base table, the third table object including information linking the third table object to the second nested object.

The invention provides a method and a system for establishing a relationship between data tables, and belongs to the technical field of big data. Comprising the following steps: S1, foreign key constraint: explaining how the foreign key constraint maintains a relationship between tables, including cascade operation and reference integrity, and discussing an implementation mode of the foreign key constraint in a database, such as use and optimization of an index; s2, a connection table explains the effect of the connection table in processing a many-to-many relationship, including the structure and use of an intermediate table, and analyzes the influence of the connection table on query performance and an optimization strategy; and S3, self-association: how self-association supports storage and query of tree structure data is described, and advantages and disadvantages of self-association in database design are discussed. According to the system for establishing the data table relation, the foreign key constraint of the RDBMS is taken as a core, logical association is realized through the primary key, the foreign key and the relation type definition, and the non-relational database simulates the relation through a reference or embedded document, so that the data consistency and the query efficiency are ensured.

An import job associated with a data store update is inspected and schemas associated with target data tables that are to be updated with update data are analyzed. Referential integrity issues associated with foreign keys in the target tables are identified in the update data. The update data is broken into three portions, a first portion that is guaranteed to not have a referential integrity issue, a second portion this is known to have a referential integrity issue, and a third portion that cannot be determined at this stage of processing. The import job is modified to update the corresponding target tables with the first portion of the update data while the second and third portions are not updated to the target data base tables but a custom message is recorded in fields associated with the second and third portions that describes the issue for subsequent review / resolution.

Various embodiments described herein provide for systems, methods, devices, instructions, and like for generating synthetic data. According to various embodiments, synthetic data generation comprises receiving input specifying one or more source tables and join key columns, and generating synthetic data that preserves statistical similarity and referential integrity among columns of the source data.

A centralized data transformation system and corresponding methods / techniques define, select, and execute data transformation rules on data exported from disparate data sources within a source data environment to obtain scrubbed data, which can be imported into a target data environment in a manner that maintains referential integrity. The centralized data transformation system enables data portability between source and target environments, while ensuring compliance with limitations of the target environment. The centralized data transformation system applies scrubber rules consistently across related data fields of data objects of the same object type to ensure that the transformed data complies with limitations of the target environment pertaining to maintaining multiple copies of a given data set.

A projection smart contract includes a synchronized copy of a subset of data held in a private smart contract. The subset of data can include information required for an interaction with another private smart contract while omitting data from the first private smart contract that need not be shared for the transaction. The projection can also be permissioned to limit availability of even the subset of data to parties that require access to the subset of information. Thus, data can be shared between private smart contracts without disclosing private information within those smart contracts.

A projection smart contract includes a synchronized copy of a subset of data held in a private smart contract. The subset of data can include information required for an interaction with another private smart contract while omitting data from the first private smart contract that need not be shared for the transaction. The projection can also be permissioned to limit availability of even the subset of data to parties that require access to the subset of information. Thus, data can be shared between private smart contracts without disclosing private information within those smart contracts.

A system for encrypting information for use with a large language model can include unencrypted information; an identification module configured to identify words to be encrypted in the unencrypted information; a key generation module configured to generate keys corresponding to the words to be encrypted in the unencrypted information, the keys having a similar format as the corresponding words so that the keys preserves the format of the corresponding words to maintain a similar context; a replacement module configured to replace the words with the corresponding keys; and a prompt module configured to determine a prompt to the large language model requesting the large language model to determine an encrypted output based upon the encrypted information, wherein, in response to the reception of the encrypted output from the large language model, the replacement module is configured to replace the keys with the corresponding words to form an unencrypted output.

Techniques provide mechanisms for logical referential integrity in relational database management systems. A child record with a foreign key can be inserted into a child table out of order from inserting parent record with the primary key without foreign key violations. When the child record is inserted a referential integrity check is performed to determine whether the primary key exists in a parent table. An integrant field for each child record is set to indicate whether the primary key exists. Query results can filter out records that do not have referential integrity.