主权项 |
1. A method for querying a database having a table containing point spatial data, the method comprising:
receiving a user request specifying a query window for point spatial data contained within the query window; generating one or more tiles that cover the query window; computing extents of the one or more tiles; generating a query for determining point spatial data in the table contained within the one or more tiles using the extents of the one or more tiles, said query comprising predicate clauses, said predicate clauses comprising, for each extent of said extents, a respective predicate clause specifying one or more conditions based on said each extent; and computing the query, wherein computing the query includes, for each predicate clause of said predicate clauses:
sending a respective set of smart scan requests to an enhanced storage device for execution to cause said enhanced storage device to scan for rows that satisfy the one or more conditions of said each predicate clause, andfrom the enhanced storage device, receiving resultant rows returned for the set of smart scans. |