Cross feature testing in database systems

ABSTRACT

Cross feature testing is a generic term that refers to testing one or more features together. In this paper, we discuss what cross feature testing in a database system specifically entails. We will identify and explain some of the dependencies amongst feature interactions and how they are categorized. We also review some of the problem symptoms that can occur from cross feature failures. Some strategies to address these issues as they relate to the database are also discussed, but a thorough analysis of any cross feature test solutions is beyond the scope of this paper the goal of which is to provide a basis for future dialog on this topic.

REFERENCES

• 1: Bolton, M. Pairwise Testing. http://www.developsense.com/testing/PairwiseTesting.html.
• 2: Kalen Delaney, Inside Microsoft (r) SQL Server (tm) 2005: The Storage Engine, Microsoft Press, Redmond, WA, 2006
• 3: Gadomski, A. M., Balducelli, C., Bologna, S., and DiCostanzo, G. 1998 Integrated Parallel Bottom-up and Top-down Approach to the Development of Agent-based Intelligent DSSs for Emergency Management. TIEMS98, (Washington, DC).
• 4: McDowell, A. G. All-Pairs Testing. http://www.mcdowella.demon.co.uk/allPairs.html.
• 5: Keith Stobie, Too darned big to test, Queue, v.3 n.1, February 2005 [doi>10.1145/1046931.1046944]
• 6: SQL Server 2005 Virtual Backup Device Interface (VDI) Specification. Microsoft Download Center. http://www.microsoft.com/downloads/details.aspx?FamilyID=416f8a51-65a3-4e8-a4c8-adfe15e850fc&DisplayLang=en.
• 7: Rathakrishnan, B. et al. Using CLR Integration in SQL Server 2005. SQL Server Books Online. http://msdn2.microsoft.com/en-us/library/ms345136.aspx.
• 8: Understanding Extensible Key Management. SQL Server Books Online. http://msdn2.microsoft.com/en-us/library/bb895340(SQL.100).aspx.
• 9: Microsoft Knowledge Base KB 933265. Microsoft Knowledge Base. http://support.microsoft.com/kb/933265/.
• 10: Encrypting Connections to SQL Server. SQL Server Books Online. http://msdn2.microsoft.com/en-us/library/ms189067.aspx.
• 11: Database Mirroring in SQL Server 2005. SQL Server Books Online. http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx.
• 12: Backup Compression (SQL Server). SQL Server Books Online. http://technet.microsoft.com/en-us/library/bb964719(SQL.100).aspx.
• 13: Hsueh, S. 2008. Database Encryption in SQL Server 2008 Enterprise Edition. Microsoft SQL Server technical article. http://msdn2.microsoft.com/en-us/library/cc278098(SQL.100).aspx.
• 14: Partitioned Tables and Indexes in SQL Server 2005. SQL Server Books Online. http://msdn2.microsoft.com/en-us/library/ms345146.aspx.
• 15: SQL Server 2005 Security Features at a Glance. http://www.microsoft.com/sql/technologies/security/security-at-a-glance.mspx.
• 16: Starting SQL Server in Single-User Mode. SQL Server Books Online. http://msdn.microsoft.com/en-us/library/ms188236.aspx.
• 17: Myra B. Cohen , Peter B. Gibbons , Warwick B. Mugridge , Charles J. Colbourn, Constructing test suites for interaction testing, Proceedings of the 25th International Conference on Software Engineering, May 03-10, 2003, Portland, Oregon
• 18: C. Lott , A. Jain , S. Dalal, Modeling requirements for combinatorial software testing, ACM SIGSOFT Software Engineering Notes, v.30 n.4, July 2005

INDEX TERMS

Primary Classification:
  B. Hardware
  B.8 Performance and Reliability
      B.8.1 Reliability, Testing, and Fault-Tolerance

General Terms:
Design, Human Factors, Management, Reliability

Keywords:
cross feature, database, definition, microsoft SQL server, test design, test strategy