Progress Software has been granted a patent for a method that processes queries involving distinct set and sort operations. The method includes generating a query plan that prioritizes sorting before set operations, determining resultant rows, and sending these results to a client. GlobalData’s report on Progress Software gives a 360-degree view of the company including its patenting strategy. Buy the report here.

According to GlobalData’s company profile on Progress Software, Data backup blockchains was a key innovation area identified from patents. Progress Software's grant share as of June 2024 was 70%. Grant share is based on the ratio of number of grants to total number of patents.

Query processing with prioritized sorting and set operations

Source: United States Patent and Trademark Office (USPTO). Credit: Progress Software Corp

The granted patent US12007987B1 outlines a computer-implemented method and system for processing queries that involve both set operations and sort operations on data structures. The method begins with receiving a query that specifies a set operation involving two distinct data structures and a sort operation that organizes the result set based on specified attributes from each data structure. Notably, the patent emphasizes that the sort operation is executed prior to the set operation, which is a key aspect of the query plan generation. The method further includes determining resultant rows based on the query and sending these results to a client. Additional claims detail the ability to generate multiple sets of resultant rows and the buffering and merging of these rows based on common values in the specified attributes.

Moreover, the patent specifies that the data structures can be either relational or non-relational and that the queries may utilize structured query language (SQL). The claims also cover the determination of whether the specified attributes have defined indexes, which can enhance query performance. The set operations mentioned include various types of joins, such as inner joins and outer joins. Overall, the patent presents a structured approach to efficiently handling complex queries that require sorting and set operations, potentially improving data retrieval processes in computing systems.

To know more about GlobalData’s detailed insights on Progress Software, 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

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.