Backup with storage in a database

S. M. Taranin

Modelirovanie i analiz informacionnyh sistem, Tome 23 (2016) no. 4, pp. 479-481.

Résumé

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.

Détail

Mots-clés : file
Keywords: data, backup, database, block, model.

Bibliographie

[1] Kazakov V. G., Fedosin S. A., “Technologii i algoritmi reservnogo kopirovania”, Vserossiyskiy konkursniy otbor obzorno-analiticheskih statey po prioritetnomu napravleniu “Informacionno-telekommunikacionnie sistemi”, 2008, 1–49 (in Russian)

[2] Aliev A. A., Samadov R. B., “An algorithm of a full backup in cloud computing”, Baku State University News, 2013, no. 4, 120–127

[3] Mugoh L., Ateya I. L., Shibwabo B. K, “Continuous Data Protection Architecture as a Strategy for Reduced Data Recovery Time”, Journal of Systems Integration, 2:4 (2011), 54–69 | DOI

[4] Kazakov V. G., Fedosin S. A., Plotnikova N. P., “Method of adaptive dedublication with multilevel block indexing”, Fundamental research, 2013, no. 8 (part 6), 1322–1325

[5] Kathuria V., Dhamankar R., Kodavalla H., “Transaction Isolation and Lazy Commit”, IEEE 23rd International Conference on Data Enginering (2007), 1204–1211

[6] Curtis Preston Mugoh W., Data Protection Strategies In Today's Data Center, Oracle White Paper, 2012, 8 pp.

[7] Zhu N., Chiueh T., Portable and Efficient Continuous Data Protection for Network File Servers, Stony Brook University, 2007, 17 pp.

[8] Meyer D. T., Bolosky W. J., “A Study of Practical Deduplication”, ACM Transactions on Storage, 7:4 (2012), 1–13 | DOI | Zbl

[9] Storer M. W., Greenan K., Long D. D. E., Miller E. L., “Secure Data Deduplication”, Proceedings of the 4th ACM international workshop on Storage security and survivability (2008), 1–10

[10] Renzel K., Keller W., Client/Server Architectures for Business Information Systems. A Pattern Language, 1997, 25 pp.

[11] Date C. J., An Introduction to Database Systems, v. 8, Pearson Education, Inc., 2004

[12] Groff J., Weinberg P., Oppel A., SQL The Complete Reference, v. 3, The McGraw-Hill Companies, 2010

[13] Date C. J., SQL and Relational Theory. How to Write Accurate SQL Code, O'Reilly Media Inc., 2009

[14] Sebastian J., Aelterman S., The Art of SQL Server FILESTREAM, Simple Talk Publishing, 2012 | Zbl

[15] Sears R., Catharine van Ingen, Gray J., To BLOB or Not To BLOB: Large Object Storage in a Database or a Filesystem?, Technical Report MSR-TR-2006-45, 2006, 11 pp.

[16] Maksimov V., Kozlenko L. A., Markin C. P., Bojchenko I. A., “Zashchishchennaya relyacionnaya SUBD Linter”, Otkrytye sistemy. SUBD, 1999, no. 11–12 (in Russian)