Installation and method for updating an address database with recorded address records

• US 7,219,095 B1
• Filed: 07/05/2000
• Issued: 05/15/2007
• Est. Priority Date: 07/05/1999
• Status: Expired due to Term

• Current Assignee: PTT Post Holdings BV
• Original Assignee: PTT Post Holdings BV
• Inventors: Van Westbroek, Erik Wilhelmus Gilles, Brandt, Dick, Nauta, Frank Auke, Bezuijen, Peter Christoffel, Van Der Veer, Marco Gerardus, Frings, Helanus Elisabeth Rudolph, Bruijs, Petrus Adrianua
• Primary Examiner(s): Wong; Leslie
• Application Number:
  US10/019,941
• Time in Patent Office: 2,505 Days
• Field of Search: 707/6, 707/7, 707/10, 707/102, 707/104.1, 382/102, 382/209, 382/229, 700/226
• US Class Current: 707/688
• CPC Class Codes: B07C 3/14 using light-responsive detecting means for information carriers G06K7/14
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: Y10S 707/99937 Sorting
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

Installation and method for updating an address database in a database memory (44) containing recorded address records, making use of the following steps: receiving and processing address data as shown on items of post; storing the address data; the determination of a quality rating for the address data on the basis of predefined criteria; comparison of the address data with the address records stored in the database memory (44); and updating the content of the database memory (44) on the basis of the quality rating and the comparison of the address data with the stored address records.

Claims

1. Installation for updating an address database with recorded address records, comprising:

at least one processor (14, 15, 42) for receiving and processing address data as shown on items of post;

a memory (22), connected to the at least one processor (14, 15, 42), for storing the address data; and

a database memory (44), connected to the at least one processor (14, 15, 42), containing the address database stored therein, wherein,

the at least one processor (14, 15, 42) is equipped

i) to determine a quality rating for the address data as scanned from an item of post on the basis of predefined criteria, the quality rating indicating how good the address data are,

ii) to derive a name for an addressee from the name lines, to derive an address for the addressee from the address data, to read registered names of persons residing at that address from the address database and to compare these with the name of the addressee and, on the basis of that comparison, to determine a comparison score per registered name, the comparison score having a higher value the greater the degree of correspondence between the name of the addressee and a respective registered name, the comparison score being derived apart from the quality rating,

iii) to update statistical data relating to said address records stored in said database memory (44), and

iv) to update the content of the database memory (44) on the basis of a rule-based system taking into account the quality rating, the comparison score, and said statistical data.

2. Installation according to claim 1, wherein said statistical data includes at least one of the group comprising:

frequency with which an address record occurs per sorting centre;

dates on which an address record occurred on an item of post;

interval between two successive times that an address record was used on an item of post;

average of length of time between two successive times that an address record was used on an item of post; and

sender'"'"'s address data in relation to the address records.

3. Installation according to claim 1, wherein the at least one processor is equipped to determine a reliability rating for recognition of the address data and partly to base the quality rating on the reliability rating for recognition.

4. Installation according to claim 1, wherein the at least one processor is equipped to select name lines from the address data, to split the name lines into individual elements in accordance with predefined rules and partly to base the quality rating on the selection of name lines and the splitting thereof.

5. Installation according to claim 4, further comprising:

stored common names, and

wherein the at least one processor is equipped to compare the individual elements of the name lines with the common names, to establish a commonness rating on the basis thereof and partly to base the quality rating on the commonness rating.

6. Installation according to claim 1, wherein the at least one processor is equipped to determine that the address data are new if the comparison scores are relatively low and the quality rating is relatively high.

7. Installation according to claim 6, wherein the at least one processor is equipped to generate an additional address record, containing the address data, in the address database if the address data are new.

8. Installation according to claim 7, wherein the at least one processor is equipped to record one of the following four statuses per address record:

status new, if the address record is generated;

status common, if the associated address data are received from different senders;

status reliable, if the associated address data are regularly read afresh; and

status old, if the address record lapses.

9. Installation according to claim 1, wherein the at least one processor is equipped to determine that the address data are known if the comparison scores are relatively high and the quality rating is relatively high.

10. Installation according to claim 1, wherein the at least one processor is equipped to determine that the address data are unknown if the comparison scores are relatively low and the quality rating is relatively low.

11. Installation according to claim 1, wherein the address database is stored with security, such that either the data stored in the central database can be processed only via predefined rules or some of the data stored in the central database can be accessed via a secure output routine.

12. Installation according to claim 1, further comprising post sorting units (26, 28) for automatic sorting of the items of post (1) making use of the address database.

13. The computer storage medium according to claim 1, wherein said statistical data includes at least one of the group comprising:

frequency with which an address record occurs per sorting centre;

dates on which an address record occurred on an item of post;

