Load balancing for elastic query service system

    公开(公告)号:US10366103B2

    公开(公告)日:2019-07-30

    申请号:US15392750

    申请日:2016-12-28

    Applicant: SAP SE

    Abstract: 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.

    FRAMEWORK FOR DATA GEOCODING
    2.
    发明申请

    公开(公告)号:US20180131763A1

    公开(公告)日:2018-05-10

    申请号:US15343340

    申请日:2016-11-04

    Applicant: SAP SE

    CPC classification number: H04L67/1097 G06F16/29 H04L67/18 H04W4/02

    Abstract: 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.

    SPATIAL FILTER FOR GEO-ENRICHED DATA
    3.
    发明申请

    公开(公告)号:US20180130237A1

    公开(公告)日:2018-05-10

    申请号:US15343385

    申请日:2016-11-04

    Applicant: SAP SE

    CPC classification number: G06T11/20 G06F17/30241 G06T2215/16

    Abstract: 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.

    Scaling for elastic query service system

    公开(公告)号:US10896198B2

    公开(公告)日:2021-01-19

    申请号:US15392702

    申请日:2016-12-28

    Applicant: SAP SE

    Abstract: 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.

    CACHING FOR QUERY PROCESSING SYSTEMS
    6.
    发明申请

    公开(公告)号:US20190065560A1

    公开(公告)日:2019-02-28

    申请号:US15693338

    申请日:2017-08-31

    Applicant: SAP SE

    Abstract: 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.

    SCALING FOR ELASTIC QUERY SERVICE SYSTEM
    7.
    发明申请

    公开(公告)号:US20180121529A1

    公开(公告)日:2018-05-03

    申请号:US15392702

    申请日:2016-12-28

    Applicant: SAP SE

    CPC classification number: G06F16/27 G06F16/2471

    Abstract: 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.

    Data import and reconciliation
    8.
    发明授权

    公开(公告)号:US11030224B2

    公开(公告)日:2021-06-08

    申请号:US15684113

    申请日:2017-08-23

    Applicant: SAP SE

    Abstract: 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.

    SPATIAL FILTER FOR GEO-ENRICHED DATA
    9.
    发明申请

    公开(公告)号:US20190206097A1

    公开(公告)日:2019-07-04

    申请号:US16295865

    申请日:2019-03-07

    Applicant: SAP SE

    CPC classification number: G06T11/20 G06F16/29 G06T7/60 G06T2215/16

    Abstract: 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.

    DATA IMPORT AND RECONCILIATION
    10.
    发明申请

    公开(公告)号:US20190065528A1

    公开(公告)日:2019-02-28

    申请号:US15684113

    申请日:2017-08-23

    Applicant: SAP SE

    Abstract: 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.

Patent Agency Ranking