title: Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¿ÑÐ¾ÑÐ¾ÑÐ¸Ð¿Ð° Ð¼Ð½Ð¾Ð³Ð¾Ð¼ÐµÑÐ½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ ÑÑÐµÑÐ° ÑÑÐ°ÑÐ¸ÑÑÐ¸ÑÐµÑÐºÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð½Ð° Ð¿ÑÐ¸Ð¼ÐµÑÐµ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²Ð° ÑÑÐ´ÐµÐ±Ð½ÑÑ Ð°Ð²ÑÐ¾ÑÐµÑ Ð½Ð¸ÑÐµÑÐºÐ¸Ñ ÑÐºÑÐ¿ÐµÑÑÐ¸Ð·.
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Development of a prototype of a multidimensional database for accounting statistical data on the example of the production of forensic auto technical examinations
Creators: name: ÐÐ°Ð·Ð°ÑÐ¾Ð², ÐÑÑÐµÐ¼
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2023
Subjects: Ð¼Ð½Ð¾Ð³Ð¾Ð¼ÐµÑÐ½Ð°Ñ Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ
OLAP-ÑÐµÑ Ð½Ð¾Ð»Ð¾Ð³Ð¸Ð¸
Ð³Ð¸Ð¿ÐµÑÐºÑÐ±
Ð¼Ð½Ð¾Ð³Ð¾Ð¼ÐµÑÐ½Ð°Ñ Ð¼Ð¾Ð´ÐµÐ»Ñ Ð´Ð°Ð½Ð½ÑÑ
multidimensional database
OLAP-technologies
hypercube
multidimensional data model

