If thousands of records weren't a lot, HN wouldn't have to manually break up comment threads anytime a U.S. president is elected.
Just because you didn't think of some valid usage for a feature, it doesn't mean that there isn't any.
Every major RDBMS supports window functions (even MySQL, though recent). Why would you bring remote data into a local process to do something the remote process can do with its own local data vastly more efficiently?
I worked at a company that bilked the government for vast sums of money by doing all this and charging them for the hardware. The guvvies knew what was going on, but their little empires were more important if they got a bigger budget, so they went along with it.
Some people get excited about huge datasets; I don't get it myself, but "big data" is a successful buzzword because it pushes people's buttons.