Testing Database Systems

If you separate the idea of testing the interfaces to your database from testing the database internals, then the usual unit testing frameworks (xUnit) work for testing the interfaces. Tools are beginning to be available to help with testing the internals. See Visual Studio Team System for Database Professionals (for SQL Server), Eclipse Data Tools Platform, and Qute from Quest (for Oracle) for examples.

Scott W. AmblerAgile Database Techniques: Effective Strategies for the Agile Software Developer, Wiley and Sons, 2003.

Ambler, Scott W. and Pramod SadalageRefactoring Databases: Evolutionary Database Design, Addison-Wesley, 2006.

Scott W. Ambler, "Test-Driven Development of Relational Databases", IEEE Software, May/June 2007, pp 37-43. 

Richard Dallaway, "Unit Testing Database Code", 2006. 

Don Slutz, "Massive Stochastic Testing of SQL", Proceedings of the Very Large Database Conference 1998. They developed a tool to generate statistically random SQL. inputs. 

T. Dasu and T. Johnson, Exploratory Data Mining and Data Cleaning John Wiley and Sons, 2003.

Larry English, Improving Data Warehouse and Business Information Quality, New York, Wiley, 1999.

Search for more resources