Developing a database management SAAS for multi-cloud distributed databases

Abstract

In the ever-changing world of DevOps, regular database maintenance and backups are critical to achieving stability and safety by minimizing downtime, performance degradation, security breaches, or data loss. These behaviors are not allowed, which is harmful to the reputation of users and companies at worst or punishable by non-compliance violations, periods of inactivity, and declining productivity, especially when a disaster could come from data loss for core software operations. The risk of catastrophic data loss from system failures, cyber-attacks, or human errors is simply too great to allow any business that cares about its survival not to have a backup. In business agility, which is so ruthless to IT managers and operators, if they do not maintain their databases correctly, all kinds of issues can result from difficulty in collaborating effectively through true replication barriers caused by moves between production, testing, or development environments.

The key accomplishment of this thesis was creating better database maintenance software that ensures data security through carefully planned backups of databases in the software ecosystem. To achieve this, I thoroughly examined current database management systems, pointing out flaws in their data retrieval and backup procedures.

The main achievement of this thesis was more secure data, thanks to better database maintenance software with backups planned on the environment. I did this by extensively evaluating popular database management systems and exposing data recovery and backup problems. This work created and implemented a database connector that is flexible and applicable to any type of database for easy communication. This provides an automated process of data dump where users can choose time intervals to automate their dumps and save the system from manually causing human errors and loss in database related issues while improving the user experience. I also worked on backend encryption techniques for the security component to encrypt data during backup. It is the same with the validation system, which validates that we are only moving accurate, complete data since integrity checks are behind it. I made sure to design an easy user interface, actively allowing users to look up their previous backup logs and modify the schedules for backups, in addition to being able users to easily restore data when needed. This thesis enhanced the reliability of database management, helped maintain data security, and gave guidelines relevant to recovery techniques.