摘要
针对结构化数据的查询,通常需要针对每个特定的字段设置条件,然后再构造SQL进行查询。这种查询方式对于不熟悉业务和数据结构的用户来说,往往显得不够方便。这里阐述了如何利用Oracle的复制机制,对数据库中的数据进行重新排列,便于使用简单的SQL算法实现全数据库的模糊搜索,从而对结构化数据实现了搜索引擎的功能。
The usual method for querying the structured data is to set query conditions for the special data column and construct a SQL based on these conditions. It is discommodious for those users which are not familiar with the data structure. An implementation method of search engineer for the structured data based on the Oracle replication is presented in this paper. That is rearranging the data in the database by replication, so that users can use simple SQL to search any keyword through the whole database intangibly.
出处
《东华大学学报（自然科学版）》
CAS
CSCD
北大核心
2005年第4期41-44,共4页
Journal of Donghua University(Natural Science)
