MOD

Database recovery mechanisms depend on various guarantees provided by the underlying storage media. With the changing industrial landscape, database systems are deployed on storage media that may not provide all the guarantees that traditional ...

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

Fuzz testing has been known for almost two decades and it is a relatively well known and documented technique among security testers and researchers today. Fuzzing is a valuable and effective mechanism for finding security vulnerabilities.

The case ...

The query engine is the component inside a database system that is responsible for the compilation and execution of every SQL statement submitted by a database user or application. One of the most important steps of query compilation is query ...

Testing and debugging database system applications is often challenging and time consuming. A database tester (or DB tester for short) has to detect a problem, determine why it happened, set up an environment to reproduce it, and then create a fix to ...

Keeping the test databases as small as possible leads to faster execution of tests and facilitates the task of completing the test cases and evaluating the actual outputs against the expected. In this paper we present an automated approach to database ...

Operational and usage profiles collected from customers provide developers and testers with valuable quantitative information on usage patterns of software being developed. Unfortunately, gathering such profiles from a large set of customers can be ...

Oracle Database Replay provides a new way to test changes to a database system by reproducing the real user workload in a test environment. It helps to identify potential problems after software or hardware upgrades, patches, or changes to database ...

Traditionally, the goal of benchmarking a software system is to evaluate its performance under a particular workload for a fixed configuration. The most prominent examples for evaluating transactional database systems as well as other components on top (...

Transaction relationships are usually ignored in current OLTP workload modeling and benchmark test system implementation. In this paper, two workflow driven models for real system workloads are proposed, one using Markov process, and the other Petri-...

Database workloads consist of mixes of queries that run concurrently and interact with each other. In this paper, we demonstrate that query interactions can have a significant impact on database system performance. Hence, we argue that it is important ...

SQL tuning---the attempt to improve a poorly-performing execution plan produced by the database query optimizer---is a critical aspect of database performance tuning. Ironically, as commercial databases strive to improve on the manageability front, SQL ...

White-box testing is an important part of every software testing and quality assurance strategy. Testing database-driven applications requires the adoption of white-box testing, but it is not clear what adoption is needed. Instead of focusing on a ...