Transaction Dependency Based Approach for Database Damage Assessment Using a Matrix

One of the critical concerns in the current era is information security. Companies are sharing vast online critical data, which exposes their databases to malicious attacks. When protection techniques fail to prevent an attack, recovery is needed. Database recovery is not a straightforward procedure...

Full description

Saved in:
Bibliographic Details
Main Author: Haraty, Ramzi Ahmed (author)
Other Authors: Kaddoura, Sanaa (author), Zekri, Ahmed (author)
Format: article
Published: 2017
Online Access:http://hdl.handle.net/10725/6941
http://dx.doi.org/10.4018/IJSWIS.2017040105
http://libraries.lau.edu.lb/research/laur/terms-of-use/articles.php
https://www.igi-global.com/article/transaction-dependency-based-approach-for-database-damage-assessment-using-a-matrix/176734
Tags: Add Tag
No Tags, Be the first to tag this record!
_version_ 1864513481076637696
author Haraty, Ramzi Ahmed
author2 Kaddoura, Sanaa
Zekri, Ahmed
author2_role author
author
author_facet Haraty, Ramzi Ahmed
Kaddoura, Sanaa
Zekri, Ahmed
author_role author
dc.creator.none.fl_str_mv Haraty, Ramzi Ahmed
Kaddoura, Sanaa
Zekri, Ahmed
dc.date.none.fl_str_mv 2017
2018-01-23T14:25:22Z
2018-01-23T14:25:22Z
2018-01-23
dc.identifier.none.fl_str_mv 1552-6283
http://hdl.handle.net/10725/6941
http://dx.doi.org/10.4018/IJSWIS.2017040105
Haraty, R. A., Kaddoura, S., & Zekri, A. (2017). Transaction Dependency Based Approach for Database Damage Assessment Using a Matrix. International Journal on Semantic Web and Information Systems (IJSWIS), 13(2), 74-86.
http://libraries.lau.edu.lb/research/laur/terms-of-use/articles.php
https://www.igi-global.com/article/transaction-dependency-based-approach-for-database-damage-assessment-using-a-matrix/176734
dc.language.none.fl_str_mv en
dc.relation.none.fl_str_mv International Journal on Semantic Web and Information Systems
dc.rights.*.fl_str_mv info:eu-repo/semantics/openAccess
dc.title.none.fl_str_mv Transaction Dependency Based Approach for Database Damage Assessment Using a Matrix
dc.type.none.fl_str_mv Article
info:eu-repo/semantics/publishedVersion
info:eu-repo/semantics/article
description One of the critical concerns in the current era is information security. Companies are sharing vast online critical data, which exposes their databases to malicious attacks. When protection techniques fail to prevent an attack, recovery is needed. Database recovery is not a straightforward procedure, since the transactions are highly interconnected. Traditional recovery techniques do not consider the interconnection between transactions because this information is not saved anywhere in the log file. Thus, they rollback all the transactions starting from the detected malicious transaction to the end of the log file. Hence, both affected and benign transactions will be rolled back, which is a waste of time. This paper presents an algorithm that works efficiently to assess the damage caused in the database by malicious transaction and recovers it. The proposed algorithm keeps track of the transactions that read from one another and store this information in a single matrix. The experimental results prove that the algorithm is faster than any other existing algorithm in this domain.
eu_rights_str_mv openAccess
format article
id LAURepo_830becf35a93a529cfbf04069fe6b5bf
identifier_str_mv 1552-6283
Haraty, R. A., Kaddoura, S., & Zekri, A. (2017). Transaction Dependency Based Approach for Database Damage Assessment Using a Matrix. International Journal on Semantic Web and Information Systems (IJSWIS), 13(2), 74-86.
language_invalid_str_mv en
network_acronym_str LAURepo
network_name_str Lebanese American University repository
oai_identifier_str oai:laur.lau.edu.lb:10725/6941
publishDate 2017
repository.mail.fl_str_mv
repository.name.fl_str_mv
repository_id_str
spelling Transaction Dependency Based Approach for Database Damage Assessment Using a MatrixHaraty, Ramzi AhmedKaddoura, SanaaZekri, AhmedOne of the critical concerns in the current era is information security. Companies are sharing vast online critical data, which exposes their databases to malicious attacks. When protection techniques fail to prevent an attack, recovery is needed. Database recovery is not a straightforward procedure, since the transactions are highly interconnected. Traditional recovery techniques do not consider the interconnection between transactions because this information is not saved anywhere in the log file. Thus, they rollback all the transactions starting from the detected malicious transaction to the end of the log file. Hence, both affected and benign transactions will be rolled back, which is a waste of time. This paper presents an algorithm that works efficiently to assess the damage caused in the database by malicious transaction and recovers it. The proposed algorithm keeps track of the transactions that read from one another and store this information in a single matrix. The experimental results prove that the algorithm is faster than any other existing algorithm in this domain.PublishedN/A2018-01-23T14:25:22Z2018-01-23T14:25:22Z20172018-01-23Articleinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/article1552-6283http://hdl.handle.net/10725/6941http://dx.doi.org/10.4018/IJSWIS.2017040105Haraty, R. A., Kaddoura, S., & Zekri, A. (2017). Transaction Dependency Based Approach for Database Damage Assessment Using a Matrix. International Journal on Semantic Web and Information Systems (IJSWIS), 13(2), 74-86.http://libraries.lau.edu.lb/research/laur/terms-of-use/articles.phphttps://www.igi-global.com/article/transaction-dependency-based-approach-for-database-damage-assessment-using-a-matrix/176734enInternational Journal on Semantic Web and Information Systemsinfo:eu-repo/semantics/openAccessoai:laur.lau.edu.lb:10725/69412021-03-19T10:43:19Z
spellingShingle Transaction Dependency Based Approach for Database Damage Assessment Using a Matrix
Haraty, Ramzi Ahmed
status_str publishedVersion
title Transaction Dependency Based Approach for Database Damage Assessment Using a Matrix
title_full Transaction Dependency Based Approach for Database Damage Assessment Using a Matrix
title_fullStr Transaction Dependency Based Approach for Database Damage Assessment Using a Matrix
title_full_unstemmed Transaction Dependency Based Approach for Database Damage Assessment Using a Matrix
title_short Transaction Dependency Based Approach for Database Damage Assessment Using a Matrix
title_sort Transaction Dependency Based Approach for Database Damage Assessment Using a Matrix
url http://hdl.handle.net/10725/6941
http://dx.doi.org/10.4018/IJSWIS.2017040105
http://libraries.lau.edu.lb/research/laur/terms-of-use/articles.php
https://www.igi-global.com/article/transaction-dependency-based-approach-for-database-damage-assessment-using-a-matrix/176734