Patent ID: 11966395
Assignee: THOUGHTSPOT, INC.
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 9:
10. A database analysis system, comprising:
a memory, wherein the memory stores instructions for query generation based on merger of subqueries;
a processor that executes the instruction to output results data responsive to a request for data, wherein to output the results data the processor executes the instruction to:
obtain data expressing the request for data in a first form that is incompatible with a defined structured data access language of a database;
in response to obtaining the data expressing the request for data, generate a query specification expressing the request for data in a second form that is implemented by the database analysis system and is incompatible with the defined structured data access language;
generate a transformed query specification, wherein, to generate the transformed query specification, the processor executes the instructions to transform the query specification, wherein to transform the query specification the processor executes the instructions to:
determine that a first subquery portion of the query specification is mergeable with a second subquery portion of the query specification; and
in response to determining that the first subquery portion of the query specification is mergeable with the second subquery portion of the query specification, generate a merged subquery portion of the transformed query specification, wherein, to generate the merged subquery portion, the processor executes the instructions to merge the first subquery portion with the second subquery portion;

generate one or more database queries, in a form that is compatible with the defined structured data access language, in accordance with the transformed query specification; and
obtain the results data using data output by the database in response to execution of the one or more database queries.