Metadata search for remote applications
The present disclosure pertains to systems and methods for providing search results. A database server can include both a database and a search engine. The database server can receive, from a software service server, storage metadata indicating a plurality of tables of the database and fields of each of the plurality of tables. The database can generate a metadata search index, including tables and fields populated based on the storage metadata, and store it on the database. The database server may receive a search request including one or more search terms from a query-building application of a remote computer. The search engine can determine search statements based on the search request and execute the search statements on a view of the stored metadata search index to obtain index search results. Metadata search results based on the index search results can be provided to the query-building application.
1. A computer-implemented method, comprising:
receiving, at a database server including a database and a search engine, storage metadata from a software service server, the storage metadata comprising an entity relationship model indicating a plurality of tables of the database and fields of each of the plurality of tables;
parsing the entity relationship model to determine the plurality of tables and the fields of each of the plurality of tables;
converting the plurality of tables and the fields of each of the plurality of tables parsed from the entity relationship model into a normalized format;
generating a metadata search index including tables and fields populated based on the plurality of tables and the fields of each of the plurality of tables parsed from the entity relationship model and converted into the normalized format;
storing the metadata search index on the database;
receiving, at the database server, a search request from a query-building application of a remote computer, the search request including one or more search terms;
determining, by the search engine, one or more search statements based on the search request;
executing, by the search engine, the one or more search statements on a view of the stored metadata search index to obtain index search results; and
providing the metadata search results based on the index search results to the query-building application.
2. The computer-implemented method of claim 1 , further comprising:
receiving a communication from the query-building application; and
sending a request for the storage metadata to the software service server in response to receiving the communication.
3. The computer-implemented method of claim 1 , wherein the index search results are data objects, wherein the method further comprises:
converting the data objects of the index search results to hypertext transfer protocol.
4. The computer-implemented method of claim 1 , wherein the software service server uses the database of the database server to store application data.
5. The computer-implemented method of claim 1 , wherein the query-building application uses the metadata search results a query for querying the database, the method further comprising:
receiving, at the database server, a query search request based on the query.
6. The computer-implemented method of claim 1 , wherein the entity relationship model indicates a storage format for an application provided by the software service server.
7. The computer-implemented method of claim 6 , wherein the conversion of the plurality of tables and the fields into the normalized format provides for federated search across the application and another application, wherein search results for the application are combinable with search results for the other application.
8. A non-transitory machine-readable medium storing a program executable by at least one processing unit of a device, the program comprising sets of instructions for:
receiving, at a database server including a database and a search engine, storage metadata from a software service server, the storage metadata comprising an entity relationship model indicating a plurality of tables of the database and fields of each of the plurality of tables;
parsing the entity relationship model to determine the plurality of tables and the fields of each of the plurality of tables;
converting the plurality of tables and the fields of each of the plurality of tables parsed from the entity relationship model into a normalized format;
generating a metadata search index including tables and fields populated based on the plurality of tables and the fields of each of the plurality of tables parsed from the entity relationship model and converted into the normalized format;
storing the metadata search index on the database;
receiving, at the database server, a search request from a query-building application of a remote computer, the search request including one or more search terms;
determining, by the search engine, one or more search statements based on the search request;
executing, by the search engine, the one or more search statements on a view of the stored metadata search index to obtain index search results; and
providing the metadata search results based on the index search results to the query-building application.
9. The non-transitory machine-readable medium of claim 8 , wherein the program further comprises sets of instructions for:
receiving a communication from the query-building application; and
sending a request for the storage metadata to the software service server in response to receiving the communication.
10. The non-transitory machine-readable medium of claim 8 , wherein the index search results are data objects, wherein the program further comprises sets of instructions for:
converting the data objects of the index search results to hypertext transfer protocol.
11. The non-transitory machine-readable medium of claim 8 , wherein the software service server uses the database of the database server to store application data.
12. The non-transitory machine-readable medium of claim 8 , wherein the query-building application uses the metadata search results a query for querying the database wherein the program further comprises sets of instructions for:
receiving, at the database server, a query search request based on the query.
13. The non-transitory machine-readable medium of claim 8 , wherein the entity relationship model indicates a storage format for an application provided by the software service server.
14. The non-transitory machine-readable medium of claim 13 , wherein the conversion of the plurality of tables and the fields into the normalized format provides for federated search across the application and another application, wherein search results for the application are combinable with search results for the other application.
15. A computer system, comprising:
one or more processors;
memory;
a database;
a search engine; and
computer program code comprising instructions, executable on said one or more processors, the computer program code configured to:
receive storage metadata from a software service server, the storage metadata comprising an entity relationship model indicating a plurality of tables of the database and fields of each of the plurality of tables;
parse the entity relationship model to determine the plurality of tables and the fields of each of the plurality of tables;
convert the plurality of tables and the fields of each of the plurality of tables parsed from the entity relationship model into a normalized format;
generate a metadata search index including tables and fields populated based on the plurality of tables and the fields of each of the plurality of tables parsed from the entity relationship model and converted into the normalized format;
store the metadata search index on the database;
receive a search request from a query-building application of a remote computer, the search request including one or more search terms;
determine, by the search engine, one or more search statements based on the search request;
execute, by the search engine, the one or more search statements on a view of the stored metadata search index to obtain index search results; and
provide the metadata search results based on the index search results to the query-building application.
16. The computer system of claim 15 , wherein the program further comprises sets of instructions for:
receiving a communication from the query-building application; and
sending a request for the storage metadata to the software service server in response to receiving the communication.
17. The computer system of claim 15 wherein the index search results are data objects, wherein the program further comprises sets of instructions for:
converting the data objects of the index search results to hypertext transfer protocol.
18. The non-transitory machine-readable medium of claim 15 , wherein the query-building application uses the metadata search results a query for querying the database wherein the program further comprises sets of instructions for:
receiving, at the database server, a query search request based on the query.
19. The computer system of claim 15 , wherein the entity relationship model indicates a storage format for an application provided by the software service server.
20. The computer system of claim 15 , wherein the conversion of the plurality of tables and the fields into the normalized format provides for federated search across the application and another application, wherein search results for the application are combinable with search results for the other application.