Method and apparatus for converting a geographic location to a direct marketing area for a query

• US 6,295,528 B1
• Filed: 11/30/1998
• Issued: 09/25/2001
• Est. Priority Date: 11/30/1998
• Status: Expired due to Term

• Current Assignee: Switchboard LLC
• Original Assignee: InfoSpace, Inc. (Blucora Incorporated)
• Inventors: Garbe, Darrell, Marcus, Kevin
• Primary Examiner(s): Black, Thomas
• Assistant Examiner(s): DO, THUY T
• Application Number:
  US09/201,575
• Time in Patent Office: 1,030 Days
• Field of Search: 707/6, 707/2, 707/3, 707/4, 707/10, 707/101, 707/102, 707/104, 707/205
• US Class Current: 707/759
• CPC Class Codes: G06F 16/29 Geographical information databases
• CPC Class Codes: G06Q 30/0241 Advertisements
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]
• CPC Class Codes: Y10S 707/919 Geographic
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

A method and system are provided for performing database queries with geographic inputs that are converted to a direct marketing area prior to performing the query. Direct marketing areas define geographic locations as discrete areas of interest that may be more useful than city limits or a specific geographic location (e.g., latitude/longitude). Direct marketing areas are more useful geographic designations for purposes of advertising and marketing. A geographic input, such as a city and state, or a latitude and longitude are converted to a direct marketing area. The direct marketing area is then substituted for the entered geographic parameter (e.g., city and state or latitude and longitude), and the requested database query is performed.

Claims

1. A method for performing a database query, comprising:

(a) in response to a query request received from a query requester, the query request containing a geographic location input parameter, determining if a direct marketing area should be used in a query;

(b) if the direct marketing area should be used in the query, obtaining the direct marketing area corresponding to the geographic location input parameter, if possible; and

(c) replacing the geographic location input parameter with the direct marketing area, if the direct marketing area for the geographic location input parameter was obtained.

2. The method of claim 1, wherein the direct marketing area is obtained from a geographic location/direct marketing area database containing a plurality of geographic locations and a corresponding direct marketing area for each of the geographic locations.

3. The method of claim 1, further comprising performing the query.

4. The method of claim 3, further comprising:

(a) formatting a result received from the query performed; and

(b) sending the formatted result to the query requester.

5. A computer-readable medium having computer executable instructions for performing the method recited in any one of claims 1-4.

6. An apparatus for performing a database query, comprising:

(a) a processing unit; and

(b) a storage medium coupled to the processing unit, the storage medium storing program code implemented by the processing unit for;

(i) in response to a query request received from a query requester, the query request containing a geographic location input parameter, determining if a direct marketing area should be used in a query;

(ii) if the direct marketing area should be used in the query, obtaining the direct marketing area corresponding to the geographic location input parameter, if possible; and

(iii) replacing the geographic location input parameter with the direct marketing area, if the direct marketing area for the geographic location input parameter was obtained.

7. The apparatus of claim 6, wherein the direct marketing area is obtained from a geographic location/direct marketing area database containing a plurality of geographic locations and a corresponding direct marketing area for each of the geographic locations.

8. The apparatus of claim 6, wherein the program code implemented by the processing unit further performs the query.

9. The apparatus of claim 8, wherein the program code implemented by the processing unit further:

(a) formats a result received from the query performed; and

(b) sends the formatted result to the query requester.

10. A method for performing a database query, comprising:

(a) in response to a query request received from a query requester, the query request containing a geographic location input parameter, determining if a direct marketing area should be used in a query;

(b) if the direct marketing area should be used in the query, obtaining the direct marketing area corresponding to the geographic location input parameter, if possible; and

(c) replacing the geographic location input parameter with the direct marketing area prior to performing the query, if the direct marketing area for the geographic location input parameter was obtained.

11. The method of claim 10, wherein the direct marketing area is obtained from a geographic location/direct marketing area database containing a plurality of geographic locations and a corresponding direct marketing area for each of the geographic locations.

12. The method of claim 10, further comprising performing the query.

13. The method of claim 12, further comprising:

(a) formatting a result received from the query performed; and

(b) sending the formatted result to the query requester.

14. A computer-readable medium having computer executable instructions for performing the method recited in any one of claims 10-13.

15. An apparatus for performing a database query, comprising:

(a) a processing unit; and

(b) a storage medium coupled to the processing unit, the storage medium storing program code implemented by the processing unit for;

(i) in response to a query request received from a query requester, the query request containing a geographic location input parameter, determining if a direct marketing area should be used in a query;

(ii) if the direct marketing area should be used in the query, obtaining the direct marketing area corresponding to the geographic location input parameter, if possible; and

(iii) replacing the geographic location input parameter with the direct marketing area prior to performing the query, if the direct marketing area for the geographic location input parameter was obtained.

16. The apparatus of claim 15, wherein the direct marketing area is obtained from a geographic location/direct marketing area database containing a plurality of geographic locations and a corresponding direct marketing area for each of the geographic locations.

17. The apparatus of claim 15, wherein the program code implemented by the processing unit further performs the query.

18. The apparatus of claim 17, wherein the program code implemented by the processing unit further:

(a) formats a result received from the query performed; and

(b) sends the formatted result to the query requester.