Method and system for dynamic data merge in databases
First Claim
Patent Images
1. A data repository defined by a single logical specification, comprising:
- a data store comprising a plurality of tables and a view of the plurality of tables;
a data dictionary comprising a meta-table and means to generate the data store, wherein the meta-table is generated from the single logical specification defining the data repository; and
a merge engine configured to merge incoming data with the data store based on match attributes defined by the single logical specification, wherein the incoming data is stored in at least one staging area.
1 Assignment
0 Petitions
Accused Products
Abstract
A data repository defined by a single logical specification includes a data store including a plurality of tables and a view of the plurality of tables, a data dictionary including a meta-table and means to generate the data store, where the meta-table is generated from the single logical specification defining the data repository, and a merge engine configured to merge incoming data with the data store based on match attributes defined by the single logical specification, where the incoming data is stored in at least one staging area.
-
Citations
17 Claims
-
1. A data repository defined by a single logical specification, comprising:
-
a data store comprising a plurality of tables and a view of the plurality of tables;
a data dictionary comprising a meta-table and means to generate the data store, wherein the meta-table is generated from the single logical specification defining the data repository; and
a merge engine configured to merge incoming data with the data store based on match attributes defined by the single logical specification, wherein the incoming data is stored in at least one staging area. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
-
10. A method to merge incoming data with data in a data store, comprising:
-
loading incoming data through at least one loader into at least one staging area in a server;
reporting and fixing problems with referential integrity in the incoming data;
matching incoming data through the use of match attributes in a match table, wherein the match attributes define a plurality of rules to match entities of incoming data in the staging area with entities of data in the data store;
updating links in the staging area in preparation for the merge; and
modifying entities of data in the data store based on the entities of incoming data in the staging area. - View Dependent Claims (11, 12, 13)
-
-
14. A computer readable medium containing software instructions stored thereon to perform:
-
loading incoming data through at least one loader into at least one staging area in a server;
reporting and fixing problems with referential integrity in the incoming data;
matching incoming data through the use of match attributes in a match table, wherein the match attributes define a plurality of rules to match entities of incoming data in the staging area with entities of data in the data store;
updating links in the staging area in preparation for the merge; and
modifying entities of data in the data store based on the entities of incoming data in the staging area. - View Dependent Claims (15, 16, 17)
-
Specification