x
login about faq Site discussion (meta-askssc)

what exactly means:implementation of spatial relational operators in databases?

what exactly means:implementation of spatial relational operators in databases?

more ▼

asked Feb 10 '10 at 05:53 PM in Default

ina gravatar image

ina
1 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort oldest

Spatial databases are those that contain data about physical space - so that can either be geometric data which is in flat planes, or geographic data which is in curved planes, like the earth's surface.

The operators for those types of data are defined here for geography and here for gerometry. Because the two types of spatial data are implemented as CLR types in SQL Server, the operations on them are performed by the CLR type operators, both static (i.e. call them with typename::methodname) and instanced (i.e. call them with columnname.functionname).

more ▼

answered Feb 10 '10 at 06:09 PM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.2k 56 63 87

Holy cow. I've never seen it summarized quite so well. Nice job.

Feb 10 '10 at 07:22 PM Grant Fritchey ♦♦

@Grant - thank you kindly sir!

Feb 10 '10 at 08:57 PM Matt Whitfield ♦♦

Thank you, Matt,for your help.

Feb 12 '10 at 05:44 AM ina
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x58
x7

asked: Feb 10 '10 at 05:53 PM

Seen: 1069 times

Last Updated: Feb 10 '10 at 06:18 PM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.