DBSoft: A toolkit for testing database transactions

Research output: Contribution to journalArticle

1 Citation (Scopus)

Abstract

Databases (DBs) are used in all enterprise transactions, which require attention not only to the consistency of DB, but also to existence, accuracy and correctness of data required by the transactions. While the Atomicity, Consistency, Isolation, and Durability (ACID) properties of a transaction ensure that DB is consistent after the execution of each transaction, it is not sure that the transactions retrieve the correct data. Indeed, the testing phase of the transactions, in the development process, is often ignored. Therefore, there is a need for testing techniques and tools. This paper proposes an architecture, a design, and an implementation of a tester, we refer to as DBSoft, to test transactions, in terms of required data they need to access. The architecture of DBSoft is a layered one. It is made of five components having separate concerns and serving each other: (C1) a parser to collect information, specifically for the metadata, (C2) an input generator to generate test cases, (C3) an output generator to implement the test cases, (C4) an output validator to validate test cases, and (C5) a report generator to generate test reports. DBSoft aims at avoiding cost effective transaction run-time errors.

Original languageEnglish
Pages (from-to)205-212
Number of pages8
JournalJournal of Emerging Technologies in Web Intelligence
Volume5
Issue number3
DOIs
Publication statusPublished - Aug 2013

Keywords

  • Databases
  • Metadata
  • Testing Tools
  • Transactions
  • XML

ASJC Scopus subject areas

  • Computer Networks and Communications

Fingerprint Dive into the research topics of 'DBSoft: A toolkit for testing database transactions'. Together they form a unique fingerprint.

  • Cite this