Open AccessStorage organization for "open" sets of entity attributes in relational databases
Author(s) -
Andrey G. Oleynik,
AUTHOR_ID
Publication year - 2021
Publication title -
trudy kolʹskogo naučnogo centra ran
Language(s) - English
Resource type - Journals
ISSN - 2307-5252
DOI - 10.37614/2307-5252.2021.5.12.011
Subject(s) - directory , computer science , relational database , database , set (abstract data type) , relational model , database model , database design , object (grammar) , database schema , information retrieval , entity–relationship model , development (topology) , mathematics , artificial intelligence , programming language , mathematical analysis , operating system
Relations are practically implemented by database management systems in the form of two-dimensional tables. In this regard, certain difficulties arise in the development of relational database schemas, in which it is necessary to represent objects with an alterable (open) set of attributes. The article proposes a solution to this problem by including special relations in the scheme - relations of properties directory. Properties directory allow replenishing the sets of object attributes without changing the structure of the database. Examples of the practical use of properties directory in the development of database schemas of two information systems are presented.