计算机工程与应用 ›› 2008, Vol. 44 ›› Issue (35): 151-154.DOI: 10.3778/j.issn.1002-8331.2008.35.046

• 数据库、信号与信息处理 • 上一篇    下一篇

混合关系中的函数依赖及其相关规则

李彩丽1,缪 园2   

  1. 1.中国科学院 软件研究所,北京100080
    2.中国科学院 研究生院,北京100049
  • 收稿日期:2007-12-24 修回日期:2008-03-19 出版日期:2008-12-11 发布日期:2008-12-11
  • 通讯作者: 李彩丽

Functional dependencies and corresponding rules in hybrid relations

LI Cai-li1,MIAO Yuan2   

  1. 1.Division of Graduated Students,Institute of Software,Chinese Academy of Sciences,Beijing 100080,China
    2.School of Graduated Students,Chinese Academy of Sciences,Beijing 100049,China
  • Received:2007-12-24 Revised:2008-03-19 Online:2008-12-11 Published:2008-12-11
  • Contact: LI Cai-li

摘要: 在实际应用中有这样一类关系数据库,其中数据项在某个属性上的取值本身又是一个关系。讨论这种混合关系中的函数依赖及其相应的相关规则具有一定的理论意义和实际应用价值。给出这种混合关系的形式定义、混合关系中4种类型的函数依赖关系以及相应的4种类型的相关规则;并给出混合关系到一般关系的转换,通过这个转换说明了混合关系与普通关系的联系及其差别。给出一个实际应用中的例子,来说明混合关系中的函数依赖和相关规则的形式多样性。

关键词: 关系数据库, 函数依赖, 属性, 相关规则

Abstract: In practical applications,there is a class of relations in which the value of a tuple at an attribute is a relation.Such a relation is called a hybrid one.It is necessary to discuss the functional dependences and the corresponding rules in hybrid relations.This paper firstly gives the formal definitions of hybrid relations,and four types of functional dependences and the corresponding rules in hybrid relations.Then a transformation from a hybrid relation to a common one is given,the difference between the hybrid relation and a common one is given,and an example is given to show how a hybrid relation is used in a hybrid relation for the graduated student management.

Key words: relational databases, functional dependence, attributes, rules