摘要
开展了对关系型数据库的逻辑设计规范的研究,从数据完整性、表逻辑、表分区、字段逻辑以及索引5方面详细介绍了关系型数据库的逻辑设计规范。关系型数据库的逻辑设计直接决定了数据的完整性、准确性与一致性,对数据库的性能具有重要影响。数据库逻辑设计的规范化可以减少数据冗余,提高数据库存储效率,从而提升整体数据库的性能。
In this paper,the specification of relational database logical design has been studied in detail from five aspects,i.e.,data integrity,table logic,table partition,field logic and index.The logical design of relational database directly determines the integrity,accuracy and consistency of data,and has an important influence on the performance of database.The specification of database logical design can reduce data redundancy and increase the storage efficiency of database,therefore,can improve the performance of the entire database.
作者
陈英达
黄巨涛
林强
唐亮亮
Chen Yingda;Huang Jutao;Lin Qiang;Tang Liangliang(Information Center, Guangdong Power Grid Company Limited, Guangzhou 510080)
出处
《微型电脑应用》
2018年第6期1-2,7,共3页
Microcomputer Applications
基金
广东电网有限责任公司2017年信息化项目(037800HA42170006)
关键词
关系型数据库
逻辑设计
规范
relational database
logical design
specification
