6 results about "Referential integrity" patented technology

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.

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

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.