Most spatial databases allow representing simple geometric objects such as spatial data structures pdf, lines and polygons. MM multimedia standard and extends the Simple Features standard with data types that support circular interpolations. Such databases can be useful for websites that wish to identify the locations of their visitors for customization purposes. Instead, spatial databases use a spatial index to speed up database operations.
In addition to typical SQL queries such as SELECT statements, spatial databases can perform a wide variety of spatial operations. Spatial Measurements: Computes line length, polygon area, the distance between geometries, etc. Spatial Functions: Modify existing features to create new ones, for example by providing a buffer around them, intersecting features, etc. Examples include “do two polygons overlap” or ‘is there a residence located within a mile of the area we are planning to build the landfill? Conventional index types do not efficiently handle spatial queries such as how far two points differ, or whether points fall within a spatial area of interest.
Typically the preferred method for indexing spatial data. Objects are added to an MBR within the index that will lead to the smallest increase in its size. Data Manager with spatial datatypes, functions, and utilities. However, in MySQL version 5.