首页 | 官方网站   微博 | 高级检索  
     

函数依赖对商覆盖立方体生成效率的影响
引用本文:彭湘凯,陈富强.函数依赖对商覆盖立方体生成效率的影响[J].计算机工程与应用,2009,45(34):134-135.
作者姓名:彭湘凯  陈富强
作者单位:1.广东技术师范学院,广州 510665 2.华南理工大学 计算机科学与工程学院,广州 510641
摘    要:提出一种新的商覆盖立方体生成算法DDFS。指出在基本表维属性之间可能存在函数依赖;分析了这种函数依赖对DFS算法的影响;按照决定子在前的原则调整了DFS算法对基本表进行水平分割时所依据的维属性的顺序;对于存在函数依赖的维属性对,节省了判断是否存在类函数依赖的操作。采用weather数据集进行的实验结果表明,采用DDFS计算商覆盖立方体所需时间仅为采用DFS算法时的76%。得出DDFS较之DFS可以缩短商覆盖立方体生成时间。

关 键 词:数据仓库  商覆盖立方体  函数依赖  深度优先探索  
收稿时间:2009-6-25
修稿时间:2009-8-3  

Computing cover quotient cube considering functional dependency in base tables
PENG Xiang-kai,CHEN Fu-qiang.Computing cover quotient cube considering functional dependency in base tables[J].Computer Engineering and Applications,2009,45(34):134-135.
Authors:PENG Xiang-kai  CHEN Fu-qiang
Affiliation:1.Guangdong Polytechnic Normal University,Guangzhou 510665,China 2.School of Computer Science & Engineering,South China University of Technology,Guangzhou 510641,China
Abstract:This paper proposes a new algorithm DDFS to compute cover quotient cube.Functional dependency between base attributes are considered to improve the efficiency of computing.When the base table is partitioned with a particular attribute order,the attribute functionally depended is considered with a priority.For the attributes pair where there is a functional dependency,the cost of finding the congeneric functional dependency is retrenched.Experimental result on the dataset weather shows that the computing time associated with DDFS is only 76% of that with DFS.There is a conclusion that DDFS can shorten the time of computing cover quotient cube,compared with DFS.
Keywords:data warehouse  cover quotient cube  functional dependency  Deep First Search(DFS)
本文献已被 维普 万方数据 等数据库收录!
点击此处可从《计算机工程与应用》浏览原始摘要信息
点击此处可从《计算机工程与应用》下载全文
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司    京ICP备09084417号-23

京公网安备 11010802026262号