Registration and maintenance of address data for each service point in a territory
First Claim
1. A computer-implemented method of mining address data to locate a preferred address for each of a plurality of parcels, comprising:
- maintaining a package-level detail database of active shipment records, each active shipment record comprising an active tracking number, an active ship-to address, and an active delivery pattern code;
maintaining an electronic archive of delivery records, each delivery record comprising a past tracking number, a past ship-to address, a past delivery pattern code, and a stop identifier;
receiving address indicia data associated with a current parcel;
assigning a mining key to said current parcel, said mining key comprising a parcel tracking number and a current delivery pattern code related to said address indicia;
comparing said mining key to said package-level detail database and said archive by having one or more computer components execute logic for;
(a) retrieving from said archive those select delivery records having a past delivery pattern code that matches said current delivery pattern code, each of said select delivery records having a select past ship-to address;
(b) retrieving from said package-level detail database those select active shipment records having an active ship-to address that matches any said select past ship-to address in said select delivery records;
building a set of mined data comprising said select delivery records and said select active shipment records;
prioritizing said set of mined data in order of the records most closely associated with said mining key, such that a preferred address related to said mining key occurs first, by having said one or more computer components execute logic for;
(a) replacing one or more sequence values in a plurality of ship-to address records stored in said set of mined data with a representative symbol;
(b) clustering together those said ship-to address records having the same stop identifier; and
(c) clustering together those said ship-to address records having the same delivery pattern code; and
assigning said preferred address to said current parcel for delivery.
1 Assignment
0 Petitions
Accused Products
Abstract
A computer system and method is disclosed for mining current and archived address data in order to identify a preferred address for each service point in a territory. The data mining system may start in response to the presentation of a candidate address for matching. The set of mined data may be prioritized by clustering like characteristics, building similarity matrices, and by constructing dendrograms with nodes joined according to common characteristics. A computer system and method for maintaining a central database of preferred addresses is also disclosed. Selected address data gathered in a queue may be scored by characteristic, grouped by consignee location, and staged for processing. The scored queue of data may be prioritized by clustering like characteristics, building similarity matrices, and by constructing dendrograms.
-
Citations
18 Claims
-
1. A computer-implemented method of mining address data to locate a preferred address for each of a plurality of parcels, comprising:
-
maintaining a package-level detail database of active shipment records, each active shipment record comprising an active tracking number, an active ship-to address, and an active delivery pattern code; maintaining an electronic archive of delivery records, each delivery record comprising a past tracking number, a past ship-to address, a past delivery pattern code, and a stop identifier; receiving address indicia data associated with a current parcel; assigning a mining key to said current parcel, said mining key comprising a parcel tracking number and a current delivery pattern code related to said address indicia; comparing said mining key to said package-level detail database and said archive by having one or more computer components execute logic for; (a) retrieving from said archive those select delivery records having a past delivery pattern code that matches said current delivery pattern code, each of said select delivery records having a select past ship-to address; (b) retrieving from said package-level detail database those select active shipment records having an active ship-to address that matches any said select past ship-to address in said select delivery records; building a set of mined data comprising said select delivery records and said select active shipment records; prioritizing said set of mined data in order of the records most closely associated with said mining key, such that a preferred address related to said mining key occurs first, by having said one or more computer components execute logic for; (a) replacing one or more sequence values in a plurality of ship-to address records stored in said set of mined data with a representative symbol; (b) clustering together those said ship-to address records having the same stop identifier; and (c) clustering together those said ship-to address records having the same delivery pattern code; and assigning said preferred address to said current parcel for delivery. - View Dependent Claims (2, 3, 4)
-
-
5. A computer-implemented method of scoring and maintaining address data for any of a plurality of records in an address database, comprising:
-
maintaining a package-level detail database of active shipment records, each active shipment record comprising an active tracking number, an active ship-to address, and an active delivery pattern code; maintaining an electronic archive of delivery records, each delivery record comprising a past tracking number, a past ship-to address, a past delivery pattern code, and a stop identifier; gathering address data via a database management system from said detail database and said archive into a queue for a period of days; scoring said address data in said queue; building a consignee staging queue for storing those data in said queue related to a select consignee location; assigning a mining key to a current parcel selected from said consignee staging queue, said mining key comprising a parcel tracking number and a current delivery pattern code; comparing said mining key to said package-level detail database and said archive by having one or more computer components execute logic for; (a) retrieving from said archive those select delivery records having a past delivery pattern code that matches said current delivery pattern code, each of said select delivery records having a select past ship-to address; (b) retrieving from said package-level detail database those select active shipment records having an active ship-to address that matches any said select past ship-to address in said select delivery records; building a set of mined data comprising said select delivery records and said select active shipment records; prioritizing said set of mined data in order of the records most closely associated with said mining key, such that a preferred address related to said mining key occurs first, by having said one or more computer components execute logic for; (a) replacing one or more sequence values in a plurality of ship-to address records stored in said set of mined data with a representative symbol; (b) clustering together those said ship-to address records having the same stop identifier; and (c) clustering together those said ship-to address records having the same delivery pattern code; and assigning said preferred address to said current parcel and updating said address database. - View Dependent Claims (6, 7, 8, 9)
-
-
10. A computer system for locating a preferred address for each of a plurality of parcels, comprising:
-
a package-level detail database of active shipment records, each active shipment record comprising an active tracking number, an active ship-to address, and an active delivery pattern code; an electronic archive of delivery records, each delivery record comprising a past tracking number, a past ship-to address, a past delivery pattern code, and a stop identifier; a current parcel bearing address indicia; a mining key assigned to said current parcel, said mining key comprising a parcel tracking number and a current delivery pattern code related to said address indicia; a processor adapted to execute; an association process configured to compare said mining key to said package-level detail database and said archive by; (a) retrieving from said archive those select delivery records having a past delivery pattern code that matches said current delivery pattern code, each of said select delivery records having a select past ship-to address; (b) retrieving from said package-level detail database those select active shipment records having an active ship-to address that matches any said select past ship-to address in said select delivery records; (c) determining a set of mined data comprising said select delivery records and said select active shipment records, said set of mined data; (d) prioritizing said set of mined data in order of the records most closely associated with said mining key, such that a preferred address related to said mining key occurs first, by;
(1) replacing one or more sequence values in a plurality of ship-to address records stored in said set of mined data with a representative symbol;
(2) clustering together those said ship-to address records having the same stop identifier; and
(3) clustering together those said ship-to address records having the same delivery pattern code; andan electronic address database administrator adapted to assign said preferred address to said current parcel for delivery. - View Dependent Claims (11, 12, 13)
-
-
14. A computer system for scoring and maintaining address data for any of a plurality of records in an address database, comprising:
-
a package-level detail database of active shipment records, each active shipment record comprising an active tracking number, an active ship-to address, and an active delivery pattern code; an electronic archive of delivery records, each delivery record comprising a past tracking number, a past ship-to address, a past delivery pattern code, and a stop identifier; a queue of address data gathered from said detail database and said archive for a period of days; a consignee staging queue for storing those data in said queue related to a select consignee location; a mining key assigned to a current parcel selected from said consignee staging queue, said mining key comprising a parcel tracking number and a current delivery pattern code; a processor adapted to execute; a scoring process configured for assigning a score to said address data in said queue; and an association process configured for comparing said mining key to said package-level detail database and said archive by; (a) retrieving from said archive those select delivery records having a past delivery pattern code that matches said current delivery pattern code, each of said select delivery records having a select past ship-to address; (b) retrieving from said package-level detail database those select active shipment records having an active ship-to address that matches any said select past ship-to address in said select delivery records; (c) determining a set of mined data comprising said select delivery records and said select active shipment records, said set of mined data; (d) prioritizing said set of mined data in order of the records most closely associated with said mining key, such that a preferred address related to said mining key occurs first, by;
(1) replacing one or more sequence values in a plurality of ship-to address records stored in said set of mined data with a representative symbol;
(2) clustering together those said ship-to address records having the same stop identifier; and
(3) clustering together those said ship-to address records having the same delivery pattern code; andan address database administrator for assigning said preferred address to said current parcel and for updating said address database. - View Dependent Claims (15, 16, 17, 18)
-
Specification