Prosecution Insights
Last updated: July 17, 2026
Application No. 18/647,728

NOISY AGGREGATES IN A QUERY PROCESSING SYSTEM

Non-Final OA §102
Filed
Apr 26, 2024
Priority
Apr 28, 2023 — provisional 63/499,040
Examiner
IDOWU, OLUGBENGA O
Art Unit
Tech Center
Assignee
Snowflake Inc.
OA Round
1 (Non-Final)
71%
Grant Probability
Favorable
1-2
OA Rounds
1y 1m
Est. Remaining
90%
With Interview

Examiner Intelligence

Grants 71% — above average
71%
Career Allowance Rate
464 granted / 650 resolved
+11.4% vs TC avg
Strong +19% interview lift
Without
With
+19.1%
Interview Lift
resolved cases with interview
Typical timeline
3y 3m
Avg Prosecution
25 currently pending
Career history
677
Total Applications
across all art units

Statute-Specific Performance

§101
0.5%
-39.5% vs TC avg
§103
82.5%
+42.5% vs TC avg
§102
14.8%
-25.2% vs TC avg
§112
0.5%
-39.5% vs TC avg
Black line = Tech Center average estimate • Based on career data from 650 resolved cases

Office Action

§102
DETAILED ACTION 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 . Claim Rejections - 35 USC § 102 The following is a quotation of the appropriate paragraphs of 35 U.S.C. 102 that form the basis for the rejections under this section made in this Office action: A person shall be entitled to a patent unless – (a)(1) the claimed invention was patented, described in a printed publication, or in public use, on sale, or otherwise available to the public before the effective filing date of the claimed invention. Claim(s) 1 – 20 are rejected under 35 U.S.C. 102(a)(1) as being anticipated by Krieger, 2022/0121767. As per claim 1, Krieger teaches a method comprising: receiving a query directed at a shared dataset, the query identifying a operation (access request, [0025]); accessing, by at least one hardware processor, a set of data from the shared dataset to perform the operation, the set of data comprising data accessed from a table of the shared dataset (dataset including rows and columns, [0020]); determining that an aggregation constraint policy is attached to the table, the aggregation constraint policy restricting output of data values stored in the table (access policies for rows and columns, [0020]); determining, based on a context of the query, that the aggregation constraint policy should be enforced in relation to the query (filtering based on credentials, [0021]); assigning a specified noise level to the shared dataset based on determining that the aggregation constraint policy should be enforced (redaction based on policies and credentials, [0025-0026]); and generating an output to the query based on the set of data and the operation, the output to the query comprising data values added to the table based on the specified noise level (redacting and censoring cells in a presentation, [0068]). As per claim 2, Krieger teaches wherein assigning the specified noise level to the shared dataset further comprises: adjusting an amount of noise based on a privacy level, wherein the privacy level determines a degree of privacy preservation for the shared dataset (redaction based on policies and credentials, [0025-0026]). As per claim 3, Krieger teaches further comprising: determining the privacy level based on at least one of a trust level of a querying party, sensitivity of the shared dataset, risk potential of data exposure, or accuracy of aggregated results (sensitive data, [0068]). As per claim 4, Krieger teaches wherein the receiving the query directed at the shared dataset further comprises: determining that the query is attempting to directly access sensitive information; and rejecting the query when the query is in violation of the aggregation constraint policy (removing sensitive information, [0068]). As per claim 5, Krieger teaches further comprising: providing an interface for a data provider to review and adjust the aggregation constraint policy and the specified noise level; and controlling an amount of noise per entity granularity based on the context of the query or a context of the aggregation constraint policy (adjusting privileges, [0021], adjusting policies [0043][0065]). As per claim 6, Krieger teaches further comprising: applying, based on the aggregation constraint policy, user-specified noise to aggregate functions of the query on a table at runtime; and identifying a minimum group size, based on the aggregation constraint policy, to be satisfied before returning the output (adjusting privileges, [0021], adjusting policies [0043][0065]). As per claim 7, Krieger teaches further comprising: generating aggregate results of the query; and injecting noise into the aggregate results of the query based on the specified noise level (redacting and censoring, [0068][0025-0026]). Claims 8-14 are rejected based on claims 1-7 Claims 15 – 20 are rejected based on claims 1-6 Conclusion Any inquiry concerning this communication or earlier communications from the examiner should be directed to OLUGBENGA O IDOWU whose telephone number is (571)270-1450. The examiner can normally be reached Monday-Friday 8am - 5pm. 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, Jung Kim can be reached at 5712723804. 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. /OLUGBENGA O IDOWU/Primary Examiner, Art Unit 2494
Read full office action

Prosecution Timeline

Apr 26, 2024
Application Filed
Mar 07, 2025
Response after Non-Final Action
Jun 23, 2026
Non-Final Rejection mailed — §102 (current)

Precedent Cases

Applications granted by this same examiner with similar technology

Patent 12670410
PRIVACY ENHANCED FEDERATED TRAINING AND INFERENCE OVER VERTICALLY AND HORIZONTALLY PARTITIONED DATA
3y 4m to grant Granted Jun 30, 2026
Patent 12665777
BLOCKCHAIN-BASED DATA PROCESSING METHOD AND APPARATUS, DEVICE, MEDIUM, AND PRODUCT
2y 7m to grant Granted Jun 23, 2026
Patent 12659166
BIOSECURITY CONTROL SYSTEM BASED ON BLOCKCHAIN TECHNOLOGY FOR REGULATION AND MONITORING THE PRINTING OF GENETIC SEQUENCES
2y 0m to grant Granted Jun 16, 2026
Patent 12652181
MANAGEMENT SYSTEM, CONTENT MANAGEMENT METHOD, AND STORAGE MEDIUM FOR MANAGING CONTENT DATA USING BLOCKCHAIN
2y 5m to grant Granted Jun 09, 2026
Patent 12634145
CRYPTOGRAPHIC TRUST SYSTEM FOR ELECTRONIC COMMUNICATIONS INTEGRITY USING TUPLE SPACES AND MESSAGING USER AGENTS
2y 4m to grant Granted May 19, 2026
Study what changed to get past this examiner. Based on 5 most recent grants.

Strategy Recommendation AI-generated — please review before filing

Get a prosecution strategy drawn from examiner precedents, rejection analysis, and claim mapping.
Typically takes 5-10 seconds — AI-generated, attorney review required before filing

Prosecution Projections

1-2
Expected OA Rounds
71%
Grant Probability
90%
With Interview (+19.1%)
3y 3m (~1y 1m remaining)
Median Time to Grant
Low
PTA Risk
Based on 650 resolved cases by this examiner. Grant probability derived from career allowance 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