In-memory spatial database for geocoding/geoprocessing

摘要

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.

主权项

1. A system including instructions recorded on a non-transitory computer-readable medium and executable by at least one processor, the system comprising:
an in-memory database configured to interface with an application server hosting one or more web services, the in-memory database configured to perform extract, transform, and load (ETL) operations to collect data from one or more external data sources and perform geocoding and geoprocessing on the data such that the geocoding and geoprocessing are not performed at the application server but rather at a database level represented by the in-memory database, the in-memory database including,
an extraction module configured to cause the at least one processor to perform the ETL operations including extracting the data from the one or more external data sources, and transforming the data into a standard format associated with the in-memory database, the data including business data and address data;a geocoder configured to cause the at least one processor to geocode the address data including obtaining spatial data based on the address data using an internal reference table stored in the in-memory database, the spatial data including geographical coordinate data corresponding to the address data; anda geoprocessing module configured to cause the at least one processor to geographically process the spatial data including calculating geographical topology information using the geocoded address data including the geographical coordinate data; anda storage configured to store the spatial data and the business data.