Method, apparatus, and system for searching based on search visibility rules

• US 7,962,446 B2
• Filed: 09/10/2007
• Issued: 06/14/2011
• Est. Priority Date: 06/18/2001
• Status: Expired due to Term

• Current Assignee: Siebel Systems Inc. (Oracle Corporation)
• Original Assignee: Siebel Systems Inc. (Oracle Corporation)
• Inventors: Subramaniam, Pavitra, Ying, Jian-Jung, Zoss, Jason, Caltabiano, Marc
• Primary Examiner(s): AL HASHEMI, SANA A
• Application Number:
  US11/852,764
• Publication Number:
  US 20070299813A1
• Time in Patent Office: 1,373 Days
• Field of Search: 707/610, 707/692, 707/752
• US Class Current: 707/610
• CPC Class Codes: G06F 16/2423 Interactive query statement specification based on a database schema
• CPC Class Codes: G06F 16/2457 with adaptation to user needs
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: G06F 2221/2141 Access rights, e.g. capability lists, access control lists, access tables, access matrices
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99942 Manipulating data structure, e.g. compression, compaction, compilation
• CPC Class Codes: Y10S 707/99943 Generating database or data structure, e.g. via user interface
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing

Abstract

According to one aspect of the present invention, a method is provided in which a search request containing search criteria is received from a first user. A search is performed based upon the search criteria and the first user'"'"'s organizational identifier to identify data records that match the search criteria and to which the first user is allowed to access based upon the first user'"'"'s organizational identifier. In another embodiment, a search is performed based upon the search criteria and a list of categories to which the first user is authorized to access to identify records that match the search criteria and to which the first user is allowed to access based upon the list of categories.

Claims

1. A method comprising:

selecting a database table to be indexed, wherein

the database table comprises a database record, and

the database record comprises

a data element, and

a plurality of organizational identifiers, wherein each organizational identifier indicates a visibility permission to an organization for the data element;

generating, using a processor, an indexed set of records comprising information from the database table, wherein

for each of the organizational identifiers in the database record,

the indexed set of records comprises a corresponding indexed record that comprises the data element of the database record, and the organizational identifier;

associating the indexed set of records with a search category; and

associating the search category with one or more organizational identifiers.

3. The method of claim 1 wherein said generating the indexed set of records comprises:

selecting one or more fields from the database table to be indexed; and

including information from the one or more selected fields of the database table in the indexed set of records.

4. The method of claim 1 wherein the search category is selected from a set of search categories.

5. The method of claim 1 further comprising:

creating the search category.

6. The method of claim 1 further comprising:

associating the search category with a catalog comprising a plurality of search categories,

wherein

the plurality of search categories share a common characteristic.

11. The method of claim 4 further comprising:

associating each record of the database table with each corresponding search category from the set of search categories prior to said generating.

12. The method of claim 4 further comprising:

providing a listing of available search categories to a user, wherein

the listing of available search categories comprises the search category only if an organizational identifier associated with the user matches the organizational identifier associated with the search category.

13. The method of claim 6 wherein the common characteristic is the one or more organizational identifiers.

17. The method of claim 13 further comprising:

providing a listing of catalogs to a user, wherein

the listing comprises the catalog if an organizational identifier of the user matches an organizational identifier of the one or more organizational identifiers associated with the catalog.

2. A machine-readable medium comprising a set of instructions executable by one or more processors, the set of instructions comprising:

instructions configured to select a database table to be indexed, wherein

the database table comprises a database record, and

the database record comprises

a data element, and

a plurality of organizational identifiers, wherein each organizational identifier indicates a visibility permission to an organization for the data element;

instructions, executable on a processor, configured to generate an indexed set of records comprising information from the database table, wherein for each of the organizational identifiers in the database record,

the indexed set of records comprises a corresponding indexed record that comprises the data element of the database record, and the organizational identifier;

instructions configured to associate the indexed set of records with a search category; and

instructions configured to associate the search category with one or more organizational identifiers.

7. The machine-readable medium of claim 2 wherein said set of instructions comprises:

instructions configured to select one or more fields from the database table to be indexed; and

instructions configured to include information from the one or more selected fields of the database table in the indexed set of records.

8. The machine-readable medium of claim 2 wherein the search category is selected from a set of search categories.

9. The machine-readable medium of claim 2 wherein said set of instructions comprises:

instructions configured to create the search category.

10. The machine-readable medium of claim 2 wherein said set of instructions comprises:

instructions configured to associate the search category with a catalog comprising a plurality of search categories, wherein

the plurality of search categories share a common characteristic.

14. The machine-readable medium of claim 8 wherein said set of instructions comprises:

instructions configured to associate each record of the database table with each corresponding search category from the set of search categories prior to generation of the indexed set of records.

15. The machine-readable medium of claim 8 wherein said set of instructions comprises:

instructions configured to provide a listing of available search categories to a user, wherein

the listing of available search categories comprises the search category only if an organizational identifier associated with the user matches the organizational identifier associated with the search category.

16. The machine-readable medium of claim 10 wherein the common characteristic is the one or more organizational identifiers.

18. The machine-readable medium of claim 16 wherein said set of instructions comprises:

instructions configured to provide a listing of catalogs to a user, wherein the listing comprises the catalog if an organizational identifier of the user matches an organizational identifier of the one or more organizational identifiers associated with the catalog.