METHODS AND SYSTEMS FOR OPTIMIZING TEXT SEARCHES OVER STRUCTURED DATA IN A MULTI-TENANT ENVIRONMENT
Search systems and methods for searching structured data and enhancing the relevancy of search results provided to a requesting user or application. Enhanced search results are provided by searching a cache of a user's most recently used items to eliminate or reduce search indexing latency. Also, more relevant search results are provided by re-ranking results based on use history, data security models and/or hierarchical user role models. Further, enhanced search results are provided by including user information in the search index.
1 . A computer program product, comprising a non-transitory computer usable medium having a computer readable program code embodied therein, the computer readable program code adapted to be executed to implement a method, the method comprising:
formulating a search query including a first search parameter;
sending the search query to a query server;
searching indexed data records in a database system using the first search parameter; and
returning a plurality of matching records, based on the searching;
wherein the matching records have associated relevancy scores and are ordered in an order that is based, at least in part, on activity data associated with the matching records.
2 . The computer program product of claim 1 , wherein formulating the search query is performed by an application server in response to a specific search request received from a user system including the search parameter.
3 . The computer program product of claim 2 , wherein the indexed data records include a user ID field and/or a user role field, and wherein the search query includes one or both of a user ID and a role of the user from which the search request was received.
4 . The computer program product of claim 1 , wherein the activity data includes one of data in a last activity field and/or data in a last update field.
5 . The computer program product of claim 1 , further comprising displaying at least a portion of the search results in the order.
6 . A method, comprising:
formulating a search query including a first search parameter;
sending the search query to a query server;
searching indexed data records in a database system using the first search parameter; and
returning a plurality of matching records, based on the searching, utilizing a processor;
wherein the matching records have associated relevancy scores and are ordered in an order that is based, at least in part, on activity data associated with the matching records.
7 . The method of claim 6 , wherein the formulating the search query is performed by an application server in response to a specific search request received from a user system including the search parameter.
8 . The method of claim 7 , wherein the indexed data records include a user ID field and/or a user role field, and the search query includes one or both of a user ID and a role of the user from which the search request originated.
9 . The method of claim 6 , wherein the activity data includes one of data in a last activity field and/or data in a last update field.
10 . The method of claim 6 , further comprising displaying at least a portion of the search results in said order.
11 . An apparatus for performing a text search over structured data in a database system, comprising:
a processor for:
formulating a search query including a first search parameter;
sending the search query to a query server;
searching indexed data records in a database system using the first search parameter; and
returning a plurality of matching records, based on the searching;
wherein the system is operable such that the matching records have associated relevancy scores and are ordered in an order that is based, at least in part, on activity data associated with the matching records.
12 . The apparatus of claim 11 , wherein the formulating the search query is performed by an application server in response to a specific search request received from a user system including the search parameter.
13 . The apparatus of claim 12 , wherein the indexed data records include a user ID field and/or a user role field, and the search query includes one or both of a user ID and a role of the user from which the search request originated.
14 . The apparatus of claim 11 , wherein the activity data includes one of data in a last activity field and/or data in a last update field.
15 . The apparatus of claim 11 , wherein the processor is further for displaying at least a portion of the search results in said order.