New Updated DVD Store Database Test Program Overview with Dave Jaffe, Ph.D.

12/8/11: DVDStore MySQL version now available at
Be sure to watch these videos in 720p HD

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, MySQL, and PostgreSQL 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.

DVD Store Version 2.1 was released December 2010 and includes enhancements allowing for the creation of any size database, running a single driver program against multiple targets with consolidated and broken-out stats, better error handling, auto creation of driver program config file, and updated data with current dates.

DVD Store 2.1 is also included as one of the workloads in VMmark 2.0 - a multi-host virtualization benchmark from VMware.

The code is freely available to all under the GPL from 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 2011).  Added support for PostgreSQL DB. Click for download. Details in ds21_documentation.txt in main tarball.

DVD Store Quick Links

Readme FAQs
DVD Store Database Schema LAMP Stack

DVD Store Test Database Uses

PowerEdge R910 SQL OLTP Virtualization Study - Performance and performance/watt of SQL virtual machines (VMs) on VMware with Xeon 7500 and E7-4800 series processors

EqualLogic Demo Video - Shows VSS Snapshot integration with SQL Server

VMware – Results with Oracle database on VMware

VMware and DB2 - Performance testing of DB2 virtual machines (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