Unlock instant, AI-driven research and patent intelligence for your innovation.

Mirroring data changes in a database system

A database and data technology, applied in the direction of database distribution/replication, electronic digital data processing, structured data retrieval, etc., can solve the problem of low efficiency of updating data changes

Active Publication Date: 2015-02-04
MICROSOFT TECH LICENSING LLC
View PDF3 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method for updating changes to data in a file on a secondary server is an inefficient way to update changes to data

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Mirroring data changes in a database system
  • Mirroring data changes in a database system
  • Mirroring data changes in a database system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0014] In general, one or more implementations described herein involve mirroring data changes in a database system. Data and metadata stored on the primary database system can be used for high availability and disaster recovery (HADRON) purposes by mirroring data changes and metadata changes in the primary database system to the secondary database system. will refer to Figure 1-5 Describes in more detail various techniques for mirroring data changes in a database system.

[0015] Implementations of the various techniques described herein are operational with numerous general purpose or special purpose computing system environments or configurations. Examples of well-known computing systems, environments and / or configurations suitable for the various technologies described herein include, but are not limited to, personal computers, server computers, handheld or laptop devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electro...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

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.

Description

technical field [0001] The invention relates to mirroring data changes in a database system. Background technique [0002] Currently, database systems are equipped with high availability and disaster recovery (HADRON) features such that data and metadata stored on a primary database server remains accessible even if the primary database server becomes temporarily or permanently unavailable. In these database systems, the master database server typically contains the original versions of the data and metadata that are accessed and modified by users. The secondary database server is then used to mirror all activity that occurs on the data and metadata stored on the primary database server, such that a copy of the changed data and metadata is stored on the secondary database server. As a result, in the event the primary database server becomes temporarily unavailable, a secondary database server comprising data and metadata closely similar to the primary database server will b...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/30
CPCG06F17/30575G06F16/27G06F16/275G06F16/273
Inventor V·卡姆拉P·马德哈瓦拉普C·迪亚科努P·波尔沃尔J·方S·阿查里雅A·基里卡
Owner MICROSOFT TECH LICENSING LLC