DBSoft: A toolkit for testing database transactions

Zuhoor A. Al-Khanjari, Youcef Baghdadi, Abdullah Al-Hamdani, Sara Al-Kindi

نتاج البحث: المساهمة في مجلةArticleمراجعة النظراء

1 اقتباس (Scopus)

ملخص

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.

اللغة الأصليةEnglish
الصفحات (من إلى)205-212
عدد الصفحات8
دوريةJournal of Emerging Technologies in Web Intelligence
مستوى الصوت5
رقم الإصدار3
المعرِّفات الرقمية للأشياء
حالة النشرPublished - أغسطس 2013

ASJC Scopus subject areas

  • ???subjectarea.asjc.1700.1705???

بصمة

أدرس بدقة موضوعات البحث “DBSoft: A toolkit for testing database transactions'. فهما يشكلان معًا بصمة فريدة.

قم بذكر هذا