Testing on a budget: integrating e-business certification into the Oracle DBMS testing

Authors:
Mohamed Zait;Allison Lee;Khaled Yagoub;Ravi Sahani;Holly Casaletto;Lokesh Kumar
Affiliations:
Oracle USA, Redwood Shores, CA;Oracle USA, Redwood Shores, CA;Oracle USA, Redwood Shores, CA;Oracle USA, Redwood Shores, CA;Oracle USA, Redwood Shores, CA;Oracle USA, Redwood Shores, CA
Venue:
Proceedings of the Second International Workshop on Testing Database Systems
Year:
2009

Citing 2
Cited 1

Cost-based query transformation in Oracle

VLDB '06 Proceedings of the 32nd international conference on Very large data bases
Automatic SQL tuning in oracle 10g

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30

Testing cardinality estimation models in SQL server

DBTest '12 Proceedings of the Fifth International Workshop on Testing Database Systems

Quantified Score

Hi-index	0.00

Visualization

Abstract

Testing complex software is one of the most challenging steps in the software development lifecycle. Several testing methods are usually used from the time the subject software component is ready for testing until the complete system where the software component operates is released for distribution. In this paper, we describe one of the methods used to test the SQL Engine of the Oracle database management system (DBMS). This process has been designed to track, detect and report quality problems along with detailed metrics that make it easier to find the root cause of different types of regressions (failures, result correctness, and performance). The test process has been built on top of a framework that is extensible so that any schema and SQL workload can be plugged into the framework. The process described here is currently part of the Oracle DBMS test process.