Thread

  1. Re: k-neighbourhood search in databases

    Oleg Bartunov <oleg@sai.msu.su> — 2011-04-08T13:24:51Z

    Hans,
    
    thanks a lot. I've heard about Oracle Spatial, but I don't know
    if it's knn is  just syntactic sugar for workarounds.
    
    Oleg
    
    On Fri, 8 Apr 2011, PostgreSQL - Hans-J?rgen Sch?nig wrote:
    
    > hello ...
    >
    > i have put some research into that some time ago and as far as i have seen there is a 99% chance that no other database can do it the way we do it. it seems nobody comes even close to it (especially not in the flexibility-arena).
    >
    > oracle: disgusting workaround ...
    > http://www.orafaq.com/usenet/comp.databases.oracle.misc/2005/11/03/0083.htm
    >
    > db2: disgusting workaround (no server side code it seems)
    >
    > sybase: disgusting workaround (no serverside code it seems)
    >
    > microsoft: there seems to be something coming out (or just out) but i have not seen anything working yet.
    >
    > 	regards,
    >
    > 		hans
    >
    >
    >
    > On Apr 8, 2011, at 2:21 PM, Oleg Bartunov wrote:
    >
    >> Hi there,
    >>
    >> I'm interesting if other databases provides built-in effective knn search ? Google didn't help me.
    >>
    >> 	Regards,
    >> 		Oleg
    >> _____________________________________________________________
    >> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
    >> Sternberg Astronomical Institute, Moscow University, Russia
    >> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
    >> phone: +007(495)939-16-83, +007(495)939-23-83
    >>
    >> --
    >> Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
    >> To make changes to your subscription:
    >> http://www.postgresql.org/mailpref/pgsql-hackers
    >>
    >
    > --
    > Cybertec Sch?nig & Sch?nig GmbH
    > Gr?hrm?hlgasse 26
    > A-2700 Wiener Neustadt, Austria
    > Web: http://www.postgresql-support.de
    >
    
     	Regards,
     		Oleg
    _____________________________________________________________
    Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
    Sternberg Astronomical Institute, Moscow University, Russia
    Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
    phone: +007(495)939-16-83, +007(495)939-23-83