interval between two successive times that an address record was used on an item of post;

average of length of time between two successive times that an address record was used on an item of post; and

sender'"'"'s address data in relation to the address records.

14. Method for updating an address database in a database memory (44) containing recorded address records, comprising the steps of:

determining a quality rating for the address data as scanned from an item of post on the basis of predefined criteria, the quality rating indicating how good the address data are;

deriving a name for an addressee from the name lines, derive an address for the addressee from the address data, reading registered names of persons residing at that address from the address database and comparing these with the name of the addressee and, on the basis of that comparison, determining a comparison score per registered name, a comparison score having a higher value the greater the degree of correspondence between the name of the addressee and a respective registered name, the comparison score being derived apart from the quality rating;

updating statistical data relating to said address records stored in said database memory (44); and

updating the content of the database memory (44) on the basis of a rule-based system taking into account the quality rating, the comparison score, and said statistical data.

15. Method according to claim 14, wherein said statistical data includes at least one of the group comprising:

frequency with which an address record occurs per sorting centre;

dates on which an address record occurred on an item of post;

interval between two successive times that an address record was used on an item of post; and

average of length of time between two successive times that an address record was used on an item of post;

sender'"'"'s address data in relation to the address records.

16. Method according to claim 14, comprising the further step of determining a reliability rating for recognition of the address data and partly basing the quality rating on the reliability rating for recognition.

17. Method according to claim 14, comprising the further steps of:

selecting name lines from the address data;

splitting the name lines into individual elements in accordance with predefined rules; and

partly basing the quality rating on the selection of name lines and the splitting thereof.

18. Method according to claim 17, comprising the further steps of:

comparing the individual elements of the name lines with common names; and

establishing a commonness rating on the basis thereof; and

partly basing the quality rating on the commonness rating.

19. Method according to claim 14, comprising the further step of determining the address data are new if the comparison scores are relatively low and the quality rating is relatively high.

20. Method according to claim 19, comprising the further step of generating an additional address record, containing the address data, in the address database if the address data are new.

21. Method according to claim 20, comprising the step of recording one of the following four statuses per address record:

status new, if the address record is generated;

status common, if the associated address data are received from different senders;

status reliable, if the associated address data are regularly read afresh; and

status old, if the address record lapses.

22. Method according to claim 14, comprising the further step of determining that the address data are known if the comparison scores are relatively high and the quality rating is relatively high.

23. Method according to claim 14, comprising the further step of determining that the address data are unknown if the comparison scores are relatively low and the quality rating is relatively low.

24. Method according to claim 14, wherein the address database is stored with security such that either the data stored in the central database can be processed only via predefined rules or some of the data stored in the central database can be accessed via a secure output routine.

25. Method according to claim 14, comprising the further step of sorting items of post (1) making use of the address database.

26. A computer-readable storage medium encoded with a computer program of instructions executable executed by a computer to control the computer to execute a method of updating an address database in a database memory (44) containing recorded address records, the method making use of the following steps:

determining a quality rating for the address data as scanned from an item of post on the basis of predefined criteria, the quality rating indicating how good the address data are;

deriving a name for an addressee from the name lines, derive an address for the addressee from the address data, reading registered names of persons residing at that address from the address database and comparing these with the name of the addressee and, on the basis of that comparison, determining a comparison score per registered name, a comparison score having a higher value the greater the degree of correspondence between the name of the addressee and a respective registered name, the comparison score being derived apart from the quality rating;

updating statistical data relating to said address records stored in said database memory (44); and

updating the content of the database memory (44) on the basis of a rule-based system taking into account the quality rating, the comparison score, and said statistical data.

27. The computer-readable storage medium according to claim 26, wherein said statistical data includes at least one of the group comprising:

frequency with which an address record occurs per sorting centre;

dates on which an address record occurred on an item of post;

interval between two successive times that an address record was used on an item of post;

average of length of time between two successive times that an address record was used on an item of post; and

sender'"'"'s address data in relation to the address records.

28. A computer storage medium storing a program product for a computer to perform, and executed by a processor of the computer, a method of updating an address database in a database memory (44) containing recorded address records, the method making use of the following steps:

determining a quality rating for the address data as scanned from an item of post on the basis of predefined criteria, the quality rating indicating how good the address data are;

deriving a name for an addressee from the name lines, derive an address for the addressee from the address data, reading registered names of persons residing at that address from the address database and comparing these with the name of the addressee and, on the basis of that comparison, determining a comparison score per registered name, a comparison score having a higher value the greater the degree of correspondence between the name of the addressee and a respective registered name, the comparison score being derived apart from the quality rating;

updating statistical data relating to said address records stored in said database memory (44); and

updating the content of the database memory (44) on the basis of a rule-based system taking into account the quality rating, the comparison score, and said statistical data.