Computer-implemented method of assessing the quality of a database mapping
A computer-implemented method is provided of assessing the quality of a database mapping. Fields of a source file are mapped to fields of a target database using a database mapping. A sampled subset of the records in the source file are converted to records in the target database using the field mappings, wherein the quality of the records in the source file is presumed to be high. A data validator is selected from a plurality of different data validators, wherein the selection is made based at least in part on the purpose of the target database. A sampled subset of the converted records are tested with the selected data validator to determine the quality of the database mapping.
1. A computer-implemented method of assessing the results of a database mapping, the method comprising:
(a) mapping fields of a source file to fields of a target database using a database mapping;
(b) converting data in a sampled subset of the records in the source file to records containing the sampled data in the target database using the field mappings;
(c) selecting a data validator from a plurality of different data validators to test the data in the mapped fields, wherein the selection is made based at least in part on the purpose of the target database; and
(d) testing the data in the sampled subset of the converted records with the selected data validator to determine the percentage of the records in the sampled subset that are validated using the selected data validator.
2. The method of claim 1 wherein the target database is a mailing database.
3. The method of claim 1 further comprising:
(e) performing transformative operations on data in at least some of the fields, and step (b) further comprises converting records containing data in the source file to records containing data in the target database using the field mappings and the transformative operations.
4. The method of claim 1 wherein the purpose of the target database is direct mail addressing.
5. The method of claim 1 wherein the purpose of the target database is courier addressing.
6. The method of claim 1 wherein the purpose of the target database is email addressing.
7. A computer-implemented method of assessing the results of a database mapping, the method comprising:
(a) providing a plurality of different database mappings that map fields of a source file to fields of a target database;
(b) converting data in a sampled subset of records in the source file to records containing the sampled data in the target database using the database mappings, wherein a sampled subset of records is converted for each of the plurality of different database mappings;
(c) testing the data in the sampled subset of records for each of the plurality of different database mappings with a data validator using the data in the mapped fields for the respective database mapping; and
(d) identifying the database mapping that provides the highest percentage of records in the sampled subset that are validated using the data validator.
8. The method of claim 7 further comprising:
(e) automatically selecting the plurality of different database mappings to be used in step (a) based on an analysis of the similarity of fields in the source file with fields in the target database.
9. The method of claim 7 wherein the target database is a mailing database.
10. The method of claim 7 further comprising:
(e) performing transformative operations on at least some of the fields, and step (b) further comprises converting records containing data in the source file to records containing data in the target database using the field mappings and the transformative operations.
11. The method of claim 7 further comprising:
(e) selecting the data validator from a plurality of different data validators, wherein the selection is made based at least in part on the purpose of the target database.
12. A computer-implemented method of assessing the results of a database mapping and performing a database mapping, the method comprising:
(a) providing a plurality of different database mappings that map fields of a source file to fields of a target database;
(b) converting data in a sampled subset of records in the source file to records containing the sampled data in the target database using the database mappings, wherein a sampled subset of records is converted for each of the plurality of different database mappings;
(c) testing data in the sampled subset of records for each of the plurality of different database mappings with a data validator using the mapped fields for the respective database mapping;
(d) identifying the database mapping that provides the highest percentage of records containing data in the sampled subset that are validated using the data validator; and
(e) mapping the fields of the source file to fields of the target database for all records in the source file using the database mapping that was identified as providing the highest percentage of records in the sampled subset that are validated using the data validator.
13. The method of claim 12 further comprising:
(f) automatically selecting the plurality of different database mappings to be used in step (a) based on an analysis of the similarity of fields in the source file with fields in the target database.
14. The method of claim 12 wherein the target database is a mailing database.
15. The method of claim 12 further comprising:
(f) performing transformative operations on at least some of the fields, and step (b) further comprises converting records in the source file to records in the target database using the field mappings and the transformative operations.
16. The method of claim 12 further comprising:
(f) selecting the data validator from a plurality of different data validators, wherein the selection is made based at least in part on the purpose of the target database.