Oracle Application with Database Testing tool

Authors(2) :-Navyashree. B S, Dr. S Kuzhalvaimozhi

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.

Authors and Affiliations

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

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

  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/.

Publication Details

Published in : Volume 4 | Issue 6 | May-June 2018
Date of Publication : 2018-05-08
License:  This work is licensed under a Creative Commons Attribution 4.0 International License.
Page(s) : 398-404
Manuscript Number : CSEIT184675
Publisher : Technoscience Academy

ISSN : 2456-3307

Cite This Article :

Navyashree. B S, Dr. S Kuzhalvaimozhi, "Oracle Application with Database Testing tool", International 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.
Journal URL : http://ijsrcseit.com/CSEIT184675

Article Preview

Follow Us

Contact Us