The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Sep. 22, 2026
Filed:
Mar. 20, 2025
Applicant:
Zoom Communications, Inc., San Jose, CA (US);
Assignee:
Zoom Communications, Inc., San Jose, CA (US);
Primary Examiner:
Int. Cl.
CPC ...
G06F 16/00 (2019.01); G06F 16/2453 (2019.01); G06F 16/2455 (2019.01);
U.S. Cl.
CPC ...
G06F 16/24537 (2019.01); G06F 16/2455 (2019.01);
Abstract
A query that includes a plurality of COUNT(DISTINCT) operations applied to a same dimensional column with conditional filtering is received. The query is transformed to obtain a transformed query. Transforming the query includes rewriting the plurality of COUNT(DISTINCT) operations into corresponding aggregation operations using a first combination of SUM( ) and COUNT( ) or a second combination using SUM( ) and MAX( ); and generating the transformed query incorporating the aggregation operations. The transformed query is then transmitted to a database system for execution to generate a query result.