Patent Document ID: 8090700
Application ID: 12037178

Base Claim:
1. A method for batch-updating multiple distinct structured query language (SQL) statements in a database, comprising the steps of: identifying a set of one or more data types, wherein the set comprises one or more columns that are each updated, respectively, by one of the multiple distinct SQL statements; identifying multiple tables, wherein each of the multiple tables is updated, respectively, by one of the multiple distinct SQL statements; identifying a set of one or more columns used in a WHERE clause of each of the multiple distinct SQL statements; configuring a UNION ALL view for updating the multiple distinct SQL statements; and batch-updating the multiple distinct SQL statements, wherein the multiple distinct SQL statements comprise two or more distinct SQL statements, wherein each distinct SQL statement updates a unique table with a unique combination of SET and WHERE clauses and includes a WHERE clause that specifies a record that is unique from each record specified by each WHERE clause in the one or more other distinct SQL statements, wherein batch-updating comprises using the UNION ALL view comprising the set of one or more data types, the set of one or more tables and the set of one or more columns used in a WHERE clause, and wherein each distinct SQL statement is mapped to each set of the UNION ALL view.

---

Claim 4:
4. The method of claim 1 , wherein creating a UNION ALL view comprises creating a UNION ALL view comprising two or more parameterized SQL statements.