title: ÐÑÐ¾ÐµÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ Ð¸ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ñ ÑÐ°Ð½Ð¸Ð»Ð¸ÑÐ° Ð´Ð°Ð½Ð½ÑÑ Ð¸ Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÑÐµÑÐºÐ¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ Ð´Ð»Ñ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð¼Ð°Ð³Ð¸ÑÑÑÐ°
titleType: Subtitle
title: Design and development of a data warehouse and analytical system for the company
Creators: name: Ð¡Ð¸Ð½Ð¸ÑÐ¸Ð½Ð°, ÐÐ¸ÐºÐ°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2019
Subjects: ÐÐ°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ
ÐÑÑÐ¸ÑÐ»Ð¸ÑÐµÐ»ÑÐ½ÑÐµ Ð¼Ð°ÑÐ¸Ð½Ñ ÑÐ»ÐµÐºÑÑÐ¾Ð½Ð½ÑÐµ
Ð°ÑÑÑÐ¾ÑÑÐ¸Ð½Ð³
Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÑÐµÑÐºÐ°Ñ ÑÐ¸ÑÑÐµÐ¼Ð°

description: ÐÐ±ÑÐµÐºÑÐ¾Ð¼ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ²Ð»ÑÐµÑÑÑ Ð¼ÐµÐ¶Ð´ÑÐ½Ð°ÑÐ¾Ð´Ð½Ð°Ñ Ð°Ð³ÑÐ¾ÐºÑÐ»ÑÑÑÑÐ½Ð°Ñ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ñ, ÐºÐ¾ÑÐ¾ÑÐ°Ñ ÑÐ²Ð»ÑÐµÑÑÑ ÐºÐ»Ð¸ÐµÐ½ÑÐ¾Ð¼ ÐÐ¢-Ð°ÑÑÑÐ¾ÑÑÐµÑÐ° Â«EPAM SystemsÂ». Ð¦ÐµÐ»Ñ Ð²ÑÐ¿ÑÑÐºÐ½Ð¾Ð¹ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ â Ð¿ÑÐ¾ÐµÐºÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ Ð¸ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° ÑÑÐ°Ð½Ð¸Ð»Ð¸ÑÐ° Ð´Ð°Ð½Ð½ÑÑ Ð¸ Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÑÐµÑÐºÐ¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ Ð´Ð»Ñ Ð¼ÐµÐ¶Ð´ÑÐ½Ð°ÑÐ¾Ð´Ð½Ð¾Ð¹ Ð°Ð³ÑÐ¾ÐºÑÐ»ÑÑÑÑÐ½Ð¾Ð¹ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸. ÐÐ° Ð¾ÑÐ½Ð¾Ð²Ðµ Ð°Ð½Ð°Ð»Ð¸Ð·Ð° ÑÑÑÐµÑÑÐ²Ð¾Ð²Ð°Ð²ÑÐµÐ¹ Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÑÐµÑÐºÐ¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸ Ð²ÑÑÐ²Ð»ÐµÐ½ ÑÑÐ´ Ð¿ÑÐ¾Ð±Ð»ÐµÐ¼ â Ð¼ÐµÐ´Ð»ÐµÐ½Ð½Ð°Ñ Ð·Ð°Ð³ÑÑÐ·ÐºÐ° Ð¾ÑÑÐµÑÐ¾Ð², Ð½Ð°Ð³ÑÑÐ·ÐºÐ° OLTP-ÑÐ¸ÑÑÐµÐ¼Ñ, ÑÐ°Ðº ÐºÐ°Ðº Ð½Ð° Ð½ÐµÐ¹ Ð±Ð°Ð·Ð¸ÑÐ¾Ð²Ð°Ð»Ð°ÑÑ Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÑÐµÑÐºÐ°Ñ ÑÐ¸ÑÑÐµÐ¼Ð°, Ð° ÑÐ°ÐºÐ¶Ðµ Ð´Ð¾ÑÐ¾Ð³Ð¾Ð²Ð¸Ð·Ð½Ð° Ð°ÑÐµÐ½Ð´Ñ ÑÐµÑÐ²ÐµÑÐ° Ð¸ Ð»Ð¸ÑÐµÐ½Ð·Ð¸Ð¹ Ð´Ð»Ñ Ð±Ð¾Ð»ÑÑÐ¾Ð³Ð¾ ÐºÐ¾Ð»Ð¸ÑÐµÑÑÐ²Ð° Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»ÐµÐ¹. ÐÑÐµÐ´Ð»Ð¾Ð¶ÐµÐ½Ð¾ ÑÐµÑÐµÐ½Ð¸Ðµ Ð¿Ð¾ ÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ñ ÑÑÐ°Ð½Ð¸Ð»Ð¸ÑÐ° Ð´Ð°Ð½Ð½ÑÑ Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ ÐºÐ¾Ð»Ð¾Ð½Ð¾ÑÐ½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð¸ Ð´Ð°Ð»ÑÐ½ÐµÐ¹ÑÐµÐµ Ð¿ÐµÑÐµÑÐ¾Ð·Ð´Ð°Ð½Ð¸Ðµ Ð¸ Ð¾Ð¿ÑÐ¸Ð¼Ð¸Ð·Ð°ÑÐ¸Ñ Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÑÐµÑÐºÐ¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ Ð½Ð° Ð´ÑÑÐ³Ð¾Ð¹ Ð±Ð¾Ð»ÐµÐµ Ð´ÐµÑÐµÐ²Ð¾Ð¹, Ð½Ð¾ Ð½Ðµ Ð¼ÐµÐ½ÐµÐµ Ð¼Ð¾ÑÐ½Ð¾Ð¹ Ð¿Ð»Ð°ÑÑÐ¾ÑÐ¼Ðµ. 
Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° ÑÐ°ÐºÐ¾Ð¹ Ð½Ð¾Ð²Ð¾Ð¹ Ð°Ð½Ð°Ð»Ð¸ÑÐ¸ÑÐµÑÐºÐ¾Ð¹ ÑÐ¸ÑÑÐµÐ¼Ñ Ð¿ÑÐ¸Ð½ÐµÑÐµÑ Ð¿Ð¾Ð»Ð¾Ð¶Ð¸ÑÐµÐ»ÑÐ½ÑÐ¹ ÑÑÑÐµÐºÑ ÐºÐ¾Ð¼Ð¿Ð°Ð½Ð¸Ð¸ Ð² ÑÐµÐ»Ð¾Ð¼, Ð° ÑÐ°ÐºÐ¶Ðµ ÑÑÑÐµÑÑÐ²ÐµÐ½Ð½Ð¾ ÑÑÐºÐ¾Ð½Ð¾Ð¼Ð¸Ñ ÐµÐµ Ð±ÑÐ´Ð¶ÐµÑ.
description: The object of the research is an international agricultural company, which is a client of the IT-outsourcer âEPAM Systemsâ. The purpose of the final qualifying work is the design and development of a data warehouse and analytical system for an international agricultural company. Based on the analysis of the existing analytical system of the company, a number of problems were identified - slow loading of reports, the load on the OLTP system, since the analytical system was based on it, as well as the high cost of server rent and licenses for a large number of users. A solution was proposed to create a data warehouse using a column database and further re-create and optimize the analytical system on another cheaper but not less powerful platform. The development of such a new analytical system will bring a positive effect to the company as a whole, and also significantly save its budget.