ALEXANDRIA, Va., April 15 -- United States Patent no. 12,602,380, issued on April 14, was assigned to Oracle International Corp. (Redwood Shores, Calif.).
"Subsumption of views and subqueries" was invented by Rafi Ahmed (Fremont, Calif.), Mohamed Ziauddin (Pleasanton, Calif.) and Sankar Subramanian (Cupertino, Calif.).
According to the abstract* released by the U.S. Patent & Trademark Office: "Techniques for subsumption of inline views and subqueries in a query are described. An optimization technique of subsumption is enabled by inline views having identical tables and identical join conditions and having aggregation functions but no group-by clauses. When subsumption takes place, a single query block replaces the inline views (or subque...