Oracle Application with Database Testing tool

Authors

  • Navyashree. B S  Department of Information Science and Engineering, The National Institute of Engineering, Mysuru, Karnataka, India
  • Dr. S Kuzhalvaimozhi  Department of Information Science and Engineering, The National Institute of Engineering, Mysuru, Karnataka, India

Keywords:

Oracle Database, Real Application Cluster, Vdbench, Silly Little Oracle Benchmark.

Abstract

Oracle Database is simple and highly scalable database. It is majorly used for online transactions processing. Large enterprises widely use Oracle Database in their organization in multiple departments like HR Department, IT Department etc., Each department would host their database with large schema and tablespace. Ensuring database is sized well to handle multiple users to get optimal performance is very important. Oracle deployment can be done with single node deployment and Real Application Cluster (RAC) with multiple nodes. Database testing tools help in measuring the workloads on the database. The tool will provide measured values of latency, throughput and Input / Output Operations per Second (IOPS). Mainly there are two notable Oracle Database tools like Vdbench testing tool and Silly Little Oracle Benchmark (SLOB) testing tool.

References

  1. Hendro Nindito, Andreas Raharto Condrobimo, Albert Versius Dian Sano,” Rule Based Classification for Diseases Articles Using Oracle Database 12c”.
  2. Shadi Abdul Khalek, Sarfraz Khurshid,” Systematic Testing of Database Engines Using a Relational Constraint Solver 2011 Fourth IEEE International Conference on Software Testing, Verification and Validation
  3. Oracle, “Unstructured Data Management with Oracle Database 12 c,” White Pap., no. September 2014.
  4. K Gayathri and M. Chitra, “Review of Classification Techniques for Identifying Disease Cause and Diagnosis,” Int. J. Adv. Res. Comput. Sci. Software Eng., vol. 4, no. 11, pp. 521–524, 2014
  5. G Mamakis, A. G. Malamos, J. A. Ware, and I. Karelli, “Document Classification in Summarization,” J. Inf. Comput. Sci., vol. 7, no. 1, pp. 25–36, 2012.
  6. Raquel Blanco, Javier Tuya, Ruben V. Seco, "Test Adequacy Evaluation for the User-database Interaction: A Specification-Based Approach", Software Testing Verification and Validation (ICST) 2012 IEEE Fifth International Conference on, pp. 71-80, 2012.
  7. Oracle, “Oracle Text, An Oracle Technical White Paper,” Oracle Tech. White Pap., no. June, 2013.
  8. K Gayathri and M. Chitra, “Review of Classification Techniques for Identifying Disease Cause and Diagnosis,” Int. J. Adv. Res. Comput. Sci. Software Eng., vol. 4, no. 11, pp. 521–524, 2014.
  9. Shadi A. Khalek, Bassem Elkarablieh, Y. O. Laleye, and Sarfraz Khurshid. Query-Aware Test Generation Using a Relational Constraint Solver. In ASE ’08, pages 238-247, IEEE
  10. Nicolas Bruno, Surajit Chaudhuri, and Dilys Thomas. Generating queries with cardinality constraints for DBMS testing. IEEE Transactions on Knowledge and Data Engineering, 18(12):1721–1725, 2006
  11. Meikel Poess and Jr. John M. Stephens. Generating thousand benchmark queries in seconds. In VLDB’2004, pages 1045– 1053.
  12. Nicolas Bruno and Surajit Chaudhuri. Flexible database generators. In VLDB ’05, pages 1097–1107. VLDB Endowment
  13. Yuetang Deng, Phyllis Frankl, and David Chays. Testing database transactions with agenda. In ICSE ’05: Proceedings of the 27th international conference on Software engineering, pages 78–87, 2005.
  14. Carsten Binnig, Donald Kossmann, Eric Lo, and M. Tamer ¨ Ozsu. Qagen: generating query-aware test databases. In SIGMOD Conference, pages 341–352, 2007.
  15. MySql opensource database. http://www.mysql.com/.

IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology

Downloads

Published

2018-05-08

Issue

Volume 4, Issue 6, May-June-2018

Section

Research Articles

License

Copyright (c) IJSRCSEIT

Creative Commons License

This work is licensed under a Creative Commons Attribution 4.0 International License.

How to Cite

[1]
Navyashree. B S, Dr. S Kuzhalvaimozhi, " Oracle Application with Database Testing tool, IInternational Journal of Scientific Research in Computer Science, Engineering and Information Technology(IJSRCSEIT), ISSN : 2456-3307, Volume 4, Issue 6, pp.398-404, May-June-2018.