Data seeding optimization for database replication
AssigneeMicrosoft Corporation
InventorsMichael E. Nelson, Tomas Talius, Robin D. Dhamankar
Life of this patent
Estimating the term…
Abstract
Streaming database replication is provided by merging a stream of user transactions with a stream of copy transactions comprising copy data into a combined stream on a source. A target receives a single stream that includes copy transaction and concurrent user transactions in an order that enables conflicts between data being copied and user transactions to be handled correctly. Furthermore, locks applied to data subject to a copy transaction or user transaction can be released once the copy transaction or user transaction is added to the combined stream.
Claims20
A computer-implemented method, comprising:
- merging on a source database server a first stream of one or more copy transactions comprising copy data from a database on the source database server and a second stream of one or more user transactions over the database concurrently with the copy transactions from the first stream producing a third stream.
A system, comprising:
- a processor coupled to a memory, the processor configured to execute the following computer-executable components stored in the memory:
- a first component configured combine on a source database server a first stream comprising one or more user transactions over a source database and a second stream comprising one or more copy transactions over the source database into a combined stream.
A computer-readable storage medium having instructions stored thereon that enable at least one processor to perform a method upon execution of the instructions, the method comprising:
- merging on a source database server a first stream of copy transactions comprising data copied from a source database of the server and a second stream of user transactions over the source database that occur concurrently with the copy transactions of the first stream to produce a combined stream;
- and
- initiating transmission of the combined stream to a target database server.
Dependencies are inferred from the claim text.