{"title":"关系型数据库中候选键的交换代数算法派生","authors":"A. Rushdi, M. Rushdi","doi":"10.1109/ETCT.2016.7882992","DOIUrl":null,"url":null,"abstract":"This paper utilizes concepts and tools of switching algebra to describe an algorithm for computing all candidate keys of a relational database. Our algorithm starts with a superkey comprising all attributes, and then uses logical inference to reduce it to the set of candidate keys. The essential step in this inference is the construction of the complete sum of a pertinent switching function. Some computational saving is possible through the use of Boolean quotients if essential and/or superfluous attributes are recognized.","PeriodicalId":340007,"journal":{"name":"2016 International Conference on Emerging Trends in Communication Technologies (ETCT)","volume":"13 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2016-11-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"7","resultStr":"{\"title\":\"Switching-algebraic algorithmic derivation of candidate keys in relational databases\",\"authors\":\"A. Rushdi, M. Rushdi\",\"doi\":\"10.1109/ETCT.2016.7882992\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"This paper utilizes concepts and tools of switching algebra to describe an algorithm for computing all candidate keys of a relational database. Our algorithm starts with a superkey comprising all attributes, and then uses logical inference to reduce it to the set of candidate keys. The essential step in this inference is the construction of the complete sum of a pertinent switching function. Some computational saving is possible through the use of Boolean quotients if essential and/or superfluous attributes are recognized.\",\"PeriodicalId\":340007,\"journal\":{\"name\":\"2016 International Conference on Emerging Trends in Communication Technologies (ETCT)\",\"volume\":\"13 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2016-11-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"7\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"2016 International Conference on Emerging Trends in Communication Technologies (ETCT)\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/ETCT.2016.7882992\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"2016 International Conference on Emerging Trends in Communication Technologies (ETCT)","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ETCT.2016.7882992","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Switching-algebraic algorithmic derivation of candidate keys in relational databases
This paper utilizes concepts and tools of switching algebra to describe an algorithm for computing all candidate keys of a relational database. Our algorithm starts with a superkey comprising all attributes, and then uses logical inference to reduce it to the set of candidate keys. The essential step in this inference is the construction of the complete sum of a pertinent switching function. Some computational saving is possible through the use of Boolean quotients if essential and/or superfluous attributes are recognized.