Mirroring data changes in a database system
First Claim
Patent Images
1. A method for mirroring one or more data changes from a first database server to one or more second database servers, comprising:
- by the first database server, intercepting two or more operations that each make a change to data of a particular file stored on the first database server, wherein one of the operations is a filesystem command intercepted from a file system stack and one of the operations is a database command intercepted from a database stack;
by the first database server, detecting an offset location and length of each data change;
by the first database server, analyzing the offset location and length of each data change to the particular file to merge the data changes of the filesystem command operation and the database command operation into a single data change having a merged offset location and merged length, the single data change comprising a chunk;
by the first database server, adding the chunk into a database log, the database log having one or more database log blocks;
storing metadata associated with the particular file in a database;
adding information related to a change to the metadata to a database log block of the database log; and
writing the database log blocks by the first database server.
2 Assignments
0 Petitions
Accused Products
Abstract
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.
-
Citations
16 Claims
-
1. A method for mirroring one or more data changes from a first database server to one or more second database servers, comprising:
-
by the first database server, intercepting two or more operations that each make a change to data of a particular file stored on the first database server, wherein one of the operations is a filesystem command intercepted from a file system stack and one of the operations is a database command intercepted from a database stack; by the first database server, detecting an offset location and length of each data change; by the first database server, analyzing the offset location and length of each data change to the particular file to merge the data changes of the filesystem command operation and the database command operation into a single data change having a merged offset location and merged length, the single data change comprising a chunk; by the first database server, adding the chunk into a database log, the database log having one or more database log blocks; storing metadata associated with the particular file in a database; adding information related to a change to the metadata to a database log block of the database log; and writing the database log blocks by the first database server. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14)
-
-
15. A database management system, comprising:
-
a filesystem filter driver configured to intercept one or more filesystem operations that make one or more changes to one or more data on a first database server, wherein the filesystem operations comprise file system commands intercepted from a file system stack; a filestream manager configured to intercept one or more database operations that make one or more changes to the data, wherein the database operations comprise database commands intercepted from a database stack; a chunker of the first database server configured to; merge the filesystem operations and the database operations into a single data change comprising a chunk; add one or more log records having the chunk into a database log; and write one or more database log blocks of the database log, wherein the chunker is configured to; analyze the information to determine an offset location and a length for each change made by each filesystem operation and each database operation; and merge two or more offset locations and two or more lengths into a single data change having a merged offset location and merged length, wherein the two or more offset locations and the two or more lengths are adjacent to or overlapping with each other; a log reader configured to; read the database log blocks; determine whether one of the database log blocks in the database log includes one of the log records having the chunk; and if the one of the database log blocks includes the one of the log records, then send data that corresponds to the one of the log records to one or more second database management systems. - View Dependent Claims (16)
-
Specification