The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Nov. 16, 2021
Filed:
Apr. 02, 2019
Thoughtspot, Inc., Sunnyvale, CA (US);
Rakesh Kothari, San Jose, CA (US);
Amit Prakash, Saratoga, CA (US);
Sandeep Kumar, Karnataka, IN;
Archit Bansal, Sunnyvale, CA (US);
Vaibhav Agarwal, Sunnyvale, CA (US);
Zhiquan Sui, Sunnyvale, CA (US);
Swati Kwatra, Sunnyvale, CA (US);
ThoughtSpot, Inc., San Jose, CA (US);
Abstract
Systems and methods for query generation based on a logical data model are described. For example, methods may include accessing a first join graph representing tables in a database; receiving a first query that references data in two or more of the tables of the database; selecting a connected subgraph of the first join graph that includes the two or more tables referenced in the first query; generating multiple leaf queries that reference respective subject tables that are each a root table of the connected subgraph or a table including a measure referenced in the first query; generating a query graph that specifies joining of results from queries based on the multiple leaf queries to obtain a transformed query result; and invoking a transformed query on the database that is based on the query graph and the queries based on the multiple leaf queries to obtain the transformed query result.