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

文章基本信息

  • 标题:Formulas of Retrieval Rate in Database Based on Normalization Design
  • 本地全文:下载
  • 作者:Bin Yan
  • 期刊名称:Computer and Information Science
  • 印刷版ISSN:1913-8989
  • 电子版ISSN:1913-8997
  • 出版年度:2009
  • 卷号:2
  • 期号:3
  • 页码:32
  • DOI:10.5539/cis.v2n3p32
  • 出版社:Canadian Center of Science and Education
  • 摘要:

    A normalization database is considered as mathematics logical design to avoid redundancies and inconsistencies in the stored data which brought about null data and many relationship tables in the physical database. A retrieval rate is affected directly in running a practical system of the normalization design. We argue in the paper that rate formulas given out retrieval speed via testing the vast amount of data with decomposing fields and data in practical or ideal network environment. The rate formulas show that relationship tables increased must decrease retrieval speed and a minimum table must increase retrieval speed on the contrary, which compared with normal form according to the database theory and practical requirement. A speed is predictable to calculate the rate formulas. The retrieval speed is mainly concerned with server performance base on normal form too.

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