Re: Optomized Range Searching....
Date: 15 Aug 2000 14:35:14 -0500
Message-ID: <aWgm5.18063$Mt4.1384897_at_sol.newscene.com>
Jan Hidders <hidders_at_wsinis12.win.tue.nl> wrote in message
news:8nb9sj$8a2$1_at_news.tue.nl...
> On 14 Aug 2000 23:19:14 -0500, Art Pollard <pollarda_at_lextek.com> wrote:
> >
> >I am wondering if there are any papers on ways
> >to optomize range searching. (Specifically numerical
> >range searching.) For example, if a database user
> >requested all books under $100, it could make for
> >a lot of traversing in the BTree or other index when
> >you consider all decimal places that are possible.
>
> Maybe I am misunderstanding you, but usually you just look up the page
that
> contains the upperbound and the page that contains the lowerbound. The
pages
> "in between" will then contain records that fall within the range. So, you
> just have to traverse the tree two times.
I am sure there are other optomizations out there for this sort of thing but when it comes to numeric range processing you could run into some real efficiency problems if the range between your low and high contain an extremely large number of enteries.
-Art Received on Tue Aug 15 2000 - 21:35:14 CEST