{"title":"关系数据库中“开放”实体属性集的存储组织","authors":"A. Oleynik","doi":"10.37614/2307-5252.2021.5.12.011","DOIUrl":null,"url":null,"abstract":"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.","PeriodicalId":438304,"journal":{"name":"Transaction Kola Science Centre","volume":"1 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2021-12-27","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Storage organization for \\\"open\\\" sets of entity attributes in relational databases\",\"authors\":\"A. Oleynik\",\"doi\":\"10.37614/2307-5252.2021.5.12.011\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"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.\",\"PeriodicalId\":438304,\"journal\":{\"name\":\"Transaction Kola Science Centre\",\"volume\":\"1 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2021-12-27\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Transaction Kola Science Centre\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.37614/2307-5252.2021.5.12.011\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Transaction Kola Science Centre","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.37614/2307-5252.2021.5.12.011","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Storage organization for "open" sets of entity attributes in relational databases
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.