Data validation using signatures and sampling

• US 8,051,288 B2
• Filed: 01/23/2009
• Issued: 11/01/2011
• Est. Priority Date: 05/28/2003
• Status: Expired due to Fees

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Rajasekaran, Kulothungan, Garg, Neeraj, Carter, Cale D., Martin, Deuane J., Singh, Pankaj K.
• Primary Examiner(s): Truong; Thanhnga B
• Application Number:
  US12/358,695
• Publication Number:
  US 20090132955A1
• Time in Patent Office: 1,012 Days
• Field of Search: 709/227, 709/246, 705 58- 59, 713/155, 713/170, 713175-177, 713/180, 382/123, 382/207
• US Class Current: 713/170
• CPC Class Codes: H04L 2209/30 Compression, e.g. Merkle-Damgard construction
• CPC Class Codes: H04L 2209/56 Financial cryptography, e.g. electronic payment or e-cash
• CPC Class Codes: H04L 2209/80 Wireless
• CPC Class Codes: H04L 9/3247 involving digital signatures

Abstract

Architecture that facilitates validation of a data mapping of data from a data source to a data target. There is included a signature generation component that generates a source signature of all or a portion of the data source and a target signature of all or a corresponding portion of the data target, and a sampling component that obtains a sample of the source data a corresponding sample of the target data. The data signatures and data samples are compared respectively and processed with a processing component to determine the status of the validation process.

Claims

1. A computer system for facilitating management of a data mapping validation system, the computer system comprising:

a processor coupled to a computer storage medium;

the computer storage medium that stores thereon a plurality of computer software components executable by the processor;

a signature generation component that receives management information associated with generating at least one data signature of a data source and generating at least one data signature of a data target;

a sampling component that receives management information associated with obtaining at least one data sample of the data source and obtaining at least one data sample of the data target; and

a processing component that obtains a signature compare output from the signature generation component and a sample compare output from the sampling component, converts the signature compare output and the sample compare output into a common format, and compares the signature compare output and the sample compare output to determine equivalency between the signature compare output and the sample compare output.

2. The computer system of claim 1, wherein the management information includes a menu for facilitating selection of at least one of the data source, the data target, data type, or an optimization algorithm.

3. The computer system of claim 1, wherein the management information includes a capability to connect to a remote site via a hyperlink.

4. The computer system of claim 1, wherein the management information includes a capability for a user to select at least one of a compression level, sampling level, scheduling feature, or trigger event.

5. The computer system of claim 1, further comprising a graphical user interface that presents a workspace area that discloses validation status information.

6. The computer system of claim 5, wherein the workspace area allows user input to impact management of the data mapping validation system.

7. The computer system of claim 5, wherein the graphical user interface presents a representation of the management information to facilitate user interaction therewith.

8. A method for facilitating management of a data mapping validation system, the method comprising:

storing computer-executable instructions on one or more computer-readable media;

executing the computer-executable instructions by one or more computing devices, causing the one or more computing devices to;

(1) present a representation of management information via an interface upon a physical display, the management information including the processes of generating data signatures and obtaining data samples of a data source and a data target;

(2) generate a signature of the source data and a signature of the target data;

(3) compare the signature of the source data and the signature of the target data, wherein the comparison of the signature of the source data and the target data results in a signature compare output;

(4) retrieve a sample of the source data and a sample of the target data;

(5) compare the sample of the source data and the sample of the target data, wherein the comparison of the sample of the source data and the sample of the target data results in a sample compare output; and

(6) process the signature compare output and the sample compare output, wherein processing includes converting the signature compare output and the sample compare output to a common format and determining the equivalency between the signature compare output and the sample compare output.

9. The method of claim 8, wherein the management information includes a menu for facilitating the selection of at least one of the data source, the data target, data type, or an optimization algorithm.

10. The method of claim 8, wherein the management information includes a capability to connect to a remote site via a hyperlink.

11. The method of claim 8, wherein the management information includes a capability for a user to select at least one of a compression level, sampling level, scheduling feature, or trigger event.

12. The method of claim 8, further comprising presenting a workspace area that presents validation status information.

13. The method of claim 12, wherein the workspace area allows user input to effect management of the data mapping validation system.

14. The method of claim 8, wherein the management information includes a menu for facilitating the selection of at least one of the data source, the data target, data type, an optimization algorithm, a capability to connect to a remote site via a hyperlink, and a capability for a user to select at least one of a compression level, sampling level, scheduling feature, or trigger event.