Peer-reviewed articles 17,970 +


Title: COMPARING BACKUP AND RESTORE EFICIENCY IN MYSQL, MS SQL SERVER AND MONGODB
COMPARING BACKUP AND RESTORE EFICIENCY IN MYSQL, MS SQL SERVER AND MONGODB

PlumX Article Metrics by Elsevier
I. Kuyumdzhiev
10.5593/sgem2019/2.1/S07.022
1314-2704
978-619-7408-79-9
English
19
2.1
Informatics
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
conference
https://www.sgem.org/index.php/jresearch-article?citekey=Kuyumdzhiev20197167174
Download PDF
19th International Multidisciplinary Scientific GeoConference SGEM 2019
19th International Multidisciplinary Scientific GeoConference SGEM 2019, 30 June - 6 July, 2019
Proceedings Paper
STEF92 Technology
International Multidisciplinary Scientific GeoConference-SGEM
Bulgarian Acad Sci; Acad Sci Czech Republ; Latvian Acad Sci; Polish Acad Sci; Russian Acad Sci; Serbian Acad Sci & Arts; Slovak Acad Sci; Natl Acad Sci Ukraine; Natl Acad Sci Armenia; Sci Council Japan; World Acad Sci; European Acad Sci, Arts & Letters; Ac
167-174
30 June - 6 July, 2019
website
cdrom
5344
backup; recovery; mysql; mongodb; sql server