Кафедра "Програмна інженерія та інтелектуальні технології управління ім. А. В. Дабагяна"
Постійне посилання колекціїhttps://repository.kpi.kharkov.ua/handle/KhPI-Press/1665
Офіційний сайт кафедри http://web.kpi.kharkov.ua/asu
Від січня 2022 року кафедра має назву "Програмна інженерія та інтелектуальні технології управління ім. А. В. ДАБАГЯНА" (тоді ж, у січні 2022 року в окремий підрозділ виділилася кафедра "Інформаційні системи та технології"), попередні назви – "Програмна інженерія та інформаційні технології управління" (від 2015), "Автоматизовані системи управління" (від 1977); первісна назва – кафедра автоматичного управління рухом.
Кафедра автоматичного управління рухом заснована в 1964 році задля підготовки інженерів-дослідників у галузі автоматичного управління рухом з ініціативи професора Харківського політехнічного інституту Арега Вагаршаковича Дабагяна та генерального конструктора КБ "Електроприладобудування" Володимира Григоровича Сергєєва.
Кафедра входить до складу Навчально-наукового інституту комп'ютерних наук та інформаційних технологій Національного технічного університету "Харківський політехнічний інститут".
У складі науково-педагогічного колективу кафедри працюють: 4 доктора технічних наук; 24 кандидата наук: 22 – технічних, 1 – фізико-математичних, 1 – економічних, 1 – доктор філософії; 3 співробітників мають звання професора, 19 – доцента, 1 – старшого наукового співробітника.
Переглянути
Результати пошуку
Публікація An approach to the translation of natural language business rules into sql table constraints(2021) Orlovskyi, D. L.; Kopp, A. M.Публікація Making data storages decentralized: an idea of smart contracts generation from relational database tables(2021) Kopp, A. M.; Orlovskyi, D. L.Публікація An approach to build a decentralized collection of business process models(Publisher Individual entrepreneur Picha Y. V., 2021) Kopp, A. M.; Orlovskyi, D. L.; Orekhov, Sergey ValerievichIn this study we have proposed the approach to organization of decentralized blockchain-based business process model repository that could be used to provide secure software solution to store and access the business process model collection in a tamper-resistant manner.Публікація Towards the alignment between database security framework and business process maturity model(Одеська національна академія харчових технологій, 2021) Kopp, A. M.; Orlovskyi, D. L.This paper considers the extension and improvement of database security framework by means of its alignment with business process maturity model in order to provide the holistic tool for organizations that are planning to establish a database security system, as well as to assess and ensure its quality using the well-known scale of maturity levels.Публікація Towards an approach to decentralized storage and exchange of business process models(2021) Kopp, A. M.; Orlovskyi, D. L.This paper proposes an approach to decentralized storage and exchange of business process models using the blockchain technology and tokenization approach. There was proposed an idea of the Ethereum smart contract that implements the non-fungible token extended with syntactic and semantic properties, which can be used to evaluate quality and estimate value of tokenized business process models.Публікація General Issues of Applications Architecture Domain Design(2021) Kopp, A. M.; Orlovskyi, D. L.; Ersoyleyen, D.Applications architecture domain as a part of enterprise architecture is the baseline of any organizational activity, which main goal is to provide the executional environment for business processes in order to deliver products or services to satisfy customer needs and generate revenue. Nowadays, software engineering projects always begin with the architecture design phase, despite the waterfall or agile methodology is used by a software development team. Applications architecture design is the most important and, at the same time, the most error-prone stage of the whole software engineering project. It is well-known,that design shortcomings made on the applications design phase may increase drastically to testing and maintenance phases. Further costs to defects fixing may be hundred times higher in the later project stages in compare to the design stage on which applications architecture is defined.Публікація An Approach and Software Prototype for Translation of Natural Language Business Rules into Database Structure(CEUR Workshop Proceedings, 2021) Kopp, A. M.; Orlovskyi, D. L.; Orekhov, Sergey ValerievichIn the recent decades data has indeed become one of the most valuable assets for government institutions, private businesses, and individual persons. Nowadays almost any software, from social networks and dating mobile applications to large information systems and analytical services for enterprise management, accumulates, stores, and processes data to solve certain problems in their subject areas. Extremely large data volumes are organized in databases that are used as the baseline for almost all of modern software applications. As the most important components of software systems, databases should be carefully designed, since drawbacks at the stage of requirements elicitation may result in exponential growth of defects fixing costs at testing and maintenance phases. Therefore, this study proposes an approach and software tool to database schema generation from textual requirements also known in database design domain as business rules. This may help database designers to rapidly obtain usable database schemas in order to detect and fix defects as early as possible. Moreover, proposed solution may simplify the database design process, since database creation scripts are generated from business rules directly. Thus, instead of coding all the required statements, engineers are only need to check obtained schema and make certain adjustments to data types, unique attributes, or used naming style. This research considers relational model and relational databases, since they are most widely used nowadays. State-of-the-art analysis is made, proposed approach is described in details, software tool with its brief usage examples is described, conclusions are made, and further research directions are formulated.Публікація An Approach to Development of Interactive Adaptive Software Tool to Support Data Analysis Activity(CEUR Workshop Proceedings, 2021) Orlovskyi, D. L.; Kopp, A. M.; Bilous, I. S.In the recent decades, databases have been used in any field of human activity to keep valuable data about ongoing processes. Large amounts of data stored in enterprise databases are useless without having a specialized software tool for data discovery or querying. Most business users that make data-driven decisions usually do not have special training and experience in database querying using special formal languages. Existing solutions are based on "query wizards" and database query forms that require knowledge of a database schema and inconvenient for users without special training. Proposed approach is based on the content-based filtering of already executed queries by usage frequency and similarity criteria in order to suggest relevant queries that may be re-used. It is a baseline of the interactive adaptive system for data analysis, which design and development is outlined in this study. Software prototype was demonstrated and its usage was discussed. Conclusions were made and future research was formulated.Публікація Methodical guidelines for laboratory works "Data modeling using the IDEF1X notation"(2022) Orlovskyi, D. L.; Kopp, A. M.Goal: State the laboratory practice problem. Study and analyze the subject area. Select main database objects based on analysis. Simplified description of the subject area. Some enterprise purchases products from various suppliers. Suppliers can be both legal entities and individual entrepreneurs. Products purchase is performed as batches and processed in the form of supply contracts. Each supply contract has unique number and might be concluded with single supplier. Preliminary order, invoice or similar document is reason for supply. Each contract document for each product type contains product name, number of items, and cost (in UAH). Supplied products are brought to the warehouse for the purpose of further sales through various channels. Subject area analysis allowed to identify and describe core business processes related to products supply. It is assumed that enterprise will have to store large enough amount of data related to products supply. Besides, product supply information should be organized in the way that staff and management could perform analytical processing of this information. Therefore, it is necessary to create database used to store and process information related to products supply. Business process analysis allowed to define following information that might be included in the database.Публікація Methodical guidelines for laboratory works "Learning the basics of working with DBMS MySQL: the main tools for implementing and supporting the business logic of SQL language"(2022) Orlovskyi, D. L.; Kopp, A. M.MySQL Database Management System (DBMS) is a freely distributed relational database developed and maintained by Oracle. From the very beginning, MySQL was developed by the Swedish company MySQL AB, which was later acquired by Sun Microsystems, which, in turn, was later acquired by Oracle. MySQL is distributed under both the GNU General Public License (GPL) and its commercial license. Under the terms of the GPL, software that uses MySQL libraries must also be distributed under the GPL license. For cases where developers do not want to open the source code of their software, a commercial license is provided. The advantage of a commercial license is quality service support. Contrary to Oracle’s MySQL licensing policy and to ensure free DBMS status, a fork of MySQL was created and called MariaDB. This database supports high compatibility with MySQL, ensuring the exact correspondence of the programming interface, the socalled API (Application Programming Interface), and MySQL commands. MySQL is a great solution for small, medium, and sometimes even large software systems. MySQL is also part of the WAMP (Windows, Apache, MySQL, PHP/Perl/Python) and LAMP (Linux, Apache, MySQL, PHP/Perl/Python) web application development stacks. This database is included in many ready-made assemblies of servers designed for web applications, such as XAMPP (which is proposed for use in this laboratory workshop), OpenServer, Denwer, and more. Recently, however, it is because of openness support, server builders and hosting providers are increasingly incorporating MariaDB into WAMP and LAMP stacks. Typically, MySQL is used as a server accessed by local or remote clients. However, the distribution also contains a library that provides the deployment of an internal server for standalone applications. In this laboratory workshop, we get acquainted with the implementation and maintenance of business logic in the database.