x

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

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

more ▼

asked Feb 10, 2010 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, 2010 at 06:09 PM

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 87

Holy cow. I've never seen it summarized quite so well. Nice job.
Feb 10, 2010 at 07:22 PM Grant Fritchey ♦♦
@Grant - thank you kindly sir!
Feb 10, 2010 at 08:57 PM Matt Whitfield ♦♦
Thank you, Matt,for your help.
Feb 12, 2010 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x66
x9

asked: Feb 10, 2010 at 05:53 PM

Seen: 1476 times

Last Updated: Feb 10, 2010 at 06:18 PM