J4 ›› 2013, Vol. 12 ›› Issue (10): 9-13.

• 数学与计算机科学 • 上一篇    下一篇

Matlab在求候选关键字的替换算法中的应用

  

  1. 大理学院数学与计算机学院,云南大理 671003
  • 收稿日期:2013-03-12 修回日期:2013-03-22 出版日期:2013-10-15 发布日期:2013-10-15
  • 作者简介:吴荣海,讲师,主要从事Petri网应用及计算机应用研究.
  • 基金资助:

    云南省教育厅科学研究基金资助项目(2011Y255)

Application of Matlab in Replacement Algorithm for Finding All Candidate Keys

  1. College of Mathematics and Computer , Dali University, Dali, Yunnan 671003,China
  • Received:2013-03-12 Revised:2013-03-22 Online:2013-10-15 Published:2013-10-15

摘要:

在关系模式分解和规范化过程中,候选关键字的确定具有重要意义。针对该问题利用Matlab对求给定关系模式R(U,F)全部候选关键字的替换算法进行了实现,测试结果表明,给出的Matlab函数代码简洁、运行速度较快,运行结果正确、直观且易于理解。

关键词: Matlab , 关系模式, 属性闭包, 候选关键字

Abstract:

The candidate keys play an important role in the decomposition process and normalization process for relational schema. In the paper, a replacing algorithm for finding all candidate keys of relational schema R (U, F) has been implemented in Matlab. Finally, it was verified by the example that was complied and simulated in Matlab. The result of simulation is easier to understand and show the speediness, efficiency, correctness of the M-functions.

Key words: Matlab, relational schema, closure of attributes set, candidate keys

中图分类号: