Initially, Cotton did pilot testing to ensure everything would connect. He then built a recertification application prototype that, when launched, would enable the school district to provide teachers, administrators and other users with real-time Web access to information residing on the AS/400. Cotton hopes to take the application live this summer. Via a portal, Cotton will provide teachers a way to access certification information or to determine their recertification status. The DB2 libraries will allow users to query information from the AS/400 as XML and match it up to certification records. That process currently takes two weeks or more to complete, but teachers will be able to get the results in real time when the recertification application is launched, Cotton said.Eventually, Cotton said he hopes to have an end-to-end system that will let state Department of Education personnel use Web services to request certification information from the AS/400. This will enable him to eliminate the final keying of information into the education departments site. "I love the ability to write Web services and access data," Cotton said. "The application represents a significant savings in man-hours by providing on-demand information to teachers while eliminating time-consuming requests to human resources for that information." While Cotton chose DB2 mainly because of his installed IBM hardware and DB2s integration with the Microsoft development environments, he said he also likes new features such as the IBM Learning Optimizer. The Learning Optimizer, which takes advantage of DB2s autonomic muscle, helps the database learn from its past actions to speed command execution and optimize the quickest route to requested business information. For more on IBMs autonomic computing strategy, click here. New navigation tools in DB2, such as the iSeries Navigator, also enable administrators to find information on the AS/400 faster, allowing the district to accelerate application development cycles, Cotton said. Cotton said he will begin using DB2 to provide the school districts finance department with access to data residing on the AS/400 in July. By providing Web-based access to financial data residing on the AS/400, the district will be able to make information such as budgets available to the public via XML. "By enabling us to give client access to the AS/400, DB2 has really helped us to keep leveraging our AS/400 as a useful piece of equipment," Cotton said. "We now have ample opportunity to pull legacy data and work with the system at will. DB2 has helped us bring the AS/400 back into the mainstream of things." Senior Writer Anne Chen can be reached at firstname.lastname@example.org. Check out eWEEK.coms for the latest database news, reviews and analysis.
Administrators will also be able to see the impact of ongoing teacher training courses and degree programs as soon as the information becomes available, he said.