Back to results
US 11,893,046 B2Granted
Method and apparatus for implementing a set of integrated data systems
OwnerRobert Mackinventor
Life of this patent
Estimating the term…
Abstract
A method, an apparatus, and a system for configuring, designing, and/or implementing integrated data modeling methods for configuring direct data system interoperability between multiple data systems based upon compliance with data integration standards. Integrated data modeling is an enhancement of traditional data modeling where newly defined common entity relationships are used to join multiple data models. When instantiated, integrated data models form integrated data systems where data integrity is enforced among multiple data systems.
Claims19
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.
10 more elements
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.
7 more elements
Dependencies are inferred from the claim text.