Scholarly record
COMPARING BACKUP AND RESTORE EFICIENCY IN MYSQL, MS SQL SERVER AND MONGODB
Abstract
This paper suggests that in order to create efficient backup and recovery strategy for database management system, an appropriate unit of analysis and a proper, data is needed. Key factors for evaluating backup and recovery are time needed to bring the system back online and the amount of data loss. The paper examines methods for managing these factors in three of the most popular DBMS ? MySQL, MS SQL Server and MongoDB. Each of them has a set of backup types that can be combined in different strategies. Depending on characteristics of the database (such as size, modify rate etc.) the combination could lead to efficient results or slowing down the system performance and loss of data. Some advantages and disadvantages of the examined DBMS are found and preferable presets to be used for better efficiency are defined. The reason these findings are important is that they help database administrators to build the best backup and recovery strategy depending on organization's needs
Publication Impact Profile
- Captures
- Mendeley - Readers: 17
Publication details
References0
Structured references will appear here after the reference import pass. The count is preserved now so the scholarly record is not incomplete.
Citing literature
Number of times cited according to Crossref: 10
View or Download full articleAccess options
SWS access login
Login as SWS Scientific CommitteeLogin as SWS Scientific PartnerLogin as SWS AuthorAuthors and approved SWS contributors will read and export their own linked papers after identity matching by SWS profile, email and SGEM GlobalID.
For librarian assistance: [email protected]
Purchase Instant Access
- Article can be downloaded after successful payment.
- Article may be used according to SWS library access terms.
- Article cannot be redistributed.