COHERENT DATA IDENTIFICATION METHOD AND APPARATUS FOR DATABASE TABLE DEVELOPMENT
First Claim
Patent Images
1. A method comprising the steps ofstoring a plurality of sets of metadata in a computer memory using a computer program running on a computer processor;
- andstoring a plurality of constituent data items in the computer memory using a computer program running on a computer processor, wherein each constituent data item of the plurality of constituent data items is comprised of one or more data items;
wherein each data item of the one or more data items of each of the plurality of constituent data items is a named data field which identifies a column in a database table in the computer memory;
wherein each of the plurality of sets of metadata corresponds to one of the plurality of constituent data items, such that there is one set of metadata for each of the plurality of constituent data items;
wherein each set of metadata includesa constituent data item name for a corresponding one of the plurality of constituent data items;
an indication of which one or more interrogatives a corresponding one of the plurality of constituent data items may be assigned to,at least one business key comprised of at least one business key data item,and an indication of any dependencies of a corresponding one of the plurality of constituent data items on any other constituent data items of the plurality of constituent data items.
0 Assignments
0 Petitions
Accused Products
Abstract
A method, apparatus, and system for configuring, designing, and/or implementing database tables is detailed that provides a framework into which a remainder of database tables are developed. Also detailed is a method to develop this framework of database tables. This so developed framework provides a platform for integrating data from multiple databases. A method is also provided for maintaining and managing master data as a single source of reference data to multiple databases that are based upon this framework.
-
Citations
25 Claims
-
1. A method comprising the steps of
storing a plurality of sets of metadata in a computer memory using a computer program running on a computer processor; - and
storing a plurality of constituent data items in the computer memory using a computer program running on a computer processor, wherein each constituent data item of the plurality of constituent data items is comprised of one or more data items; wherein each data item of the one or more data items of each of the plurality of constituent data items is a named data field which identifies a column in a database table in the computer memory; wherein each of the plurality of sets of metadata corresponds to one of the plurality of constituent data items, such that there is one set of metadata for each of the plurality of constituent data items; wherein each set of metadata includes a constituent data item name for a corresponding one of the plurality of constituent data items; an indication of which one or more interrogatives a corresponding one of the plurality of constituent data items may be assigned to, at least one business key comprised of at least one business key data item, and an indication of any dependencies of a corresponding one of the plurality of constituent data items on any other constituent data items of the plurality of constituent data items. - View Dependent Claims (2)
- and
-
3. A method comprising
setting up and storing a first entity-relationship diagram in a first data model in a computer memory prior to storing data values in a first database in the computer memory; -
using a computer processor to interpret the first entity-relationship diagram in the first data model in the computer memory in order to form the first database in the computer memory; and storing a first plurality of data records in a database table, each including a row of a plurality of data values, in the first database; wherein the first entity-relationship diagram includes; a first unified reference data entity classified in the computer memory by one and only one first interrogative; wherein the first unified reference data entity is an independent data entity in the first entity-relationship diagram; further comprising adding the first unified reference data entity to a second entity-relationship diagram as an independent data entity; wherein an independent data entity does not inherit any foreign key data attributes from any other data entity of the first data model, wherein a foreign key data attribute is a named data field which is used to identify a column of data values after the first database has been formed and wherein a foreign key data attribute is derived from a data entity; and wherein a data entity is a component of the first entity-relationship diagram which becomes a database table once the first database is instantiated from the first entity-relationship diagram. - View Dependent Claims (4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 15, 16, 17, 18, 19)
-
-
14. A method comprising
setting up and storing a first entity-relationship diagram in a first data model in a computer memory prior to storing data values in a first database in the computer memory; -
setting up and storing a second entity-relationship diagram in a second data model in the computer memory prior to storing data values in the first database in the computer memory; wherein the first entity-relationship diagram includes a set of independent data entities; wherein the second entity-relationship diagram includes the set of independent data entities; combining the first entity-relationship diagram and the second entity-relationship diagram to form a combined entity-relationship diagram in a combined data model in the computer memory; using a computer processor to interpret the combined entity-relationship diagram in the combined data model in the computer memory in order to form the first database in the computer memory; and storing a plurality of data records, each including a row of a plurality of data values, in the first database; wherein each independent data entity of the set of independent data entities is a data entity of a data model of a plurality of data models of the first database that is independent of all other data entities of the plurality of data models of the first database, such that each independent data entity does not inherit any foreign key data attributes from any other data entity of any of the plurality of data models of the first database, wherein a foreign key data attribute is a named data field which is used to identify a database table'"'"'s column of data values after the first database has been formed and which is derived from another data entity of the plurality of data models of the first database; wherein a data entity is database instantiated as a database table in the first database in computer memory.
-
-
20. A method comprising
storing a plurality of unified reference databases in one or more computer memories; -
populating a plurality of data records for each of the plurality of unified reference databases in the one or more computer memories from a common source unified database; wherein the common source unified database includes at least one of; a who common source unified database, which includes only data records related to the interrogative who, a what common source unified database, which includes only data records related to the interrogative what, a where common source unified database, which includes only data records related to the interrogative where; a when common source unified database, which includes only data records related to the interrogative when; a how common source unified database, which includes only data records related to the interrogative how; and a why common source unified database, which includes only data records related to the interrogative why. - View Dependent Claims (21)
-
-
22. A method comprising
storing a plurality of shared reference databases in a computer memory, wherein each of the plurality of shared reference databases has a first plurality of shared reference database tables, such that the first plurality of shared reference database tables is contained within each of the plurality of shared reference databases; -
wherein each of the first plurality of shared reference database tables has a business key index declared, so that there are a plurality of business key indices declared for the corresponding first plurality of shared reference database tables; wherein each business key index of the plurality of business key indices is declared by Standard Query Language (SQL)) computer software command, such that there are a plurality of business key indices declared; wherein each business key index of the plurality of business key indices is a named data field which will later identify a database table column of business key index data values in a database table in the computer memory; wherein each business key index of the plurality of business key indices is comprised of at least one data field; wherein each business key index is database instantiated from one or more business related data columns such that each of the business key index data values provide unique identification of a corresponding data record of a plurality of data records and the first business key index is database instantiated in each of the first plurality of shared reference database tables, further comprising populating the plurality of data records for each shared reference database of the plurality of shared reference databases in the computer memory from a first common source database; wherein each of the first plurality of shared reference database tables contains only a subset of all of the data records that are used in the plurality of shared reference databases; wherein each of the first plurality of shared reference database tables is a data structure that is populated from a first common source database; wherein each of the first business key index database table columns is independent of any other shared reference database table columns of the first plurality of shared reference database tables in that each of the first business key index database table column has all of its data records stored in the computer memory without referring to any other shared reference database table columns of the first plurality of shared reference database tables; and further comprising using the first common source database to store and manage the data quality of a plurality of data records of each of the plurality of shared reference databases. - View Dependent Claims (23, 24, 25)
-
Specification