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

• US 7,467,133 B2
• Filed: 06/14/2004
• Issued: 12/16/2008
• 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:
  US10/867,930
• Publication Number:
  US 20070118504A1
• Time in Patent Office: 1,646 Days
• Field of Search: 707/1, 707/3, 707/10, 707/100
• US Class Current: 1/1
• 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:

providing a set of predetermined search categories for display to a user;

associating each predetermined search category of the set of predetermined search categories with a corresponding indexed set of records by;

generating a first indexed set of records corresponding to a first predetermined search category, wherein said generating the first indexed set of records comprises

selecting one or more fields of a database table,

generating a search table corresponding to the database table, wherein

columns of the search table correspond to the selected one or more fields, and

adding a visibility column to the search table, wherein

the visibility column comprises one or more identifiers of organizations authorized to access each record in the search table;

receiving, from the user, selection of a selected search category and a search key for searching;

generating a query comprising the search key and an organizational identifier of the user;

performing the query on an indexed set of records corresponding to the selected search category; and

providing results of said performing the query to the user.

2. The method of claim 1 wherein said performing the query further comprises:

selecting a subset of the indexed set of records by comparing the organizational identifier of the user with the one or more organizational identifiers associated with each record; and

searching the subset of the indexed set of records using the search key.

3. The method of claim 1 wherein the results of said performing the query comprise data stored in records of the indexed set of records selected by said searching.

4. The method of claim 1 wherein the results of said performing the query comprise data pointed to by records of the indexed set of records selected by said searching.

5. An apparatus comprising:

means for providing a set of predetermined search categories for display to a user;

means for associating each predetermined search category of the set of predetermined search categories with a corresponding indexed set of records that further comprises

means for generating a first indexed set of records corresponding to a first predetermined search category, wherein said means for generating the first indexed set of records comprises

means for selecting one or more fields of a database table,

means for generating a search table corresponding to the database table, wherein

columns of the search table correspond to the selected one or more fields, and

means for adding a visibility column to the search table, wherein

the visibility column comprises one or more identifiers of organizations authorized to access each record in the search table;

means for receiving, from the user, selection of a selected search category and a search key for searching;

means for generating a query comprising the search key and an organizational identifier of the user;

means for performing the query on an indexed set of records corresponding to the selected search category; and

means for providing results of said means for performing the query to a user.

6. The apparatus of claim 5 wherein said means for performing the query further comprises:

means for selecting a subset of the indexed set of records by comparing the organizational identifier of the user with the one or more organizational identifiers associated with each record; and

means for searching the subset of the indexed set of records using the search key.

7. A computer readable storage medium comprising:

a first set of instructions, executable by a processor, configured to provide a set of predetermined search categories for display to a user;

a second set of instructions, executable by the processor, configured to receive, from the user, selection of a selected search category and a search key for searching;

a third set of instructions, executable by the processor, configured to generate a query comprising the search key and an organizational identifier of the user;

a fourth set of instructions, executable by the processor, configured to perform the query on an indexed set of records corresponding to the selected search category;

a fifth set of instructions, executable by the processor, configured to provide results of said performing the query to the user;

a sixth set of instructions, executable by the processor, configured to associate each predetermined search category of the set of predetermined search categories with a corresponding indexed set of records; and

a seventh set of instructions, executable by the processor, configured to generate a first indexed set of records corresponding to a first predetermined search category, wherein the sixth set of instructions comprises

a eighth set of instructions, executable by the processor, configured to select one or more fields of a database table,

a ninth set of instructions, executable by the processor, configured to generate a search table corresponding to the database table, wherein

columns of the search table correspond to the selected one or more fields, and

a tenth set of instructions, executable by the processor, configured to add a visibility column to the search table, wherein

the visibility column comprises one or more identifiers of organizations authorized to access each record in the search table.

8. The computer readable storage medium of claim 7 wherein the fourth set of instructions further comprises:

an eleventh set of instructions, executable by the processor, configured to select a subset of the indexed set of records by comparing the organizational identifier of the user with the one or more organizational identifiers associated with each record; and

a twelfth set of instructions, executable by the processor, configured to search the subset of the indexed set of records using the search key.

9. The computer readable storage medium of claim 7 further comprising:

a thirteenth set of instructions, executable by the processor, configured to provide results of the fourth set of instructions.