Prosecution Insights
Last updated: April 19, 2026
Application No. 18/977,185

Whole-Query Optimization Using Program Synthesis

Final Rejection §101§103
Filed
Dec 11, 2024
Examiner
TO, BAOQUOC N
Art Unit
2154
Tech Center
2100 — Computer Architecture & Software
Assignee
Simon Fraser University Technology Licensing Office
OA Round
2 (Final)
90%
Grant Probability
Favorable
3-4
OA Rounds
2y 9m
To Grant
98%
With Interview

Examiner Intelligence

Grants 90% — above average
90%
Career Allow Rate
854 granted / 950 resolved
+34.9% vs TC avg
Moderate +8% lift
Without
With
+8.0%
Interview Lift
resolved cases with interview
Typical timeline
2y 9m
Avg Prosecution
29 currently pending
Career history
979
Total Applications
across all art units

Statute-Specific Performance

§101
25.3%
-14.7% vs TC avg
§103
28.0%
-12.0% vs TC avg
§102
18.3%
-21.7% vs TC avg
§112
8.7%
-31.3% vs TC avg
Black line = Tech Center average estimate • Based on career data from 950 resolved cases

Office Action

§101 §103
Notice of Pre-AIA or AIA Status The present application, filed on or after March 16, 2013, is being examined under the first inventor to file provisions of the AIA . 1. In response to the Office Action dated on 07/30/2025, applicant(s) amend the application as follow: Claims amended: 1, 3, 13 and 15 Claims canceled: 2 and 14 Claims newly added: none Claims pending: 1, 3-13 and 15-24 Response to Arguments 2. Applicant’s arguments with respect to claim(s) 1 and 13 have been considered but are moot because the new ground of rejection does not rely on any reference applied in the prior rejection of record for any teaching or matter specifically challenged in the argument. Claim Rejections - 35 USC § 101 3. The argument filed on 10/28/2025 has overcome the 101 rejection. Claim Rejections - 35 USC § 103 In the event the determination of the status of the application as subject to AIA 35 U.S.C. 102 and 103 (or as subject to pre-AIA 35 U.S.C. 102 and 103) is incorrect, any correction of the statutory basis (i.e., changing from AIA to pre-AIA ) for the rejection will not be considered a new ground of rejection if the prior art relied upon, and the rationale supporting the rejection, would be the same under either status. The following is a quotation of 35 U.S.C. 103 which forms the basis for all obviousness rejections set forth in this Office action: A patent for a claimed invention may not be obtained, notwithstanding that the claimed invention is not identically disclosed as set forth in section 102, if the differences between the claimed invention and the prior art are such that the claimed invention as a whole would have been obvious before the effective filing date of the claimed invention to a person having ordinary skill in the art to which the claimed invention pertains. Patentability shall not be negated by the manner in which the invention was made. The factual inquiries for establishing a background for determining obviousness under 35 U.S.C. 103 are summarized as follows: 1. Determining the scope and contents of the prior art. 2. Ascertaining the differences between the prior art and the claims at issue. 3. Resolving the level of ordinary skill in the pertinent art. 4. Considering objective evidence present in the application indicating obviousness or nonobviousness. This application currently names joint inventors. In considering patentability of the claims the examiner presumes that the subject matter of the various claims was commonly owned as of the effective filing date of the claimed invention(s) absent any evidence to the contrary. Applicant is advised of the obligation under 37 CFR 1.56 to point out the inventor and effective filing dates of each claim that was not commonly owned as of the effective filing date of the later invention in order for the examiner to consider the applicability of 35 U.S.C. 102(b)(2)(C) for any potential 35 U.S.C. 102(a)(2) prior art against the later invention. 4. Claim(s) 1, 3-4, 6-9, 13, 15-16 and 18-21 is/are rejected under 35 U.S.C. 103 as being unpatentable over PATHAK et al. (Pub. No. US 2025/0139136 A1) in view of Grosset et al. (Pub. No. 2008/0201293 A1). As to claim 1, PATHAK discloses a computer-implemented method for performing a query search to rewrite queries, the computer-implemented method comprising: receiving, by one or more processors, an input database query to perform a first database operation, wherein the first database operation would occurs within a first period of time (original query) (paragraph 0022); analyzing, by the one or more processors, the input database query to determine a set of one or more query segments of the input database query representative of the first database operation (parsing) (paragraph 0066); generating, by the one or more processors, a plurality of candidate output database queries based at least on the one or more query segments (component queries) (paragraph 0022); and Pathak does not explicitly discloses the input database query includes one or more operation indicators or one or more variables associated with the first database and determining, by the one or more processors, at least one confirmed output database query of the plurality of candidate output database queries, wherein the at least one confirmed output database query, when implemented by a computing device, causes the computing device to perform a second database operation equivalent to the first database operation within a second period of time shorter than or equal to the first period of time. However, Grosset discloses the input database query includes one or more operation indicators or one or more variables associated with the first database operation (the user 12A, for example, may interact with enterprise applications 25,26 to formulate a report and defined a query specification…) (paragraph 0040) (query specification includes one or more operation indicators or one or more variables associated with the first database operation) and determining, by the one or more processors, at least one confirmed output database query of the plurality of candidate output database queries, wherein the at least one confirmed output database query, when implemented by a computing device, causes the computing device to perform a second database operation equivalent to the first database operation within a second period of time shorter than or equal to the first period of time (the data access service may rewrite a complex DMX query as a much simpler query that returns the same data but that will take less processing time and/or consume less memory during execution) (paragraph 0035). This suggests the concept of As to claim 3, Pathak discloses the computer-implemented method of claim 1, wherein determining the at least one confirmed output database query includes: analyzing, by the one or more processors, at least some of the plurality of candidate output database queries to calculate a score for each analyzed candidate output database query (ranking) (paragraph 0043); generating, by the one or more processors, an ordered list of the plurality of candidate output database queries based on the score for each analyzed candidate output database query (ranking) (paragraph 0043); and analyzing, by the one or more processors and in accordance with the ordering, one or more of the plurality of candidate output database queries to determine the at least one confirmed output database query (ranking) (paragraph 0043). As to claim 4, Pathak discloses the computer-implemented method of claim 3, wherein the score for each analyzed candidate output database query is based at least on a number of shared semantic properties between the input database query and the corresponding candidate output database query (ranking the importance of the candidate instance-specific part) (Paragraph 0043). As to claim 6, Pathak discloses the computer-implemented method of claim 3, wherein the analyzing the one or more of the plurality of candidate output database queries occurs within a user-defined time period (the computing system 102 processes the component queries in parallel using plurality processor resources of the language model, as claimed within period of time) (paragraph 0022). As to claim 7, Pathak discloses the computer-implemented method of claim 1, further comprising: testing, by the one or more processors, each of the at least one confirmed output database query using one or more test cases to determine whether the at least one confirmed output database query and the input database query return identical outputs for the one or more test cases (such as the BERT model) to transform a combination of the original query 106 and a candidate component response to an output score that reflect an extended which the candidate component-query response answers the original query 106. In either case, the post-processing component 502 applies rules that specifies that all component-query responses having confidence scores above a prescribed threshold levels should be include in the final responses 152, or just the most relevant N component-query responses (in which N is determined parameter selected for use in a particular environment)) (paragraph 0067). As to claim 8, Pathak discloses the computer-implemented method of claim 7, wherein testing a first set of the at least one confirmed output database query occurs in parallel with determining a second set of the at least one confirmed output database query (parallel) (paragraph 0031). As to claim 9, Pathak discloses the computer-implemented method of claim 8, further comprising: determining, by the one or more processors, a third set of the at least one confirmed output database query using results of testing the first set of the at least one confirmed output database query (such as the BERT model) to transform a combination of the original query 106 and a candidate component response to an output score that reflect an extended which the candidate component-query response answers the original query 106. In either case, the post-processing component 502 applies rules that specifies that all component query responses having confidence scores above a prescribed threshold levels should be include in the final responses 152, or just the most relevant N component-query responses (in which N is determined parameter selected for use in a particular environment)) (paragraph 0067). Claim 13 is rejected under the same reason as to claim 1, Pathak discloses a system (computing system) (paragraph 0121) for performing a query search to rewrite queries, the system comprising: one or more processors (one or more processor) (paragraph 0118); and memory (memory unit) (paragraph 0121) associated with the one or more processors (one or more processor) (paragraph 0118) and storing instructions (instructions) (paragraph 0119) that, when executed, cause the one or more processor (one or more processor) (paragraph 0118) to. Claim 15 is rejected under the same reason as to claim 1. Claim 16 is rejected under the same reason as to claim 4. Claim 18 is rejected under the same reason as to claim 6. Claim 19 is rejected under the same reason as to claim 7. Claim 20 is rejected under the same reason as to claim 8. Claim 21 is rejected under the same reason as to claim 9. 5. Claim(s) 5, 10-12, 17 and 22-24 is/are rejected under 35 U.S.C. 103 as being unpatentable over Pathak et al. (Pub. No. US 2025/0139136 A1) in view of Grosset et al. (Pub. No. 2008/0201293 A1) and further in view of Dettinger et al. (Pub. No. US 2009/0006352 A1). As to claim 5, Pathak discloses the computer-implemented method of claim 3 excepting for wherein the ordered list is in order of computational cost in analyzing the at least some of the plurality of candidates. However, Fender discloses wherein the ordered list is in order of Application/Control Number: 18/977,185 Art Unit: 2154 Page 12 computational cost in analyzing the at least some of the plurality of candidates (multiple rewrites may be considered and applied to the current version of the query to generate a candidate rewritten query. An execution cost estimate of the candidate rewritten query, which reflects multiple rewrites, is then compared to the current version of the query) (paragraph 0105). This suggests wherein the ordered list is in order of computational cost in analyzing the at least some of the plurality of candidates. Therefore, it would have been obvious to one ordinary skill in the art before the effective filing date of the instant application to modify teaching of Pathak to include wherein the ordered list is in order of computational cost in analyzing the at least some of the plurality of candidates as disclosed by Dettinger to compare the query cost. Claim 17 is rejected under the same reason as to claim 5. As to claim 10, Pathak discloses he computer-implemented method of claim 7 excepting for mutating, by the one or more processors and using a predefined set of mutation rules, the input database query to generate at least one mutant database query; and generating, by the one or more processors, the one or more test cases including at least one test input for each mutant database query of the at least one mutant database query such that a mutant output for the corresponding mutant database query differs from an output of the input database query. However, Dettinger discloses mutating, by the one or more processors and using a predefined set of mutation rules, the input database query to generate at least one mutant database query; and generating, by the one or more processors, the one or more test cases including at least one test input for each mutant database query of the at least one mutant database query such that a mutant output for the corresponding mutant database query differs from an output of the input database query (non-permitted field may be removed form query conditions in the case that doing so does not without materially affect the query results (i.e., if the modified query Application/Control Number: 18/977,185 Art Unit: 2154 Page 13 returns the same result as the original query), in the case that the results of the modified query are determined to be useful despite being different from the result of the original query, and the like) (Paragraph 0052). The modified query including modified rule which applied to the query and the output is different from the original query. Therefore, it would have been obvious to one ordinary skill in the art before the effective filing date of the instant application to modify teaching of Pathak to include mutating, by the one or more processors and using a predefined set of mutation rules, the input database query to generate at least one mutant database query; and generating, by the one or more processors, the one or more test cases including at least one test input for each mutant database query of the at least one mutant database query such that a mutant output for the corresponding mutant database query differs from an output of the input database query as disclosed by Dettinger in order to test and learn from the modified query. Claim 22 is rejected under the same reason as to claim 10. As to claim 11, Pathak discloses the computer-implemented method of claim 1 excepting for verifying, by the one or more processors and using an equivalence checking algorithm, that each of the at least one confirmed output database query and the input database query return identical outputs. However, Dettinger discloses verifying, by the one or more processors and using an equivalence checking algorithm, that each of the at least one confirmed output database query and the input database query return identical outputs (non-permitted field may be removed form query conditions in the case that doing so does not without materially affect the query results (i.e., if the modified query returns the same result as the original query), in the case that the results of the modified query are determined to be useful despite being different from the result of the original query, and the like) (Paragraph 0052). This suggests checking algorithm that each of the at least one confirmed output database query and the input database query return identical outputs. Therefore, it would have been obvious to one ordinary skill in the art before the effective filing date of the instant application to modify Pathak to include checking algorithm that each of the at least one confirmed output database query and the input database query return identical outputs as disclosed by Dettinger in order to verify the candidate query perform as intended. Claim 23 is rejected under the same reason as to claim 11. As to claims 12, Pathak disclose the computer-implemented method of claim 11, wherein the verifying includes: encoding, by the one or more processors, semantics associated with one or more operation indicators in the input database query for each of the at least one confirmed output database query and the input database query; and wherein the verifying is based at least on the encoded semantics for each of the at least one confirmed output database query and the input database query (an encoder-decoder receives encode output information produced...) (paragraph 0103). Claim 24 is rejected under the same reason as to claim 12. Conclusion 6. Applicant's amendment necessitated the new ground(s) of rejection presented in this Office action. Accordingly, THIS ACTION IS MADE FINAL. See MPEP § 706.07(a). Applicant is reminded of the extension of time policy as set forth in 37 CFR 1.136(a). A shortened statutory period for reply to this final action is set to expire THREE MONTHS from the mailing date of this action. In the event a first reply is filed within TWO MONTHS of the mailing date of this final action and the advisory action is not mailed until after the end of the THREE-MONTH shortened statutory period, then the shortened statutory period will expire on the date the advisory action is mailed, and any nonprovisional extension fee (37 CFR 1.17(a)) pursuant to 37 CFR 1.136(a) will be calculated from the mailing date of the advisory action. In no event, however, will the statutory period for reply expire later than SIX MONTHS from the mailing date of this final action. Any inquiry concerning this communication or earlier communications from the examiner should be directed to BAOQUOC N TO whose telephone number is (571)272-4041. The examiner can normally be reached Mon-Fri 9AM - 6PM. Examiner interviews are available via telephone, in-person, and video conferencing using a USPTO supplied web-based collaboration tool. To schedule an interview, applicant is encouraged to use the USPTO Automated Interview Request (AIR) at http://www.uspto.gov/interviewpractice. If attempts to reach the examiner by telephone are unsuccessful, the examiner’s supervisor, Boris Gorney can be reached at 571-270-5626. The fax phone number for the organization where this application or proceeding is assigned is 571-273-8300. Information regarding the status of published or unpublished applications may be obtained from Patent Center. Unpublished application information in Patent Center is available to registered users. To file and manage patent submissions in Patent Center, visit: https://patentcenter.uspto.gov. Visit https://www.uspto.gov/patents/apply/patent-center for more information about Patent Center and https://www.uspto.gov/patents/docx for information about filing in DOCX format. For additional questions, contact the Electronic Business Center (EBC) at 866-217-9197 (toll-free). If you would like assistance from a USPTO Customer Service Representative, call 800-786-9199 (IN USA OR CANADA) or 571-272-1000. BAOQUOC N. TO Examiner Art Unit 2154 /BAOQUOC N TO/Primary Examiner, Art Unit 2154
Read full office action

