Method, system, and program for combining and processing transactions

A system for accessing a database and combining a plurality of transactions, the system comprising:

• a processor implemented database proxy configured to:
• receive a plurality of transactions from a plurality of clients, wherein said plurality of transactions each comprises a select query;
• combine said select queries in said transactions using a set operator, wherein said select query comprises a plurality of SQL statements;
• associate each of said SQL statements from said select queries to be combined with a client ID of said corresponding client;
• generate a first list of data types for each selected SQL statement, wherein said first list of data types comprises data types from said selected SQL statement and said corresponding client ID;
• generate a second list of data types, wherein said second list of data types comprises all said data types from said selected SQL statements;
• convert said SQL statements of each said client so that said data types of each said SQL statement are arranged in order of said data types of a corresponding data type set;
• store a correspondence between said data types of a converted SQL statement and said data types of an unconverted SQL statement for each of said client IDs of said clients;
• combine all said converted SQL statements using said set operator;
• send combined SQL statements to said database;
• and
• send combined select queries to said database as a combined transaction.

A non-transitory computer readable storage medium tangibly embodying a computer readable program code having computer readable instructions which when implemented, cause a computer to implement a method for accessing a database and combining a plurality of transactions by the computer, the method comprising:

• receiving a plurality of transactions from a plurality of clients, wherein each of said plurality of transactions comprises a select query;
• combining said select queries in said transactions using a set operator, wherein said select query comprises a plurality of SQL statements;
• associating each of said SQL statements from said select queries to be combined with a client ID of said corresponding client;
• generating a first list of data types for each selected SQL statement, wherein said first list of data types comprises data types from said selected SQL statement and said corresponding client ID;
• generating a second list of data types, wherein said second list of data types comprises all said data types from said selected SQL statements;
• converting said SQL statements of each said client so that said data types of each said SQL statement are arranged in order of said data types of a corresponding data type set;
• storing a correspondence between said data types of a converted SQL statement and said data types of an unconverted SQL statement for each of said client IDs of said clients;
• combining all said converted SQL statements using said set operator;
• sending combined SQL statements to said database;
• and
• sending combined select queries to said database as a combined transaction.