Sergey Mirvoda

Mr. Sergey Mirvoda

orcid

Research Focus & Metrics

Academic Career Length

12Years (2015-Present)

(Calculated once Scilit publication data is synced: current year − year of first publication + 1)

Representative Publications

View All Publications
1 January 2015
Verified
Book Chapter
Closed access
PDF file
ABAndrey Borodin
Andrey Borodin
YKYuri Kiselev
Yuri Kiselev
SMSergey Mirvoda
Sergey Mirvoda
SPSergey Porshnev
Sergey Porshnev

1 March 2017
Verified
Conference Paper
Closed access
ABAndrey Borodin
Andrey Borodin
SMSergey Mirvoda
Sergey Mirvoda
SPSergey Porshnev
Sergey Porshnev
MBMikhail Bakhterev
Mikhail Bakhterev
Generalized index search tree (GiST) greatly simplifies data access methods development. Important parts like query processing, failure recovery, memory management are implemented in generic code, so access method developer has to implement only specifics of the desired algorithm. But this generality comes with a significant cost of fitting a method for GiST API. In this paper we present number of tweaks to the R-tree implementation inside PostgreSQL GiST framework and analyze possible ways of GiST API advancements.

6 May 2021 in Symmetry
Verified
Journal Article
Open access
PDF file
SPSergey Porshnev
Sergey Porshnev
ABAndrey Borodin
Andrey Borodin
OPOlga Ponomareva
Olga Ponomareva
SMSergey Mirvoda
Sergey Mirvoda
OCOlga Chernova
Olga Chernova
The article discusses the approaches providing symmetric access of all industrial production services to the data of business processes of the enterprise by building a single warehouse of heterogeneous data of a metallurgical production. The warehouse is a part of an automated statistic quality control system for the products of a metallurgical enterprise. The article describes an ontological storage model of data coming from various sources of information in the production process. The concept of “a unit of production of metallurgical production” is introduced that is the connecting component of the entire production life cycle of a metallurgical production. The authors propose an ontological model of the production process, in terms of information flows which are formed in an enterprise at each stage of production. Based on the constructed ontological model, the structure of recording an array of information in the heterogeneous data warehouse is justified and formed. Heterogeneous data warehouse forms a single information space of the enterprise, which serves as the basis for analytical analysis throughout the production and decision—making process. For example, timely response to the deviation reasons from the given physical and chemical properties of the finished product.

1 November 2016
Verified
Conference Paper
Closed access
ABAndrey Borodin
Andrey Borodin
YKYuri Kiselev
Yuri Kiselev
SMSergey Mirvoda
Sergey Mirvoda
SPSergey Porshnev
Sergey Porshnev
Data aggregation is a process of expressing information in a summary form for further interpretation using statistical analysis, machine learning or data mining. Almost every data manipulation language has built-in, standard or common capabilities to aggregate data. This paper overviews different concepts of expressing data aggregation in programming languages. Specifically, we overview data aggregation in declarative SQL-based languages like T-SQL, PL/SQL, PostgreSQL, MDX, Neo4j, imperative C# LINQ and R. These concepts affected our domain-specific query language which we designed and implemented for metallurgical production.

1 April 2019
Verified
Conference Paper
Closed access
ABAndrey Borodin
Andrey Borodin
SMSergey Mirvoda
Sergey Mirvoda
SPSergey Porshnev
Sergey Porshnev
OPOlga Ponomareva
Olga Ponomareva
In this paper we present our continuous work on developing query language for metallurgical industry. We cover design of DSLQM language extensions for arithmetic calculations, discus features important for end users especially localization and internationalization of programming languages and provide some advises on choosing optimal programming paradigm.

28 April 2016
Verified
Book Chapter
Closed access
PDF file
ABAndrey Borodin
Andrey Borodin
SMSergey Mirvoda
Sergey Mirvoda
SPSergey Porshnev
Sergey Porshnev