Building a geographic database

• US 8,478,784 B2
• Filed: 11/27/2002
• Issued: 07/02/2013
• Est. Priority Date: 11/27/2002
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP AG (SAP SE)
• Inventors: Segler, Michael, Bender, Thorsten, Hassler, Philipp
• Primary Examiner(s): AL HASHEMI, SANA A
• Application Number:
  US10/306,808
• Publication Number:
  US 20040103117A1
• Time in Patent Office: 3,870 Days
• Field of Search: 707/101, 707/104.1, 707/100, 707/608, 707/705, 707/790, 707/813, 707/821, 707/899, 701/201, 701/208, 701/211
• US Class Current: 707/790
• CPC Class Codes: G06F 16/29 Geographical information databases

Abstract

A system receives output geographic information en masse from a server. The output geographic information corresponds to input geographic information provided to the server en masse. The system builds a database that indexes at least some of the output geographic information to at least some of the input geographic information, attempts to locate specific output geographic information in the database, and determines the specific output geographic information by calculation if the specific output geographic information cannot be located in the database.

Claims

1. A method for obtaining geographic information comprising:

receiving, on a base computer system, output geographic information en masse from one or more servers, the output geographic information comprising routes, travel durations and distances, the output geographic information corresponding to input geographic information provided by the base computer to the one or more servers en masse, the input geographic information comprising sets of locations, the sets of locations being defined in terms of geographic coordinates;

building, on the base computer system, a database that indexes at least some of the output geographic information to at least some of the input geographic information;

wherein building the database comprises indexing the output geographic information in the database based on which geographic server provided the output geographic information;

attempting to locate specific output geographic information in the database;

wherein attempting comprises attempting to locate specific output geographic information that corresponds to specific input geographic information, and determining, by the base computer system, the specific output geographic information by calculation if the specific output geographic information cannot be located in the database, the calculated specific output geographic information being one of straight-line distance and duration.

3. The method of claim 1, wherein calculating comprises calculating the straight-line distance and duration using geographic coordinates as the specific input geographic information.

4. The method of claim 1, wherein receiving and building are performed by maintenance software and attempting and determining are performed by application software.

5. The method of claim 1, wherein building comprises indexing the output geographic information in the database by geographic region.

10. The method of claim 5, wherein the geographic region comprises at least one of an area of a country, a country, and a continent.

2. A system comprising:

one or more servers; and

a computer system;

wherein the computer system comprises at least one memory that stores executable instructions and at least one processor that executes the instructions to;

receive output geographic information en masse from the one or more servers, the output geographic information comprising routes, travel durations and distances, the output geographic information corresponding to input geographic information provided to the one or more servers en masse, the input geographic information comprising sets of locations, the sets of locations being defined in terms of geographic coordinates;

build a database that indexes at least some of the output geographic information to at least some of the input geographic information;

wherein to build the database comprises indexing the output geographic information in the database based on which geographic server provided the output geographic information;

attempt to locate specific output geographic information in the database, wherein attempting comprises attempting to locate specific output geographic information that corresponds to specific input geographic information; and

determine the specific output geographic information by calculation if the specific output geographic information cannot be located in the database, the calculated specific output geographic information being one of straight-line distance and duration.

6. The system of claim 2, wherein calculating comprises calculating the straight-line distance and duration using geographic coordinates as the specific input geographic information.

7. The system of claim 2, wherein receiving and building are performed by maintenance software and attempting and determining are performed by application software.

8. The system of claim 2, wherein building comprises indexing the output geographic information in the database by geographic region.

9. The system of claim 8, wherein the geographic region comprises at least one of an area of a country, a country, and a continent.