Intra-platform data migration
First Claim
Patent Images
1. A database (DB) platform system that includes first and second DBs having respective first and second records, the system comprising:
- a processor; and
a memory to store one or more sequences of instructions which, when executed by the processor, cause the processor to;
automatically associate a globally unique identifier (GUID) with each record of the first DB, the GUID of each record comprises a record identifying attribute combined with a data source identifier, the record identifying attribute uniquely identifies a record within the first DB or the second DB, and the data source identifier identifies a source of the record within the first DB or the second DB;
compare GUIDs of records in the first DB to GUIDs of records the second DB;
insert into the second DB first records from the first DB for which no second records in the second DB have corresponding GUIDs;
update in the second DB, in response to insertion of the first records into the second DB, second records for which first records in the first DB have corresponding GUIDs;
insert at least one second record of the second DB into the first DB when a GUID of the at least one second record does not exist in the first DB; and
update at least one first record in the first DB with data of the at least one second record of the second DB when the GUID of the at least one second record does exist in the first DB.
1 Assignment
0 Petitions
Accused Products
Abstract
A data migration system and method operate within a database platform system, which includes first and second databases, to provide data migration between databases. The data migration includes automatically generating a globally unique identifier for each record of the first database, such as upon creation of each record. Records in the second database are updated or inserted according to whether or not records in the second database have globally unique identifiers that correspond to globally unique identifiers of records in the first database.
-
Citations
20 Claims
-
1. A database (DB) platform system that includes first and second DBs having respective first and second records, the system comprising:
-
a processor; and a memory to store one or more sequences of instructions which, when executed by the processor, cause the processor to; automatically associate a globally unique identifier (GUID) with each record of the first DB, the GUID of each record comprises a record identifying attribute combined with a data source identifier, the record identifying attribute uniquely identifies a record within the first DB or the second DB, and the data source identifier identifies a source of the record within the first DB or the second DB; compare GUIDs of records in the first DB to GUIDs of records the second DB; insert into the second DB first records from the first DB for which no second records in the second DB have corresponding GUIDs; update in the second DB, in response to insertion of the first records into the second DB, second records for which first records in the first DB have corresponding GUIDs; insert at least one second record of the second DB into the first DB when a GUID of the at least one second record does not exist in the first DB; and update at least one first record in the first DB with data of the at least one second record of the second DB when the GUID of the at least one second record does exist in the first DB. - View Dependent Claims (2, 3, 4, 5, 6, 20)
-
-
7. A database (DB) platform method, the method comprising:
-
automatically associating, by a computing device, a globally unique identifier (GUID) with each record of a first DB of a DB platform, the GUID of each record comprises a record identifying attribute combined with a data source identifier, the record identifying attribute uniquely identifies a record within the first DB or the second DB, and the data source identifier identifies a source of the record within the first DB or the second DB; comparing, by the computing device, GUID of records in the first DB to GUIDs of records a second DB in the DB platform; inserting, by the computing device, into the second DB first records from the first DB for which no second records in the second DB have corresponding GUIDs; updating, by the computing device, in the second DB second records for which first records in the first DB have corresponding GUIDs; inserting, by the computing device, at least one second record of the second DB into the first DB when a GUID of the at least one second record does not exist in the first DB; and updating, by the computing device, at least one first record in the first DB with data of the at least one second record of the second DB when the GUID of the at least one second record does exist in the first DB. - View Dependent Claims (8, 9, 10, 11, 12, 19)
-
-
13. A database (DB) platform system that includes first and second DBs having respective first and second records, the system comprising:
-
a processor; and a memory to store one or more sequences of instructions of a dynamic record identifier and one or more sequences of instructions of an update and insert operator, wherein; the processor is to execute the one or more sequences of instructions of the dynamic record identifier to automatically generate a globally unique identifier (GUID) for each record of the first DB, the GUID of each record comprises a record identifying attribute combined with a data source identifier, the record identifying attribute uniquely identifies a record within the first DB or the second DB, and the data source identifier comprises identifies a source of the record within the first DB or the second DB; the processor is to execute the one or more sequences of instructions of the update and insert operator to; update or insert records in the second DB according to whether corresponding records in the first DB are present or not, respectively; insert at least one second record of the second DB into the first DB when a GUID of the at least one second record does not exist in the first DB; and update at least one first record in the first DB with data of the at least one second record of the second DB when the GUID of the at least one second record does exist in the first DB. - View Dependent Claims (14, 15, 16, 17, 18)
-
Specification