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:
generating a search configuration for a stored database view, the stored database view comprising a result set of a database query, the result set arranged in one or more fields of a table, the 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 stored 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. 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 hardware processor to perform operations comprising:
generating a search configuration for a stored database view, the stored database view comprising a result set of a database query, the result set arranged in one or more fields of a table, the 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.
10. The system of claim 9 , wherein the operations further comprise:
causing the generated search results to be displayed on the computing device.
11. The system of claim 9 , wherein the database query is configured to query a column-oriented database, and the stored database view comprises a column-oriented view.
12. The system of claim 9 , wherein the database query comprises a structured query language (SQL) statement.
13. The system of claim 9 , wherein the search configuration is generated in response to the database view being stored.
14. The system of claim 9 , 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.
15. The system of claim 14 , wherein the first software application is a cloud-based application, and the second software application is a cloud-based application.
16. The system of claim 9 , 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.
17. 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 hardware processor to perform operations comprising:
generating a search configuration for a stored database view, the stored database view comprising a result set of a database query, the result set arranged in one or more fields of a table, the 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.
18. The non-transitory machine-readable storage medium of claim 17 , wherein the operations further comprise:
causing the generated search results to be displayed on the computing device.
19. The non-transitory machine-readable storage medium of claim 17 , wherein the database query is configured to query a column-oriented database, and the stored database view comprises a column-oriented view.
20. The non-transitory machine-readable storage medium of claim 17 , wherein the database query comprises a structured query language (SQL) statement.