G06F 16/24524
Access plan code generation and invalidation
Official title: {Access plan code generation and invalidation; Reuse of access plans}
G06F16/24524 (Access plan code generation and invalidation) appears on 321 US grants and 315 published applications in this corpus.
Search patents in G06F- Granted patents
- 321
- Published applications
- 315
- Assignees
- 112
- Inventors
- 758
- Latest grant
- 11 Aug 2026
Filings by year
| Year | Granted patents | Published applications |
|---|---|---|
| 1988 | 1 | 0 |
| 1989 | 1 | 0 |
| 1990 | 0 | 0 |
| 1991 | 0 | 0 |
| 1992 | 0 | 0 |
| 1993 | 0 | 0 |
| 1994 | 0 | 0 |
| 1995 | 0 | 0 |
| 1996 | 1 | 0 |
| 1997 | 3 | 0 |
| 1998 | 4 | 0 |
| 1999 | 3 | 0 |
| 2000 | 5 | 0 |
| 2001 | 3 | 1 |
| 2002 | 10 | 3 |
| 2003 | 3 | 3 |
| 2004 | 2 | 5 |
| 2005 | 2 | 7 |
| 2006 | 5 | 13 |
| 2007 | 3 | 7 |
| 2008 | 8 | 8 |
| 2009 | 6 | 8 |
| 2010 | 6 | 7 |
| 2011 | 9 | 8 |
| 2012 | 7 | 10 |
| 2013 | 6 | 12 |
| 2014 | 13 | 11 |
| 2015 | 12 | 16 |
| 2016 | 13 | 21 |
| 2017 | 23 | 19 |
| 2018 | 18 | 16 |
| 2019 | 19 | 23 |
| 2020 | 23 | 25 |
| 2021 | 24 | 20 |
| 2022 | 28 | 19 |
| 2023 | 20 | 14 |
| 2024 | 13 | 11 |
| 2025 | 16 | 14 |
| 2026 | 11 | 14 |
By publication year. Applications have been published since 2001. 2026 runs to 8 Oct.
Recent patents
- Systems and methods for discovery, classification, and indexing of data in a native computing system11 Aug 2026US 12,705,236 B2OneTrust, LLC
- Refusal system28 Jul 2026US 12,694,024 B2Intuit Inc.
- Analytical query processing with decoupled compute instances5 May 2026US 12,619,628 B2Snowflake Inc.
- Auditing of database search queries for privileged data14 Apr 2026US 12,602,505 B2International Business Machines Corporation
- Automatic error mitigation in database statements using alternate plans31 Mar 2026US 12,591,573 B2Oracle International Corporation
- Automatic filter binding for row-level security in database systems17 Sep 2026US 2026/0278145 A1Sap SE
- Data query method, device, system, and storage medium20 Aug 2026US 2026/0244609 A1Cloud Intelligence Assets Holding (Singapore) Private Limited
- Enhanced retrieval of structured data in fulfillment processes with ontology-based knowledge graphs20 Aug 2026US 2026/0244625 A1Target Brands, Inc.
- Adaptive data retrieval using agentic prompt processing units13 Aug 2026US 2026/0236463 A1Cisco Technology, Inc.
- Plan validation2 Jul 2026US 2026/0187063 A1Intuit Inc.
Most cited
By later US patents
- User interface for information retrieval system405US 5,768,578 ALucent Technologies Inc. · 1998
- Automated query optimization method using both global and parallel local optimizations for materialization access planning for distributed databases335US 4,769,772 AHoneywell Bull Inc. · 1988
- Method and apparatus for improving the performance of a database management system through a central cache mechanism234US 6,073,129 ABull HN Information Systems Inc. · 2000
- System, method, and program for extending a SQL compiler for handling control statements packaged with SQL query statements227US 5,875,334 AInternational Business Machines Corporation · 1999
- Shared nothing parallel execution of procedural constructs in SQL199US 6,081,801 AInternational Business Machines Corporation · 2000