Research Article

Designing and Development of Database Testing Tool

by  Taranpreet Kaur, Sumeet Kaur Sehra
journal cover
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 120 - Issue 19
Published: June 2015
Authors: Taranpreet Kaur, Sumeet Kaur Sehra
10.5120/21334-4330
PDF

Taranpreet Kaur, Sumeet Kaur Sehra . Designing and Development of Database Testing Tool. International Journal of Computer Applications. 120, 19 (June 2015), 9-14. DOI=10.5120/21334-4330

                        @article{ 10.5120/21334-4330,
                        author  = { Taranpreet Kaur,Sumeet Kaur Sehra },
                        title   = { Designing and Development of Database Testing Tool },
                        journal = { International Journal of Computer Applications },
                        year    = { 2015 },
                        volume  = { 120 },
                        number  = { 19 },
                        pages   = { 9-14 },
                        doi     = { 10.5120/21334-4330 },
                        publisher = { Foundation of Computer Science (FCS), NY, USA }
                        }
                        %0 Journal Article
                        %D 2015
                        %A Taranpreet Kaur
                        %A Sumeet Kaur Sehra
                        %T Designing and Development of Database Testing Tool%T 
                        %J International Journal of Computer Applications
                        %V 120
                        %N 19
                        %P 9-14
                        %R 10.5120/21334-4330
                        %I Foundation of Computer Science (FCS), NY, USA
Abstract

Tool enable user to perform all the operations from the beginning of data definition which includes Creating, Altering, Dropping and Truncate of table to the data manipulation that includes Selecting, Inserting, Updating and deleting of data, which is followed by controlling them that is commit and reset. In Data Definition we have commands of Creating and dropping of databases followed by creation of tables within a database. And it also allows altering the contents of table either by adding column(s) or removing them. Along with this, user can truncate the table that is removing the whole content of a table. In data manipulation, user has the provision of selecting a specific amount of data from a table by using "where" clause in the command of view data. User can also view data from different table(s) of databases by using sub-queries and join commands according to the requirement. User can insert, update and delete a number of data items whenever and whichever required. At any instance user has a provision of commit and reset of transaction.

