The DVD Store Version 2 (DS2) is a complete online e-commerce test application, with a backend database component, a web application layer, and driver programs. The goal in designing the database component as well as the midtier application was to utilize many advanced database features (transactions, stored procedures, triggers, referential integity) 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 SQL Server, Oracle and MySQL. Included in the release are data generation programs, shell scripts to build data for 10MB, 1GB and 100 GB versions of the DVD Store, database build scripts and stored procedure, 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

Uses of the DVD Store Test Database:

VMware - Results with Oracle DB on VMware

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 SQL Server testing

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

Return to Dell TechCenter Home Page