G06F 16/24544
Join order optimisation
Official title: {Join order optimisation}
G06F16/24544 (Join order optimisation) appears on 797 US grants and 794 published applications in this corpus.
Search patents in G06F- Granted patents
- 797
- Published applications
- 794
- Assignees
- 188
- Inventors
- 1,433
- Latest grant
- 6 Oct 2026
Filings by year
| Year | Granted patents | Published applications |
|---|---|---|
| 1994 | 2 | 0 |
| 1995 | 1 | 0 |
| 1996 | 0 | 0 |
| 1997 | 3 | 0 |
| 1998 | 7 | 0 |
| 1999 | 2 | 0 |
| 2000 | 2 | 0 |
| 2001 | 0 | 0 |
| 2002 | 8 | 5 |
| 2003 | 3 | 4 |
| 2004 | 2 | 7 |
| 2005 | 4 | 8 |
| 2006 | 4 | 13 |
| 2007 | 2 | 11 |
| 2008 | 6 | 7 |
| 2009 | 8 | 12 |
| 2010 | 11 | 8 |
| 2011 | 13 | 9 |
| 2012 | 8 | 16 |
| 2013 | 13 | 21 |
| 2014 | 22 | 48 |
| 2015 | 23 | 49 |
| 2016 | 48 | 70 |
| 2017 | 57 | 57 |
| 2018 | 59 | 71 |
| 2019 | 57 | 53 |
| 2020 | 75 | 36 |
| 2021 | 68 | 51 |
| 2022 | 61 | 48 |
| 2023 | 48 | 53 |
| 2024 | 73 | 51 |
| 2025 | 61 | 52 |
| 2026 | 46 | 34 |
By publication year. Applications have been published since 2001. 2026 runs to 8 Oct.
Recent patents
- User-centric and LLM-enhanced adaptive ETL code synthesis6 Oct 2026US 12,754,718 B2Hitachi, Ltd.
- Systems and methods for dynamic query optimization for distributed computing environments6 Oct 2026US 12,754,912 B2Elevance Health, Inc.
- Index join query optimization29 Sep 2026US 12,748,756 B2Sap SE
- Generating an optimized join tree for execution of a plurality of join operations via a database system15 Sep 2026US 12,737,359 B2Ocient Holdings LLC
- Dynamic-ledger-enabled edge-device query processing1 Sep 2026US 12,724,775 B2Strong Force Vcn Portfolio 2019, LLC
- Automatically building business intelligence models3 Sep 2026US 2026/0260200 A1Microsoft Technology Licensing, LLC
- Device and method for extracting graph27 Aug 2026US 2026/0252563 A1GraphAI Co., Ltd.
- System and method for automated path discovery of joinable tables in database backups6 Aug 2026US 2026/0228086 A1Eon IO, Ltd.
- System and method for performing join operations in digital backups of database applications6 Aug 2026US 2026/0228087 A1Eon IO, Ltd.
- Multi-parameter batch upsert statement execution30 Jul 2026US 2026/0219917 A1Sap SE
Most cited
By later US patents
- Extending the semantics of the outer join operator for un-nesting queries to a data base390US 5,412,804 AOracle Corporation · 1995
- Computer automated system and method for optimizing the processing of a query in a relational database system by merging subqueries with the query166US 5,367,675 AInternational Business Machines Corporation · 1994
- Performing sequence analysis as a multipart plan storing intermediate results as a relation147US 7,702,610 B2Netezza Corporation · 2010
- Method and apparatus for semantic discovery and mapping between data sources130US 7,426,520 B2Exeros, Inc. · 2008
- Method, system, and program for a join operation on a multi-column table and satellite tables including duplicate values125US 6,374,235 B1International Business Machines Corporation · 2002