ALEXANDRIA, Va., July 7 -- United States Patent no. 12,675,487, issued on July 7, was assigned to UNIVERSITAT POLITECNICA DE CATALUNYA (Barcelona, Spain).
"Checking SQL assertions" was invented by Xavier Oriol Hilari (Barcelona, Spain) and Ernest Teniente Lopez (Barcelona, Spain).
According to the abstract* released by the U.S. Patent & Trademark Office: "Methods are disclosed for a RDMS to compile an SQL assertion into SQL statements. RDMS includes SQL assertions including an SQL assertion to be checked and relational tables fulfilling pre-update satisfaction of the SQL assertions. SQL update and SQL assertion affect relational tables having pre-update content. The methods include: creating triggers to simulate, at run-time, SQL update e...