Prosecution Insights
Last updated: April 19, 2026
Application No. 17/654,145

ELIMINATING MANY-TO-MANY JOINS BETWEEN DATABASE TABLES

Final Rejection §101
Filed
Mar 09, 2022
Examiner
CHOI, YUK TING
Art Unit
2164
Tech Center
2100 — Computer Architecture & Software
Assignee
Sisense Ltd.
OA Round
6 (Final)
72%
Grant Probability
Favorable
7-8
OA Rounds
3y 3m
To Grant
99%
With Interview

Examiner Intelligence

Grants 72% — above average
72%
Career Allow Rate
466 granted / 652 resolved
+16.5% vs TC avg
Strong +37% interview lift
Without
With
+37.4%
Interview Lift
resolved cases with interview
Typical timeline
3y 3m
Avg Prosecution
29 currently pending
Career history
681
Total Applications
across all art units

Statute-Specific Performance

§101
16.8%
-23.2% vs TC avg
§103
55.0%
+15.0% vs TC avg
§102
13.5%
-26.5% vs TC avg
§112
6.8%
-33.2% vs TC avg
Black line = Tech Center average estimate • Based on career data from 652 resolved cases

Office Action

§101
DETAILED ACTION Response to Amendment 1. This office action is in response to applicant’s communication filed on 12/11/2025 in response to the non-final office action mailed on 09/11/2025 and the Patent Board Decision filed on 07/02/2023. The Applicant’s remarks and amendments to the claims and/or the specification were considered with the results as follows. 2. In response to the last Office Action, claims 17, 26 and 27 are amended. No claims have been added or canceled. As a result, claims 17-35 are pending in this office action. 3. The 35 USC 103 rejections have been withdrawn due to the Patent Board Decision filed on 07/02/2025. Response to Arguments 4. Applicant's arguments with respect to 35 USC 101 have been fully considered but are not persuasive and details are as follow: Applicant’s argument stated as “The claim provides for an improvement in the functioning of computers or other technology and thus applies any judicial exception to effect improved operation of a computer system…This is an improvement in computer technology because the computer is not actually performing a join operation, i.e., the first join operation, but instead it performs an operation which is less computationally expensive than a Join operation…”. In response to Applicant’s argument, the Examiner disagrees because the amended features in claim 17 are similar to claims 36 and 38 for which the Patent Trial and Appeal Board (PTAB) affirmed the 35 USC 101 rejections. While Applicant did not make any arguments about claims 36 and 38 at appeal, and the PTAB’s reasoning was that it was not an argument on the merits, they still affirmed the rejections. Applicant’s remarks appear to argue that the mere statement that the query that is generated entirely as an abstract idea is “executed” somehow, “practically implements the first two steps of the method so as to realize in the computer the benefit of the enhanced operation”. The argument would appear to be that this ‘enhanced query’ is more efficient to perform on the computer. However, this does not appear to be an improvement in the functioning of the computer itself, rather it is a consequence of the improvement solely in the abstract idea. That is, since the query can be rewritten/enhanced as a mental process or abstract idea, any benefit would apply even if the query was executed without a computer (e.g., performing the same query by hand outside a computer). The amended feature “executing the database query using the enhanced operation and without executing a join as part of the enhanced operation, whereby as a result of executing by the processing circuitry the database query using the enhanced operation and without executing a join as part of the enhanced operation a correct result as if the first join was performed is achieved in less time than would be required of the processing circuitry to perform the first join itself” is mere instruction to apply the abstract idea on a computer.” The same execution benefits would occur in hand processing the results from the ‘enhanced query’. Further, the specification describes the database at page 12, as a generic DBMS server and also on p.18 as essentially executing standard generic SQL. All of that support that the database and DBMS itself are generic computer components and conventional, and that they execute any queries provided in an entirely generic, conventional fashion. Accordingly, merely executing the ‘enhanced query’ is not any integration into a practical application or significantly more. Moreover, when analyzing the claimed method as a whole and giving the claim its broadest reasonable interpretation, “if the condition for performing a contingent step is not satisfied [e.g., if the first join was performed is achieved in more time than would be required of the processing circuitry to perform the first join itself], the performance recited by the step need not be carried out in order for the claimed method to be performed”. Therefore, the 35 USC 101 rejection is maintained. Claim Rejections - 35 USC § 101 5. 35 U.S.C. 101 reads as follows: Whoever invents or discovers any new and useful process, machine, manufacture, or composition of matter, or any new and useful improvement thereof, may obtain a patent therefor, subject to the conditions and requirements of this title. Claims 17-35 are rejected under 35 U.S.C. 101 because the claimed invention is directed to non-statutory subject matter. In claims 17-35 are rejected under 35 U.S.C 101 because the claimed invention is directed to a judicial exception (i.e., a law of nature, a natural phenomenon, or an abstract idea) without significantly more. Claims 17-35 are directed to the abstract idea of enhancing database execution, as explained in detail below. The claims do not include additional elements that are sufficient to amount to significantly more than the judicial exception because the additional computer components which are recited at a high level of generality, provide conventional computer software functions that do not add meaningful limits to practicing the abstract idea. Claim 17, recites, in part, a method comprising instructions to enhance database query execution comprising the following steps: Identifying a first join operation within a database query between a first table and a second table, wherein the first join operation is a many-to-many join operation or a one-to many join operation, wherein fields of the second table are used for filtering rows from the first table or for joining with another table [e.g. “identifying” a query can constitute a mental process as observing and evaluating fields in database tables using pen and paper]; converting the first join operation to an enhanced operation, wherein the enhanced operation includes a semijoin operation [e.g. “converting” can constitute a mental process as a judgement after evaluation and observation between fields in database tables using pen and paper]; executing the database query using the enhanced operation and without executing a join as part of the enhanced operation, whereby as a result of executing by the processing circuitry the database query using the enhanced operation and without executing a join as part of the enhanced operation as a correct result as if the first join was performed is achieved in less time than would be required to perform the first join itself [ e.g., “executing” can constitute a mental process as a judgement after replacing the query to other SQL relational operation using pen and paper]. Claim 17 as it is recited falls within one of the groupings of abstract ideas [e.g. mental processes] enumerated in the 2019 PEG. The recited concept can be performed in human mind including an observation, evaluation, judgment, opinion. The additional elements including executing SQL operations such as a join operation and a semi-join operation are mere instructions to implement an abstract idea on a computer and merely use a computer as a tool to perform an abstract idea. The additional elements (or combination of elements) are well-understood, routine or conventional activity “The join operation or the semi join [e.g. the current enhanced operation] is a conventional SQL relational operation which is used for data retrieval (US 2007/0061288 A1, para. [0007]-para. [0008]). Moreover, the specification describes the database at page 12, as a generic DBMS server and also on p.18 as essentially executing standard generic SQL. All of that support that the database and DBMS itself are generic computer components and conventional, and that they execute any queries provided in an entirely generic, conventional fashion. Accordingly, merely executing the ‘enhanced query’ is not any integration into a practical application or significantly more. The additional elements do not amount to significantly more than the above-identified judicial exception (the abstract idea). Looking at the limitation as an ordered combination adds nothing that is not already present when looking at the elements taken individually. There is no indication that the combination of elements improves the functioning of a computer or improves any other technology. Therefore, claim 17 is ineligible subject under 35 USC 101. Claims 18-20 further describe the enhance operation is used for filtering rows are similar to claim 17 fall in “Mental Processes: Concepts performed in the human mind”, e.g., observation, evaluation, judgement and opinion, enumerated in the 2019 PEG. The claim describes the enhanced operation is a semijoin operation which is conventional SQL relational operations (US 2007/0061288 A1, para. [0007]-para. [0008]). Claims 18-20 do not include additional elements that are sufficient to amount to significantly more than the judicial exception. Therefore, claims 18-20 are ineligible subject under 35 USC 101. Claim 21 further describe that the conversion is achieved during execution of the database query is similar to claim 17 fall in “Mental Processes: Concepts performed in the human mind”, e.g., observation, evaluation, judgement and opinion, enumerated in the 2019 PEG. The additional feature “converting an operation during execution of a query” is mere instructions to implement an abstract idea on a computer to perform an abstract idea. The converting steps are insignificant extra-solution activity, the judicial exception is not integrated into a practical application. Claim 21 is ineligible subject under 35 USC 101. Claim 25 further defines the database is a columnar database or a relational database is similar to claim 17 falls in “Mental Processes: Concepts performed in the human mind”, e.g., observation, evaluation, judgement and opinion, enumerated in the 2019 PEG. That is, other than reciting a computer database, nothing in the claim elements precludes the step from practically being performed in the mind. The additional element “relational database” merely uses a computer as a tool to perform an abstract idea. Claim 25 does not include additional elements that are sufficient to amount to significantly more than the judicial exception. Therefore, claim 25 is ineligible subject under 35 USC 101. Claim 26 recites, in part, a non-transitory computer readable medium having stored thereon instructions for causing a processing circuity to execute a process, the process comprising: Identifying a first join operation within a database query between a first table and a second table, wherein the first join operation is a many-to-many join operation or a one-to many join operation, wherein fields of the second table are used for filtering rows from the first table or for joining with another table [e.g. “identifying” can constitute a mental process an evaluation between fields in database tables using pen and paper]; converting the first join operation to an enhanced operation, wherein the enhanced operation includes a semijoin operation [e.g. “converting” can constitute a mental process as a judgement after evaluation and observation between fields in database tables using pen and paper]; executing the database query using the enhanced operation and without executing a join as part of the enhanced operation, whereby as a result of executing by the processing circuitry the database query using the enhanced operation and without executing a join as part of the enhanced operation as a correct result as if the first join was performed is achieved in less time than would be required to perform the first join itself [ e.g., “executing” can constitute a mental process as a judgement after replacing the query to other SQL relational operation using pen and paper]. Claim 26 as it is recited falls within one of the groupings of abstract ideas [e.g., mental processes] enumerated in the 2019 PEG. The recited concept can be performed in human mind including an observation, evaluation, judgment, opinion. That is, other than reciting a computer circuitry and a database, nothing in the claim elements precludes the step from practically being performed in the mind. The additional elements including SQL operations such as a join operation and a semi-join operation are mere instructions to implement an abstract idea on a computer and merely use a computer as a tool to perform an abstract idea. The additional elements (or combination of elements) are well-understood, routine or conventional activity “The join operation or the semi join operation is conventional SQL relational operation, which is used for data retrieval (US 2007/0061288 A1, para. [0007]-para. [0008]). The additional elements do not amount to significantly more than the above-identified judicial exception (the abstract idea). Looking at the limitation as an ordered combination adds nothing that is not already present when looking at the elements taken individually. There is no indication that the combination of elements improves the functioning of a computer or improves any other technology. Therefore, claim 26 is ineligible subject under 35 USC 101. Claim 27 recites, in part, a system for enhancing database query execution comprising: a processing circuity and a memory containing instructions that, when executed by the processing circuitry, configure the system to: Identifying a first join operation within a database query between a first table and a second table, wherein the first join operation is a many-to-many join operation or a one-to many join operation, wherein fields of the second table are used for filtering rows from the first table or for joining with another table [e.g. “identifying” can constitute a mental process an evaluation between fields in database tables using pen and paper]; converting the first join operation to an enhanced operation, wherein the enhanced operation includes a semi-join operation [e.g. “converting” can constitute a mental process as a judgement after evaluation and observation between fields in database tables using pen and paper]; executing the database query using the enhanced operation and without executing a join as part of the enhanced operation, whereby as a result of executing by the processing circuitry the database query using the enhanced operation and without executing a join as part of the enhanced operation as a correct result as if the first join was performed is achieved in less time than would be required to perform the first join itself [ e.g., “executing” can constitute a mental process as a judgement after replacing the query to other SQL relational operation using pen and paper]. Claim 27 as it is recited falls within one of the groupings of abstract ideas [e.g. mental processes] enumerated in the 2019 PEG. The recited concept can be performed in human mind including an observation, evaluation, judgment, opinion. The additional elements including executing SQL operations such as a join operation and a semi-join operation are mere instructions to implement an abstract idea on a computer and merely use a computer as a tool to perform an abstract idea. The additional elements (or combination of elements) are well-understood, routine or conventional activity “The join operation or the semi join [e.g. the current enhanced operation] is a conventional SQL relational operation which is used for data retrieval (US 2007/0061288 A1, para. [0007]-para. [0008]). Moreover, the specification describes the database at page 12, as a generic DBMS server and also on p.18 as essentially executing standard generic SQL. All of that support that the database and DBMS itself are generic computer components and conventional, and that they execute any queries provided in an entirely generic, conventional fashion. Accordingly, merely executing the ‘enhanced query’ is not any integration into a practical application or significantly more. The additional elements do not amount to significantly more than the above-identified judicial exception (the abstract idea). Looking at the limitation as an ordered combination adds nothing that is not already present when looking at the elements taken individually. There is no indication that the combination of elements improves the functioning of a computer or improves any other technology. Therefore, claim 27 is ineligible subject under 35 USC 101. Claims 28-30 further describe the enhance operation is used for filtering rows are similar to claim 27 fall in “Mental Processes: Concepts performed in the human mind”, e.g., observation, evaluation, judgement and opinion, enumerated in the 2019 PEG. The claim describes the enhanced operation is a semijoin operation which is a conventional SQL relational operation (US 2007/0061288 A1, para. [0007]-para. [0008]). Claims 28-30 do not include additional elements that are sufficient to amount to significantly more than the judicial exception. Therefore, claims 28-30 are ineligible subject under 35 USC 101. Claim 31 further describe that the conversion is achieved during execution of the database query is similar to claim 27 falls in “Mental Processes: Concepts performed in the human mind”, e.g., observation, evaluation, judgement and opinion, enumerated in the 2019 PEG. The additional feature “converting an operation during execution of a query” is mere instructions to implement an abstract idea on a computer to perform an abstract idea. The converting steps are insignificant extra-solution activity, the judicial exception is not integrated into a practical application. Claim 31 is ineligible subject under 35 USC 101. Claim 35 further defines the database is a columnar database or a relational database is similar to claim 27 falls in “Mental Processes: Concepts performed in the human mind”, e.g., observation, evaluation, judgement and opinion, enumerated in the 2019 PEG. That is, other than reciting a computer database, nothing in the claim elements precludes the step from practically being performed in the mind. The additional element “relational database” merely uses a computer as a tool to perform an abstract idea. Claim 35 does not include additional elements that are sufficient to amount to significantly more than the judicial exception. Therefore, claim 35 is ineligible subject under 35 USC 101. Conclusion 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. Any inquiry concerning this communication or earlier communications from the examiner should be directed to YUK TING CHOI whose telephone number is (571)270-1637. The examiner can normally be reached Monday-Friday 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, AMY NG can be reached on 5712701698. 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. /YUK TING CHOI/Primary Examiner, Art Unit 2164
Read full office action

