Testing WEB Database Applications

With the growth of the web over the past decade, there has been a similar growth in services that are accessible over the Web. Many new services are web sites that are driven from data stored in databases. Examples of web applications include new services that provide access to large data repositories. E-commerce applications such as online stores, and business-to-business(B2B) support products. Electronic business processing has drastically grown since the advent of the WORLD WIDE WEB. Commercial, scientific, and social activities are increasing becoming dependent on Web-database applications that exploit multiple geographically dispersed information sources and services. Web-enable database system provides the opportunity to fundamentally change the way web sites are produced, managed, and delivered. It is essential that these applications function correctly and provide acceptable performance. Most work on web database applications has been on making them more powerful, but relatively little has been done to ensure their quality.AGENDA (A test GEnerator for Relational Database Applications) is a tool set for testing relational database application. In this paper we extend AGENDA to test web application. We use the SOOT tool to extract URL links and their input information from the application sources. The URL links are partitioned into 3 different types based on their content. Then web application graph is simplified according to their URL link types. Based on the famous Cyclomatic Complexity measurement, An algorithm is used to generate some interesting paths for testing. After AGENDA generating input for each URL, the URLs plus input for individual URL in the given path is stored in an XML file. Our Tool automatically executes the test case based on the XML file, and AGENDA validate the new database state andsystem output. Preliminary empirically evaluation based on TPC-W benchmark is presented.