Oracle International Corporation

Ravikanth V Kothuri

Siva Ravada

Daniel Geringer

Daniel Abugov

Ning An

A method, system, and computer program product provides improved performance for queries on local partitioned indexes. A method of performing a database query comprises receiving a query of spatial data in a database, the database comprising at least one partitioned spatial index, obtaining metadata relating to all partitions of the spatial index using array-fetching techniques, determining, for each partition, whether the partition is relevant to the query by comparing with 'footprint' (root_mbr) information stored in the metadata for the partition, and processing the query on each relevant partition.

Pruning of spatial queries using index root MBRS on partitioned indexes

The present invention provides techniques by which updates may be incorporated in database indexes without causing deadlocks of user transactions. In deferred-incorporate update, the updates are propagated to the index only at transaction commit time. A method of handling transactions including updates in a database management system comprises the steps of receiving an update to a database maintained by the database management system, the update operable to cause an index of the database to be modified, recording the update in a log, and receiving an indication that the transaction is to be committed and in response, incorporating the update from the log into an index of the database. The update may comprise an insert operation and/or a delete operation.

Deferred incorporation of updates for spatial indexes

A method for evaluating a spatial query comprises receiving a spatial query defining a query window including a void, identifying an interior circle for the query window, wherein the interior circle includes a void, and processing the spatial query by either (1) modifying the at least one interior circle to exclude the void, and using the modified interior circle to evaluate the spatial query by checking whether a data MBR is inside the modified interior circle and when it does, including the data item in the query result set, or (2) by checking whether a data MBR is inside the interior circle and when it does, checking whether the data MBR intersects the MBRs of any of the voids, and including the data item in the query result set when there is no intersection.

Growing community of inventors

Nashua, NH, United States of America

Ravikanth V Kothuri