|
| This Article | ||
| ||
| Share | ||
| Bibliographic References | ||
| Add to: | ||
 Digg  Furl  Spurl  Blink  Simpy  Google  Del.icio.us  Y!MyWeb | ||
| Search | ||
| ||
Test-Driven Development of Relational Databases
May/June 2007 (vol. 24 no. 3)
pp. 37-43
| ASCII Text | x | ||
| Scott W. Ambler, "Test-Driven Development of Relational Databases," IEEE Software, vol. 24, no. 3, pp. 37-43, May/June, 2007. | |||
| BibTex | x | ||
| @article{ 10.1109/MS.2007.91, author = {Scott W. Ambler}, title = {Test-Driven Development of Relational Databases}, journal ={IEEE Software}, volume = {24}, number = {3}, issn = {0740-7459}, year = {2007}, pages = {37-43}, doi = {http://doi.ieeecomputersociety.org/10.1109/MS.2007.91}, publisher = {IEEE Computer Society}, address = {Los Alamitos, CA, USA}, } | |||
| RefWorks Procite/RefMan/Endnote | x | ||
| TY - MGZN JO - IEEE Software TI - Test-Driven Development of Relational Databases IS - 3 SN - 0740-7459 SP37 EP43 EPD - 37-43 A1 - Scott W. Ambler, PY - 2007 KW - test-driven development KW - TDD KW - database refactoring KW - database testing KW - test-driven database design KW - TDD KW - relational database KW - behavior-driven development KW - BDD VL - 24 JA - IEEE Software ER - | |||
DOI Bookmark: http://doi.ieeecomputersociety.org/10.1109/MS.2007.91
Developers can use a test-driven development with database schema just as they use it with application code. Implementing test-driven database development (TDDD) involves three relatively simple steps: database refactoring, database regression testing, and continuous database integration. In database refactoring, developers make a simple change to a database to improve the design without changing its semantics. In database regression testing, they run a comprehensive test suite that validates the database regularly-ideally, whenever developers change the database schema or access the database in a different way. In continuous database integration, developers rebuild and retest the database schema whenever it changes. From a technical viewpoint, TDDD is straightforward. However, cultural challenges can make it difficult to adopt.
Index Terms:
test-driven development, TDD, database refactoring, database testing, test-driven database design, TDD, relational database, behavior-driven development, BDD
Citation:
Scott W. Ambler, "Test-Driven Development of Relational Databases," IEEE Software, vol. 24, no. 3, pp. 37-43, May-June 2007, doi:10.1109/MS.2007.91
Usage of this product signifies your acceptance of the Terms of Use.