Microsoft Technology Licensing, LLC

Vaibhav Kamra

Cristian Diaconu

Jun Fang

Pradeep Madhavarapu

Alexandru C Chirica

Priyank Porwal

Srinivasmurthy P Acharya

Rohan Kumar

Arkadi Brjazovski

Srini Acharya

Michael J Purtell

High availability and disaster recovery can be achieved within a database management system by detecting which parts of a file have changed and sending the changed parts to secondary servers, without sending the entire file that has experienced the changes. A log cracker reads data from a transaction log that stores records from a database and a separately maintained file system. The log cracker sends mirror commands with some of the transaction log data to the file system to initiate mirroring of the data from the file system to secondary servers. The log data is then subsequently sent to the secondary servers as well, to enable identification of changed data without having to transfer the entire file that has been changed.

Mirroring file data

A method for mirroring one or more data changes from a first database server to one or more second database servers. The method includes intercepting one or more operations that make one or more changes to one or more data on the first database server. After intercepting these operations, the method merges the operations into one or more chunks, adds one or more log records having the chunks into a database log. The database log includes one or more database log blocks. The method then writes the database log blocks.

Mirroring data changes in a database system

The present invention extends to methods, systems, and computer program products for mirroring file data. Generally, high availability and disaster recovery ('HADRON') is achieved within a database management system by detecting which parts of a file have changed and sending the changed parts to secondaries. Adjacent or partially overlapping parts of a file can coalesce to form larger chunks of changed data. Coalescing reduces the overall number of chunks that are tracked.

The claimed subject matter provides a system and/or a method that extends transactional guarantees to unstructured data in a file system. A database engine, configured to retain structured data, can reserve a portion of the file system to store unstructured data to be managed by the database engine. A kernel component can associate a transaction with at least one stream that corresponds to the reserved portion of the file system. The association enables transaction based access to the reserved portion of the file system managed by the database engine.

Growing community of inventors

Bellevue, WA, United States of America

Vaibhav Kamra