The Proceedings of the Information Systems Education Conference 2006: §2124 Home Papers/Indices prev (§2123) Next (§2125)

Fri, Nov 3, 9:00 - 9:25, Bordeaux Paper (refereed)

Recommended Citation: Anderson, R, M J Jafar, and A A Abdullat. Teaching Scalability Issues in Large Scale Database Application Development. In The Proceedings of the Information Systems Education Conference 2006, v 23 (Dallas): §2124. ISSN: 1542-7382. (A later version appears in Information Systems Education Journal 5(28). ISSN: 1545-679X.)

Teaching Scalability Issues in Large Scale Database Application Development

Refereed

13 pages

Russell Anderson    [a1] [a2]
CIS Department
West Texas A&M University    [u1] [u2]
Canyon, Texas, USA    [c1] [c2]

Musa J. Jafar    [a1] [a2]
CIS Department
West Texas A&M University    [u1] [u2]
Canyon, Texas, USA    [c1] [c2]

Amjad A. Abdullat    [a1] [a2]
Computer Information Systems Department
West Texas A&M University    [u1] [u2]
Canyon, Texas, USA    [c1] [c2]

Many information systems degree programs include a course in database application development. These courses typically require the students to design and develop a complete database application. In doing so, the instructor will frequently discuss performance and scalability issues of the applications. However, giving the students a valid, hands-on performance and scalability experience is difficult. The problems of doing so usually originate with the small size of the test database and from testing the whole application with too few concurrent users- frequently one. Although this can be partially overcome by requiring students to programmatically construct larger test databases; it still does not address the performance and scalability problems that arise when hundreds or even thousands of users are concurrently executing transactions against the system. At the Department of Computer Information Systems of West Texas A&M University, we have implemented a hardware/software solution that allows students to assess most performance and scalability characteristics of their database applications. The solution allows students to execute from two to thousands of concurrent and varied transactions against the database. While doing this they can monitor and gather performance statistics such as minimum, maximum, and mean transaction response time, and failure rates due to locking or other DBMS/OS configuration problems. In the paper we describe in detail the methodology and the hardware/software solution platform that we use to implement the performance tests. We also present the results of our first round of use in a classroom setting the learning experiences of the students and the issues encountered.

Keywords: database performance, scalability, web applications, testing

Read this refereed paper in Adobe Portable Document (PDF) format. (13 pages, 927 K bytes)
Preview this refereed paper in Plain Text (TXT) format. (27 K bytes)
View the PowerPoint Slides (PPT) for this presentation. (871 K bytes)

CDpic
Comments and corrections to
webmaster@isedj.org