Data represent today an important asset for companies and organizations and must be protected. Most of an organization’s sensitive and proprietary data resides in a Database Management System (DBMS). Various attacks (e.g., malicious transactions) may corrupt data items in the database systems, which decreases the integrity level of the database. Malicious transactions detection mechanisms are becoming more and more sophisticated to detect such attacks. These mechanisms are implemented either externally as an autonomous subsystems separated from the DBMS, internally to the DBMS using database triggers, or internally to the DBMS using database stored procedures by compiling them into native code residing in shared libraries. The focus of this paper is to investigate the effect of malicious transactions detection mechanisms implementation on database performance. This paper presents implementation of three mechanisms for detection of malicious transactions in the Oracle 10g DBMS, and investigates the performance of the three mechanisms using a telephone database. The experimental results showed that the average performance overhead caused by the activation of the external and the native mechanisms is about 40%, and about 48% for the database trigger mechanism. As a result, the external and the native mechanisms outperform the database trigger mechanism in term of database performance.
Shalish, W., Ghalwash, A., El-Deeb, H., Salama, G., Mohamed, H., & Badran, K. (2011). Database Performance Sensitivity for Malicious Transactions Detection Mechanisms. International Conference on Aerospace Sciences and Aviation Technology, 14(AEROSPACE SCIENCES & AVIATION TECHNOLOGY, ASAT - 14 – May 24 - 26, 2011), 1-10. doi: 10.21608/asat.2011.23379
MLA
W. K. Shalish; A. Z. Ghalwash; H. M. El-Deeb; G. I. Salama; H. A. Mohamed; K. Badran. "Database Performance Sensitivity for Malicious Transactions Detection Mechanisms", International Conference on Aerospace Sciences and Aviation Technology, 14, AEROSPACE SCIENCES & AVIATION TECHNOLOGY, ASAT - 14 – May 24 - 26, 2011, 2011, 1-10. doi: 10.21608/asat.2011.23379
HARVARD
Shalish, W., Ghalwash, A., El-Deeb, H., Salama, G., Mohamed, H., Badran, K. (2011). 'Database Performance Sensitivity for Malicious Transactions Detection Mechanisms', International Conference on Aerospace Sciences and Aviation Technology, 14(AEROSPACE SCIENCES & AVIATION TECHNOLOGY, ASAT - 14 – May 24 - 26, 2011), pp. 1-10. doi: 10.21608/asat.2011.23379
VANCOUVER
Shalish, W., Ghalwash, A., El-Deeb, H., Salama, G., Mohamed, H., Badran, K. Database Performance Sensitivity for Malicious Transactions Detection Mechanisms. International Conference on Aerospace Sciences and Aviation Technology, 2011; 14(AEROSPACE SCIENCES & AVIATION TECHNOLOGY, ASAT - 14 – May 24 - 26, 2011): 1-10. doi: 10.21608/asat.2011.23379