Backup with Storage in a Database

This paper presents an overview of some technologies that are used in modern backup systems. We consider their advantages and disadvantages. Next, we consider an example of the realisation of the backup system with files store in the database. We propose to divide the copied files into blocks of fix...

Full description

Bibliographic Details
Main Author: S. M. Taranin
Format: Article
Language:English
Published: Yaroslavl State University 2016-08-01
Series:Моделирование и анализ информационных систем
Subjects:
Online Access:https://www.mais-journal.ru/jour/article/view/372
_version_ 1826559001399132160
author S. M. Taranin
author_facet S. M. Taranin
author_sort S. M. Taranin
collection DOAJ
description This paper presents an overview of some technologies that are used in modern backup systems. We consider their advantages and disadvantages. Next, we consider an example of the realisation of the backup system with files store in the database. We propose to divide the copied files into blocks of fixed length. Each block is a sequence of bytes. The block length may be adaptive, i.e. it can vary depending on the type or file size. We can store the file content in one table, and information of them such as names, attributes, and relationships between them, store in another table. The information of retained files and folders can be stored also on the client side in a hierarchical structure. It is a set of records and a model of the copied directory. The presence of such a model allows to find changes of the copied directory without additional queries to the database. If a file is modified, it is copied only the changed blocks. The model is also updated on the client side. Thus, the load on the data channel reduces. This paper presents the algorithms of saving and restoring data, and describes the factors that affect to the speed of their work. It demonstrates the dependence of the rate of saving and recovery of the fineness of the partition files, as well as the structure of the copied directory.
first_indexed 2024-04-10T02:24:27Z
format Article
id doaj.art-f1e3f50e3a0e451eaa3e461898cba13f
institution Directory Open Access Journal
issn 1818-1015
2313-5417
language English
last_indexed 2025-03-14T08:53:27Z
publishDate 2016-08-01
publisher Yaroslavl State University
record_format Article
series Моделирование и анализ информационных систем
spelling doaj.art-f1e3f50e3a0e451eaa3e461898cba13f2025-03-02T12:46:58ZengYaroslavl State UniversityМоделирование и анализ информационных систем1818-10152313-54172016-08-0123447949110.18255/1818-1015-2016-4-479-491318Backup with Storage in a DatabaseS. M. Taranin0P.G. Demidov Yaroslavl State University, YaroslavlThis paper presents an overview of some technologies that are used in modern backup systems. We consider their advantages and disadvantages. Next, we consider an example of the realisation of the backup system with files store in the database. We propose to divide the copied files into blocks of fixed length. Each block is a sequence of bytes. The block length may be adaptive, i.e. it can vary depending on the type or file size. We can store the file content in one table, and information of them such as names, attributes, and relationships between them, store in another table. The information of retained files and folders can be stored also on the client side in a hierarchical structure. It is a set of records and a model of the copied directory. The presence of such a model allows to find changes of the copied directory without additional queries to the database. If a file is modified, it is copied only the changed blocks. The model is also updated on the client side. Thus, the load on the data channel reduces. This paper presents the algorithms of saving and restoring data, and describes the factors that affect to the speed of their work. It demonstrates the dependence of the rate of saving and recovery of the fineness of the partition files, as well as the structure of the copied directory.https://www.mais-journal.ru/jour/article/view/372filedatabackupdatabaseblockmodel
spellingShingle S. M. Taranin
Backup with Storage in a Database
Моделирование и анализ информационных систем
file
data
backup
database
block
model
title Backup with Storage in a Database
title_full Backup with Storage in a Database
title_fullStr Backup with Storage in a Database
title_full_unstemmed Backup with Storage in a Database
title_short Backup with Storage in a Database
title_sort backup with storage in a database
topic file
data
backup
database
block
model
url https://www.mais-journal.ru/jour/article/view/372
work_keys_str_mv AT smtaranin backupwithstorageinadatabase