Autocomplete of searches for data stored in multi-tenant architecture

• US 10,134,067 B2
• Filed: 07/27/2015
• Issued: 11/20/2018
• Est. Priority Date: 07/27/2015
• Status: Active Grant

• Current Assignee: Ariba Incorporated (SAP SE)
• Original Assignee: Ariba Incorporated (SAP SE)
• Inventors: Gangadharappa, Kiran, Vuppala, Raj, Shahane, Dinesh, Chavan, Harshad
• Primary Examiner(s): Cheema, Azam M
• Application Number:
  US14/809,821
• Publication Number:
  US 20170032136A1
• Time in Patent Office: 1,212 Days
• CPC Class Codes: G06F 16/3322 using system suggestions G06F16/3325 takes precedence
• CPC Class Codes: G06F 16/35 Clustering; Classification
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: G06Q 30/0603 Catalogue ordering
• CPC Class Codes: G06Q 30/0625 Directed, with specific intent or strategy

Abstract

In an example embodiment, identifications of user actions are received from a first user device, the user actions being actions related to identifying data from a multi-tenant database to view. A portion of a first search query is received from a first user device corresponding to a first tenant in a multi-tenant architecture. A list of permissions for the first user device is then obtained. A plurality of fields is retrieved from a multi-tenant database based on the portion of the first search query, the fields obtained from data stored by multiple different tenants in the multi-tenant database, the plurality of fields retrieved being limited to fields for which the first user device has permission to view. Then a plurality of autocomplete suggestions are identified from the plurality of retrieved fields, the identifying based on the user actions.

Claims

1. A method comprising:

receiving identifications of user actions from a first user device, the user actions being actions performed via a graphical user interface to identify data from a multi-tenant database to view;

receiving a portion of a first search query from a first user device corresponding to a first tenant in a multi-tenant architecture;

obtaining a list of permissions for the first user device;

extracting a plurality of autocomplete suggestions from a plurality of fields from a multi-tenant database based on the portion of the first search query, the fields obtained from data stored by multiple different tenants in the multi-tenant database, the plurality of fields from which the autocomplete suggestions are extracted being limited to fields for which the first user device has permission to view;

transmitting one or more of the plurality of autocomplete suggestions to the first user device for display in the graphical user interface and allowing for user selection of one or more of the autocomplete suggestions via the graphical user interface to complete the first search query; and

upon receipt of the completed first search query, retrieving data from the multi-tenant database in response to the first search query and transmitting the retrieved data to the first user device.

2. The method of claim 1, wherein the user actions include identifying a category of items in a catalog to view.

3. The method of claim 1, wherein the user actions include identifying a filter to be applied to items in a catalog.

4. The method of claim 1, wherein the data in the multi-tenant database includes catalogs supplied by at least two different tenants.

5. The method of claim 1, wherein the data in the multi-tenant database includes fields written in a plurality of different languages.

6. The method of claim 1, further comprising indexing data from a plurality of tenants, the indexing including creating a mapping of n-grams from a plurality of fields of the data.

7. The method of claim 1, wherein the extracting includes excluding fields from consideration that are not identified as being autocompletable.

8. A system comprising:

an indexing core executable on one or more processors, the indexing core configured to index data received from multiple tenants in a multi-tenant database; and

a search core configured to;

receive identifications of user actions from a first user device, the user actions being actions performed in a graphical user interface to identify data from a multi-tenant database to view;

receive a portion of a first search query from a first user device corresponding to a first tenant in a multi-tenant architecture;

obtain a list of permissions for the first user device;

extract a plurality of autocomplete suggestions from a plurality of fields from a multi-tenant database based on the portion of the first search query, the fields obtained from data stored by multiple different tenants in the multi-tenant database, the plurality of fields from which the autocomplete suggestions are extracted being limited to fields for which the first user device has permission to view;

transmit one or more of the plurality autocomplete suggestions to the first user device for display in the graphical user interface and allowing for user selection of one or more of the autocomplete suggestions in the graphical user interface to complete the first search query; and

upon receipt of the completed first search query, retrieve data from the multi-tenant database in response to the first search query and transmit the retrieved data to the first user device.

9. The system of claim 8, wherein the user actions and the portion of the first query are retrieved from a user interface running on the first user device.

10. The system of claim 8, wherein the extracting is performed by an eligible field retriever in the search core.

11. The system of claim 10, wherein the identification of the plurality of autocomplete suggestions is performed by an autocomplete engine in the search core.

12. The system of claim 11, wherein the indexing core is further configured to create a mapping of n-grams from a plurality of fields of the data.

13. The system of claim 12, wherein the autocomplete engine is configured to use the mapping of n-grams in the identifying of the plurality of autocomplete suggestions.

14. A non-transitory machine-readable storage medium comprising instructions which, when implemented by one or more machines, cause the one or more machines to perform operations comprising:

receiving identifications of user actions from a first user device, the user actions being actions performed via a graphical user interface to identify data from a multi-tenant database to view;

receiving a portion of a first search query from a first user device corresponding to a first tenant in a multi-tenant architecture;

obtaining a list of permissions for the first user device;

extracting a plurality of autocomplete suggestions from a plurality of fields from a multi-tenant database based on the portion of the first search query, the fields obtained from data stored by multiple different tenants in the multi-tenant database, the plurality of fields from which the autocomplete suggestions are extracted being limited to fields for which the first user device has permission to view;

transmitting one or more of the plurality of autocomplete suggestions to the first user device for display in the graphical user interface and allowing for user selection of one or more of the autocomplete suggestions via the graphical user interface to complete the first search query; and

upon receipt of the completed first search query, retrieving data from the multi-tenant database in response to the first search query and transmitting the retrieved data to the first user device.

15. The non-transitory machine-readable storage medium of claim 14, wherein the user actions include identifying a category of items in a catalog to view.

16. The non-transitory machine-readable storage medium of claim 14, wherein the user actions include identifying a filter to be applied to items in a catalog.

17. The non-transitory machine-readable storage medium of claim 14, wherein the data in the multi-tenant database includes catalogs supplied by at least two different tenants.

18. The non-transitory machine-readable storage medium of claim 14, wherein the data in the multi-tenant database includes fields written in a plurality of different languages.

19. The non-transitory machine-readable storage medium of claim 14, further comprising indexing data from a plurality of tenants, the indexing including creating a mapping of n-grams from a plurality of fields of the data.

20. The non-transitory machine-readable storage medium of claim 14, wherein the extracting includes excluding fields from consideration that are not identified as being autocompletable.