Open In App
Related Articles

Spatial and Geographical data

Like Article
Save Article
Report issue

Spatial data support in database is important for efficiently storing, indexing and querying of data on the basis of spatial location. For example, suppose that we want to store a set of polygons in a database and to query the database to find all polygons that intersect a given polygon. We cannot use standard index structures, such as B-trees or hash indices, to answer such a query efficiently. Efficient processing of the above query would require special-purpose index structures, such as R-trees for the task. 

Two types of Spatial data are particularly important: 

Computer-aided design (CAD)data, which include spatial information about how objects-such as building, cars, or aircraft-are constructed. Other important examples of computer-aided-design databases are integrated-circuit and electronic-device layouts. 

CAD systems traditionally stored data in memory during editing or other processing, and wrote the data back to a file at the end of a session of editing. The drawbacks of such a schema include cost(programming complexity, as well as time cost) of transforming data from one form to another, and the need to read in an entire file even if only parts of it are required. For large design of an entire airplane, it may be impossible to hold the complete design in memory. Designers of object oriented database were motivated in large part by the database requirements of CAD systems. Object-oriented database represent components of design as objects, and the connections between the objects indicate how the design is structure. 

Geographic data such as road maps, land-usage maps, topographic elevation maps, political maps showing boundaries, land-ownership maps, and so on. Geographical information system are special purpose databases for storing geographical data. Geographical data are differ from design data in certain ways. Maps and satellite images are typical examples of geographic data. Maps may provide not only location information associated with locations such as elevations. Soil type, land type and annual rainfall.

Types of geographical data :

  • Raster data
  • Vector data 

1.Raster data: Raster data consist of pixels also known as grid cells in two or more dimensions. For example, image of Satellites , digital pictures, and scanned maps.

2.Vector data: Vector data consist of triangles, lines, and various geometrical objects in two dimensions and cylinders, cuboids, and other polyhedrons in three dimensions. For example, building boundaries and roads.

Applications of Spatial databases in DBMS :

  • Microsoft SQL server: Since the 2008 version of Microsoft SQL server supported spatial databases.
  • CouchDB : This is document-based database in which spatial data is enabled by plugin called GeoCouch.
    Neo4j database. 

Last Updated : 06 Mar, 2023
Like Article
Save Article
Share your thoughts in the comments
Similar Reads