Method for updating databases
View Patent ↗Techniques for batch-updating one or more structured query language (SQL) statements in a database are provided. The techniques include identifying a set of one or more data types, wherein the set comprises one or more columns that are each updated, respectively, by a SQL statement, identifying a set of one or more tables, wherein each of the one or more tables are updated, respectively, by a SQL statement, identifying a set of one or more columns used in a WHERE clause of each of one or more SQL statements, and batch-updating the one or more SQL statements, wherein batch-updating comprises creating a 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 SQL statement is mapped to each set of the UNION ALL view.
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.
2. The method of claim 1 , wherein each of the one or more tables comprise one or more of the one or more data types.
3. The method of claim 1 , wherein in each SQL statement, the WHERE clause specifies at most one record.
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.
5. The method of claim 1 , wherein each of the one or more tables is different.
6. The method of claim 1 , further comprising specifying a set of values as parameters to be batch-updated.
7. The method of claim 1 , further comprising registering a set of SQL statements in advance.
8. A computer program product comprising a computer readable medium having computer readable program code for batch-updating multiple distinct structured query language (SQL) statements in a database, said computer program product including:
computer readable program code for 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;
computer readable program code for identifying multiple tables, wherein each of the multiple tables is updated, respectively, by one of the multiple distinct SQL statements;
computer readable program code for identifying a set of one or more columns used in a WHERE clause of each of the multiple distinct SQL statements;
computer readable program code for configuring a UNION ALL view for updating the multiple distinct SQL statements; and
computer readable program code for 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.
9. The computer program product of claim 8 , wherein each of the one or more tables comprise one or more of the one or more data types.
10. The computer program product of claim 8 , wherein in each SQL statement, the WHERE clause specifies at most one record.
11. The computer program product of claim 8 , wherein the computer readable code for creating a UNION ALL view comprises:
computer readable program code for creating a UNION ALL view comprising two or more parameterized SQL statements.
12. The computer program product of claim 8 , wherein each of the one or more tables is different.
13. The computer program product of claim 8 , further comprising computer readable program code for specifying a set of values as parameters to be batch-updated.
14. The computer program product of claim 8 , further comprising computer readable program code for registering a set of SQL statements in advance.
15. An apparatus for batch-updating multiple distinct structured query language (SQL) statements in a database, comprising:
a memory; and
at least one processor coupled to said memory and operative to:
identify 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;
identify multiple tables, wherein each of the multiple tables is updated, respectively, by one of the multiple distinct SQL statements;
identify a set of one or more columns used in a WHERE clause of each of the multiple distinct SQL statements;
configure a UNION ALL view for updating the multiple distinct SQL statements; and
batch-update 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.
16. The apparatus of claim 15 , wherein each of the one or more tables comprise one or more of the one or more data types.
17. The apparatus of claim 15 , wherein in each SQL statement, the WHERE clause specifies at most one record.
18. The apparatus of claim 15 , wherein in creating a UNION ALL view, the at least one processor coupled to said memory is further operative to:
create a UNION ALL view comprising two or more parameterized SQL statements.
19. The apparatus of claim 15 , wherein each of the one or more tables is different.
20. The apparatus of claim 15 , wherein the at least one processor coupled to said memory is further operative to:
specify a set of values as parameters to be batch-updated.
21. The apparatus of claim 15 , wherein the at least one processor coupled to said memory is further operative to:
register a set of SQL statements in advance.