Prosecution Timeline

Dec 11, 2024
Application Filed
Jul 26, 2025
Non-Final Rejection — §101, §103
Oct 28, 2025
Response Filed
Jan 10, 2026
Final Rejection — §101, §103 (current)

Precedent Cases

Applications granted by this same examiner with similar technology

Patent 12596744
MULTIMODAL SEARCH ON WEARABLE SMART DEVICES
2y 5m to grant Granted Apr 07, 2026
Patent 12561362
INFORMATION PROCESSING APPARATUS, INFORMATION PROCESSING METHOD, AND PROGRAM
2y 5m to grant Granted Feb 24, 2026
Patent 12554716
TIME SERIES DATA QUERY METHOD AND APPARATUS, ELECTRONIC DEVICE, AND STORAGE MEDIUM
2y 5m to grant Granted Feb 17, 2026
Patent 12541501
SYSTEMS AND METHODS FOR UNIFIED DATA VALIDATION
2y 5m to grant Granted Feb 03, 2026
Patent 12504928
Determining Corrective Actions for a Storage Network Based on Event Records
2y 5m to grant Granted Dec 23, 2025
Study what changed to get past this examiner. Based on 5 most recent grants.

AI Strategy Recommendation

Get an AI-powered prosecution strategy using examiner precedents, rejection analysis, and claim mapping.
Powered by AI — typically takes 5-10 seconds

Prosecution Projections

3-4
Expected OA Rounds
90%
Grant Probability
98%
With Interview (+8.0%)
2y 9m
Median Time to Grant
Moderate
PTA Risk
Based on 950 resolved cases by this examiner. Grant probability derived from career allow rate.

Sign in with your work email

Enter your email to receive a magic link. No password needed.

Personal email addresses (Gmail, Yahoo, etc.) are not accepted.

Free tier: 3 strategy analyses per month