1. How to submit my research paper? What’s the process of publication of my paper?
The journal receives submitted manuscripts via email only. Please submit your research paper in .doc or .pdf format to the submission email: jetwi@etpub.com.
2.Can I submit an abstract?
The journal publishes full research papers. So only full paper submission should be considered for possible publication. Papers with insufficient content may be rejected as well, make sure your paper is sufficient enough to be published...[Read More]

DBSoft: A Toolkit for Testing Database Transactions

Zuhoor A. Al-Khanjari, Youcef Baghdadi, Abdullah Al-Hamdani, and Sara Al-Kindi
Department of Computer Science, Sultan Qaboos University, Muscat, Oman
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.

Index Terms—databases, transactions, testing tools, metadata, XML

Cite: Zuhoor A. Al-Khanjari, Youcef Baghdadi, Abdullah Al-Hamdani, and Sara Al-Kindi, "DBSoft: A Toolkit for Testing Database Transactions," Journal of Emerging Technologies in Web Intelligence, Vol. 5, No. 3, pp. 205-212, August 2013. doi:10.4304/jetwi.5.3.205-212
Copyright © 2013-2020 Journal of Emerging Technologies in Web Intelligence, All Rights Reserved
E-mail: jetwi@etpub.com