Method and apparatus for implementing a set of integrated data systems

• US 10,417,263 B2
• Filed: 09/25/2014
• Issued: 09/17/2019
• Est. Priority Date: 06/03/2011
• Status: Active Grant

• Current Assignee: Robert Mack
• Original Assignee: Robert Mack
• Inventors: Mack, Robert
• Primary Examiner(s): Channavajjala, Srirama
• Application Number:
  US14/496,342
• Publication Number:
  US 20150019484A1
• Time in Patent Office: 1,818 Days
• CPC Class Codes: G06F 16/212 with details for data modelling support
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/2228 Indexing structures
• CPC Class Codes: G06F 16/2365 Ensuring data consistency and integrity
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/288 Entity relationship models
• CPC Class Codes: G06F 16/38 Retrieval characterised by using metadata, e.g. metadata not derived from the content or metadata generated manually

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.

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.

2. The apparatus of claim 1

wherein the first data model contains 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.

3. The apparatus of claim 2

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 first data model.

4. The apparatus of claim 1

wherein the first plurality of unique data records is a set of unique master reference data records;

wherein the first plurality of unique data records are configured to be compatible with the first master reference data standard entity-type; and

wherein the instructions stored in the one or more non-transitory computer readable mediums include instructions to enforce master reference data integrity for the first plurality of unique data records by making sure that if a particular data record is changed in the first master reference standard database table of the first database, a copy of the particular data record in any copy of the first master reference standard database table of a second database is also changed to keep the particular data record and the copy of the particular data record the same.

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.

6. The apparatus of claim 5

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 first modified copy of the first database table of the second database, a copy of the particular data record is also changed in the first database table of the first database to keep the particular data record and the copy of the particular data record the same.

7. The apparatus of claim 5

wherein each of the first 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 first plurality of databases is populated with data records copied from a second plurality of data records.

8. The apparatus of claim 7

wherein each of the first plurality of databases is further comprised of a third unique index instantiated into the second database table.

9. The apparatus of claim 7

wherein the second plurality of unique data records is a second set of unique master reference data records;

and

wherein the instructions stored in the one or more memories include instructions to the enforce master reference data integrity rules within the second database tables in each database of the first plurality of databases.

10. The apparatus of claim 5

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 of the first plurality of databases;

and

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 of the first plurality of databases.

11. The apparatus of claim 5

wherein the first unique index of the first database table in the first database of the first plurality of databases and the first unique index of the first copy of the first database table of the second database of the first plurality of databases are structurally exact copies.

12. The apparatus of claim 5

wherein the first unique index of the first database table in the first database of the first plurality of databases and the first unique index of the first copy of the first database table of the second database of the first plurality of databases and the first unique index of the second copy of the first database table in the third database of the first plurality of databases are structurally exact copies.

13. The apparatus of claim 5

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 of the first plurality of databases and the second database of the first plurality of databases;

and

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 third database of the first plurality of databases.

14. The apparatus of claim 13

wherein the instructions stored in the one or more computer memories include instructions to 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;

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;

wherein the second master reference data integrity rule is enforced by the first database management system for the first database of the first plurality of databases;

wherein the second master reference data integrity rule is enforced by the first database management system for the second database of the first plurality of databases; and

wherein the second master reference data integrity rule is enforced by the second database management system for the third database of the first plurality of databases.

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.

16. The apparatus of claim 15

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;

and

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.

17. The apparatus of claim 15

wherein the one or more computer memories includes a second unique index for the first database table in the first database;

wherein the one or more computer memories includes a second unique index for the 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 using the second unique index 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.

18. The apparatus of claim 15

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 and the second database.

19. The apparatus of claim 15

wherein the instructions stored in the one or more computer memories include instructions to:

data system instantiate a second database table in the first database in the one or more computer memories;

data system instantiate a second unique index for the second database table in the one or more computer memories;

data system instantiate a first copy of the second database table in the second database in the one or more computer memories;

data system instantiate a copy of the second unique index in the first copy of the second database table in the one or more computer memories;

populating the second database table in the first database with data records copied from a second plurality of unique data records in the one or more computer memories;

populating the first copy of the second database table in the second database with data records copied from the second plurality of unique data records in the one or more computer memories to form a first modified copy of the second database table in the second database; and

wherein the one or more computer memories has stored therein the second plurality of unique data records defining a second source of unique common data records for the second master reference data standard.

20. The apparatus of claim 19

wherein the one or more computer processors are programmed to allow a particular data record in the second 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 second database table in the second database, only if both the particular data record of the second database table in the first database and the copy of the particular data record in the first modified copy of the second database table in the second database are copies of the same unique data record of the second plurality of unique data records;

and

wherein the second database table in the first database and the first modified copy of the second database table in the second database have different subsets of data records of the second plurality of unique data records.

21. The apparatus of claim 19

wherein the second plurality of unique data records is a second 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 for the second plurality of unique data records.

22. The apparatus of claim 19

data system instantiate a third unique index in the second database table of the first database in the one or more computer memories;

data system instantiate a copy of the third unique index in the first modified copy of the second database table in the second database in the one or more computer memories;

wherein the one or more computer processors are programmed to allow a particular data record in the second database table in the first database to be joined using the third unique index in the one or more computer memories with a copy of the particular data record in the first modified copy of the second database table in the second database, only if both the particular data record of the second database table in the first database and the copy of the particular data record in the first modified copy of the second database table in the second database are copies of the same unique data record of the second plurality of unique data records; and

wherein the second database table in the first database and the first modified copy of the second database table in the second database have different subsets of data records of the second plurality of unique data records.

23. The apparatus of claim 22

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;

and

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.

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.

25. The apparatus of claim 24

wherein there are at least three databases in the plurality of databases.

26. The apparatus of claim 25

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 a first database of the plurality of databases, a second database of the plurality of databases, and a third database of the plurality of databases.

27. The apparatus of claim 24

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 a first database of the plurality of databases;

and

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 a second database of the plurality of databases.

28. The apparatus of claim 24

wherein each of the first plurality of databases includes the second database table with a third unique index;

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 third unique indexes of the second database tables of the first plurality of databases defining a third data system access path.

29. The apparatus of claim 28

wherein the instructions stored in the one or more computer memories include instruction to combine data records retrieved from two or more databases of the plurality of databases using the first data system access path and the third data system access path.

30. The apparatus of claim 24

wherein the instructions stored in the one or more computer memories include a first plurality of instructions defining a first database management system to retrieve a first plurality of data records from a first database of the plurality of databases;

and

wherein the instructions stored in the one or more computer memories include a second plurality of instructions defining a second database management system to retrieve a second plurality of data records from a second database of the plurality of databases.

31. The apparatus of claim 30

wherein the first plurality of data records retrieved from the first database of the plurality of databases and the second plurality of data records retrieved from the second database of the plurality of databases are combined using the first data system access path.

32. The apparatus of claim 30

wherein the first plurality of data records retrieved from the first database of the plurality of databases and the second plurality of data records retrieved from the second database of the plurality of databases are combined using the second data system access path.