US Patent Issued to Zoom Communications on Sept. 22 for "Database query optimization for count distinct operations" (Chinese Inventors)

ALEXANDRIA, Va., Sept. 24 -- United States Patent no. 12,743,419, issued on Sept. 22, was assigned to Zoom Communications Inc. (San Jose, Calif.).

"Database query optimization for count distinct operations" was invented by Jiyue Ma (Hangzhou, China) and Wei Zhang (Hangzhou, China).

According to the abstract* released by the U.S. Patent & Trademark Office: "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 combinati...