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

文章基本信息

  • 标题:Optimizing Access Strategies for a Distributed Database Design using Genetic Fragmentation
  • 本地全文:下载
  • 作者:Rajinder Singh Virk ; Gurvinder Singh
  • 期刊名称:International Journal of Computer Science and Network Security
  • 印刷版ISSN:1738-7906
  • 出版年度:2011
  • 卷号:11
  • 期号:6
  • 页码:180-183
  • 出版社:International Journal of Computer Science and Network Security
  • 摘要:A key component of any Relational Distributed Database Query Optimizer is to fragment various tables and distribute fragmented Data over the sites of network. Then find an near optimal or best possible subquery operation allocation plan in a stipulated time period. In this paper we have proposed a Genetic Algorithm (GA) for finding near optimal fragmentation plan for selecting the various nodes or sites for placing recursively the vertically fragmented data attributes in two components for a Query Transaction on the Database. We discuss advantages of using proposed Genetic Algorithm (PGA) over various other prevalent Algorithms and un partitioned case. Experimental results for a simulated Distributed Database over a Wide Area Network show encouraging results for the use of PGA over other techniques.
  • 关键词:Distributed Database; Query Optimization; Database Fragmentation; Access Strategies; Genetic Algorithms
国家哲学社会科学文献中心版权所有