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

Claim 15:
16. A non-transitory computer-readable storage medium that includes instructions that, when executed by a processor, facilitate performance of operations comprising:
outputting, by a database analysis system, results data responsive to a request for data, wherein outputting the results data includes:
obtaining 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, generating 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;
generating a transformed query specification by transforming the query specification, wherein transforming the query specification includes:
determining 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, generating a merged subquery portion of the transformed query specification by merging the first subquery portion with the second subquery portion;

generating 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
obtaining the results data using data output by the database in response to execution of the one or more database queries.