规范化与非规范化之间的区别
更改数据库结构的过程基本上分为两种方式,一种是规范化,另一种是非规范化。
以下是规范化和非规范化之间的重要区别。
Normalizationisusedtoremoveredundantdatafromthedatabaseandtostorenon-redundantandconsistentdataintoit.Normalizationmainlyfocusesonclearingthedatabasefromunuseddataandtoreducethedataredundancyandinconsistency.DuringNormalizationasdataisreducedsoanumberoftablesaredeletedfromthedatabasehencetablesarelesserinnumber.Normalizationusesoptimizedmemoryandhencefasterinperformance.Normalizationmaintainsdataintegrityi.e.anyadditionordeletionofdatafromthetablewillnotcreateanymismatchintherelationshipofthetables.Normalizationisgenerallyusedwherenumberofinsert/update/deleteoperationsareperformedandjoinsofthosetablesarenotexpensive.热门推荐
10 青春告白祖国简短祝福语
11 中秋祝福语送朋友简短
12 18岁简短祝福语经典
13 公司28 周年祝福语简短
14 送女士祝福语长辈简短
15 儿女的生日祝福语简短
16 美好的成语祝福语简短
17 简短56岁生日祝福语
18 朋友孩子考试祝福语简短