Supporting relational database integrity constraints during operation and reengineering in business intelligence tasks

The object of the study is a relational database - a database based on the relational model. The subject of the research is methods for maintaining data integrity in relational systems oriented towards intellectual analysis. The task of identifying new information about the relationships between data that could be added and entered during the database operation is considered. Relationships are represented in the form of dependencies of various types, which can be used as input data for methods of redesign (reengineering) of a relational database. Based on the analysis of the design features of information systems that use the relational data model, the main problems of maintaining integrity in the case of multivalued functional dependencies are considered. The main properties of multivalued functional dependencies of attributes are studied and a method of maintaining integrity using relational systems is proposed. A number of examples are given that explain the general problem of maintaining the integrity of relational data models, as well as the technology of specific model constraints and the method of solving the research problem. The results obtained allow us to further solve the problem of developing information systems focused on effective integrated technology - relational database reengineering in combination with modern methods of intelligent analysis in user applications.