Sap Se

Mohsen Asadi

Sae-Won Om

Christopher Tam

Jonathan Tiu

Lyndon Hiew

Xing Jin

Christopher Bolognese

Thanh Nguyen

Jacky Hu

Sumedha Sharma

Anthony Kohan

Chao Han

Christoper Bolognese

Anna Chen

Wan Gong

Alexandre Rojkov

Yijian Wang

Richard Mar

Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receiving a request for a map visualization that includes geo-enriched data comprising a set of shapes. In response to the request, the program further generates a query for the geo-enriched data. The program also sends the query to a geo-enriching data system. The program further receives the geo-enriched data from the geo-enriching data system. The program also generates the map visualization that includes the set of shapes.

Geo-enriched data based on shapes for visualizations

In one embodiment, the present disclosure pertains to downloading visualization data. Data visualizations in a user interface display may be created from remote data. Portions of the remote data may be downloaded to a local computer to recreate the data visualizations without the need for remote data requests. In another embodiment, a data export architecture includes jobs comprising a plurality of tasks configured in series. In one example embodiment, the jobs may correspond to particular data visualizations to be downloaded.

Downloading visualization data between computer systems

In one embodiment, the present disclosure pertains to data import and reconciliation. In one embodiment, a location field is compared against alternative geo-descriptors to link the location fields to areaIDs and geospatial shapes. A similarity search is performed against unmatched location fields. In one example embodiment, a table is generated with unique location IDs, areaIDs, and metadata describing the results of the comparison.

Data import and reconciliation

Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives a request for a map visualization that includes a plurality of geo-enriched data and geographical elements associated with a level of a plurality of levels in a hierarchy of geographical elements. The program further identifies a set of geographical elements associated with the level based on the hierarchy of geographical elements. The program also generates the map visualization to include the plurality of geo-enriched data and the set of geographical elements.

Hierarchical map visualizations of geo-enriched data

Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives a query for data from a client device. The program further generates a key based on the query for the data. The program also selects a cache service instance in a plurality of cache service instances. The program further sends the cache service instance the key and a request for a cached version of the data. The program also receives the cached version of the data from the cache service instance. The program further processes the query based on the cached version of the data. The program also sends a result set for the query to the client device.

Caching for query processing systems

Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives a set of queries for data from a dataset stored in a first database instance. The program further determines that a value calculated based on a set of metrics associated with processing the set of queries for data from the dataset stored in the first database instance exceeds a threshold value. In response to the determination, the program also replicates the dataset from the first database instance to a second database instance.

Scaling for elastic query service system

Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives from a data modeling system a data model definition of a data model. The program further generates a query for geo-enriched data from the data model based on the data model definition. The program also sends the query to a proxy system for the proxy system to forward the query to a geo-enriched data system. The program further receives a set of geo-enriched data from the geo-enriched data system via the proxy system.

Data models for geo-enriched data

Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives, from a client device, a request to geo-enrich data that includes a set of data and a set of location data associated with the set of data. The program also selects a geocoder from a plurality of different geocoders based on the set of location data associated with the set of data. The program further geo-enriches the set of location data using the selected geocoder.

Framework for data geocoding

Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives a query for data from a dataset stored in at least one database instance in a plurality of database instances. The program further determines a set of candidate database instances in the plurality of database instances that stores the dataset. The program also selects a database instance in the set of candidate database instances based on a set of metrics associated with the set of candidate database instances. The program further processes the query using the selected database instance.

Load balancing for elastic query service system

Some embodiments provide a non-transitory machine-readable medium that stores a program. The program sends a second computing system a spatial filter and a first query for a first set of geo-enriched data associated with a spatial visualization. The program further sends the second computing system the spatial filter and a second query for a second set of geo-enriched data associated with a non-spatial visualization. The program also receives, from the second computing system, a subset of the first set of geo-enriched data. The program further receives, from the second computing system, a subset of the second set of geo-enriched data. The program also generates the spatial visualization to include the subset of the first set of geo-enriched data. The program further generates the non-spatial visualization to include the subset of the second set of geo-enriched data.

Growing community of inventors

Vancouver, Canada

Mohsen Asadi