The DVD Store Version 2 (DS2) is a complete, online e-commerce test application, with a back-end database component, a Web application layer, and driver programs. The goal in designing the database component as well as the mid-tier application was to utilize many advanced database features (transactions, stored procedures, triggers, referential integrity) while keeping the database easy to install and understand. The DS2 workload may be used to test databases or as a stress tool for any purpose.

The distribution includes code for Microsoft SQL Server, Oracle, and MySQL databases. Included in the release are data generation programs, shell scripts to build data for 10 MB, 1 GB, and 100 GB versions of the DVD Store; database build scripts and stored procedures; PHP Web pages; and a C# driver program.

The code is freely available to all under the GPL from linux.dell.com. Documentation is included in the kit.

Please use the "Threads" link below to ask questions, post solutions, or describe how you are using the DVD Store in your organization.

Authors: Dave Jaffe and Todd Muirhead

New version available (December 2007). Click here for details.

DVD Store Quick Links

Readme	FAQs
DVD Store Database Schema	LAMP Stack

DVD Store Test Database Uses

VMware – Results with Oracle database on VMware

VMware and DB2 - Performance testing of DB2 VMs on ESX.

Anandtech – Intel processor comparisons

JBoss – Demo of their JEE Application Server platform

c't Magazine

Dell IT – uses it for much of their Oracle testing as well as for Microsoft SQL Server testing

Dell Enterprise Technology Center – most of the papers you see here used the DVD Store workload in one form or another

Return to Dell TechCenter Home Page