Enterprise search using database views

Patent metadata

Field	Value
Publication number	US-11334585-B2
Application number	US-201916720684-A
Country	US
Kind code	B2
Filing date	Dec 19, 2019
Priority date	Dec 19, 2019
Publication date	May 17, 2022
Grant date	May 17, 2022

Abstract

Techniques for implementing enterprise search using database views are disclosed. In some example embodiments, a computer-implemented method comprises: receiving database queries; generating, for each database query, a corresponding database view comprising a result set arranged in one or more fields of a table; storing the corresponding database views of the database queries; generating a corresponding search configuration for each one of the stored database views, the corresponding search configuration indicating the field(s) of the table of the stored database view; storing the corresponding search configurations for the stored database views; receiving an enterprise search query comprising one or more terms entered via a full-text search field; generating search results for the enterprise search query based on the term(s) using the stored search configurations to access data in the field(s) of the tables of the stored database views; and causing the generated search results to be displayed.

First claim

What is claimed is:

1. A computer-implemented method comprising:
receiving, by at least one hardware processor, a plurality of database queries;
for each database query in the plurality of database queries, generating, by the at least one hardware processor, a corresponding database view based on the database query, the corresponding database view comprising a result set of the database query, the result set arranged in one or more fields of a table;
storing, by the at least one hardware processor, the corresponding database views of the plurality of database queries;
for each one of the stored database views, generating, by the at least one hardware processor, a corresponding search configuration for the stored database view, the corresponding search configuration indicating the one or more fields of the table of the stored database view;
storing, by the at least one hardware processor, the corresponding search configurations for the stored database views;
receiving, by the at least one hardware processor, an enterprise search query from a computing device, the enterprise search query comprising one or more terms entered via a full-text search field;
generating, by the at least one hardware processor, search results for the enterprise search query based on the one or more terms of the enterprise search query using the stored search configurations to access data in the one or more fields of the tables of the stored database views corresponding to the stored search configurations; and
causing, by the at least one hardware processor, the generated search results to be displayed on the computing device.

2. The computer-implemented method of claim 1 , wherein each one of the plurality of database queries is configured to query a column-oriented database, and the corresponding database views of the plurality of database queries each comprise a corresponding column-oriented view.

3. The computer-implemented method of claim 1 , wherein each one of the plurality of database queries comprises a corresponding structured query language (SQL) statement.

4. The computer-implemented method of claim 1 , wherein each one of the search configurations is generated in response to the database view corresponding to the search configuration being stored.

5. The computer-implemented method of claim 1 , wherein the plurality of database queries are received via a first software application, and the enterprise search query is received via a second software application different from the first software application.

6. The computer-implemented method of claim 5 , wherein the first software application is a cloud-based application, and the second software application is a cloud-based application.

7. The computer-implemented method of claim 1 , wherein the generated search results for the enterprise search query comprise the accessed data from the one or more fields of the tables of the stored database views corresponding to the stored search configurations.

8. The computer-implemented method of claim 1 , wherein:
the generating of the corresponding database view comprises determining the result set of the corresponding database query via a multi-tenancy architecture based on a tenant identification from which the corresponding database query was received; and
the generating of the corresponding search configuration is based on the tenant identification.

9. The computer-implemented method of claim 1 , wherein:
the generating of the corresponding database view comprises determining the result set of the corresponding database query based on one or more end user extension fields of the corresponding database query; and
the generating of the corresponding search configuration is based on the one or more end user extension fields.

10. The computer-implemented method of claim 1 , wherein the search results for the enterprise search query are based on a determined based on a role of an end user from which the corresponding enterprise search query is received, the enterprise search results being filtered based on the role of the end user.

11. A system comprising:
at least one hardware processor; and
a non-transitory computer-readable medium storing executable instructions that, when executed, cause the at least one processor to perform operations comprising:
receiving a plurality of database queries;
for each database query in the plurality of database queries, generating a corresponding database view based on the database query, the corresponding database view comprising a result set of the database query, the result set arranged in one or more fields of a table;
storing the corresponding database views of the plurality of database queries;
for each one of the stored database views, generating a corresponding search configuration for the stored database view, the corresponding search configuration indicating the one or more fields of the table of the stored database view;
storing the corresponding search configurations for the stored database views;
receiving an enterprise search query from a computing device, the enterprise search query comprising one or more terms entered via a full-text search field;
generating search results for the enterprise search query based on the one or more terms of the enterprise search query using the stored search configurations to access data in the one or more fields of the tables of the stored database views corresponding to the stored search configurations; and
causing the generated search results to be displayed on the computing device.

12. The system of claim 11 , wherein each one of the plurality of database queries is configured to query a column-oriented database, and the corresponding database views of the plurality of database queries each comprise a corresponding column-oriented view.

13. The system of claim 11 , wherein each one of the plurality of database queries comprises a corresponding structured query language (SQL) statement.

14. The system of claim 11 , wherein each one of the search configurations is generated in response to the database view corresponding to the search configuration being stored.

15. The system of claim 11 , wherein the plurality of database queries are received via a first software application, and the enterprise search query is received via a second software application different from the first software application.

16. The system of claim 15 , wherein the first software application is a cloud-based application, and the second software application is a cloud-based application.

17. The system of claim 11 , wherein the generated search results for the enterprise search query comprise the accessed data from the one or more fields of the tables of the stored database views corresponding to the stored search configurations.

18. A non-transitory machine-readable storage medium, tangibly embodying a set of instructions that, when executed by at least one hardware processor, causes the at least one processor to perform operations comprising:
receiving a plurality of database queries;
for each database query in the plurality of database queries, generating a corresponding database view based on the database query, the corresponding database view comprising a result set of the database query, the result set arranged in one or more fields of a table;
storing the corresponding database views of the plurality of database queries;
for each one of the stored database views, generating a corresponding search configuration for the stored database view, the corresponding search configuration indicating the one

Assignees

• Sap Se

Inventors

• Pantar Aravinda
• Tatzel Steffen

Classifications

• A23L33/20

  Reducing nutritive value; Dietetic products with reduced nutritive value · CPC title

• A23L33/135

  Bacteria or derivatives thereof, e.g. probiotics · CPC title

• A23L29/269

  of microbial origin, e.g. xanthan or dextran · CPC title

• A23L2/68

  Acidifying substances · CPC title

• A23L2/60

  Sweeteners · CPC title