首页>
外国专利>
AUTOMATED DATABASE QUERY FILTERING FOR SPATIAL JOINS
AUTOMATED DATABASE QUERY FILTERING FOR SPATIAL JOINS
展开▼
机译:空间连接的自动数据库查询过滤
展开▼
页面导航
摘要
著录项
相似文献
摘要
A method, system, and program product for implementing an automated query filtering process for spatial data is provided. The method includes selecting a set of common depth levels for geohash structures. Data indicating results of the selection is stored and a specified depth level of the set of common geohash depth levels is selected. The selected geohash depth level is associated with a spatial column for spatial data to determine a set of geohash depth levels required to generate geohash values. A filter table or index associated with the spatial column is generated based on the selected subset of common geohash depth levels and a relationship between the spatial column, the specified geohash depth level and the filter table is stored within a database. Geohash values for the filter table are generated and a query of the database is executed with respect to the specified geohash depth level, the filter entries, and the filter table.
展开▼