Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wazuba
Starting Member
4 Posts |
 Posted - 2009-12-12 : 04:48:56
|
| Hi all,I am trying to implement a certain algorithm using SQL server 2008 (Express edition).Basically I want to divide a certain geographical area into 3d cubes and calculate the distance of each cube from all the other cubes.Brute force calculations are not feasable (at least what I have tried)So I want to divide my space into 9 cubes and then each cube into 9 more cubes in a sort of divide and conquer style. while any cubes that are more than a certain distance apart I don't want to even calculate thier distances.The coordinates of each cube are X,Y,Z and T (time).X goes from 0 to 10 miles in 0.25mile increments.Y goes from 0 to 10 miles in 0.25mile increments.Z goes from 0 to 4 miles in 0.25mile increments.T goes from 0 to 24 hours in 1 minute incrementsAny ideas on how I should go about doing this in SQL server?Thanks!! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-12-12 : 07:03:34
|
| Please do not cross post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=137082 |
 |
|
|
|
|
|
Implementing Algorithm