Batch Submitted To The Realization Of The Data Model In The Ibm Mainframe With Db2 Query Optimization

With the IBM mainframe global restore and data intensive computing extensive use, more attention pay to mainframe again. In the field of bank,telecom,hospital,government that highly value stability,integrate related business,Mainframe is always the first choice.And Service-oriented architecture begin to combine Mainframe's power to implement business integration.In my paper I propose batch submit method,combine online transaction process with batch process,have both two advantage,effective solved browser/server model's weak point at network dependence,increase utilization of Mainframe's power,and then from database query optimization to make further complete,at last demonstration by a rounded course select system.IBM Mainframe possess nature bourn gift to deal with large number data throughout, concurrent processing capacity, good system stability, so that regard as first preferred platform at many transaction field. On the course-selecting system, its advantage manifested perfectly. The course-selecting system require thousands of student complete more than ten courses selecting respectively in several days, the foreseeable result is congestion, refresh web page to insure request would be responded earlier, the whole process is torturous. Thanks to timely introduction of Mainframe, offer us an excellent solution, either student or teacher can accomplish it easily, no longer be so helpless to handle, increase efficiency greatly. The concept of batch submit come from how client submit request. Among the DBMS transaction process have the concept too. I used this concept and apply it at request submit .IBM mainframe adopt batch data submit method,unleash parallel processing capability fully,and greatlly increase utilization of network bandwidth,unleash B/S model's flexibility and mainframe's power,avoid B/S's weakpoint.Some crucial technology related course-selecting system.DB2 query optimization include SQL statement level optimization and DBMS level optimization.statement level optimization mention the rule that write a SQL statement ought to obey,to avoid some operation that consume most time,accelerate query.DBMS optimization mention DBMS execute the SQL statement ought to obey precedence,it most like a optimizer's work.IBM WebSphere is the leading software for on demand business, delivering business integration, application & transaction infrastructure, portals. The application and transaction infrastructure delivers high-volume transaction processing for customers mission-critical applications.