ThoughtSpot has patented a method for query generation by merging subqueries based on common join graphs and grouping columns. The system transforms incompatible data requests into structured queries, merging subquery portions for efficient database analysis. GlobalData’s report on ThoughtSpot gives a 360-degree view of the company including its patenting strategy. Buy the report here.
Smarter leaders trust GlobalData
According to GlobalData’s company profile on ThoughtSpot, User behaviour analysis was a key innovation area identified from patents. ThoughtSpot's grant share as of April 2024 was 49%. Grant share is based on the ratio of number of grants to total number of patents.
Query generation based on merger of subqueries
A recently granted patent (Publication Number: US11966395B2) discloses a method and system for database analysis that involves generating query specifications in a structured data access language. The method includes obtaining data expressing a request for data in an incompatible form, transforming it into a compatible query specification, and generating database queries based on the transformed query specification. The system comprises a memory storing instructions for query generation and a processor executing these instructions to output results data in response to data requests, ensuring compatibility with the defined structured data access language.
The patent claims detail the process of determining mergeability of subquery portions based on various criteria such as the absence of filters on aggregate expressions, windowing functions, aggregate distinct functions, grouping columns, and join clauses indicating specific relationships between tables. The system further ensures that the tables involved in the subqueries are stored in the database. This innovative method and system aim to streamline database analysis processes by efficiently transforming and generating queries, ultimately enhancing data retrieval and analysis capabilities for users.
To know more about GlobalData’s detailed insights on ThoughtSpot, buy the report here.
Data Insights
From
The gold standard of business intelligence.
Blending expert knowledge with cutting-edge technology, GlobalData’s unrivalled proprietary data will enable you to decode what’s happening in your market. You can make better informed decisions and gain a future-proof advantage over your competitors.
GlobalData, the leading provider of industry intelligence, provided the underlying data, research, and analysis used to produce this article.
GlobalData Patent Analytics tracks bibliographic data, legal events data, point in time patent ownerships, and backward and forward citations from global patenting offices. Textual analysis and official patent classifications are used to group patents into key thematic areas and link them to specific companies across the world’s largest industries.
