Spatial analytics extensions

• US 9,990,374 B2
• Filed: 10/23/2014
• Issued: 06/05/2018
• Est. Priority Date: 10/23/2014
• Status: Active Grant

• Current Assignee: Business Objects Incorporated (SAP SE)
• Original Assignee: Business Objects Incorporated (SAP SE)
• Inventors: Han, Qiang, Potiagalov, Alexei
• Primary Examiner(s): Pham, Hung Q
• Application Number:
  US14/522,204
• Publication Number:
  US 20160117346A1
• Time in Patent Office: 1,321 Days
• CPC Class Codes: G06F 16/24575 using context
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
• CPC Class Codes: G06F 16/29 Geographical information databases
• CPC Class Codes: G06F 16/5854 using shape and object relationship

Abstract

Methods and apparatus, including computer program products, are provided for spatial analytics. The method may include generating a query including spatial context information, the query structured to include a predicate for the query and the spatial context information, the spatial context information including at least one of feature information or geometric information; and sending the query to a spatial query processor including a database in order to generate a query response in accordance with the predicate and spatial context information. Related systems, methods, and articles of manufacture are also disclosed.

Claims

1. A system comprising:

at least one processor; and

at least one memory including computer program code which when executed by at least one processor causes operations comprising;

generating a database query including a predicate for the database query and a plurality of spatial context information stacked within the database query to enable a first portion of the plurality of spatial context information to be used as an intermediate result for a second portion of the plurality of spatial context information, the database query providing an analytical query of a multidimensional database, at least one of the plurality of the spatial context information including feature information, geometric information, and a result topology, the feature information explicitly defining a location for the database query, the geometric information further defining, based on a data model, spatial context for the database query, the result topology defining a hierarchical structure for a result to the database query, wherein the result topology corresponds to the spatial context defined by the geometric information;

sending the generated database query to a spatial query processor including the multidimensional database; and

receiving, in response to the sent database query, a response comprising a multidimensional database query response generated in accordance with the predicate, the plurality of spatial context information, the feature information, the geometric information, and the result topology, wherein the response is presented with a map.

2. The system of claim 1, wherein the query is in accordance with java script object notation.

3. The system of claim 1, wherein the feature information identifies at least one of an administrative boundary, a political boundary, a continent, a country, a state, a province, a county, a city, a road name, a body of water, a river, a landmark, a pipe line, or a power grid.

4. The system of claim 1, wherein the geometric information comprises at least one of a geometric shape, three-dimensional information, a spatial location, a distance, a relative distance, or a direction.

5. The system of claim 1, wherein the plurality of spatial context information is selected from the user interface.

6. A non-transitory computer-readable storage medium including computer program code which when executed at least one processor causes operations comprising:

generating a database query including a predicate for the database query and a plurality of spatial context information stacked within the database query to enable a first portion of the plurality of spatial context information to be used as an intermediate result for a second portion of the plurality of spatial context information, the database query providing an analytical query of a multidimensional database, at least one of the plurality of the spatial context information including feature information, geometric information, and a result topology, the feature information explicitly defining a location for the database query, the geometric information further defining, based on a data model, spatial context for the database query, the result topology defining a hierarchical structure for a result to the database query, wherein the result topology corresponds to the spatial context defined by the geometric information;

sending the generated database query to a spatial query processor including the multidimensional database; and

receiving, in response to the sent database query, a response comprising a multidimensional database query response generated in accordance with the predicate, the plurality of spatial context information, the feature information, the geometric information, and the result topology wherein the response is presented with a map.

7. The computer-readable storage medium of claim 6, wherein the query is in accordance with java script object notation.

8. The computer-readable storage medium of claim 6, wherein the feature information identifies at least one of an administrative boundary, a political boundary, a continent, a country, a state, a province, a county, a city, a road name, a body of water, a river, a landmark, a pipe line, or a power grid.

9. The computer-readable storage medium of claim 6, wherein the geometric information comprises at least one of a geometric shape, three-dimensional information, a spatial location, a distance, a relative distance, or a direction.

10. The computer-readable storage medium of claim 6, wherein the plurality of spatial context information query is selected from the user interface.

11. A method comprising:

generating a database query including a predicate for the database query and a plurality of spatial context information stacked within the database query to enable a first portion of the plurality of spatial context information to be used as an intermediate result for a second portion of the plurality of spatial context information, the database query providing an analytical query of a multidimensional database, at least one of the plurality of the spatial context information including feature information, geometric information, and a result topology, the feature information explicitly defining a location for the database query, the geometric information further defining, based on a data model, spatial context for the database query, the result topology defining a hierarchical structure for a result to the database query, wherein the result topology corresponds to the spatial context defined by the geometric information;

sending the generated database query to a spatial query processor including the multidimensional database; and

receiving, in response to the sent database query, a response comprising a multidimensional database query response generated in accordance with the predicate, the plurality of spatial context information, the feature information, the geometric information, and the result topology wherein the response is presented with a map.

12. The method of claim 11, wherein the query is in accordance with java script object notation.

13. The method of claim 11, wherein the feature information identifies at least one of an administrative boundary, a political boundary, a continent, a country, a state, a province, a county, a city, a road name, a body of water, a river, a landmark, a pipe line, or a power grid.

14. The method of claim 11, wherein the geometric information comprises at least one of a geometric shape, three-dimensional information, a spatial location, a distance, a relative distance, or a direction.

15. The method of claim 11, wherein the plurality of spatial context information is selected from the user interface.