Search integration

• US 10,255,320 B1
• Filed: 01/27/2015
• Issued: 04/09/2019
• Est. Priority Date: 01/27/2014
• Status: Active Grant

• Current Assignee: Microstrategy Incorporated
• Original Assignee: Microstrategy Incorporated
• Inventors: Cappiello, Scott
• Primary Examiner(s): Burke, Jeff A
• Assistant Examiner(s): Nguyen, Cindy
• Application Number:
  US14/606,178
• Time in Patent Office: 1,533 Days
• CPC Class Codes: G06F 16/245 Query processing

Abstract

Search integration is described. The actions include receiving, by one or more processors, a query. The actions include identifying search results that are responsive to the query. The actions include identifying, based on the query and the search results, structured data to supplement the search results, wherein the structured data is generated from binary table data that is received and deserialized by one or more processing modules. The actions include processing the structured data and the search results. The actions include providing, for output, the processed search results and the processed structured data results.

Claims

1. A computer-implemented method comprising:

receiving, by a computing device, a query;

identifying, by the computing device, search results that are responsive to the query;

based on the query and the search results, identifying, by the computing device, structured data that supplements the search results;

determining, by a listening module of the computing device, that the structured data is ready for transmission to the computing device;

providing, by the listening module of the computing device and to a receiving module of the computing device, data identifying a port on which to receive the structured data;

receiving, by the receiving module of the computing device through the port identified by the listening module, the structured data;

determining, by the receiving module of the computing device, that the structured data is likely free of errors by calculating a checksum of the structured data;

in response to determining that the structured data is likely free of errors, decompressing, by the decompress module of the computing device, the structured data;

deserializing, by a deserialize module of the computing device, the decompressed structured data;

after deserializing the decompressed structured data, determining, by the computing device, a first processing load of an in-memory engine and a second processing load of the computing device;

based on the first processing load of the in-memory engine and the second processing load of the computing device, determining an initial portion of the deserialized structured data and the search results to be processed by the in-memory engine to balance processing loads of the in-memory engine and the computing device;

processing, by the computing device, a remaining portion of the deserialized structured data and the search results; and

providing, by the computing device and for output to the in-memory engine, the processed remaining portion of the search results and the deserialized structured data and the initial portion of the deserialized structured data and the search results.

2. The method of claim 1, wherein the query is a natural language query.

3. The method of claim 1, wherein the query is received through a dashboard application.

4. The method of claim 1, wherein processing the structured data and the search results includes:

performing analytics, filtering, aggregation, wrangling, searching, data mining, text analytics, on demand loading, incremental refreshing, streaming, data blending, complex ETL workflows, or multi-sourcing.

5. The method of claim 1, wherein identifying search results that are responsive to the query comprises:

identifying, using a search index, search results that are responsive to the query.

6. A system comprising:

one or more computers and one or more storage devices storing instructions that are operable, when executed by the one or more computers, to cause the one or more computers to perform operations comprising;

receiving, by a computing device, a query;

identifying, by the computing device, search results that are responsive to the query;

based on the query and the search results, identifying, by the computing device, structured data that supplements the search results;

determining, by a listening module of the computing device, that the structured data is ready for transmission to the computing device;

providing, by the listening module of the computing device and to a receiving module of the computing device, data identifying a port on which to receive the structured data;

receiving, by the receiving module of the computing device through the port identified by the listening module, the structured data;

determining, by the receiving module of the computing device, that the structured data is likely free of errors by calculating a checksum of the structured data;

in response to determining that the structured data is likely free of errors, decompressing, by the decompress module of the computing device, the structured data;

deserializing, by a deserialize module of the computing device, the decompressed structured data;

after deserializing the decompressed structured data, determining, by the computing device, a first processing load of an in-memory engine and a second processing load of the computing device;

based on the first processing load of the in-memory engine and the second processing load of the computing device, determining an initial portion of the deserialized structured data and the search results to be processed by the in-memory engine to balance processing loads of the in-memory engine and the computing device;

processing, by the computing device, a remaining portion of the deserialized structured data and the search results; and

providing, by the computing device and for output to the in-memory engine, the processed remaining portion of the search results and the deserialized structured data and the initial portion of the deserialized structured data and the search results.

7. The system of claim 6, wherein the query is a natural language query.

8. The system of claim 6, wherein the query is received through a dashboard application.

9. The system of claim 6, wherein processing the structured data and the search results includes:

performing analytics, filtering, aggregation, wrangling, searching, data mining, text analytics, on demand loading, incremental refreshing, streaming, data blending, complex ETL workflows, or multi-sourcing.

10. The system of claim 6, wherein identifying search results that are responsive to the query comprises:

identifying, using a search index, search results that are responsive to the query.

11. A non-transitory computer-readable medium storing software comprising instructions executable by one or more computers which, upon such execution, cause the one or more computers to perform operations comprising:

receiving, by a computing device, a query;

identifying, by the computing device, search results that are responsive to the query;

based on the query and the search results, identifying, by the computing device, structured data that supplements the search results;

determining, by a listening module of the computing device, that the structured data is ready for transmission to the computing device;

providing, by the listening module of the computing device and to a receiving module of the computing device, data identifying a port on which to receive the structured data;

receiving, by the receiving module of the computing device through the port identified by the listening module, the structured data;

determining, by the receiving module of the computing device, that the structured data is likely free of errors by calculating a checksum of the structured data;

in response to determining that the structured data is likely free of errors, decompressing, by the decompress module of the computing device, the structured data;

deserializing, by a deserialize module of the computing device, the decompressed structured data;

after deserializing the decompressed structured data, determining, by the computing device, a first processing load of an in-memory engine and a second processing load of the computing device;

based on the first processing load of the in-memory engine and the second processing load of the computing device, determining an initial portion of the deserialized structured data and the search results to be processed by the in-memory engine to balance processing loads of the in-memory engine and the computing device;

processing, by the computing device, a remaining portion of the deserialized structured data and the search results; and

providing, by the computing device and for output to the in-memory engine, the processed remaining portion of the search results and the deserialized structured data and the initial portion of the deserialized structured data and the search results.