References
  • Chan, W. K. and Cheung, S. C. (2005), "Fault-Based Testing of Database Application Programs with Conceptual Data Model" Proceedings of the 5th International Conference on Quality Software (QSIC 2005), IEEE Computer Society Press, Los Alamitos, California
  • Deng, Y. Frankl, P. G. and Chays, D. Testing database transactions with AGENDA. In Proceedings of the 27th International Conference on Software Engineering (ICSE 2005), pages 78–87. IEEE Computer Society Press, Los Alamitos, California, 2005.
  • Deng, Y. Frankl, P. G. and Wang, J. "Testing web database applications" ACM SIGSOFT Software Engineering Notes, 29 (5): 1–10, 2004.
  • Haller, K. (2009), "White-Box testing for Database-driven applications: A Requirement Analysis", Zurich, Switzerland.
  • Howard, P. (July 2012), "Exploring Successful Approaches to Test Data Management - A White Paper by Bloor Research"
  • Hall, G. C. Saucer, B. A. Brown, J. S. and Reynolds, M. W. and Casale, R. L. "Guidelines for Good Database Selection and use in Pharmacoepidemiology Research" Bourke Published online in Wiley Online Library DOI: 10. 1002/pds. 2229
  • Iacono, J. C. Brown, A. and Holtham, C. "The use of the Case Study Method in Theory Testing: The Example of Steel eMarketplaces" Cass Business School, London, UK
  • Just, R. Jalali, D. and Michael D. "Defects4J: A Database of Existing Faults to Enable Controlled Testing Studies for Java Programs" Computer Science and Engineering University of Washington.
  • Jovanovich and Irena, "Software Testing Methods and Techniques," May 26, 2008.
  • Kundu, S. (2012), "Web Testing: Tool, Challenges and Methods" IJCSI International Journal of Computer Science Issues, Vol. 9, Issue 2, No 3, March 2012 ISSN (Online): 1694-0814
  • Kumar, P. S. and Siva, N. S. (2014), "Automation of Software Testing in Agile Development-An Approach and Challenges with Distributed Database Systems" International Global Journal for Research Analysis Vol. 3 Issue 7 July 2014 ISSN NO-2277-8160
  • Kaur, H. (2013), "Comparative Study of Automated Testing Tools: Selenium, Quick Test Professional and Testcomplete. " International Journal of Engineering Research and Applications ISSN : 2248-9622, Vol. 3, Issue 5, Sep-Oct 2013, pp. 1739-1743
  • Manjunath, T. N. Hegadi, R. S. and Archana, R. A(2012) "A study on sampling techniques for data testing" International Journal of Computer Science And Communication Vol. 3 No. 1 January-June 2012 P. P 13-16
  • Mu, K. Yuriy, S. and Meliou, B. A. "Data Debugging with Continuous Testing" Computer Science & Engineering School of Computer Science University of Washington University of Massachusetts Seattle, WA, USA
  • Khan, M. E. (2010), "Different Forms of Software Testing Techniques for Finding Errors,"IJCSI International Journal of Computer Science Issues, Vol. 7, Issue 3, No 1, May 2010.
  • Orso, A. and Rothermel, G. "Software Testing: A Research Travelogue (2000–2014)" Georgia Institute of Technology Atlanta, GA, USA
  • Paygude, P. and Devale, P. R. "Automated Data Validation Testing Tool for Data Migration Quality Assurance" International Journal of Modern Engineering Research (IJMER) Vol. 3, Issue. 1, Jan-Feb. 2013 pp-599-603 ISSN: 2249-6645
  • Qu, X. Cohen, M. B. and Woolf, K. M. "Combinatorial Interaction Regression Testing: A Study of Test Case Generation and Prioritization" Department of Computer Science and Engineering University of Nebraska-Lincoln
  • Raquel Blanco, R. Tuya, J. and Seco, R. V. "Test adequacy evaluation for the user-database interaction: a specification-based Approach" University of Oviedo Gijón, Spain
  • Sharma, V. and Agrawal, A. P. (2013), "Regression Testing for Data-Driven Applications" International Journal of Innovative Technology and Exploring Engineering (IJITEE) ISSN: 2278-3075, Volume-3, Issue-1, June 2013
  • Shea, B. (2000, May/June). Avoiding Scalability Shock. Software Testing & Quality Engineering Magazine, 42-46.
  • Tuteja, M. and Dubey, G. (2012) "A Research Study on importance of Testing and Quality Assurance in Software Development Life Cycle (SDLC) Models" International Journal of Soft Computing and Engineering (IJSCE) ISSN: 2231-2307, Volume-2, Issue-3, July 2012
  • Trivedi, S. H. (2012), "Software Testing Techniques" International Journal of Advanced Research in Computer Science and Software Engineering Volume 2, Issue 10, October 2012 ISSN: 2277 128X
  • Willmor, D. and Embury, M. ,S. (2005), "Exploring test adequacy for database system", Informatics Process Group, School of Computer Science.
  • Walek, B. and Klimes, C. (2012), "A tool for database testing and optimization", International Journal of Computer and Communication Engineering, Vol. 1, No. 3, September 2012.
  • Weyuker, E & Vokolos, F. (2000). Experience with Performance Testing of Software Systems: Issues, an Approach, and Case Study. IEEE Transactions on Software Engineering, 25 (12), 1147-1156.
  • Walsham G (1993) „Interpreting Information Systems in Organizations? Wiley Series on IS
  • Xu, Z. Y. Kim, K. M, and G. Rothermel. A hybrid directed test suite augmentation technique. In Proceedings of the International Symposium on Software Reliability Engineering, 2011.
  • Yin, R. (1994, 2003),"Case Study Research Design and Methods" second and third edition Applied Social Research Methods Series, Volume 5, Sage Publications.
  • Software Testing Research Survey Bibliography. http://people. engr. ncsu. edu/txie/testingresearchsurvey. htm
Index Terms
Computer Science
Information Sciences
No index terms available.
Keywords

MySQL LAMP PHP JSP GUI XML IDM TPC-C .

Powered by PhDFocusTM