×

In-memory spatial database for geocoding/geoprocessing

  • US 8,996,545 B2
  • Filed: 11/13/2012
  • Issued: 03/31/2015
  • Est. Priority Date: 05/02/2012
  • Status: Active Grant
First Claim
Patent Images

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; and

    a 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; and

    a storage configured to store the spatial data and the business data.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×