Search center dynamic configuration using field mappings

• US 7,979,474 B2
• Filed: 10/19/2007
• Issued: 07/12/2011
• Est. Priority Date: 10/19/2007
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Mehta, Suhas R., Gutlapalli, Hari K., Kothari, Shirish K., Pak, Wai
• Primary Examiner(s): Channavajjala; Srirama
• Assistant Examiner(s): Hosseini; Reza
• Application Number:
  US11/875,373
• Publication Number:
  US 20090106191A1
• Time in Patent Office: 1,362 Days
• Field of Search: 707/2, 707/E17.002, 707/634, 707/673, 707/696, 707706-708, 707/711, 707713-715, 707/718, 707/719, 707/726, 707739-746, 707/749, 707/755, 707/756, 707/758, 707/759, 707/761, 707/763, 707/768, 707/769, 707/780, 707/802, 707/803, 707/805, 707/825, 707/830, 707/736
• US Class Current: 707/803
• CPC Class Codes: G06F 16/284 Relational databases

Abstract

A mechanism for dynamically configuring searchable fields of interest within a search center is provided. A field mappings file is used to define relationships between searchable fields of interest in searchable objects and fields within a search index accessible to an enterprise-wide search center. The field mappings file can provide the defined relationships between searchable object fields and search index fields at runtime of a user session, thus avoiding a rigid configuration at the time of search center initialization.

Claims

1. A method comprising:

providing access to a plurality of searchable objects, wherein each searchable object comprises a plurality of fields of data;

generating a search index comprising searchable fields, wherein

the generating comprises

mapping a first searchable field among the searchable fields to a first field of a first searchable object, and to

a first field of a second searchable object, and

mapping a second searchable field among the searchable fields to

a second field of the first searchable object, and to

a second field of the second searchable object, and

the second searchable object is different from the first searchable object,

the mapping the first searchable field is defined by a field mappings file,

the mapping the second searchable field is defined by the field mappings file,

the field mappings file comprises information identifying at least one searchable object and at least one index field, and

the generating is performed at a time of a search;

modifying the field mappings file, wherein

the modifying the field mappings file is performed by at least one computer processor; and

generating a modified search index, wherein the generating the modified search index comprises

modifying one or more search index settings based at least in part on modified fields of the field mappings file.

2. The method of claim 1, wherein the modifying the field mappings file results in the generating the modified search index.

3. The method of claim 2 wherein the modifying the field mappings file comprises one or more of adding a first searchable object, removing a second searchable object, adding an index field correlated to a field in a third searchable object, and removing an index field.

4. The method of claim 1 further comprising:

formatting the field mappings file using a definitional file, wherein

the definitional file defines variables and structures comprising the field mappings file.

5. The method of claim 4, wherein

the field mappings file is an XML file, and

the definitional file is an XML DTD file.

6. The method of claim 4 wherein the field mappings file comprises the definitional file.

7. The method of claim 1 further comprising:

caching the field mappings file to preserve the searchable fields for a subsequent session.

8. The method of claim 7 further comprising:

caching the modified field mappings file in place of an original field mappings file, in response to the modifying the field mappings file.

9. The method of claim 1, wherein the mapping the first searchable field comprises:

mapping an index field name of the search index to a first object field name of the first searchable object; and

mapping the index field name of the search index to a first object field name of the second searchable object.

10. The method of claim 1, wherein the mapping the first searchable field comprises:

mapping an index field name of the search index to

a name of the first searchable object, and to

a first object field name of the first searchable object; and

mapping the index field name of the search index to

a name of the second searchable object, and to

a first object field name of the second searchable object.

11. The method of claim 1, wherein the generating is performed in response to a modification of the first searchable object.

12. The method of claim 1, wherein the generating is performed in response to a modification of a search functionality of the search index.

13. A system comprising:

an interface configured to provide access to one or more storage devices, wherein

each storage device stores one or more of a plurality of searchable objects, and

each searchable object comprises a plurality of fields of data; and

a processor, coupled to the interface, wherein

the processor is configured for generating a search index comprising searchable fields, wherein the generating comprises mapping a first searchable field among the searchable fields to

a first field of a first searchable object, and to

a first field of a second searchable object, and

mapping a second searchable field among the searchable fields to

a second field of the first searchable object, and to

a second field of the second searchable object, and

the second searchable object is different from the first searchable object,

the mapping the first searchable field is defined by a field mappings file,

the mapping the second searchable field is defined by the field mappings file,

the field mappings file comprises information identifying at least one searchable object and at least one index field, and

the generating is performed at a time of a search;

the processor is configured for modifying the field mappings file; and

the processor is configured for generating a modified search index, wherein the generating the modified search index comprises

modifying one or more search index settings based at least in

part on modified fields of the field mappings file.

14. The system of claim 13 wherein the processor is further configured to:

generate the modified search index in response to the modifying the field mappings file.

15. The system of claim 13 wherein the processor is further configured to:

format the field mappings file using a definitional file, wherein

the definitional file defines variables and structures comprising the field mappings file.

16. The system of claim 13 wherein the processor is further configured to:

cache the field mappings file to preserve the searchable fields for a subsequent session.

17. The system of claim 16 wherein the processor is further configured to:

cache the modified field mappings file in place of an original field mappings file, in response to the modifying the field mappings file.

18. A computer-readable storage medium comprising:

a first set of instructions, executable by a processor, configured to provide access to a plurality of searchable objects, wherein each searchable object comprises a plurality of fields of data; and

a second set of instructions, executable by the processor, configured for generating a search index comprising searchable fields, wherein

the second set of instructions further comprises a third set of instructions, executable by the processor, configured for

mapping a first searchable field among the searchable fields to

a first field of a first searchable object, and to

a first field of a second searchable object, and

mapping a second searchable field among the searchable fields to

a second field of the first searchable object, and to

a second field of the second searchable object, and

the second searchable object is different from the first searchable object,

the mapping the first searchable field is defined by a field mappings file,

the mapping the second searchable field is defined by the field mappings file,

the field mappings file comprises information identifying at least one searchable object and at least one index field, and

the second set of instructions are performed at a time of a search;

a fourth set of instructions, configured for modifying the field mappings file; and

instructions for generating a modified search index, comprising

instructions for modifying one or more search index settings based at least in part on modified fields of the field mappings file.

19. The computer-readable storage medium of claim 18 wherein, the modifying the field mappings file results in generating a modified search index.

20. The computer-readable storage medium of claim 18 further comprising:

a fourth set of instructions, executable by the processor, configured to format the field mappings file using a definitional file, wherein

the definitional file defines variables and structures comprising the field mappings file.

21. The computer readable storage medium of claim 18 further comprising:

a fourth set of instructions, executable by the processor, configured to cache the field mappings file to preserve the searchable fields for a subsequent session.

22. The computer readable storage medium of claim 21 further comprising:

a fifth set of instructions, executable by the processor, configured to cache the modified field mappings file in place of an original field mappings file, in response to the modifying the field mappings file.