数据库设计规范.docVIP免费

关系型数据库设计规范(V1.0)浪潮集团山东通用软件有限公司一九九九年十月十日1目录文档类别使用对象41.概述51.1简介...................................................................................................................51.2术语定义...........................................................................................................51.3参考资料...........................................................................................................51.4版本更新记录...................................................................................................52．数据库设计的目标63.数据库的特征63.1完整性约束.......................................................................................................63.1.1notnull约束.............................................................................................73.1.2缺省值.....................................................................................................73.1.3unique约束........................................................................................73.1.4primarykey约束................................................................................73.1.5参照完整性约束................................................................................83.1.6check约束..........................................................................................83.2存储过程...................................................................................................83.3触发器.......................................................................................................93.4事务处理...................................................................................................93.4.3事务与一致性..................................................................................103.4.4事务和恢复......................................................................................103.5并发处理.................................................................................................103.5.3死锁..................................................................................................113.5.4读一致性..........................................................................................113.6序号生成器.............................................................................................113.7视图.........................................................................................................113.7.3安全性..............................................................................................123.7.4逻辑数据独立性..............................................................................124.调整数据库设计以提高系统性能134.1建立有用的性能标准.............................................................................134.2数据库的规范化.....................................................................................134.3通过非规范化设计提高数据库的效率.................................................1324.3.3非规范化的原因..............................................................................134.3.4非规范化技术..................................................................................144.3.5进行非规范化处理时的注意事项..................................................144.4表的大小..............................................................