US Patent Issued to Oracle International on Jan. 13 for "Join specific materialized view query rewrite for queries using unified dimension tables" (American, Indian Inventors)

ALEXANDRIA, Va., Jan. 13 -- United States Patent no. 12,524,406, issued on Jan. 13, was assigned to Oracle International Corp. (Redwood Shores, Calif.).

"Join specific materialized view query rewrite for queries using unified dimension tables" was invented by Mihajlo Tekic (Redwood City, Calif.), Praveen Tupati Jaganath Kumar (Bangalore, India), Murali Thiyagarajah (Concord, N.H.) and Andrew Witkowski (Foster City, Calif.).

According to the abstract* released by the U.S. Patent & Trademark Office: "A method and one or more non-transitory storage media for materialized view-based query rewrite are provided. A plurality of materialized views is created based on a fact table and a dimension table. Each materialized view is based on a join be...