Horton

Re: k-neighbourhood search in databases

Jeremiah Peschka <jeremiah.peschka@gmail.com>

View thread View on postgr.es
From: Jeremiah Peschka <jeremiah.peschka@gmail.com>
To: pgsql-hackers@postgresql.org
Date: 2011-04-09T04:39:14Z
Lists: pgsql-hackers 
On 4/8/11 5:21 AM, Oleg Bartunov wrote:
> Hi there,
> 
> I'm interesting if other databases provides built-in effective knn
> search ? Google didn't help me.
SQL Server provides some knn search functionality[1] with enhancements coming this November in SQL 11[2].

[1]: http://blogs.msdn.com/b/isaac/archive/2008/10/23/nearest-neighbors.aspx
[2]: http://www.sqlskills.com/BLOGS/BOBB/post/The-nearest-neighbor-optimization-in-SQL-Server-Denali.aspx


-- 
Jeremiah Peschka
Microsoft SQL Server MVP
MCITP: Database Developer, DBA