Patent ID: 8396883
Filing Date: 2013-03-12
Classification: G06F

Abstract:
1. A method for providing spatial querying in a data warehouse, comprising: receiving a query at the data warehouse; determining whether the query is a spatial query; and upon determining that the query is a spatial query, a) translating the spatial query into a regular query; b) providing the regular query to a regular database of the data warehouse, wherein translating the spatial query into the regular query comprises: mapping a virtual feature table (VFT) to regular tables, wherein the VFT includes at least one spatial data type found in the spatial query, and the regular tables include at least one regular data type that corresponds with the at least one spatial data type in the VFT; c) receiving at least one regular result from the regular database in response to the regular query; and d) returning at least one spatial-query result as an answer to the query received at the data warehouse, wherein the returning the at least one spatial-query result comprises reorganizing and translating the answer into a geometric data type.