US5761665A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method of automatic database field identification for postal coding
Assignee: Pitney Bowes Inc
•
Filing: 1995-10-31
•
Granted: 1998-06-02
•
Expires: 2015-10-31
Abstract
Abstract The invention is a method of determining the contents of a selected data field. The steps begin by attaching, from an application program, a database to be mapped. Once the database is attached, a field identification module (FIM), will scan the contents of the database to determine a data field identifier for each of the data fields to be worked upon. The FIM will then compare each of the data field identifiers with a list of known identifiers stored in a repository and assess a first score in respect of the comparison wherein the score is representative of a probability that the comparison is an accurate comparison. When a first probability score has been determined, the FIM will sample the data field according to a pre-selected list of requirements and make a second comparison with the data field. The FIM will then assess a second score. After sampling and scoring the data field, the FIM will construct a test case wherein the data field is used in the postal coding or host application and a third comparison is made in respect of the test case. The FIM will then assess a third score. The FIM will choose a field type based on the weighted average result of the three scores, and then request that the system operator confirm the selected field type. Once confirmed, the data field identifier and the data field represented thereby are added to the repository as one of the known identifiers.
Inventors
- 👤 David P. Gardner
- 👤 Steven M. Kaye
- 👤 Jeffery D. Pierce
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-09 08:54
CPC Classifications
G; G06; G06Q; G06Q50/00; G06Q50/60; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/242; G06F16/2433; G06F16/2445; G06F16/2448; G06Q10/00; G06Q10/10; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99933; Y10S707/99935; Y10S707/99937; Y10S707/99941; Y10S707/99942
Claims Analysis
Total Claims: 18
Claim 1
Independent Claim
290 words
A method of determining the contents of a selected data field comprising the steps of: (a) attaching, from an application program in a data processing system, a database to be mapped; (b) activating, from said application program, a field identification module resident within said application program, wherein said field identification module will scan said contents of said data field to locate a data field identifier for each of said data fields to be worked upon; (c) comparing each of said data field identifiers with a list of known identifiers stored in a repository; (d) assessing a first score in respect of said comparison wherein said score is representative of a probability that said comparison is an accurate comparison; (e) sampling said data field according to a pre-selected list of requirements and making a second comparison wherein said data field is compared with said pre-selected list of requirements and wherein each one of said pre-selected list of requirements is weighted, and wherein the sum of said each one of said pre-selected list of requirements does not exceed a pre-determined threshold; (f) assessing a second score in respect of said sampling wherein said second score is representative of a probability that said second comparison is an accurate comparison; (g) constructing a test case wherein said data field is used in said application program and a third comparison between an actual result and an expected result is made in respect of said test case; (h) assessing a third score in respect of said test case wherein said third score is representative of a probability that said third comparison is an accurate comparison; (i) choosing a field type based on the cumulative result of said first score, said second score, and said third score.
Claim 2
Independent Claim
290 words
A method of determining the contents of a selected data field comprising the steps of: (a) attaching, from an application program in a data processing system, a database to be mapped; (b) activating, from said application program, a field identification module resident within said application program, wherein said field identification module will scan said contents of said data field to locate a data field identifier for each of said data fields to be worked upon; (c) comparing each of said data field identifiers with a list of known identifiers stored in a repository; (d) assessing a first score in respect of said comparison wherein said score is representative of a probability that said comparison is an accurate comparison; (e) sampling said data field according to a pre-selected list of requirements and making a second comparison wherein said data field is compared with said pre-selected list of requirements and wherein each one of said pre-selected list of requirements is weighted, and wherein the sum of said each one of said pre-selected list of requirements does not exceed a pre-determined threshold; (f) assessing a second score in respect of said sampling wherein said second score is representative of a probability that said second comparison is an accurate comparison; (g) constructing a test case wherein said data field is used in said application program and a third comparison between an actual result and an expected result is made in respect of said test case; (h) assessing a third score in respect of said test case wherein said third score is representative of a probability that said third comparison is an accurate comparison; (i) choosing a field type based on the cumulative result of said first score, said second score, and said third score.
Claim 3
Dependent Claim
20 words
The method of claim 1, wherein said field identification module is a standalone module not resident within said activation program.
Claim 4
Dependent Claim
13 words
The method of claim 1, wherein said determining steps comprise a mapping cycle.
Claim 5
Dependent Claim
53 words
The method of claim 3, wherein said first score, said second score, and said third score as they are individually assessed, are factored to produce a running score, wherein said running score is reflective of the most recent score assessed weighted averaged together with previous scores, if any, assessed during said mapping cycle.
Claim 6
Dependent Claim
73 words
The method of claim 1, wherein construction of said test case comprises the steps of: (a) selecting said sample from said data field; (b) building a test case subset from previously identified data wherein said test case subset comprises said sample; (c) submitting said test case subset to an application program wherein said test case subset is compared to data contained in said application program; and (d) determining the accuracy of said comparison.
Claim 7
Dependent Claim
13 words
The method of claim 1, wherein said repository is co-located with said database.
Claim 8
Dependent Claim
14 words
The method of claim 1, wherein said repository is located independently of said database.
Claim 9
Dependent Claim
28 words
The method of claim 1, wherein said data field identifier and said data field represented thereby are added to said repository as a one of said known identifiers.
Claim 10
Independent Claim
302 words
A method of automatically identifying a database field, in a postal coding system, comprising the steps of: (a) attaching, from a postal coding program in a data processing system, a database to be mapped; (b) activating, from said application program, a field identification module resident within said application program, wherein said field identification module will scan said contents of said data field to locate a data field identifier for each of said data fields to be worked upon; (c) comparing each of said data field identifiers with a list of known identifiers stored in a repository; (d) assessing a first score in respect of said comparison wherein said score is representative of a probability that said comparison is an accurate comparison; (e) sampling said data field according to a pre-selected list of address coding requirements and making a second comparison wherein said data field is compared with said pre-selected list of address coding requirements and wherein each one of said pre-selected list of address coding requirements is weighted, and wherein the sum of said each one of said pre-selected list of address coding requirements does not exceed a predetermined threshold: (f) assessing a second score in respect of said sampling wherein said second score is representative of a probability that said second comparison is an accurate comparison; (g) constructing a test case wherein said data field is used in said application program and a third comparison between an actual result and an expected result is made in respect of said test case; (h) assessing a third score in respect of said test case wherein said third score is representative of a probability that said third comparison is an accurate comparison; and (i) choosing a field type based on the cumulative result of said first score, said second score, and said third score.
Claim 11
Independent Claim
302 words
A method of automatically identifying a database field, in a postal coding system, comprising the steps of: (a) attaching, from a postal coding program in a data processing system, a database to be mapped; (b) activating, from said application program, a field identification module resident within said application program, wherein said field identification module will scan said contents of said data field to locate a data field identifier for each of said data fields to be worked upon; (c) comparing each of said data field identifiers with a list of known identifiers stored in a repository; (d) assessing a first score in respect of said comparison wherein said score is representative of a probability that said comparison is an accurate comparison; (e) sampling said data field according to a pre-selected list of address coding requirements and making a second comparison wherein said data field is compared with said pre-selected list of address coding requirements and wherein each one of said pre-selected list of address coding requirements is weighted, and wherein the sum of said each one of said pre-selected list of address coding requirements does not exceed a predetermined threshold: (f) assessing a second score in respect of said sampling wherein said second score is representative of a probability that said second comparison is an accurate comparison; (g) constructing a test case wherein said data field is used in said application program and a third comparison between an actual result and an expected result is made in respect of said test case; (h) assessing a third score in respect of said test case wherein said third score is representative of a probability that said third comparison is an accurate comparison; and (i) choosing a field type based on the cumulative result of said first score, said second score, and said third score.
Claim 12
Dependent Claim
20 words
The method of claim 9, wherein said field identification module is a standalone module not resident within said activation program.
Claim 13
Dependent Claim
13 words
The method of claim 9, wherein said determining steps comprise a mapping cycle.
Claim 14
Dependent Claim
53 words
The method of claim 11, wherein said first score, said second score, and said third score as they are individually assessed, are factored to produce a running score, wherein said running score is reflective of the most recent score assessed weighted averaged together with previous scores, if any, assessed during said mapping cycle.
Claim 15
Dependent Claim
71 words
The method of claim 9, wherein construction of said test case comprises the steps of: (a) selecting said sample from said data field; (b) building an address from previously identified address data wherein said address comprises said sample; (c) submitting said built address to a postal coding program wherein said built address is compared to address data contained in said postal coding program; and (d) determining the accuracy of said comparison.
Claim 16
Dependent Claim
13 words
The method of claim 9, wherein said repository is co-located with said database.
Claim 17
Dependent Claim
14 words
The method of claim 9, wherein said repository is located independently of said database.
Claim 18
Dependent Claim
28 words
The method of claim 9, wherein said data field identifier and said data field represented thereby are added to said repository as a one of said known identifiers.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-06-01 | 2001-12-01 | 2002-06-02 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-06-01 | 2005-12-01 | 2006-06-02 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-06-01 | 2009-12-01 | 2010-06-02 | $7700.00 | Window Closed / Lapsed |