US Patent Issued to Oracle International on April 29 for "Techniques for automatically identifying undeclared composite key relationships in a database schema" (Israeli Inventors)

ALEXANDRIA, Va., June 9 -- United States Patent no. 12,287,774, issued on April 29, was assigned to Oracle International Corp. (Redwood Shores, Calif.).

"Techniques for automatically identifying undeclared composite key relationships in a database schema" was invented by Guy Shaked (Be'er Sheva, Israel) and Ilya Tebelev (Be'er Sheva, Israel).

According to the abstract* released by the U.S. Patent & Trademark Office: "Techniques are described herein for automatically discovering undeclared PK-FK relationships between dimension tables and a fact table in situations where: the primary keys of the dimension tables (a) are not known, and (b) are composite keys, and the foreign keys of the fact table (a) are not known, and (b) are composite key...