Checksum
A fixed-length digest computed over data content, such as MD5 or SHA-256. Any minor change to the content produces a markedly different checksum, so it is commonly used for data integrity verification and change detection.
Timeline (last 90 days)
In the synchronization scenario, checksum comparison involves only a small amount of metadata, is extremely low-cost, and is naturally idempotent: repeated execution produces no side effects.
A checksum is an aggregate fingerprint computed over an ordered numeric column in the result set in a fixed order; it is more sensitive than row counts but only covers the columns included in the computation.
The recommended backup strategy is two ordinary hard drives stored in two different locations, verified with checksums every six months.
All Facts (3)
In the synchronization scenario, checksum comparison involves only a small amount of metadata, is extremely low-cost, and is naturally idempotent: repeated execution produces no side effects.
50%UnverifiedA checksum is an aggregate fingerprint computed over an ordered numeric column in the result set in a fixed order; it is more sensitive than row counts but only covers the columns included in the computation.
50%UnverifiedThe recommended backup strategy is two ordinary hard drives stored in two different locations, verified with checksums every six months.
50%