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

Claim 8:
9. 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, wherein the database tables of the first database are populated with data records;
forming a first entity-relationship diagram in the one or more non-transitory computer-readable mediums that represents the first database, wherein the first entity-relationship diagram contains a plurality of data entities and a corresponding plurality of data entity relationships, wherein each data entity of the plurality of data entities represents a single database table of the first database, and wherein each data entity relationship of the plurality of data entity relationships represents a single foreign key constraint of the first database;
performing a database split by dividing the first database to form a second database and a third database, wherein after the database split, the second database and the third database are integrated databases, and wherein after the split, the second and third databases are linked by one or more data system access paths;
wherein performing the database split includes a step of forming a second entity-relationship diagram in the one or more non-transitory computer-readable mediums by making a copy of the first entity-relationship diagram and forming a third entity-relationship diagram in the one or more non-transitory computer-readable mediums by making a copy of the first entity-relationship diagram;
wherein performing the database split includes a step of modifying the second entity-relationship diagram to model the second database before the second database is data system instantiated and modifying the third entity-relationship diagram to model the third database before the third database is data system instantiated;
further comprising adding a plurality of common entity relationships to link the second entity-relationship diagram and the third entity-relationship diagram in the one or more non-transitory computer-readable mediums;
wherein performing the database split includes instantiating the second entity-relationship diagram into the second database and instantiating the third entity-relationship diagram into the third database;
wherein each common entity relationship is data system instantiated as a data system access path of the one or more data system access paths between the second database and the third database once data integrity has been established for each data system access path of the one or more data system access paths; and
wherein performing the database split includes populating the second database with data from the first database and populating the third database with data from the first database.