|
Our team designed an innovative software solution - booster that made possible for RDBMS DB/2 to optimize its own performance. As a result, mainframe based systems equipped with this solution were able to process a higher number of operations (queries) at any given time and handle bigger data volumes. The solution allows increasing the efficiency of the mainframe systems at practically no cost.
That tool analyses application SQL requests, pre-builds execution plans and binds them to DB2 server. After that ODBC driver examines all SQL statements on equality with processed statements and tries to execute it using prepared plans. This decreases database requests execution time.
|
 |
Tools and technologies: ANSI C, K&R C, ODBC, DB2 C interface, YACC, SQL
|
