Ask the Expert

What is write order fidelity?

What is write order fidelity? Please elaborate.

Requires Free Membership to View

This is a Q&A from SAN School Lesson 6.
Click here for more SAN School lessons.

Write order fidelity is a term that describes the ability of d data replication hardware or software to move data between geographic locations while keeping consistency for transaction oriented applications. In other words, it's the ability to keep data "in the same sequence" as it was written at the originating source.

This is extremely important for database consistency. If data is written in an incorrect sequence at different sites, the transaction logs will no longer be consistent and databases can become corrupt at the remote site. The operations are kept in proper sequence by assigning either a timestamp or sequence number to each write at the source site. The data is then transmitted to the remote site over multiple links for load balancing or asynchronously for longer distances, then reordered to the proper time sequence before written to the logs at the remote site.

This was first published in April 2004

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: