期刊文献+

用于多维数据实视图选择的分布估计算法 被引量:4

Estimation of Distribution Algorithm for Multi-dimensional Data Materialized View Selection
在线阅读 下载PDF
导出
摘要 在数据仓库中,为选择合适的视图加以实体化,提出一种新的分布估计算法。在解空间随机产生初始群体,根据适应值选择部分好的解集,利用这些优势群体建立概率模型并估计联合概率分布,再从新的概率分布中抽样得到下一代。实验结果表明,该算法能减少查询响应时间和视图维护代价,并且其寻优性能优于经典遗传算法。 To select the appropriate views to be materialized in the data warehouse,a new estimation of distribution algorithm is proposed.It generates initial solutions,the initial population uniformly distributed in the solution space,selects some of the individuals according to their fitness,and builds a posterior probability distribution model of promising solutions.New solutions are sampled from the model thus built and fully or in part replaced the old population.Experimental results show that the algorithm reduces the total query response time and maintenance cost,and outperforms canonical genetic algorithm.
作者 陈佳 李敏
出处 《计算机工程》 CAS CSCD 2012年第11期45-47,共3页 Computer Engineering
基金 湖北省教育厅中青年科技基金资助项目(20111613)
关键词 立方体 分布估计算法 数据仓库 联机分析处理 视图选择 cube Estimation of Distribution Algorithm(EDA) data warehouse On Line Analytical Processing(OLAP) view selection
  • 相关文献

参考文献23

  • 1Codd E F. Providing OLAP to User-analysts: An IT Man- date[EB/OL]. (1993-11-26). http://www.hyperion.com/whitepapers. cfm.htm.
  • 2Harinarayan V, Rajaraman A, Ullman J D. Implementing Data Cubes Efficiently[C]//Proc. of 1996 ACM SIGMOD Int'l Conf. on Management of Data. Montreal, Canada: ACM Press, 1996: 205-216.
  • 3Zhang C, Yang J. Genetic Algorithm for Materialized View Selection in Data Warehouse Environments[C]//Proc. of the 8th Int'l Conf. on Data Warehousing and Knowledge Discovery. Florence, Italy: Springer-Verlag, 1999.
  • 4Lawrence M. Multiobjective Genetic Algorithms for Materialized View Selection in OLAP Data Warehouses[C]//Proc. of 2006 Genetic and Evolutionary Computation Conference. Seattle, USA: ACM Press, 2006: 699-706.
  • 5Homg Jomg-Tzong, Chang Yu-Jan, Liu Baw-Jhiune. Applying Evolutionary Algorithms to Materialized View Selection in a Data Warehouse[J]. Soft Computing, 2003, 7(8): 574-581.
  • 6Yu Xu, Yao Xin, Choi C H, et al. Materialized View Selection as Constraint Evolutionary Optimization[J]. IEEE Trans. on Systems, Man, and Cybernetics, 2003, 33(4): 485-467.
  • 7Zhang Chuan, Yao Xin, Yang Jian. An Evolutionary Approach to Materialized View Selection in a Data Warehouse Environment[J]. IEEE Trans. on Systems, Man, and Cybernetics, 2001, 31(3): 282-293.
  • 8Lee M, Hammer J. Speeding up Materialized View Selection in Data Warehouses Using a Randomized Algorithm[J]. International Journal of Cooperative Information Systems, 2001, 10(3): 327- 353.
  • 9Wang Ziqiang, Zhang Dexian. Optimal Genetic View Selection Algorithm Under Space Constraint[J]. International Journal of Information Technology, 2005, 11(5): 44-51.
  • 10Lin Wenyang, Chung K. A Genetic Selection Algorithm for OLAP Data Cubes[J]. International Journal of Knowledge and Information Systems, 2004, 6(1): 83-102.

二级参考文献13

  • 1Gupta H.Selection of views to materialize in a data warehouse[C].In:Proc.6th Int.Conf.Database Theory,January,1997,98-112.
  • 2Gupta H,Mumick I S.Selection of views to materialize under a maintenance cost constraint[C].In:Proc.7th Int.Conf.Database Theory,January,1999,453-470.
  • 3Theodoratos D,Sellis T.Data warehouse configuration[C].In:Proc.23rd Int.Conf.Very Large Data Bases,August,1997,126-135.
  • 4Harinarayan V,Rajaraman A,Ullman J.Implementing data cubes efficiently[C].In:Proc.1996 ACM Int.Conf.Management of Data,June,1996,205-216.
  • 5Yang J,Karlapalem K,Li Q.Algorithms for materialized view design in data warehousing environment[C].In:Proc.23rdInt.Conf.Very Large Data Bases,August,1997,136-145.
  • 6Zhang C,Yang J.Genetic algorithm for materialized view selection in data warehouse environment[C].In:Proc.First Int.Conf.Data Warehousing and Knowledge Discovery,August,1999,116-125.
  • 7Zhang C,Yao X,Yang J.Evolving materialized views in data warehouse[J].IEEE Proceedings of the 1999 Congress on Evolutionary Computation,1999,2(2):823-829.
  • 8Qiu S G,Ling T W.View selection in OLAP environment[C].In:Proc.11th Int.Conf.Database and Expert System Application,September,2000,447-456.
  • 9Zhang C,Yao X,Yang J.An evolutionary approach to materialized views selection in a data warehouse environment[J].IEEE Transactions on System,Man,and Cybernetics-Part C:Applications and Reviews,2001,31(3):282-294.
  • 10Horng J T,Chang Y J,Liu B J.Applying evolutionary algorithms to materialized view selection in a data warehouse[J].Soft Computing,2003,7(8):574-581.

共引文献3

同被引文献36

引证文献4

二级引证文献6

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部