Refactoring a Complex Scientometric Software System to Support PostgreSQL Database Management System

Programmnaya Ingeneria Pub Date : 2024-02-19 DOI:10.17587/prin.15.59-72

M. Krivchikov, V. Roganov, V. Vasenin

{"title":"Refactoring a Complex Scientometric Software System to Support PostgreSQL Database Management System","authors":"M. Krivchikov, V. Roganov, V. Vasenin","doi":"10.17587/prin.15.59-72","DOIUrl":null,"url":null,"abstract":"The problem of software import substitution is under a great deal of attention in Russia since 2015. As a part of import substitution for a complex software system, database migration presents a considerable risk. Despite the SQL ISO standardization efforts, different implementations of SQL relational database management system are partially incompatible on the level of source codes for the schema, queries and stored procedures. Incompatibilities can manifest even at the level of query semantics. Some traits of complex scientometric software systems further complicate the migration process. Such traits include the complex data model and, consequently, the presence of non-trivial graph-traversing SQL queries which should complete fast enough to be used interactively for thousands of users simultaneously. In this paper an experience of refactoring a complex scientometric software system to support PostgreSQL database management system is presented. Our approach includes both usage and modification of the existing tools and development of the in-house software to support the refactoring process compounded with an extensive automated testing procedures.","PeriodicalId":513113,"journal":{"name":"Programmnaya Ingeneria","volume":"29 9","pages":""},"PeriodicalIF":0.0000,"publicationDate":"2024-02-19","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Programmnaya Ingeneria","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.17587/prin.15.59-72","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 0

Abstract

The problem of software import substitution is under a great deal of attention in Russia since 2015. As a part of import substitution for a complex software system, database migration presents a considerable risk. Despite the SQL ISO standardization efforts, different implementations of SQL relational database management system are partially incompatible on the level of source codes for the schema, queries and stored procedures. Incompatibilities can manifest even at the level of query semantics. Some traits of complex scientometric software systems further complicate the migration process. Such traits include the complex data model and, consequently, the presence of non-trivial graph-traversing SQL queries which should complete fast enough to be used interactively for thousands of users simultaneously. In this paper an experience of refactoring a complex scientometric software system to support PostgreSQL database management system is presented. Our approach includes both usage and modification of the existing tools and development of the in-house software to support the refactoring process compounded with an extensive automated testing procedures.

查看原文本刊更多论文

重构复杂的科学计量软件系统以支持 PostgreSQL 数据库管理系统

自 2015 年以来，软件进口替代问题在俄罗斯备受关注。作为复杂软件系统进口替代的一部分，数据库迁移带来了相当大的风险。尽管在 SQL ISO 标准化方面做出了努力，但在模式、查询和存储过程的源代码层面上，SQL 关系数据库管理系统的不同实现存在部分不兼容性。甚至在查询语义层面也会出现不兼容的情况。复杂的科学计量软件系统的一些特征使迁移过程更加复杂。这些特征包括复杂的数据模型，以及随之而来的非难图遍历 SQL 查询，这些查询应快速完成，以便同时供数千名用户交互使用。本文介绍了重构一个复杂的科学计量软件系统以支持 PostgreSQL 数据库管理系统的经验。我们的方法包括使用和修改现有工具以及开发内部软件，以支持重构过程和广泛的自动测试程序。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

求助全文

约1分钟内获得全文求助全文

来源期刊

Programmnaya Ingeneria

自引率

0.00%

发文量