description: ÐÑÐµÐ´Ð¼ÐµÑÐ¾Ð¼ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ ÑÐ²Ð»ÑÐµÑÑÑ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° Ð¿ÑÐ¾ÑÐ¾ÑÐ¸Ð¿Ð° Ð¼Ð½Ð¾Ð³Ð¾Ð¼ÐµÑÐ½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ ÑÐ¿ÐµÑÐ¸Ð°Ð»ÑÐ½ÑÑ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½ÑÑ ÑÑÐµÐ´ÑÑÐ² Ð¸ ÐµÐ³Ð¾ Ð°Ð¿ÑÐ¾Ð±Ð°ÑÐ¸Ñ. ÐÐ±ÑÐµÐºÑÐ¾Ð¼ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð²ÑÑÑÑÐ¿Ð°ÐµÑ Ð¼Ð½Ð¾Ð³Ð¾Ð¼ÐµÑÐ½Ð°Ñ Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ. Ð¦ÐµÐ»Ñ ÑÐ°Ð±Ð¾ÑÑ: ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°ÑÑ Ð¿ÑÐ¾ÑÐ¾ÑÐ¸Ð¿ Ð¼Ð½Ð¾Ð³Ð¾Ð¼ÐµÑÐ½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ ÑÑÑÑÐ° ÑÑÐ°ÑÐ¸ÑÑÐ¸ÑÐµÑÐºÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð½Ð° Ð¿ÑÐ¸Ð¼ÐµÑÐµ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²Ð° ÑÑÐ´ÐµÐ±Ð½ÑÑ Ð°Ð²ÑÐ¾ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ñ ÑÐºÑÐ¿ÐµÑÑÐ¸Ð·. Ð Ð¿ÑÐ¾ÑÐµÑÑÐµ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ Ð±ÑÐ»Ð¸ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ñ Ð¼ÐµÑÐ¾Ð´Ñ ÑÐ¸ÑÑÐµÐ¼Ð½Ð¾Ð³Ð¾ Ð°Ð½Ð°Ð»Ð¸Ð·Ð°, ÑÑÐ°Ð²Ð½Ð¸ÑÐµÐ»ÑÐ½Ð¾Ð³Ð¾ Ð°Ð½Ð°Ð»Ð¸Ð·Ð°, ÑÐ¸Ð½ÑÐµÐ·Ð°, Ð¼Ð¾Ð´ÐµÐ»Ð¸ÑÐ¾Ð²Ð°Ð½Ð¸Ñ, Ð¸Ð·Ð¼ÐµÑÐµÐ½Ð¸Ñ. Ð ÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð¼ ÑÐ°Ð±Ð¾ÑÑ ÑÐ²Ð»ÑÐµÑÑÑ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð°Ñ Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ, Ð¿ÑÐµÐ´Ð½Ð°Ð·Ð½Ð°ÑÐµÐ½Ð½Ð°Ñ Ð´Ð»Ñ ÑÑÐµÑÐ° ÑÑÐ°ÑÐ¸ÑÑÐ¸ÑÐµÑÐºÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð½Ð° Ð¿ÑÐ¸Ð¼ÐµÑÐµ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²Ð° ÑÑÐ´ÐµÐ±Ð½ÑÑ Ð°Ð²ÑÐ¾ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ñ ÑÐºÑÐ¿ÐµÑÑÐ¸Ð·. ÐÐ±Ð»Ð°ÑÑÑ Ð¿ÑÐ¸Ð¼ÐµÐ½ÐµÐ½Ð¸Ñ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð²: ÑÑÐµÑÐ° Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²Ð° ÑÑÐ´ÐµÐ±Ð½ÑÑ Ð°Ð²ÑÐ¾ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ñ ÑÐºÑÐ¿ÐµÑÑÐ¸Ð·. ÐÑÐ²Ð¾Ð´Ñ: â Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½ ÐºÐ¾Ð¼Ð¿Ð°ÑÐ°ÑÐ¸Ð²Ð½ÑÐ¹ Ð°Ð½Ð°Ð»Ð¸Ð· Ð¾ÑÐ½Ð¾Ð²Ð½ÑÑ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸Ð¹ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ¸ Ð¼Ð½Ð¾Ð³Ð¾Ð¼ÐµÑÐ½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ; â ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð° ÑÐµÐ»ÑÑÐ¸Ð¾Ð½Ð½Ð°Ñ Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ ÑÑÐµÐ´ÑÑÐ²Ð° PostgreSQL; â Ð¿Ð¾ÑÑÑÐ¾ÐµÐ½Ð° Ð¼Ð½Ð¾Ð³Ð¾Ð¼ÐµÑÐ½Ð°Ñ Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ Ñ Ð¸ÑÐ¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°Ð½Ð¸ÐµÐ¼ Ð¿ÑÐ¾Ð³ÑÐ°Ð¼Ð¼Ð½Ð¾Ð³Ð¾ ÐºÐ¾Ð¼Ð¿Ð»ÐµÐºÑÐ° ÐÐ½ÑÐ¾ÐÐ¸Ð·Ð¾Ñ; â Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½Ð¾ ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ Ð¸ Ð°Ð¿ÑÐ¾Ð±Ð°ÑÐ¸Ñ ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð¾Ð¹ Ð¼Ð½Ð¾Ð³Ð¾Ð¼ÐµÑÐ½Ð¾Ð¹ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ Ð´Ð»Ñ ÑÑÐµÑÐ° ÑÑÐ°ÑÐ¸ÑÑÐ¸ÑÐµÑÐºÐ¸Ñ Ð´Ð°Ð½Ð½ÑÑ Ð² Ð¾Ð±Ð»Ð°ÑÑÐ¸ Ð¿ÑÐ¾Ð¸Ð·Ð²Ð¾Ð´ÑÑÐ²Ð° ÑÑÐ´ÐµÐ±Ð½ÑÑ Ð°Ð²ÑÐ¾ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ñ ÑÐºÑÐ¿ÐµÑÑÐ¸Ð·. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½Ð°Ñ Ð±Ð°Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ Ð¿Ð¾Ð·Ð²Ð¾Ð»Ð¸Ñ ÑÐ²ÐµÐ»Ð¸ÑÐ¸ÑÑ ÑÐºÐ¾ÑÐ¾ÑÑÑ Ð¸ ÑÐ¾ÑÐ½Ð¾ÑÑÑ Ð°Ð½Ð°Ð»Ð¸Ð·Ð° Ð´Ð°Ð½Ð½ÑÑ Ð¸ ÑÐ»ÑÑÑÐ¸ÑÑ ÐºÐ°ÑÐµÑÑÐ²Ð¾ ÑÐºÑÐ¿ÐµÑÑÐ¸Ð·Ñ Ð´Ð»Ñ Ð²ÑÐ½ÐµÑÐµÐ½Ð¸Ñ ÑÑÐ´ÐµÐ±Ð½ÑÑ ÑÐµÑÐµÐ½Ð¸Ð¹.
description: The subject of the research is the development of a prototype of a multidimensional database using special software tools and its testing. The object of the research is a multidimensional database. The purpose of the work: to develop a prototype of a multidimensional database for accounting statistical data in the field of production of forensic auto technical examinations. Methods of system analysis, comparative analysis, synthesis, modeling, measurement were used in the research process. The result of the work is a developed database designed to take into account statistical data in the field of production of forensic auto technical examinations. The scope of application of the results: the scope of production of forensic auto technical examinations. Conclusions: â a comparative analysis of the main technologies for the development of a multidimensional database is carried out; â a relational database has been developed using the PostgreSQL tool; â a multidimensional database was built using the InfoVisor software package; â testing and approbation of the developed multidimensional database for accounting of statistical data in the field of production of forensic auto technical examinations was carried out. The developed database will increase the speed and accuracy of data analysis and improve the quality of expertise for making court decisions.