IN-MEMORY SPATIAL DATABASE FOR GEOCODING/GEOPROCESSING

• US 20130297556A1
• Filed: 11/13/2012
• Published: 11/07/2013
• Est. Priority Date: 05/02/2012
• Status: Active Grant

• Current Assignee: SAP SE
• Original Assignee: SAP SE
• Inventors: Chen, Yingyu, Dong, Bin, Shen, Yongyuan
• Granted Patent: US 8,996,545 B2
• Time in Patent Office: Days
• US Class Current: 707/602
• CPC Class Codes: G06F 16/00 Information retrieval; Database structures therefor; File system structures therefor
• CPC Class Codes: G06F 16/29 Geographical information databases

Abstract

The embodiments provide an in-memory database system having an extraction module configured to extract data (e.g., business data and address data) from one or more external data sources and transform the data into a standard format, a geocoder configured to geocode the address data including obtaining spatial data based on the address data using an internal reference table, and an internal database configured to store the internal reference table, the business data, the address data, and the spatial data

Claims

1. An in-memory database system comprising:

an extraction module configured to extract data from one or more external data sources, and transform the data into a standard format, the data including business data and address data;

a geocoder configured to geocode the address data including obtaining spatial data based on the address data using an internal reference table; and

an internal database configured to store the internal reference table, the business data, the address data, and the spatial data.

2. The in-memory database system of claim 1, wherein the extraction module is configured to extract data from one or more external data sources in real-time via one or more real-time jobs.

3. The in-memory database system of claim 1, wherein the extraction module is configured to extract data from one or more external data sources in time intervals via one or more batch jobs.

4. The in-memory database system of claim 1, wherein the extraction module is configured to transform the data into a standard format includes:

a data quality unit configured to clean and merge the data into the standard format.

5. The in-memory database system of claim 1, wherein the data from one or more external data sources includes data having different formats.

6. The in-memory database system of claim 1, wherein the geocoder configured to geocode the address data includes:

a job status monitor configured to monitor a status of extracting and transforming by the extraction module,

the job status monitor configured to determine that the address data is contained in the extracted data,

wherein the geocoder is configured to query the internal reference table using the address data as determined by the job status monitor, determine matching address data in the internal reference table, and obtain corresponding spatial data from the internal reference table.

7. The in-memory database system of claim 1, wherein the spatial data includes longitude and latitude information corresponding to the address data.

8. The in-memory database system of claim 1, wherein the spatial data is stored in a column based format in the internal database.

9. The in-memory database system of claim 1, further comprising:

a geoprocessing module configured to geographically process the spatial data according to spatial procedure information including performing one or more spatial queries on the spatial data according to the spatial procedure information.

10. The in-memory database system of claim 9, wherein the geoprocessing module is configured to transmit results of the one or more spatial queries to an outside geographic information system (GIS) application for further processing.

11. The in-memory database system of claim 9, wherein the geoprocessing module, the extraction module, the geocoder, and the internal database is located in a same database tier.

12. The in-memory database system of claim 1, further comprising:

a modeling module configured to create database views for the internal database, the database views including at least one of an attribute view, analytic view and calculation view.

13. The in-memory database system of claim 12, wherein the modeling module is configured to transmit one or more database views to a user interface component for display.

14. A method for geocoding address data by an in-memory database system, the method comprising:

extracting, by the in-memory database system, data from one or more external data sources;

transforming, by the in-memory database system, the data into a standard format, the data including business data and address data;

geocoding, by the in-memory database system, the address data including obtaining spatial data based on the address data using an internal reference table; and

storing, in the in-memory database system, the internal reference table, the business data, the address data, and the spatial data.

15. The method of claim 14, wherein the extracting step extracts data from one or more external data sources in real-time via one or more real-time jobs.

16. The method of claim 14, wherein the extracting step extracts data from one or more external data sources in time intervals via one or more batch jobs.

17. The method of claim 14, further comprising:

geographically processing, by the in-memory database system, the spatial data according to spatial procedure information including performing one or more spatial queries on the spatial data according to the spatial procedure information.

18. The method of claim 14, further comprising:

creating, by the in-memory database system, database views for the internal database, the database views including at least one of an attribute view, analytic view and calculation view.

19. A computer program product tangibly embodied on a non-transitory computer-readable storage medium and including executable code that, when executed, is configured to cause an in-memory database system to:

extract data from one or more external data sources;

transform the data into a standard format, the data including business data and address data;

geocode the address data including obtaining spatial data based on the address data using an internal reference table; and

store, in the in-memory database system, the internal reference table, the business data, the address data, and the spatial data.

20. The computer program product of claim 19, wherein the executable code that, when executed, is configured to cause an in-memory database system to:

geographically process the spatial data according to spatial procedure information including performing one or more spatial queries on the spatial data according to the spatial procedure information.