title: ÐÐ¾Ð´Ñ Ð¾Ð´ Ðº ÑÐ¾Ð¿ÑÐ¾Ð²Ð¾Ð¶Ð´ÐµÐ½Ð¸Ñ ÑÐ¸ÑÑÐµÐ¼Ñ Ð¾Ð±ÑÐ°Ð±Ð¾ÑÐºÐ¸ Ð¸ Ñ ÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¼Ð°Ð³Ð¸ÑÑÑÐ°
titleType: Subtitle
title: Approach to maintenance of data warehouse
Creators: name: ÐÑÑÐ°Ð½Ð¸Ð½Ð°, ÐÐ½Ð½Ð°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2024
Subjects: ÑÐ¾Ð¿ÑÐ¾Ð²Ð¾Ð¶Ð´ÐµÐ½Ð¸Ðµ
ÑÐ¸ÑÑÐµÐ¼Ð° Ñ ÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð´Ð°Ð½Ð½ÑÑ
Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ñ
maintenance
data warehouse
automation

description: ÐÐ°Ð½Ð½Ð°Ñ Ð´Ð¸ÑÑÐµÑÑÐ°ÑÐ¸Ñ Ð¿Ð¾ÑÐ²ÑÑÐµÐ½Ð° ÐºÑÐ¸ÑÐ¸ÑÐµÑÐºÐ¸Ð¼ Ð°ÑÐ¿ÐµÐºÑÐ°Ð¼ Ð¿Ð¾Ð´Ð´ÐµÑÐ¶ÐºÐ¸ Ð¸ ÑÐ¾Ð¿ÑÐ¾Ð²Ð¾Ð¶Ð´ÐµÐ½Ð¸Ñ ÑÐ¸ÑÑÐµÐ¼ Ð¾Ð±ÑÐ°Ð±Ð¾ÑÐºÐ¸ Ð¸ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸. ÐÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ ÑÐ°ÑÑÐ¼Ð°ÑÑÐ¸Ð²Ð°ÐµÑ ÑÑÑÐµÑÑÐ²ÑÑÑÐ¸Ðµ Ð¼ÐµÑÐ¾Ð´Ð¾Ð»Ð¾Ð³Ð¸Ð¸ Ð¸ Ð¿Ð¾Ð´ÑÐ¾Ð´Ñ, Ð¿Ð¾Ð´ÑÐµÑÐºÐ¸Ð²Ð°Ñ Ð²Ð°Ð¶Ð½Ð¾ÑÑÑ Ð²ÑÑÐ¾ÐºÐ¾Ð¹ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸ÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸, Ð½Ð°Ð´ÐµÐ¶Ð½Ð¾ÑÑÐ¸ Ð¸ ÑÐ¾ÐºÑÐ°ÑÐµÐ½Ð¸Ñ Ð²ÑÐµÐ¼ÐµÐ½Ð¸ Ð¿ÑÐ¾ÑÑÐ¾Ñ. ÐÑÐ¾Ð±Ð¾Ðµ Ð²Ð½Ð¸Ð¼Ð°Ð½Ð¸Ðµ ÑÐ´ÐµÐ»ÑÐµÑÑÑ ÑÐ¾Ð²ÑÐµÐ¼ÐµÐ½Ð½ÑÐ¼ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸ÑÐ¼, ÑÐ°ÐºÐ¸Ð¼ ÐºÐ°Ðº Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð°ÑÐ¸Ñ Ð¸ DevOps, Ð´Ð»Ñ Ð¿Ð¾Ð²ÑÑÐµÐ½Ð¸Ñ Ð½Ð°Ð´ÐµÐ¶Ð½Ð¾ÑÑÐ¸ Ð¸ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÐ¸ ÑÐ¸ÑÑÐµÐ¼Ñ. Ð¡ ÑÐµÐ½ÑÑÐ±ÑÑ Ð¿ÑÐ¾ÑÐ»Ð¾Ð³Ð¾ Ð³Ð¾Ð´Ð° ÑÐ¸ÑÑÐµÐ¼Ð° Ð¿ÑÐ¾ÑÐ»Ð° Ð°ÐºÑÐ¸Ð²Ð½ÑÐ¹ ÑÐµÐ»Ð¸Ð· Ñ ÑÑÐ°ÑÐµÐ»ÑÐ½ÑÐ¼ ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸ÐµÐ¼ Ð¸ Ð¾Ð±Ð½Ð¾Ð²Ð»ÐµÐ½Ð¸ÐµÐ¼ ÐºÐ¾Ð½ÑÐ¸Ð³ÑÑÐ°ÑÐ¸Ð¹. Ð Ð¾ÐºÑÑÐ±ÑÐµ Ð±ÑÐ»Ð° Ð²Ð²ÐµÐ´ÐµÐ½Ð° PREPROD-ÑÑÐµÐ´Ð°, Ð² Ð´ÐµÐºÐ°Ð±ÑÐµ â Ð¿ÑÐ¾Ð´ÑÐºÑÐ¸Ð²Ð½ÑÐ¹ ÐºÐ¾Ð½ÑÑÑ. Ð ÑÐ½Ð²Ð°ÑÐµ Ð¿ÑÐ¾Ð²Ð¾Ð´Ð¸Ð»Ð¾ÑÑ Ð°ÐºÑÐ¸Ð²Ð½Ð¾Ðµ ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ ÑÐ¸ÑÑÐµÐ¼Ñ Ð¸ Ð¾Ð±Ð½Ð¾Ð²Ð»ÐµÐ½Ð¸Ðµ ÐºÐ¾Ð½ÑÐ¸Ð³ÑÑÐ°ÑÐ¸Ð¸ PREPROD, Ð¸ Ñ ÑÐµÐ²ÑÐ°Ð»Ñ Ð²ÑÐµ ÑÑÐµÐ´Ñ Ð°ÐºÑÐ¸Ð²Ð½Ð¾ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·ÑÑÑÑÑ. Ð Ð¼Ð°Ðµ Ð±ÑÐ»Ð° Ð¾Ð±Ð½Ð¾Ð²Ð»ÐµÐ½Ð° ÐºÐ¾Ð½ÑÐ¸Ð³ÑÑÐ°ÑÐ¸Ñ PROD, ÑÑÐ¾ Ð¿Ð¾Ð²ÑÑÐ¸Ð»Ð¾ ÑÑÐ°Ð±Ð¸Ð»ÑÐ½Ð¾ÑÑÑ ÑÐ¸ÑÑÐµÐ¼Ñ. ÐÐ½Ð°Ð»Ð¸Ð· Ð´Ð°Ð½Ð½ÑÑ Ð¿Ð¾ Ð¸Ð½ÑÐ¸Ð´ÐµÐ½ÑÐ°Ð¼ Ð¿Ð¾ÐºÐ°Ð·Ð°Ð» ÑÐ½Ð¸Ð¶ÐµÐ½Ð¸Ðµ Ð²ÑÐµÐ¼ÐµÐ½Ð¸ Ð¿ÑÐ¾ÑÑÐ¾Ñ, ÑÑÐ¾ Ð´ÐµÐ¼Ð¾Ð½ÑÑÑÐ¸ÑÑÐµÑ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÑ Ð²Ð½ÐµÐ´ÑÐµÐ½Ð½ÑÑ ÑÐºÑÐ¸Ð¿ÑÐ¾Ð² Ð¸ Ð½Ð¾Ð²Ð¾Ð¹ ÐºÐ¾Ð½ÑÐ¸Ð³ÑÑÐ°ÑÐ¸Ð¸. ÐÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ðµ Ð¿ÑÐµÐ´ÑÑÐ°Ð²Ð»ÑÐµÑ ÐºÐ¾Ð¼Ð¿Ð»ÐµÐºÑÐ½ÑÐ¹ Ð¿Ð¾Ð´ÑÐ¾Ð´ Ðº Ð¾Ð±ÐµÑÐ¿ÐµÑÐµÐ½Ð¸Ñ Ð²ÑÑÐ¾ÐºÐ¾Ð¹ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´Ð¸ÑÐµÐ»ÑÐ½Ð¾ÑÑÐ¸ Ð¸ Ð½Ð°Ð´ÐµÐ¶Ð½Ð¾ÑÑÐ¸ ÑÐ¸ÑÑÐµÐ¼Ñ, Ð¿Ð¾Ð´ÑÐµÑÐºÐ¸Ð²Ð°Ñ ÑÑÑÐµÐºÑÐ¸Ð²Ð½Ð¾ÑÑÑ Ð°Ð²ÑÐ¾Ð¼Ð°ÑÐ¸Ð·Ð¸ÑÐ¾Ð²Ð°Ð½Ð½ÑÑ Ð¿ÑÐ¾ÑÐµÑÑÐ¾Ð² Ð¸ Ð¼ÐµÑÐ¾Ð´Ð¾Ð»Ð¾Ð³Ð¸Ð¹ DevOps. Ð Ð½Ð°ÑÑÐ¾ÑÑÐµÐµ Ð²ÑÐµÐ¼Ñ ÑÐ¸ÑÑÐµÐ¼Ð° ÐµÐ¶ÐµÐ´Ð½ÐµÐ²Ð½Ð¾ Ð¾Ð±ÑÐ°Ð±Ð°ÑÑÐ²Ð°ÐµÑ ÑÐ¾ÑÐ½Ð¸ Ð¼Ð¸Ð»Ð»Ð¸Ð¾Ð½Ð¾Ð² ÑÑÑÐ¾Ðº Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ Ð±Ð¾Ð»ÐµÐµ ÑÐµÐ¼ ÑÑÐ° Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»ÐµÐ¹, Ð´Ð¾ÑÑÐ¸Ð³Ð°Ñ Ð²ÑÐµÐ¼ÐµÐ½Ð¸ Ð±ÐµÑÐ¿ÐµÑÐµÐ±Ð¾Ð¹Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ 93,8% Ð·Ð° Ð²ÐµÑÑ Ð¿ÐµÑÐ¸Ð¾Ð´ Ð¸ 99,5% Ð² Ð¼Ð°Ðµ Ð¿Ð¾ÑÐ»Ðµ Ð¾Ð±Ð½Ð¾Ð²Ð»ÐµÐ½Ð¸Ð¹. Ð­ÑÐ¸ Ð¿Ð¾ÐºÐ°Ð·Ð°ÑÐµÐ»Ð¸ Ð¿Ð¾Ð´ÑÐ²ÐµÑÐ¶Ð´Ð°ÑÑ ÑÑÐ¿ÐµÑ ÑÑÑÐ°ÑÐµÐ³Ð¸Ð¸ ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ Ð¸ ÑÐ¾Ð¿ÑÐ¾Ð²Ð¾Ð¶Ð´ÐµÐ½Ð¸Ñ Ð² Ð¿Ð¾Ð´Ð´ÐµÑÐ¶Ð°Ð½Ð¸Ð¸ Ð½Ð°Ð´ÐµÐ¶Ð½ÑÑ Ð¸ ÑÑÑÐ¾Ð¹ÑÐ¸Ð²ÑÑ ÑÐ¸ÑÑÐµÐ¼ ÑÑÐ°Ð½ÐµÐ½Ð¸Ñ Ð¸Ð½ÑÐ¾ÑÐ¼Ð°ÑÐ¸Ð¸.
description: This thesis explores the critical aspects of supporting and maintaining information processing and storage systems. The study examines existing methodologies and approaches, emphasizing the importance of high performance, reliability, and reduced downtime. The research focuses on modern technologies such as automation and DevOps to enhance system reliability and efficiency. From September last year, the system underwent active release with thorough testing and configuration updates. PREPROD was introduced in October, followed by the production environment in December. Active system testing and PREPROD configuration updates were conducted in January, and all environments have been actively used since February. In May, the PROD configuration was updated, resulting in improved system stability. Analysis of incident data showed a reduction in downtime over time, demonstrating the effectiveness of the implemented scripts and the new configuration. The study presents a comprehensive approach to ensuring the systems high performance and reliability, highlighting the effectiveness of automated processes and DevOps methodologies. The system currently processes hundreds of millions of data rows daily for over a hundred users, achieving an uptime of 93.8% overall and 99.5% in May post-update. These metrics confirm the success of the testing and maintenance strategy in maintaining robust and reliable information storage systems.