Prosecution Insights
Last updated: August 18, 2026
Application No. 19/173,697

QUERY-BASED DATABASE REDACTION

Final Rejection §103
Filed
Apr 08, 2025
Priority
Nov 05, 2021 — continuation of 11/580,251 +1 more
Examiner
BULLOCK, JOSHUA
Art Unit
2153
Tech Center
2100 — Computer Architecture & Software
Assignee
Snowflake Inc.
OA Round
2 (Final)
83%
Grant Probability
Favorable
3-4
OA Rounds
1y 8m
Est. Remaining
99%
With Interview

Examiner Intelligence

Grants 83% — above average
83%
Career Allowance Rate
532 granted / 644 resolved
+27.6% vs TC avg
Strong +16% interview lift
Without
With
+16.1%
Interview Lift
resolved cases with interview
Typical timeline
3y 0m
Avg Prosecution
20 currently pending
Career history
675
Total Applications
across all art units

Statute-Specific Performance

§101
16.3%
-23.7% vs TC avg
§103
35.2%
-4.8% vs TC avg
§102
37.6%
-2.4% vs TC avg
§112
4.9%
-35.1% vs TC avg
Black line = Tech Center average estimate • Based on career data from 644 resolved cases

Office Action

§103
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 . Claims 1, 4, 6-8, 11, 13-15, 18, & 20 have been amended. Claims 1-20 are pending. Response to Arguments Applicant’s arguments with respect to claim(s) 1-20 have been considered but are moot because the new grounds of rejection. See Office Action below. Claim Rejections - 35 USC § 103 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. Claim(s) 1-20 is/are rejected under 35 U.S.C. 103 as being unpatentable over Ho et al. (US Pub. No. 2013/0144901 A1) in view of HUMPRECHT (US Pub. No. 2014/0012833 A1). In respect to Claim 1, Ho teaches: a method comprising: receiving a data query referencing unredacted data of a database, wherein the data query that is received comprises a value identifying a type of sensitive data to be redacted from the unredacted data; (Ho teaches [0020] redaction of data in a database in response to a query for data. The redaction occurs just before results are returned; thus, the redaction necessarily must be of unredacted data within a database.) Ho teaches [0040] policy scope based on redaction. Ho further teaches that the policy may specify different categories of sensitive data such as age or department number which the redaction operator will identify. responsive to receiving the data query, executing, by a processing device, a redaction operation to identify candidate sensitive data that matches the type of the sensitive data to be redacted within the unredacted data of the database; (Ho teaches [0020] redaction of data which has been determined sensitive.) Given the broadest reasonable interpretations “candidate sensitive data” is merely data which has been identified as sensitive, private, or confidential. Ho teaches [0020] redaction of sensitive data stored in a database in response to a query. Thus, Ho must teach a specified portion of the database which is redacted in response to the query. Ho further teaches [0020] data redacted based upon columns which have been identified as sensitive data. Thus, Ho must teach identifying sensitive data within the unredacted data of the portion of the database. Ho teaches [0039-0040] redaction policy for determination of redacted data. Ho teaches [0040] that the policy may specify redaction based upon specified value or specified criteria such as age, department number, etc. The specified values or specified criteria is representative of categories of sensitive data that the redaction operation may identify based upon the policy. and returning, to the client device, a redacted data set in which the candidate sensitive data that is provided is based on an authentication level of the user utilized for execution of the redaction operation (Ho teaches [0020] returning redacted data, wherein the redacted data is replaced.) Ho teaches [0037, 0043] returning of redacted data based on redaction policy analysis, wherein this analysis is based upon a probability determination that data should be identified as sensitive. Ho teaches [0043] the application of a redaction policy. For example, a credit card number is determined as sensitive data and as a result redaction is performed on the credit card number. Ho teaches [0037, 0043] that this redaction is based on a determined probability that the card number is sensitive data. For example, Ho teaches [0039-0040] determination of data to redact is based on policy thresholds as established by the definitions associated with each policy. Ho teaches [0035] that the query includes operators around policy-specified columns in the query, wherein these specification of the query [0040] defines thresholds which are defined by specified criteria. Ho does not explicitly disclose: receiving, from a client device associated with a user, a data query referencing unredacted data of a database, wherein the data query comprises a first value identifying a column associated with the unredacted data of the database and a second value identifying a type of sensitive data to be redacted from the column associated with the unredacted data However, HUMP teaches: receiving, from a client device associated with a user, a data query referencing unredacted data of a database, wherein the data query comprises a first value identifying a column associated with the unredacted data of the database and a second value identifying a type of sensitive data to be redacted from the column associated with the unredacted data (HUMP teaches [0025-0026, 0028] sensitive data to be redacted form the column associated with initially unredacted data.) It would have been obvious to one of ordinary skill in the art at the time of the filing date of the invention to incorporate the teachings of HUMP into the system of Ho. One of ordinary skill in the art would be motivated to provide a system to protect sensitive data to comply with data privacy policies and regulations. (HUMP [0004]) As per Claim 2, Ho teaches: wherein the redacted data set includes some or all of the candidate sensitive data for a first authentication level (Ho teaches [0020] redaction of data which has been determined sensitive.) As per Claim 3, Ho teaches: wherein the redacted data set includes a return value that omits at least a portion of the candidate sensitive data for a second authentication level (Ho teaches [0023] redaction at different columnar levels.) As per Claim 4, Ho teaches: wherein the redaction operation identifies one or more types of the sensitive data within the unredacted data based on the authentication level (Ho teaches [0023] redaction at different columnar levels.) As per Claim 5, Ho teaches: wherein the data query comprises a structured query language (SQL) query (Ho [0025]) As per Claim 6, Ho teaches: wherein the data query comprises a user-defined function (UDF), and the second value identifying the type of the sensitive data to be redacted from the unredacted data is an input value of the UDF (Ho [0025]) As per Claim 7, Ho teaches: wherein the redacted data set that is returned comprises an offset value indicating an offset within a data value of the unredacted data at which the sensitive data is located (Ho teaches [0020] columns which have been specifically allocated for sensitive data, wherein these columns are indicative of a location within the data set or database. Thus, Ho must teach that the redacted data set which is returned comprises a value indicating a location within the unredacted data set at which the sensitive data is located.) Claims 8-14 are the system claims corresponding to method claims 1-7 respectively, therefore are rejected for the same reasons noted previously. Claims 15-20 are the media claims corresponding to method claims 1-6 respectively, therefore are rejected for the same reasons noted previously. THIS ACTION IS MADE FINAL. 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. Conclusion Any inquiry concerning this communication or earlier communications from the examiner should be directed to JOSHUA BULLOCK whose telephone number is (571)270-1395. The examiner can normally be reached 8:00 am - 4:00 pm. 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, Kavita Stanley can be reached at 571-272-8352. 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. /JOSHUA BULLOCK/Primary Examiner, Art Unit 2153 June 27, 2026
Read full office action

