Patent ID: 11893046
Assignee: nan
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 0:
1. A method implemented by one or more computer processors programmed by computer software stored in one or more non-transitory computer-readable mediums comprising:
forming a first database in the one or more non-transitory computer-readable mediums, wherein the first database includes a plurality of database tables having a corresponding plurality of foreign key constraints;
forming a second database in the one or more non-transitory computer-readable mediums, wherein the second database includes a plurality of database tables having a corresponding plurality of foreign key constraints;
wherein a first data system access path links a first unique index of a first database table in the first database with a copy of the first unique index in a first database table in the second database;
wherein the first database table of the first database is populated with data records;
wherein the first database table of the second database is populated with data records;
wherein data integrity between the data records of the first database table of the first database and the data records of the first database table of the second database is enforced for the first data system access path;
the method further comprises performing a database consolidation by consolidating the first database and the second database into a third database;
wherein after database consolidation, the third database contains the first database and the second database;
the step of performing the database consolidation includes combining the first database table of the first database and the first database table of the second database as they existed prior to database consolidation to form a first consolidated database table in the third database with a copy of the first unique index in the first consolidated database table;
the step of performing the database consolidation includes data record consolidation, wherein the data records of the first database table of the first database and the data records of the first database table of the second database as they existed prior to database consolidation are data record consolidated into the first consolidated database table;
wherein the foreign key constraints of the first database that referenced the first database table of the first database before the first combining step, after the first combining step reference the first consolidated database table; and
wherein the foreign key constraints of the second database that referenced the first database table of the second database before the first combining step, after the first combining step reference the first consolidated database table.