Prosecution Insights
Prosecution Insights
36 pending office actions • 21 art units • 34 examiners • 1 of 36 (3%) have an AI response strategy ready • 108 patents granted in the last 365 days
Based on the USPTO statutory response window for each pending office action. 36 of the docket's apps have a known mailing date; the rest are excluded from the tile counts.
Every pending office action with a known statutory deadline, placed on a days-until-due axis. Dots left of Today are overdue; the further right, the more runway. Cases that share a deadline window stack vertically. 36 of the docket's apps have a known mailing date.
Difficulty is derived from the rejection statutes on the most recent pending office action. §101-driven and multi-statute cases are graded Hard; §112-only and obviousness-type double-patenting cases are graded Easy; everything else is Medium. "Unknown" means we have not yet parsed a statute for that office action.
| Bucket | Cases |
|---|---|
| §101 only | 2 (6%) |
| §103 only | 25 (69%) |
| §102 only | 4 (11%) |
| §112 only | 2 (6%) |
| No statute on record | 3 (8%) |
How the docket's pending cases split across USPTO tech-center bands.
Manual office-action response work runs about 10 hours per case. The time-saved bands below show what IP Author's prosecution pipeline typically delivers — a conservative 20% on the low end, 35% in the middle, 50% on the high end.
| Examiner | Apps on this docket | Allow rate | Interview lift |
|---|---|---|---|
| GOFMAN, ALEX N | 2 | 68.7% | +24.6% |
| HALM, KWEKU WILLIAM | 2 | 80.2% | +12.6% |
| MENG, JAU SHYA | 1 | 79.0% | +34.8% |
| BULLOCK, JOSHUA | 1 | 82.4% | +16.4% |
| BARTLETT, WILLIAM P | 1 | 61.2% | +29.8% |
| PHAM, KHANH B | 1 | 72.3% | +15.4% |
| MORRIS, JOHN J | 1 | 60.9% | +19.7% |
| ROSTAMI, MOHAMMAD S | 1 | 66.8% | +26.1% |
| PHAM, TUAN A | 1 | 83.6% | +27.1% |
| AGHARAHIMI, FARHAD | 1 | 70.5% | +14.5% |
Cases in front of an examiner with an allow rate of 80%+ where the difficulty is Easy or Medium. The top 4 ordered by deadline are shown.
| App # | Title | Examiner | Due in |
|---|---|---|---|
| 18746644 | JOIN ELIMINATION | HALM, KWEKU WILLIAM | 163d overdue |
| 19173697 | QUERY-BASED DATABASE REDACTION | BULLOCK, JOSHUA | 28d overdue |
| 18987523 | ACTIVE INVALIDATION OF METADATA CACHE ENTRIES | PHAM, TUAN A | 8d |
| 18776918 | JOIN CONSTRAINTS FOR QUERY PROCESSING | HALM, KWEKU WILLIAM | 26d |
Multi-statute / §101-driven matters, or cases in front of an examiner with an allow rate under 30%. The top 2 ordered by deadline are shown.
| App # | Title | Examiner | Due in |
|---|---|---|---|
| 18490586 | REAL-TIME FEATURE STORE IN A DATABASE SYSTEM | MAY, ROBERT F | 86d overdue |
| 18635678 | AUTOMATIC DATA CLASSIFICATION | MOSER, BRUCE M | 61d |
Cases in front of an examiner whose interview lift is 10 percentage points or more — i.e. interviewed cases historically resolve more favorably than non-interviewed ones. The top 8 ordered by deadline are shown.
| App # | Title | Examiner | Due in |
|---|---|---|---|
| 18746644 | JOIN ELIMINATION | HALM, KWEKU WILLIAM | 163d overdue |
| 18775830 | CATALOG QUERY FRAMEWORK ON DISTRIBUTED KEY VALUE STORE | GOFMAN, ALEX N | 145d overdue |
| 18800912 | QUERY PLANS FOR ANALYTIC SQL CONSTRUCTS | GOFMAN, ALEX N | 112d overdue |
| 19021001 | SEARCH IN A DATA MARKETPLACE | ROSTAMI, MOHAMMAD S | 60d overdue |
| 18955789 | QUERY EXECUTION USING INTERMEDIATE MATERIALIZED TABLES | AGHARAHIMI, FARHAD | 30d overdue |
| 19173697 | QUERY-BASED DATABASE REDACTION | BULLOCK, JOSHUA | 28d overdue |
| 19031161 | REPLICATION OF DYNAMIC TABLES | PHAM, KHANH B | 10d overdue |
| 18987523 | ACTIVE INVALIDATION OF METADATA CACHE ENTRIES | PHAM, TUAN A | 8d |
| Art Unit | Apps |
|---|---|
| 2166 | 4 |
| 2163 | 4 |
| 2169 | 3 |
| 2154 | 3 |
| 2168 | 2 |
| 2153 | 2 |
| 2152 | 2 |
| 2495 | 2 |
| 2164 | 2 |
| 2161 | 1 |
| App # | Title | Examiner | Art Unit | Statutes | Status | Due in | AI | Filed |
|---|---|---|---|---|---|---|---|---|
| 19205210 | UNIFIED STRUCTURED AND SEMI-STRUCTURED DATA TYPES IN DATABASE SYSTEMS | MENG, JAU SHYA | 2168 | §103 | Non-Final OA | 27d | AI Ready | May 12, 2025 |
| 19173697 | QUERY-BASED DATABASE REDACTION | BULLOCK, JOSHUA | 2153 | §102 | Non-Final OA | 28d overdue | Pending | Apr 08, 2025 |
| 19094721 | MULTI-CLUSTER WAREHOUSE | BARTLETT, WILLIAM P | 2169 | Other | Non-Final OA | 16d | Pending | Mar 28, 2025 |
| 19031161 | REPLICATION OF DYNAMIC TABLES | PHAM, KHANH B | 2166 | §103 | Final Rejection | 10d overdue | Pending | Jan 17, 2025 |
| 19025658 | ZERO-COPY CLONE OF DYNAMIC TABLES | MORRIS, JOHN J | 2152 | §103 | Final Rejection | 23d | Pending | Jan 16, 2025 |
| 19021001 | SEARCH IN A DATA MARKETPLACE | ROSTAMI, MOHAMMAD S | 2154 | §103 | Non-Final OA | 60d overdue | Pending | Jan 14, 2025 |
| 18987523 | ACTIVE INVALIDATION OF METADATA CACHE ENTRIES | PHAM, TUAN A | 2163 | §103 | Final Rejection | 8d | Pending | Dec 19, 2024 |
| 18955789 | QUERY EXECUTION USING INTERMEDIATE MATERIALIZED TABLES | AGHARAHIMI, FARHAD | 2161 | §103 | Final Rejection | 30d overdue | Pending | Nov 21, 2024 |
| 18810750 | SIMILARITY-BASED LISTING RECOMMENDATIONS IN A DATA EXCHANGE | VU, BAI DUC | 2163 | §112 | Non-Final OA | 27d | Pending | Aug 21, 2024 |
| 18800912 | QUERY PLANS FOR ANALYTIC SQL CONSTRUCTS | GOFMAN, ALEX N | 2163 | §103 | Final Rejection | 112d overdue | Pending | Aug 12, 2024 |
| 18790664 | ONLINE INDEX CREATION FOR MULTI-VERSION DATABASE WITHOUT TABLE LOCKS | BAKER, IRENE H | 2152 | §103 | Non-Final OA | 91d overdue | Pending | Jul 31, 2024 |
| 18776918 | JOIN CONSTRAINTS FOR QUERY PROCESSING | HALM, KWEKU WILLIAM | 2166 | §103 | Non-Final OA | 26d | Pending | Jul 18, 2024 |
| 18775830 | CATALOG QUERY FRAMEWORK ON DISTRIBUTED KEY VALUE STORE | GOFMAN, ALEX N | 2163 | §103 | Final Rejection | 145d overdue | Pending | Jul 17, 2024 |
| 18763971 | SIGNING MESSAGES USING PUBLIC KEY CRYPTOGRAPHY AND CERTIFICATE VERIFICATION | TSANG, HENRY | 2495 | §103 | Non-Final OA | 75d | Pending | Jul 03, 2024 |
| 18746644 | JOIN ELIMINATION | HALM, KWEKU WILLIAM | 2166 | §103 | Final Rejection | 163d overdue | Pending | Jun 18, 2024 |
| 18737362 | LOGGING FROM USER-DEFINED FUNCTIONS | LI, MENG | 2437 | Other | Non-Final OA | 149d overdue | Pending | Jun 07, 2024 |
| 18668624 | QUERY GENERATION BASED ON NATURAL LANGUAGE REQUEST AND SCHEMA-RELATED CONTEXT DATA | SKHOUN, HICHAM | 2164 | §103 | Final Rejection | 77d overdue | Pending | May 20, 2024 |
| 18651501 | ENTITY-LEVEL PRIVACY IN AGGREGATION CONSTRAINTS | JOO, JOSHUA | 2445 | §102 | Final Rejection | 12d | Pending | Apr 30, 2024 |
| 18651570 | QUERY PROCESSING IN A SECURE DATA CLEAN ROOM | JOHNSON, CARLTON | 2436 | §103 | Non-Final OA | 26d | Pending | Apr 30, 2024 |
| 18637833 | REMOTE DEPLOYMENT REPLICATION USING A PLURALITY OF DATA OBJECTS | TRUONG, CAM Y T | 2169 | §103 | Non-Final OA | 147d overdue | Pending | Apr 17, 2024 |
| 18635678 | AUTOMATIC DATA CLASSIFICATION | MOSER, BRUCE M | 2154 | §101 | Final Rejection | 61d | Pending | Apr 15, 2024 |
| 18630916 | UPGRADING APPLICATIONS WITH SERVICES | ST LEGER, GEOFFREY R | 2192 | §112 | Non-Final OA | 21d | Pending | Apr 09, 2024 |
| 18622361 | MANAGING DIFFERENTIAL PRIVACY ON DATABASE SYSTEM USING POLICIES | ZHU, ZHIMEI | 2495 | §103 | Final Rejection | 19d | Pending | Mar 29, 2024 |
| 18619649 | DATA CLEANROOM COLLABORATIONS CONTROL AND MEMBERSHIP RESTRICTIONS | STRAUB, D'ARCY WINSTON | 2491 | §102 | Non-Final OA | 3d overdue | Pending | Mar 28, 2024 |
| 18618273 | REGRESSION MITIGATION USING MULTIPLE STORED PROCEDURES | ZECHER, CORDELIA P K | 2114 | Other | Non-Final OA | 113d overdue | Pending | Mar 27, 2024 |
| 18599647 | EXPORT DATA FROM TABLES INTO PARTITIONED FOLDERS ON AN EXTERNAL DATA LAKE | FERRER, JEDIDIAH P | 2153 | §103 | Final Rejection | 45d overdue | Pending | Mar 08, 2024 |
| 18427786 | TABLE DATA PROCESSING USING A CHANGE TRACKING MANAGER | CAO, PHUONG THAO | 2164 | §103 | Final Rejection | 81d overdue | Pending | Jan 30, 2024 |
| 18392385 | INEXACT TIMESTAMP RANGE MATCHING JOIN FOR TIME SERIES DATA (AS OF JOIN) | MCQUITERY, DIEDRA M | 2166 | §103 | Non-Final OA | 30d overdue | Pending | Dec 21, 2023 |
| 18525811 | DYNAMIC PIVOT IMPLEMENTATION USING OBJECT AGGREGATION | WONG, HUEN | 2168 | §103 | Final Rejection | 17d overdue | Pending | Nov 30, 2023 |
| 18490586 | REAL-TIME FEATURE STORE IN A DATABASE SYSTEM | MAY, ROBERT F | 2154 | §101 | Final Rejection | 86d overdue | Pending | Oct 19, 2023 |
| 18470585 | APPLICATION VERSIONING AND UPGRADE | UNG, LANNY N | 2197 | §103 | Non-Final OA | 149d overdue | Pending | Sep 20, 2023 |
| 18309693 | RISK BASED ALERTING AND ENTITY PRIORITIZATION DETECTION FRAMEWORK | GILLESPIE, KAMRYN JORDAN | 2408 | §103 | Non-Final OA | 114d overdue | Pending | Apr 28, 2023 |
| 18309628 | REAL-TIME AUTOMATED SECURITY SCORING | LOPEZ, MIGUEL ALEXANDER | 2496 | §102 | Non-Final OA | 83d | Pending | Apr 28, 2023 |
| 17823175 | CODE TRANSLATIONS OF RESILIENT DISTRIBUTED DATASETS IN DATABASES | HO, ANDREW N | 2169 | §103 | Final Rejection | 99d overdue | Pending | Aug 30, 2022 |
| 17897621 | SYSTEM AND METHOD FOR ESTIMATING MODEL METRICS WITHOUT LABELS | PEACH, POLINA G | 2165 | §103 | Non-Final OA | 55d | Pending | Aug 29, 2022 |
| 17673388 | EVALUATING RELIABILITY OF ARTIFICIAL INTELLIGENCE | HAN, KYU HYUNG | 2123 | §103 | Final Rejection | 44d overdue | Pending | Feb 16, 2022 |
IP Author helps IP teams respond to office actions faster with AI-generated responses, examiner analytics, and prosecution intelligence.
Start Free Trial