Windows搜索与数据库搜索 [英] Windows Search vs Database Search

问题描述

场景:
当我们在Windows系统中进行文本/文件搜索时，结果将根据找到的项目一一显示.即，只要文件与搜索模式匹配，就会显示结果.

问题:
是否有任何方法可以实现客户端-服务器系统的类似功能，即最终用户向服务器发送请求以搜索一些数据，这些数据存储在各个数据库表中?

是否有任何数据库提供类似于Windows的将部分结果集返回给客户端并继续搜索的功能?

谢谢与问候，
Niral Soni

Scenario:
When we do a text/file search in Windows system, the result is displayed one by one, based on the items found. i.e. as soon as the file matches with the search pattern, the result is displayed.

Problem:
Is there any way of achieving the similar kind of functionality for the Client-Server system, where the end-user sends a request to server for searching some data, which are stored across various database tables?

Does any database provides Windows like facility of returning partial resultset back to the client, and continues searching?

Thanks & Regards,
Niral Soni

推荐答案

他们几乎都支持此功能.您想要实现这一目标的是一个游标，该游标一个接一个地遍历结果并将其返回给操作.尽管可以这样做，但通常不建议这样做，因为数据库在数据集上的工作效果最佳.

They pretty much all support this functionality. What you are looking for to achieve this is a cursor, which iterates over the results one by one and returns this back to be manipulated. While you can do this, it''s generally discouraged because databases work best on sets of data.

这篇关于Windows搜索与数据库搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！