Method and apparatus for implementing a set of integrated data systems
First Claim
Patent Images
1. An apparatus comprising,one or more computer processors;
- andone or more non-transitory computer readable mediums having computer software stored therein for programming the one or more computer processors to;
configure a first master reference data standard entity-type in a first entity-relationship diagram in the one or more non-transitory computer readable mediums; and
declare a first unique key for the first master reference data standard entity-type in the first entity-relationship diagram in the one or more non-transitory computer readable mediums;
wherein the one or more non-transitory computer readable mediums also have stored therein computer software for programming the one or more computer processors to data system instantiate a first master reference data standard table in the one or more non-transitory computer readable mediums from the first master reference data standard entity-type;
wherein the one or more non-transitory computer readable mediums have stored therein computer software for programming the one or more computer processors to cause the first unique key of the first master reference data standard entity-type in the first entity-relationship diagram to be used as a basis of a first common entity relationship between the first master reference data standard entity-type in the first entity-relationship diagram and a copy of the first master reference data standard entity-type added to a second entity-relationship diagram;
wherein the second entity relationship diagram, prior to adding the copy of the first master reference data standard entity-type, is not related to the first entity relationship diagram; and
wherein the first common entity relationship is defined in the one or more non-transitory computer readable mediums and relates the first unique key of the first master reference standard data entity-type in the first entity-relationship diagram with the first unique key of the copy of the first master reference data standard entity-type in the second entity-relationship diagram;
wherein the one or more non-transitory computer readable mediums have stored therein a first data model that contains the first entity-relationship diagram;
wherein the first data model is a data modeling program that supports an association of a first plurality of unique data records stored in the one or more non-transitory computer readable mediums with the first master reference data standard entity-type;
wherein the one or more non-transitory computer readable mediums has instructions stored therein for causing the one or more computer processors to store one or more data records of the first plurality of unique data records in the first master reference data standard table;
wherein the one or more non-transitory computer readable mediums has stored therein a second data model that contains the second entity-relationship diagram;
wherein the instructions stored in one or more non-transitory computer readable mediums include a plurality of second data model program instructions for configuring the copy of the first master reference data standard entity-type and for declaring the first unique key for the copy of the first master reference data standard entity-type in the second entity-relationship diagram;
wherein the second entity relationship diagram after adding the copy of the first master reference data standard entity-type, is related to the first entity relationship diagram by the first common entity relationship;
wherein the one or more non-transitory computer readable mediums include a second unique key for the first master reference data standard entity-type in the first entity-relationship diagram;
wherein the one or more non-transitory computer readable mediums include a second unique key for the copy of the first master reference data standard entity-type in the second entity-relationship diagram;
wherein the one or more non-transitory computer readable mediums includes a second common entity relationship; and
wherein the second common entity relationship relates the second unique key of the first master reference data standard entity-type in the first entity-relationship diagram of the first data model to the second unique key of the copy of the first master reference data standard entity-type in the second entity-relationship diagram of the second data model.
0 Assignments
0 Petitions
Accused Products
Abstract
A method, an apparatus, and a system for configuring, designing, and/or implementing integrated data modeling methods for configuring interoperability between multiple data system based upon compliance with data integration standards.
-
Citations
32 Claims
-
1. An apparatus comprising,
one or more computer processors; - and
one or more non-transitory computer readable mediums having computer software stored therein for programming the one or more computer processors to; configure a first master reference data standard entity-type in a first entity-relationship diagram in the one or more non-transitory computer readable mediums; and declare a first unique key for the first master reference data standard entity-type in the first entity-relationship diagram in the one or more non-transitory computer readable mediums; wherein the one or more non-transitory computer readable mediums also have stored therein computer software for programming the one or more computer processors to data system instantiate a first master reference data standard table in the one or more non-transitory computer readable mediums from the first master reference data standard entity-type; wherein the one or more non-transitory computer readable mediums have stored therein computer software for programming the one or more computer processors to cause the first unique key of the first master reference data standard entity-type in the first entity-relationship diagram to be used as a basis of a first common entity relationship between the first master reference data standard entity-type in the first entity-relationship diagram and a copy of the first master reference data standard entity-type added to a second entity-relationship diagram; wherein the second entity relationship diagram, prior to adding the copy of the first master reference data standard entity-type, is not related to the first entity relationship diagram; and wherein the first common entity relationship is defined in the one or more non-transitory computer readable mediums and relates the first unique key of the first master reference standard data entity-type in the first entity-relationship diagram with the first unique key of the copy of the first master reference data standard entity-type in the second entity-relationship diagram; wherein the one or more non-transitory computer readable mediums have stored therein a first data model that contains the first entity-relationship diagram; wherein the first data model is a data modeling program that supports an association of a first plurality of unique data records stored in the one or more non-transitory computer readable mediums with the first master reference data standard entity-type; wherein the one or more non-transitory computer readable mediums has instructions stored therein for causing the one or more computer processors to store one or more data records of the first plurality of unique data records in the first master reference data standard table; wherein the one or more non-transitory computer readable mediums has stored therein a second data model that contains the second entity-relationship diagram; wherein the instructions stored in one or more non-transitory computer readable mediums include a plurality of second data model program instructions for configuring the copy of the first master reference data standard entity-type and for declaring the first unique key for the copy of the first master reference data standard entity-type in the second entity-relationship diagram; wherein the second entity relationship diagram after adding the copy of the first master reference data standard entity-type, is related to the first entity relationship diagram by the first common entity relationship; wherein the one or more non-transitory computer readable mediums include a second unique key for the first master reference data standard entity-type in the first entity-relationship diagram; wherein the one or more non-transitory computer readable mediums include a second unique key for the copy of the first master reference data standard entity-type in the second entity-relationship diagram; wherein the one or more non-transitory computer readable mediums includes a second common entity relationship; and wherein the second common entity relationship relates the second unique key of the first master reference data standard entity-type in the first entity-relationship diagram of the first data model to the second unique key of the copy of the first master reference data standard entity-type in the second entity-relationship diagram of the second data model. - View Dependent Claims (2, 3, 4)
- and
-
5. An apparatus comprising:
-
one or more computer processors; and one or more computer memories having stored therein a first plurality of databases; a first plurality of unique data records; wherein the one or more computer memories has instructions stored therein for programming the one or more computer processors to perform a method comprising; data system instantiating a first database table that includes a first unique index in a first database of the first plurality of databases; data system instantiating a first copy of the first database table that includes the first unique index in a second database of the first plurality of databases; populating the first database table in the first database with a first set of unique data records copied from the first plurality of unique data records; populating the first copy of the first database table in the second database with a second set of unique data records copied from the first plurality of unique data records to form a first modified copy of the first database table in the second database; wherein the first set of unique data records is at least partially different from the second set of unique data records; wherein the one or more computer memories includes a computer program which is executed by the one or more computer processors to enforce master reference data integrity rules between the first database table in the first database and the first modified copy of the first database table in the second database, wherein the master reference data integrity rules are stored in the one or more computer memories; and wherein the master reference data integrity rules include a first master reference data integrity rule that if a particular data record is changed in the first database table of the first database, a copy of the particular data record is also changed in the first modified copy of the first database table of the second database to keep the particular data record and the copy of the particular data record the same; wherein the one or more computer memories has instructions stored therein for programming the one or more computer processors to perform a method comprising; data system instantiating a second copy of the first database table that includes a first unique index in a third database of the first plurality of databases; and populating the second copy of the first database table in the third database with a third set of unique data records copied from the first plurality of unique data records to form a second modified copy of the first database table in the third database of the first plurality of databases, wherein the first plurality of unique data records is a first set of unique master reference data records; wherein the instructions stored in the one or more computer memories include instructions to enforce the enforce master reference data integrity rules within the first database table in the first database of the first plurality of databases, the first modified copy of the first database table of the second database of the first plurality of databases, and the second modified copy of the first database table of the third database of the first plurality of databases; and wherein the master reference data integrity rules include a second master reference data integrity rule that if a particular data record is changed in the second modified copy of the first database table of the third database, a copy of the particular data record is also changed in the first database table of the first database, and also changed in the first modified copy of the first database table of the second database to keep the particular data record and the copies of the particular data record the same. - View Dependent Claims (6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
15. An apparatus comprising
one or more computer processors; - and
one or more computer memories having instructions stored therein for programming the one or more computer processors to; data system instantiate a first database table in a first database in the one or more computer memories; data system instantiate a first unique index in the first database table in the first database in the one or more computer memories; data system instantiate the first unique index in a copy of the first database table instantiated in a second database in one or more computer memories; populate the first database table in the first database in the one or more computer memories with data records copied from a first plurality of unique data records stored in the one or more computer memories; populate the copy of the first database table in the second database in the one or more computer memories with data records copied from the first plurality of unique date records stored in the one or more computer memories to form a first modified copy of the first database table in the second database; and wherein the one or more computer processors are programmed to allow a particular data record in the first database table in the first database to be joined in the one or more computer memories with a copy of the particular data record in the first modified copy of the first database table in the second database, only if both the particular data record of the first database table in the first database and the copy of the particular data record in the first modified copy of the first database table in the second database are copies of the same unique data record of the first plurality of unique data records; and wherein the first database table in the first database and the first modified copy of the first database table in the second database have different subsets of data records of the first plurality of unique data records; wherein the first plurality of unique data records is a first set of unique master reference data records; wherein the instructions stored in the one or more computer memories include instructions to enforce master reference data integrity rules for the first plurality of unique data records; wherein the master reference data integrity rules include a first master reference data integrity rule that if a particular data record is changed in the first database table of the first database, a copy of the particular data record is also changed in the first modified copy of the first database table of the second database to keep the particular data record and the copies of the particular data record the same; wherein the instructions stored in the one or more computer memories include a first plurality of instructions defining a first database management system to manage the first database; wherein the instructions stored in the one or more computer memories include a second plurality of instructions defining a second database management system to manage the second database; wherein the master reference data integrity rules for the first plurality of unique data records for the first database table of the first database are enforced by the first database management system; and wherein the master reference data integrity rules for the first plurality of unique data records for the first modified copy of the first database table of the second database is enforced by the second database management system. - View Dependent Claims (16, 17, 18, 19, 20, 21, 22, 23)
- and
-
24. An apparatus comprising:
-
one or more computer processors; and one or more computer memories having stored therein a plurality of databases wherein each database of the plurality of databases is comprised of a plurality of database tables that are populated with data records; wherein the one or more computer processors are programmed to add a first database table with a first unique index to each database of the plurality of databases, such that a plurality of first database tables with a corresponding plurality of first unique indexes are added to the corresponding plurality of databases; wherein each first database table of the plurality of first database tables includes the same set of database columns, and each first unique index of the plurality of the first unique indexes is the same as every other first unique index of the plurality of first unique indexes; wherein the first database table of each of the plurality of databases is populated with data records copied from a first plurality of unique data records; wherein each first database table of the plurality of first database tables of the plurality of databases have different subsets of data records of the first plurality of unique data records; and wherein the one or more computer memories further has stored therein instructions for programming the one or more computer processors to join data records from each first database table of the plurality of first database tables of the plurality of databases using the first unique indexes of the first database tables of the plurality of databases defining a first data system access path; wherein the one or more computer memories includes a computer program which is executed by the one or more computer processors to enforce master reference data integrity rules between the plurality of first database tables of the plurality of databases, wherein the master reference data integrity rules are stored in the one or more computer memories; and wherein the master reference data integrity rules includes a first master reference data integrity rule that if a particular data record is changed in a first database table of the plurality of databases, all copies of the particular data record in each first database table of the plurality of first database tables of the plurality of databases where that particular data record is stored are also changed to keep the particular data record and the copies of the particular data record the same; wherein each of the plurality of databases is further comprised of a second database table with a second unique index wherein the second database table of each of the plurality of databases is populated with data records copied from a second plurality of data records; wherein the one or more computer memories further has stored therein instructions for programming the one or more computer processors to join data records from each second database table of the plurality of second database tables of the plurality of databases using the second unique indexes of the second database tables of the first plurality of databases defining a second data system access path; wherein the instructions stored in the one or more computer memories include instructions to enforce master reference data integrity rules within each second database table of the plurality of databases; and wherein the master reference data integrity rules includes a second master reference data integrity rule that if a particular data record is changed in a second database table of the plurality of databases, all copies of the particular data record in each second database table of the plurality of second database tables of the plurality of databases where that particular data record is stored, are also changed to keep the particular data record and the copies of the particular data record the same. - View Dependent Claims (25, 26, 27, 28, 29, 30, 31, 32)
-
Specification