Configurable search graphical user interface and engine

• US 8,510,330 B2
• Filed: 01/21/2009
• Issued: 08/13/2013
• Est. Priority Date: 05/08/2003
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Brice, John, Phelps, James N., Kennedy, Sargent L.
• Primary Examiner(s): ALAM, SHAHID AL
• Application Number:
  US12/357,193
• Publication Number:
  US 20090132502A1
• Time in Patent Office: 1,665 Days
• Field of Search: 707/769, 707/770, 707/713, 707/783
• US Class Current: 707/770
• CPC Class Codes: G06F 16/217 Database tuning G06F16/2282 takes precedence; database performance monitoring G06F11/3409
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99939 Privileged access

Abstract

A configurable search engine is provided in which, in an embodiment, by running the search engine an administrator can configure the search options available to a user by selecting from a choice of options without writing code. The user may be able to further configure the search options. In an embodiment, the search engine combines searches of multiple tables in a manner that appears seamless to the user.

Claims

1. A data retrieval system including a configurable search engine, said system comprising:

a processor; and

a memory coupled to the processor, the memory configured to store instructions that when executed by the processor, cause the processor to;

allow a user to select for a searcher, a set of configuration settings from a plurality of configuration settings;

enable the searcher to personalize the search engine based on the set of configuration settings selected by the user,

wherein allowing the user to select the set of configuration settings comprises allowing the user to;

select, from a plurality of search engine related options, a set of search engine related options available for the searcher to personalize the search engine; and

specify an extent to which the searcher can personalize the set of search engine related options, wherein the set of search engine related options comprises;

options related to an appearance of the search engine and a function available to the searcher when performing a search; and

an option to select a set of search fields and behavior of the set of search fields available to the searcher for the search;

enable the searcher to perform the search using the search engine as personalized by the searcher, wherein the user has a first level of access and the searcher has a second level of access to the data retrieval system; and

enable the user to select other configuration settings from the plurality of configuration settings for configuring the search engine, wherein the other configuration settings comprise one or more of;

a setting to set security rules for the searcher;

a setting for specifying whether a search section of the search engine is initially collapsed or expanded when a search page is opened;

a setting for specifying whether the searcher is capable of accessing a basic or advanced search;

or

a setting for specifying a maximum number of visible rows from a search results grid that can be viewed at one time.

2. The system of claim 1 wherein, the set of search engine related options selected for the searcher further comprises:

an option for allowing the searcher to personalize initialization of a results grid, and

an option for allowing the searcher to personalize a layout of a search section of the search engine.

3. The system of claim 1, wherein the search engine includes a window for displaying a Structured Query Language (SQL) search query formed in response to the searcher inputting a search query in a location other than the window.

4. The system of claim 1, wherein the search engine is structured such that in response to a search query being entered into the search engine in a first form, the search engine converts the search query into a second form that is used for conducting the search.

5. The system of claim 4, wherein the second form is a programming language.

6. The system of claim 1 further comprising, a database that is accessible for storing and retrieving data.

7. The system of claim 6 wherein, the database stores configuration data corresponding to the plurality of configuration settings for the search engine.

8. The system of claim 7 wherein, the database stores personalization data corresponding to the personalization of the search engine by the searcher.

9. A method for providing a configurable a search engine, said method comprising:

allowing, by a computer system, a user to select for a searcher, a set of configuration settings from a plurality of configuration settings,

wherein the plurality of configuration settings comprises setting security rules for the searcher;

enabling the searcher to personalize the search engine based on the selected set of configuration settings, wherein allowing the user to select the set of configuration settings comprises;

selecting, from a plurality of search engine related options, a set of search engine related options for the searcher to personalize the search engine, and specifying an extent to which the searcher can personalize the set of search engine related options,

wherein the set of search engine related options comprises at least an option to specify a set of search fields available to the searcher for performing a search; and

providing, by the computer system, the searcher with an interface to perform searches using the search engine as personalized by the searcher, wherein the user has a first level of access and the searcher has a second level of access to the configurable search engine; and

in response to the searcher entering a search query using the interface;

searching for information about a component by using a category identification for searching a first category of information stored in a first table,

extracting a component identification from the information about the component, and

using the component identification for finding information from a second category of information stored in a second table.

10. The method of claim 9 wherein, the interface is a search page including at least a search dialog box for entering a search query, and a personalize search link that allows the searcher to personalize the search engine based on the set of configuration settings.

11. The method of claim 9, wherein the component identification is a synchronization identifier.

12. A non-transitory computer readable storage medium storing a sequence of instructions for providing a configurable search engine wherein execution of the sequence of instructions by a processor causes the processor to:

allow a user to select for a searcher, a set of configuration settings from a plurality of configuration settings;

enable the searcher to personalize the search engine based on the selected set of configuration settings, wherein allowing the user to select the set of configuration settings comprises allowing the user to;

select, from a plurality of search engine related options, a set of search engine related options available for the searcher to personalize the search engine; and

specify an extent to which the searcher can personalize the set of search engine related options, wherein the set of search engine related options comprises;

an option related to an appearance of a search engine interface of the search engine, and

an option to select a set of search fields and behavior of the set of search fields available to the searcher for the search;

enable the searcher to perform the search using the search engine as personalized by the searcher, wherein the user has a first level of access and the searcher has a second level of access to the configurable search engine; and

enable the user to select other configuration settings in the configuration portion of the search engine to configure the search engine, wherein the other configuration settings include one or more of;

a setting for security rules for the searcher;

a setting for specifying whether a search section of the search engine is initially collapsed or expanded when a search page is opened;

a setting for specifying whether the searcher is capable of accessing a basic and/or advanced search;

or

a setting for specifying a maximum number of visible rows from a search results grid that can be viewed at one time.

13. The non-transitory computer readable storage medium of claim 12 wherein the sequence of instructions further causes the processor to:

display the plurality of search engine related options to the user in a configuration portion of the search engine interface of the search engine to enable the user to select the set of search engine related options from the plurality of search engine related options; and

display the set of search engine related options to the searcher in a personalization portion of the search engine interface to enable the searcher to personalize the search engine.

14. The non-transitory computer readable storage medium of claim 12 wherein the sequence of instructions further causes the processor to:

store the set of configuration settings in a configuration data storage; and

store the personalization related settings in a personalization data storage.

15. The non-transitory computer readable storage medium of claim 12 wherein the option related to the appearance of the search engine interface allows the searcher to change the layout of a search section, or choose whether the search section initially appears in collapsed or expanded form, and wherein the option related to the set of search fields allows the searcher to choose the search fields of the set of search fields to be displayed in the results of the search or in the prompt for a search query.

16. The non-transitory computer readable storage medium of claim 12 wherein the plurality of search engine related options further comprises one or more of:

an option to allow the searcher to personalize initialization of the search results grid, an option to allow the searcher to save search criteria, or an option to allow the searcher to configure a search icon to specify the location of the search icon, icons associated with the search icon, or an action that initiates selection of the search icon.