发明名称 Reducing lag time when searching a repository using a keyword search
摘要 Embodiments of the invention provide systems and methods for searching a repository of information such as a database using a keyword search and/or an attribute search in near real time. According to one embodiment, a method of searching a repository of information can comprise receiving a set of search criteria for performing the search and selectively performing one or more of an attribute search and a keyword search of the information in the repository based on the received search criteria.
申请公布号 US8745079(B2) 申请公布日期 2014.06.03
申请号 US20080181475 申请日期 2008.07.29
申请人 Oracle International Corporation 发明人 Lam Yu Cong;Juvara Paolo
分类号 G06F7/00;G06F17/30 主分类号 G06F7/00
代理机构 代理人
主权项 1. A method for searching a repository of information, the method comprising: receiving at a computer system maintaining the repository of information sets of search criteria for performing a plurality of searches; and selectively performing by the computer system one or more of an attribute search and a keyword search of the information in the repository based on each of the received sets of search criteria and further based on whether the received search criteria indicates only keywords, only attributes, or both keywords and attributes, wherein the computer system executes a DataBase Management System (DBMS) and a search engine, wherein the repository comprises a plurality of tables storing the information and an index file, wherein the index file comprises a file generated and maintained by the computer system and representing contents of each of the tables, wherein the index file comprises a plurality of records, each record identifying one or more records of one or more tables, and wherein selectively performing one or more of the attribute search and the keyword search based on each of the received sets of search criteria comprises: determining by the computer system for each of the received sets of criteria whether the received criteria contains only criteria indicating attributes to be searched, only criteria indicating keywords to be searched, or both criteria indicating attributes to be searched and criteria indicating keywords to be searched;for a received set of criteria containing only criteria indicating attributes to be searched, not performing the keyword search and performing only the attribute search by searching data of the repository by executing a query of the DBMS on the tables of the repository;for a received set of criteria containing only criteria indicating keywords to be searched not performing the attribute search and performing only the keyword search by searching the index file of data in the repository using the search engine; andfor a received set of criteria containing both criteria indicating attributes to be searched and criteria indicating keywords to be searched, performing the keyword search by searching the index file of the data in the repository using the search engine and filtering results of the keyword search based on the criteria indicating attributes to be searched without performing the attribute search on all of the data of the repository.
地址 Redwood Shores CA US