Category: 

What Is a Spatial Database?

Article Details
  • Written By: Jean Marie Asta
  • Edited By: Jessica Seminara
  • Last Modified Date: 23 August 2016
  • Copyright Protected:
    2003-2016
    Conjecture Corporation
  • Print this Article
Free Widgets for your Site/Blog
The atmosphere of Jupiter's moon Io collapses every time it is eclipsed by the planet.   more...

September 29 ,  2008 :  The Dow Jones Industrial Average experienced its largest one-day drop in history.  more...

A database that is optimized for storage and querying of data related to objects in a space, which includes lines, points, and polygons, is called a spatial database. Various fields of study have multiple applications for managing geometric data, geographic data, and spatial data. In these databases, a “space” can be geographic like a map of the earth’s surface, geometric like a layout of a very large scale integration (VLSI) design, or spatial like a 3-D representation of protein molecule chains. The spatial database is similar to a standard database with additional abilities for spatial data handling. For example, spatial data types (SDTs) are offered in a spatial database’s query language and data model.

When a spatial database is used for geographic mapping, its SDTs indicate structure in a space, such as points, lines and regions, and relationships among structures, such as lines intersecting one another. A user may see these entities represented by roads, pipelines, or forests on a map, but in a programming view they are represented by lines, polygons or points. These types of databases are called object-based spatial databases. Additionally, topological relationships, such as overlapping or disjointing of lines, and directional relationships, such as the cardinal compass directions, are represented and programmed into a geographic spatial database. Metric relationships, which indicate the distance of objects, are also represented in these databases.

Ad

Spatial databases are used for business, government, marketing, and commercial data. A business may map concentrations of where a certain type of customer is located to plan the best place to construct another building, or a politician may survey a voting demographic to plan a campaign route. They can also be used for planning of cities and regions or used by police jurisdictions for crime pattern analysis. SDTs can be simple information, but they can also become very complex if what the user needs to know is very specific. These complex relationships of objects in the space are what make spatial databases beneficial because they can use and sort through massive amounts of information.

Oftentimes, specific objects in a certain spatial database have a number of variables associated with them. In this case, a spatial database can use structured query language (SQL) to provide special index functions for manipulating and querying data. While it could be used solely for storage, the database can be used for much more, including analysis of data. Objects in the database can contain an infinite amount of variables, and special spatial database tools allow for sorting of the various pieces of information.

Ad

You might also Like

Recommended

Discuss this Article

Post your comments

exception 'Exception' with message 'error writing captcha: Duplicate entry '2147483647' for key 'PRIMARY'' in /ssd/www/wisegeek/public_html/_core/classes/public/Captcha.php:44
Stack trace:
#0 /ssd/www/wisegeek/public_html/_core/controls/public/ControlDiscussionPostBox.php(324): Captcha->createCaptcha()
#1 /ssd/www/wisegeek/public_html/framework/classes/Control.php(104): ControlDiscussionPostBox->preRender(false)
#2 /ssd/www/wisegeek/public_html/framework/classes/Control.php(149): Control->render()
#3 /ssd/www/wisegeek/public_html/tpl/default-nocustom-lu/pages/public/article/article.htm(526): Control->__toString()
#4 /ssd/www/wisegeek/public_html/framework/classes/Control.php(300): require('/ssd/www/wisege...')
#5 /ssd/www/wisegeek/public_html/framework/classes/Control.php(309): Control->requireTpl('pages/public/ar...', Object(PageArticleCom), true)
#6 /ssd/www/wisegeek/public_html/framework/classes/Control.php(131): Control->renderTpl('pages/public/ar...', Object(PageArticleCom))
#7 /ssd/www/wisegeek/public_html/framework/classes/FormDataControl.php(87): Control->renderTemplate()
#8 /ssd/www/wisegeek/public_html/framework/classes/Control.php(109): FormDataControl->renderTemplate()
#9 /ssd/www/wisegeek/public_html/framework/classes/ScriptPage.php(50): Control->render(false)
#10 /ssd/www/wisegeek/public_html/framework/classes/Control.php(149): ScriptPage->render()
#11 /ssd/www/wisegeek/public_html/framework/classes/Page.php(97): Control->__toString()
#12 /ssd/www/wisegeek/public_html/_core/classes/public/PublicFrontController.php(443): Page->processRequest()
#13 /ssd/www/wisegeek/public_html/_core/classes/public/PublicFrontController.php(7): PublicFrontController->renderPage()
#14 /ssd/www/wisegeek/public_html/index.php(11): PublicFrontController::run()
#15 {main}