Securing Relational Databases against Security Vulnerabilities: A Case of Microsoft SQL Server and PostgreSQL

IF 16.4 1区化学 Q1 CHEMISTRY, MULTIDISCIPLINARY

Accounts of Chemical Research Pub Date : 2021-11-29 DOI:10.1080/19361610.2021.2006032

Hassan Kilavo, Salehe I. Mrutu, Robert G. Dudu

引用次数: 0

Abstract

Abstract This study evaluates mechanisms to secure relational databases against security vulnerabilities and utilized PostgreSQL and Microsoft SQL Server due to data breach incidences reported across the world. Emulation experiments with documentary review were employed to collect necessary study data. Identification of security features and vulnerabilities that are found to affect the data tier of the web applications were examined. The findings from the study have shown that Microsoft SQL Server is more security feature-rich in terms of Confidentiality, Integrity, and Availability compared to PostgreSQL and Microsoft SQL Server is more resilient to security attacks in its default behavior compared to PostgreSQL.

查看原文本刊更多论文

关系型数据库的安全防范:以Microsoft SQL Server和PostgreSQL为例

摘要本研究评估了保护关系数据库免受安全漏洞影响的机制，并因世界各地报告的数据泄露事件而使用PostgreSQL和Microsoft SQL Server。采用文献综述的仿真实验来收集必要的研究数据。对影响网络应用程序数据层的安全功能和漏洞的识别进行了检查。研究结果表明，与PostgreSQL相比，Microsoft SQL Server在机密性、完整性和可用性方面具有更丰富的安全功能，并且与PostgreQL相比，Microsoft SQL Server在默认行为下更能抵御安全攻击。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

求助全文

约1分钟内获得全文求助全文

来源期刊

Accounts of Chemical Research 化学-化学综合

CiteScore

31.40

自引率

1.10%

发文量

312

审稿时长

2 months

期刊介绍： Accounts of Chemical Research presents short, concise and critical articles offering easy-to-read overviews of basic research and applications in all areas of chemistry and biochemistry. These short reviews focus on research from the author’s own laboratory and are designed to teach the reader about a research project. In addition, Accounts of Chemical Research publishes commentaries that give an informed opinion on a current research problem. Special Issues online are devoted to a single topic of unusual activity and significance. Accounts of Chemical Research replaces the traditional article abstract with an article "Conspectus." These entries synopsize the research affording the reader a closer look at the content and significance of an article. Through this provision of a more detailed description of the article contents, the Conspectus enhances the article's discoverability by search engines and the exposure for the research.