EXPERIENCE IN DEVELOPING DATA DOMAIN MODEL OF A MANAGEMENT SYSTEM OF STATE PROPERTY PART 2

Author(s): Gladkov S.L.

Rubric: Information technology

DOI: 10.21777/2500-2112-2023-1-62-81

Release: 2023-1 (42)

Pages: 62-81

Keywords: state address register, federal information address system, state property register, domain model

Annotation: The article describes the experience of creation of a data model of the information system of state (municipal) property management, which ensures the sustainability of the database structure in the conditions of variability of the feature space. The effectiveness of the application of a systematic approach in the formulation of initial methodological positions in the construction of a data model of a complex information system is demonstrated. The article provides a detailed analysis of the structure of the state address register, identifies and demonstrates by examples the systemic signs of violations in the database. Within the framework of existing methodologies and tools for domain-oriented database design, a methodology has been created to increase the degree of database normalization by phasing out systemic signs of violations in the database. An approach to expanding the structure of the state address register based on the exclusion of multi-purpose columns, multi-purpose tables, redundant data, multi-valued columns is proposed. Methods of implementing flexibility schemes that do not use multi-purpose hierarchical entities are discussed. The examples demonstrate the methodological techniques used to increase the degree of normalization of the database in cases where the terms of the source documents are uncertain and/or contradictory.

Bibliography: Gladkov S.L. EXPERIENCE IN DEVELOPING DATA DOMAIN MODEL OF A MANAGEMENT SYSTEM OF STATE PROPERTY PART 2 // Education Resources and Technologies. – 2023. – № 1 (42). – С. 62-81. doi: 10.21777/2500-2112-2023-1-62-81