Prosecution Timeline

Mar 09, 2022
Application Filed
Mar 09, 2022
Response after Non-Final Action
Oct 07, 2022
Non-Final Rejection — §101
Dec 30, 2022
Response Filed
Jan 17, 2023
Final Rejection — §101
Apr 24, 2023
Request for Continued Examination
Apr 26, 2023
Response after Non-Final Action
May 12, 2023
Non-Final Rejection — §101
Sep 18, 2023
Response Filed
Oct 10, 2023
Final Rejection — §101
Mar 22, 2024
Notice of Allowance
Mar 22, 2024
Response after Non-Final Action
Apr 04, 2024
Response after Non-Final Action
Apr 30, 2024
Response after Non-Final Action
May 03, 2024
Response after Non-Final Action
Jul 05, 2024
Response after Non-Final Action
Jul 05, 2024
Response after Non-Final Action
Jul 08, 2024
Response after Non-Final Action
Jul 08, 2024
Response after Non-Final Action
Jul 01, 2025
Response after Non-Final Action
Aug 21, 2025
Request for Continued Examination
Aug 29, 2025
Response after Non-Final Action
Sep 08, 2025
Non-Final Rejection — §101
Dec 11, 2025
Response Filed
Jan 13, 2026
Final Rejection — §101 (current)

Precedent Cases

Applications granted by this same examiner with similar technology

Patent 12591610
SYSTEMS AND METHODS FOR REMOVING NON-CONFORMING WEB TEXT
2y 5m to grant Granted Mar 31, 2026
Patent 12579156
SYSTEMS AND METHODS FOR VISUALIZING ONE OR MORE DATASETS
2y 5m to grant Granted Mar 17, 2026
Patent 12562753
SYSTEM AND METHOD FOR MULTI-TYPE DATA COMPRESSION OR DECOMPRESSION WITH A VIRTUAL MANAGEMENT LAYER
2y 5m to grant Granted Feb 24, 2026
Patent 12536282
METHODS AND APPARATUS FOR MACHINE LEARNING BASED MALWARE DETECTION AND VISUALIZATION WITH RAW BYTES
2y 5m to grant Granted Jan 27, 2026
Patent 12511258
DYNAMIC STORAGE OF SEQUENCING DATA FILES
2y 5m to grant Granted Dec 30, 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

7-8
Expected OA Rounds
72%
Grant Probability
99%
With Interview (+37.4%)
3y 3m
Median Time to Grant
High
PTA Risk
Based on 652 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