DATA VALIDATION USING SIGNATURES AND SAMPLING

• US 20090132955A1
• Filed: 01/23/2009
• Published: 05/21/2009
• Est. Priority Date: 05/28/2003
• Status: Active Grant

• 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.
• Granted Patent: US 8,051,288 B2
• Time in Patent Office: Days
• US Class Current: 715/781
• 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 graphical user interface that facilitates management of a data mapping validation system, the interface comprising:

an input component for receiving management information, the management information associates with at least a process of generating data signatures or obtaining data samples of a raw data source and a raw data target; and

a presentation component for presenting a representation of the management information to facilitate user interaction therewith.

2. The interface of claim 1, 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.

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

4. The interface of claim 1, 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 interface of claim 1, further comprising a workspace area that presents validation status information, the workspace area allows user input to effect management of the data mapping validation system.

6. The interface of claim 1, further comprising an apparatus that produces the interface.

7. A system that facilitates management of a data mapping validation system, comprising:

means for receiving 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; and

means for receiving 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.

8. The system of claim 7, 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.

9. The system of claim 7, the management information includes a capability to connect to a remote site via a hyperlink.

10. The system of claim 7, 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.

11. The system of claim 7, further comprising means for presenting a workspace area that discloses validation status information.

12. The system of claim 11, the workspace area allows user input to impact management of the data mapping validation system.

13. The system of claim 11, further comprising means for presenting a representation of the management information to facilitate user interaction therewith.

14. A method that is at least partially implemented upon a processor that facilitates management of a data mapping validation system, comprising:

receiving management information, the management information associates with at least the processes of generating data signatures or obtaining data samples of a data source and a data target;

presenting a representation of the management information via an interface upon a physical display; and

disclosing a representation of a construct, the construct is a logical combination of a result from a comparison of raw source data against raw target data with a result from a comparison of a source signature against a target signature.

15. The method of claim 14, 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.

16. The method of claim 14, the management information includes a capability to connect to a remote site via a hyperlink.

17. The method of claim 14, 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.

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

19. The method of claim 18, the workspace area allows user input to effect management of the data mapping validation system.

20. The method of claim 14, 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.