Inpixon has been granted a patent for a method that processes queries to join distributed tables across a network. The technique involves analyzing criteria in a query, managing active flags to track entries, and utilizing identifiers for efficient data retrieval and updates during the join operation. GlobalData’s report on Inpixon gives a 360-degree view of the company including its patenting strategy. Buy the report here.
According to GlobalData’s company profile on Inpixon, Perimeter security was a key innovation area identified from patents. Inpixon's grant share as of June 2024 was 54%. Grant share is based on the ratio of number of grants to total number of patents.
Method for distributed table joins in a network
The patent US12032576B2 outlines a method for efficiently performing joins of multiple tables within a computer system. The process begins with the system receiving a query that specifies the tables to be joined. It identifies entries in a first table that meet the criteria outlined in the query and sets flags in an active flag structure to indicate which entries satisfy the criteria. The method further involves identifying foreign keys in a second table that correspond to the identified entries in the first table. A request is then generated to retrieve the relevant entries from the second table, which includes multiple separate requests. The system determines identifiers for these keys, specifying memory locations for the corresponding entries, and sends the requests accordingly. The flags in the first active flag structure are updated based on the responses received.
Additional claims detail specific aspects of the method, such as the inclusion of a "where" component in the query, the use of boolean values for flags, and the structure of the active flag as a column of bits corresponding to rows in the first table. The method also allows for remote direct memory access (RDMA) requests and specifies how identifiers can be generated using hash functions. Responses to the requests may include information about the computer nodes storing the second entries and the specific row numbers of those entries. The method ensures that flags are updated to reflect the accuracy of the data retrieved, indicating whether corresponding entries exist in the second table. Overall, this patent presents a structured approach to optimizing database queries involving multiple tables.
To know more about GlobalData’s detailed insights on Inpixon, 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.