Method, apparatus, and system for attaching search results

• US 6,763,351 B1
• Filed: 06/18/2001
• Issued: 07/13/2004
• Est. Priority Date: 06/18/2001
• Status: Active Grant

• Current Assignee: Oracle America, Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Subramaniam, Pavitra, Ying, Jian-Jung, Zoss, Jason, Caltabiano, Marc
• Primary Examiner(s): Mizrahi, Diane D.
• Application Number:
  US09/883,770
• Time in Patent Office: 1,121 Days
• Field of Search: 707/1, 707/2, 707/3, 707/100, 707/101, 707/102, 707/200
• US Class Current: 1/1
• CPC Class Codes: G06F 16/34 Browsing; Visualisation therefor
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching

Abstract

According to one aspect of the present mechanism, a method is provided in which a search request containing search criteria is received from a first user. A search is performed based on the search criteria to retrieve records in one or more databases that match the search criteria. A list of search results based on the retrieved records is displayed to the first user. In response to the first user'"'"'s request to associate a particular search result in the list to a particular object, associate the particular search result to the particular object.

Claims

1. A computer implemented method comprising:

receiving a search request from a first user, the search request containing search criteria, the search criteria including multiple search categories, each search category represented by a search category object associated with one or more search indices from one or more databases;

performing a search based on the search criteria to retrieve records in a database that match the search criteria, including passing the search criteria to a virtual business component;

invoking a search business service and passing the search criteria from the virtual business component to the search business service;

invoking a search adapter to conduct a query based on the search criteria;

displaying, to the first user, a list of search results based on retrieved records;

displaying details of the search result to the first user in response to the first user'"'"'s selection of selected search result in the list of search results for preview;

in response to the first user'"'"'s request to associate the selected search result to a first object of a set of defined objects, associating the selected search result to the first object; and

displaying the first object and the selected search result in a predefined view for the first user to review the association between the first object and the selected search result.

2. The method of claim 1 wherein the search criteria includes at least one search category.

3. The method of claim 1 wherein the search criteria includes at least one search keyword.

4. The method of claim 1 wherein displaying details includes:

determining whether the selected search result is a database record or an external document; and

if the selected search result is a database record, displaying details of the selected search result to the first user in a predefined view associated with a search category included in the search criteria.

5. The method of claim 1 further including:

if the selected search result is an external document, displaying content of the external document in an output data stream.

6. The method of claim 1 further including:

providing a mechanism for the first user to individually select a search result in the list of search results for association of the respective search result to an object.

7. The method of claim 1 further including:

providing a mechanism for the first user to individually select a search result in the list of search results for preview of the respective search result.

8. The method of claim 1 further including:

caching the search results to maintain persistency of the search results.

9. The method of claim 8 wherein caching includes:

caching the search results in a search business service until termination of a user session to maintain persistency of the search results until termination of the user session.

10. The method of claim 1 wherein the selected search result belongs to a first business component, the first object to which the selected search result is associated belongs to a second business component, and there is a many-to-many (M-to-M) relationship between the first and second business components.

11. The method of claim 10 wherein the M-to-M relationship between the first and second business components is established via an intersection table.

12. A computer implemented method comprising:

receiving a search request from a first user, the search request containing search criteria, the search criteria including multiple search categories, each search category represented by a search category object associated with one or more search indices from one or more databases;

performing a search based on the search criteria to retrieve records in a database that match the search criteria, including passing the search criteria to a virtual business component;

invoking a search business service and passing the search criteria from the virtual business component to the search business service;

invoking a search adapter to conduct a query based on the search criteria;

displaying, to the first user, a list of search results based on retrieved records;

displaying details of the search result to the first user in response to the first user'"'"'s selection of a selected search result in the list of search results for preview;

determining whether the selected search result is a database record or an external document;

if the selected search result is a database record, displaying details of the selected search result to the first user in a predefined view associated with a search category included in the search criteria;

in response to the first user'"'"'s request to associate the selected search result to a first object of a set of defined objects, associating the selected search result to the first object; and

displaying the first object and the selected search result in a predefined view for the first user to review the association between the first object and the selected search result.

13. The method of claim 12 wherein the search criteria includes at least one search category, at least one search keyword, and a set of access control rules.

14. The method of claim 12 wherein the search criteria includes at least one search category, at least one search keyword, and at least one filter search specification.

15. A computer implemented method comprising:

receiving a search request from a first user, the search request containing search criteria, the search criteria including multiple search categories, each search category represented by a search category object associated with one or more search indices from one or more databases;

performing a search based on the search criteria to retrieve records in a database that match the search criteria, including passing the search criteria to a virtual business component;

invoking a search business service and passing the search criteria from the virtual business component to the search business service;

invoking a search adapter to conduct a query based on the search criteria;

displaying a list of search results based on the retrieved records to the first user;

displaying details of the search result to the first user in response to the first user'"'"'s selection of a selected search result in the list of search results for preview;

determining whether the selected search result is a database record or an external document;

if the selected search result is a database record, displaying details of the selected search result in a predefined view associated with a search category included in the search criteria;

in response to the first user'"'"'s request to associate the selected search result to a first object of a set of defined objects, associating the selected search result to the first object; and

displaying the first object and the selected search result in a predefined view for the first user to review the association between the first object and the selected search result,

wherein the selected search result belongs to a first business component, the first object to which the selected search result is associated belongs to a second business component, and there is a many-to-many (M-to-M) relationship between the first and second business components, wherein the M-to-M relationship between the first and second business components is established via an intersection table.

16. A computer implemented method comprising:

receiving a search request from a first user, the search request containing search criteria, the search criteria including multiple search categories, each search category represented by a search category object associated with one or more search indices from one or more databases;

performing a search based on the search criteria to retrieve records in a database that match the search criteria, including passing the search criteria to a virtual business component;

invoking a search business service and passing the search criteria from the virtual business component to the search business service;

invoking a search adapter to conduct a query based on the search criteria;

caching the search results in a search business service until termination of a user session to maintain persistency of the search results until termination of the user session;

displaying a list of search results based on the retrieved records to the first user;

displaying details of the search result to the first user in response to the first user'"'"'s selection of a selected search result in the list of search results for preview;

determining whether the selected search result is a database record or an external document;

if the selected search result is a database record, displaying details of the selected search result in a predefined view associated with a search category included in the search criteria;

in response to the first user'"'"'s request to associate the selected search result to a first object of a set of defined objects, associating the selected search result to the first object; and

displaying the first object and the selected search result in a predefined view for the first user to review the association between the first object and the selected search result,

wherein the selected search result belongs to a first business component, the first object to which the selected search result is associated belongs to a second business component, and there is a many-to-many (M-to-M) relationship between the first and second business components, wherein the M-to-M relationship between the first and second business components is established via an intersection table.