Formulas of Retrieval Rate in Database Based on Normalization Design


  •  Bin Yan    

Abstract

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.



This work is licensed under a Creative Commons Attribution 4.0 License.
  • ISSN(Print): 1913-8989
  • ISSN(Online): 1913-8997
  • Started: 2008
  • Frequency: semiannual

Journal Metrics

WJCI (2022): 0.636

Impact Factor 2022 (by WJCI):  0.419

h-index (January 2024): 43

i10-index (January 2024): 193

h5-index (January 2024): N/A

h5-median(January 2024): N/A

( The data was calculated based on Google Scholar Citations. Click Here to Learn More. )

Contact