CFP last date
20 May 2024
Call for Paper
June Edition
IJCA solicits high quality original research papers for the upcoming June edition of the journal. The last date of research paper submission is 20 May 2024

Submit your paper
Know more
The week's pick
Responsive image
Enhancing Privacy Preservation: Multi-Attribute Protection with P-Sensitive K-Anonymity

Twinkle Patel Kiran Amin
Random Articles
Reseach Article

Designing and Development of Database Testing Tool

by Taranpreet Kaur, Sumeet Kaur Sehra
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 120 - Number 19
Year of Publication: 2015
Authors: Taranpreet Kaur, Sumeet Kaur Sehra
10.5120/21334-4330

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 },
issue_date = { June 2015 },
volume = { 120 },
number = { 19 },
month = { June },
year = { 2015 },
issn = { 0975-8887 },
pages = { 9-14 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume120/number19/21334-4330/ },
doi = { 10.5120/21334-4330 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T23:06:37.762083+05:30
%A Taranpreet Kaur
%A Sumeet Kaur Sehra
%T Designing and Development of Database Testing Tool
%J International Journal of Computer Applications
%@ 0975-8887
%V 120
%N 19
%P 9-14
%D 2015
%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
  1. 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
  2. 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.
  3. Deng, Y. Frankl, P. G. and Wang, J. "Testing web database applications" ACM SIGSOFT Software Engineering Notes, 29 (5): 1–10, 2004.
  4. Haller, K. (2009), "White-Box testing for Database-driven applications: A Requirement Analysis", Zurich, Switzerland.
  5. Howard, P. (July 2012), "Exploring Successful Approaches to Test Data Management - A White Paper by Bloor Research"
  6. 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
  7. 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
  8. 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.
  9. Jovanovich and Irena, "Software Testing Methods and Techniques," May 26, 2008.
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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.
  16. Orso, A. and Rothermel, G. "Software Testing: A Research Travelogue (2000–2014)" Georgia Institute of Technology Atlanta, GA, USA
  17. 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
  18. 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
  19. 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
  20. 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
  21. Shea, B. (2000, May/June). Avoiding Scalability Shock. Software Testing & Quality Engineering Magazine, 42-46.
  22. 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
  23. 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
  24. Willmor, D. and Embury, M. ,S. (2005), "Exploring test adequacy for database system", Informatics Process Group, School of Computer Science.
  25. 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.
  26. 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.
  27. Walsham G (1993) „Interpreting Information Systems in Organizations? Wiley Series on IS
  28. 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.
  29. Yin, R. (1994, 2003),"Case Study Research Design and Methods" second and third edition Applied Social Research Methods Series, Volume 5, Sage Publications.
  30. Software Testing Research Survey Bibliography. http://people. engr. ncsu. edu/txie/testingresearchsurvey. htm
Index Terms

Computer Science
Information Sciences

Keywords

MySQL LAMP PHP JSP GUI XML IDM TPC-C .

Powered by PhDFocusTM