Turbine, Inc. is a premier creator and operator of massive, persistent online worlds that foster powerful social gaming communities.

The Application Purpose
Following applications serve different features to the registered gamers of the client:

• There is a web application containing the functionality to manage and monitor some scheduled jobs that are responsible to collect data from the live Game Reporting System database to a Web database. The idea of the Web database is to provide data to other applications so that no further load has been generated to the live database.
• Another web application enables the gamers to keep track of the ranking of all the gamers playing the game on different worlds. The application utilizes data from the Web database updated constantly by the 1st application.
• The 3rd application provides the feature to the gamers of creating their digital signatures that can be used in the social networking sites. A Gamer can customize his/her signature to be displayed in the forum post through this application.

ReliSource was responsible for the testing of these applications. Analyzing the testing scope we went for the hybrid type of testing that included both manual and automation testing.

Challenges
Data integrity was the fundamental part for the success of the applications. Hence, the major testing effort was on the data comparison between the source and destination. Comparing about 2 billion entries was one of the major challenges of the testing phase. Another issue was the use of different types of database servers between source and destination. Moreover, remotely located test beds threw a major to the testing process.  

Solution from ReliSource
ReliSource provided an extensive automated and manual testing to address the need. Our automation engineer designed and developed a customized automation tool for the data integrity testing. The tool addressed all the needs required to test the applications. It enabled the testers to catch a lot of glitches of the applications and helped the client to develop a quality product.

Benefits
Vast amount of testing was completed on time, resulting in increased efficiency and fewer production defects. Development of the automation tool led to reduction in manual errors and increased the percentage of defects identification. The test coverage was increased due to the automation testing.

Environment

• Server : Windows 2003 Server, Sun ClientOS, Apache HTTP Server V2.2.8, MySQL V5.0, MSSQL 2003.
• Client : Internet Explorer 6 & 7 and Mozilla Firefox 2 & 3

Tools

• Bug Tracking System : Test Track Pro
• Test Cases/Scenarios : Auto generated XML using the developed testware
• Test Reporting : Automated reporting using the developed testware  
• Testing tools : Testware developed by ReliSource, Slenium, JMeter, Firebug,IE Debuger
• Documentation Depot : Perforce