Prosecution Timeline

Apr 08, 2025
Application Filed
Jan 30, 2026
Non-Final Rejection mailed — §103
Apr 07, 2026
Examiner Interview Summary
Apr 07, 2026
Applicant Interview (Telephonic)
Apr 22, 2026
Response Filed
Jul 01, 2026
Final Rejection mailed — §103 (current)

Precedent Cases

Applications granted by this same examiner with similar technology

Patent 12670164
DATABASE MANAGEMENT BASED ON PREDICTED RETRIEVAL OF DATA
2y 4m to grant Granted Jun 30, 2026
Patent 12670147
PROVIDING SUPPLEMENTAL VALUES FOR EVENTS
1y 5m to grant Granted Jun 30, 2026
Patent 12670152
READING QUERY RESULTS FROM AN EXTERNAL DATA SYSTEM
1y 2m to grant Granted Jun 30, 2026
Patent 12619650
TECHNIQUES FOR SECURING COMPUTING INTERFACES USING CLUSTERING
1y 11m to grant Granted May 05, 2026
Patent 12602401
NON-DISRUPTIVE TRANSITION TO SYNCHRONOUS REPLICATION STATE
4y 7m to grant Granted Apr 14, 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

3-4
Expected OA Rounds
83%
Grant Probability
99%
With Interview (+16.1%)
3y 0m (~1y 8m remaining)
Median Time to Grant
Moderate
PTA Risk
Based on 644 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