首页    期刊浏览 2024年11月24日 星期日
登录注册

文章基本信息

  • 标题:Discovery of functional and approximate functional dependencies in relational databases
  • 本地全文:下载
  • 作者:Ronald S. King ; James J. Legendre
  • 期刊名称:Advances in Decision Sciences
  • 印刷版ISSN:2090-3359
  • 电子版ISSN:2090-3367
  • 出版年度:2003
  • 卷号:7
  • 期号:2
  • 页码:49-59
  • DOI:10.1155/S117391260300004X
  • 出版社:Hindawi Publishing Corporation
  • 摘要:

    This study develops the foundation for a simple, yet efficient method for uncovering functional and approximate functional dependencies in relational databases. The technique is based upon the mathematical theory of partitions defined over a relation's row identifiers. Using a levelwise algorithm the minimal non-trivial functional dependencies can be found using computations conducted on integers. Therefore, the required operations on partitions are both simple and fast. Additionally, the row identifiers provide the added advantage of nominally identifying the exceptions to approximate functional dependencies, which can be used effectively in practical data mining applications.

国家哲学社会科学文献中心版权所有