Back to results
US 9,852,207 B2Granted
Method for transporting relational data
AssigneeIfWizard Corporation
InventorDominic Samuel Sellers-Blais
Life of this patent
Estimating the term…
Abstract
A method for transporting relational data from one relational database to another such database. The data transported may be a subset of data in the entire database and the relations between the root of this data and other data entities are preserved in a way allowing their reconstruction in the target database. This preservation, itself further directed through configuration, is able to recreate new data identifiers without collision, yet also without requiring maintenance of the original identifiers.
Claims13
A non-volatile computer-readable memory storing a series of instructions executable on a digital processor coupled to the memory to cause the processor to implement:
- an export interface module arranged to interface with a source client program to enable the source client program to initiate export of a subset of relational data from a source relational database to a target relational database;
- a source database connection module coupled to the export interface module and arranged to connect to the source relational database associated with the source client program to access the stored relational data;
- an export subsystem coupled to the source database connection module and configured to generate a data file representing the data for export;
- wherein the data file generated by the export subsystem replaces each row identifier with a portable substitute row identifier to avoid disclosing the original row identifier to the target client program or the target relational database;
- and
- wherein the export subsystem is configured to automatically include data referenced by the data to be exported in the data file, except for data stored in a table designated by the source client program to be ignored;
- a transport I/O subsystem coupled to the export subsystem and arranged to interface with the source client program to provide the data file to the source client program;
- an import interface module coupled to the transport I/O subsystem and arranged to interface with a target client program;
- and
- a target database connection module coupled to the import interface module and arranged to connect to a target relational database associated with the target client program to store relational data in the target relational database based on the data stored in the data file.
7 more elements
A computer-implemented method comprising the steps of:
- accessing a data table in a source RDBMS, the data table including at least one row that contains at least one column of data, and the row has an original identifier;
- selecting at least one row of the table for export;
- and
- encoding the row for export;
- wherein encoding the row includes—
- determining dependent data of the row;
- generating a portable row identifier substitute, to avoid disclosing the original row identifier to the target client program or the target relational database;
- collecting the row data and any dependent data referenced in the row to form export data, except for dependent data stored in a table designated for exclusion;
- arranging the export data, utilizing the portable row identifier substitute in lieu of the original row identifier, into a reconstructable sequence;
- wherein the reconstructable sequence includes placing dependent data in front of the data that references the dependent data;
- and then
- importing the export data into a target database according to the sequence;
- wherein determining dependent data of the selected row includes—
- accessing metadata of the source database;
- based on the metadata, identifying the table columns referenced by the selected row;
- examining a first one of the referenced table columns;
- in a case that the referenced table column is not in the same table as that of the selected row, including the referenced table column in the dependent data, otherwise skip;
- repeating said test for the remaining referenced table columns;
- based on the metadata, identifying the referencing table columns—those columns that refer to the selected row;
- examining a first one of the referencing table columns;
- in a case that the referencing table column is not in the same table as that of the selected row, including the referencing table column in the dependent data, otherwise skip;
- and
- repeating said test for the remaining referencing table columns.
20 more elements
A computer-implemented method comprising the steps of:
- accessing a data table in a source RDBMS, the data table including at least one row that contains at least one column of data, and the row has an original identifier;
- selecting a at least one row of the table for export;
- and
- encoding the row for export;
- wherein encoding the row includes—
- determining dependent data of the row;
- generating a portable row identifier substitutes, wherein the row identifier substitute is unique and traceable to the table and the original row identifier;
- collecting the row data and any dependent data referenced in the row to form export data, except for dependent data stored in a table designated for exclusion;
- arranging the export data, utilizing the portable row identifier substitutes in lieu of the original row identifiers, into a reconstructable sequence;
- and then
- importing the export data into a target database according to the sequence
- wherein determining dependent data of the selected row includes—
- accessing metadata of the source database;
- based on the metadata, identifying the table columns referenced by the selected row;
- examining a first one of the referenced table columns;
- in a case that the referenced table column is not in the same table as that of the selected row, including the referenced table column in the dependent data, otherwise skip;
- repeating said test for the remaining referenced table columns;
- based on the metadata, identifying the referencing table columns—those columns that refer to the selected row;
- examining a first one of the referencing table columns;
- in a case that the referencing table column is not in the same table as that of the selected row, including the referencing table column in the dependent data, otherwise skip;
- and
- repeating said test for the remaining referencing table columns.
19 more elements
Dependencies are inferred from the claim text.