Enterprise search using database views
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.
1. A computer-implemented method performed by a computer system having a memory and at least one hardware processor, the computer-implemented method comprising:
receiving a database query;
generating a database view based on the database query, the database view comprising a result set of the database query, the result set arranged in one or more fields of a table;
storing the database view;
generating a 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 search configuration;
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; and
generating search results for the enterprise search query based on the one or more terms of the enterprise search query using the stored search configuration to access data in the one or more fields of the table of the stored database view.
2. The computer-implemented method of claim 1 , further comprising:
causing the generated search results to be displayed on the computing device.
3. The computer-implemented method of claim 1 , wherein the database query is configured to query a column-oriented database, and the database view comprises a column-oriented view.
4. The computer-implemented method of claim 1 , wherein the database query comprises a structured query language (SQL) statement.
5. The computer-implemented method of claim 1 , wherein the search configuration is generated in response to the database view being stored.
6. The computer-implemented method of claim 1 , wherein the database query is received via a first software application, and the enterprise search query is received via a second software application different from the first software application.
7. The computer-implemented method of claim 6 , wherein the first software application is a cloud-based application, and the second software application is a cloud-based application.
8. 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 table of the stored database view corresponding to the stored search configuration.
9. The computer-implemented method of claim 1 , wherein:
the generating of the database view comprises determining the result set of the database query via a multi-tenancy architecture based on a tenant identification from which the database query was received; and
the generating of the search configuration is based on the tenant identification.
10. 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 database query;
generating a database view based on the database query, the database view comprising a result set of the database query, the result set arranged in one or more fields of a table;
storing the database view;
generating a 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 search configuration;
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; and
generating search results for the enterprise search query based on the one or more terms of the enterprise search query using the stored search configuration to access data in the one or more fields of the table of the stored database view.
11. The system of claim 10 , wherein the operations further comprising:
causing the generated search results to be displayed on the computing device.
12. The system of claim 10 , wherein the database query is configured to query a column-oriented database, and the database view comprises a column-oriented view.
13. The system of claim 10 , wherein the database query comprises a structured query language (SQL) statement.
14. The system of claim 10 , wherein the search configuration is generated in response to the database view being stored.
15. The system of claim 10 , wherein the database query is 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 10 , wherein the generated search results for the enterprise search query comprise the accessed data from the one or more fields of the table of the stored database view corresponding to the stored search configuration.
18. The system of claim 10 , wherein:
the generating of the database view comprises determining the result set of the database query via a multi-tenancy architecture based on a tenant identification from which the database query was received; and
the generating of the search configuration is based on the tenant identification.
19. 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 database query;
generating a database view based on the database query, the database view comprising a result set of the database query, the result set arranged in one or more fields of a table;
storing the database view;
generating a 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 search configuration;
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; and
generating search results for the enterprise search query based on the one or more terms of the enterprise search query using the stored search configuration to access data in the one or more fields of the table of the stored database view.
20. The non-transitory machine-readable storage medium of claim 19 , wherein the operations further comprise:
causing the generated search results to be displayed on the computing device.