DB2 命名开发规范.docx

For DB2DB Development-NamingSpecification2012/01/01Author(作者)：Jet LeeDate：Checked by(审核)：Date：Change History (变更历史)DateVersionAuthorDescription of change2012-6-121.0Jet Lee新起草2012-6-151.1Jet Lee文档拆分成两个Content1Introduction (引言)61.1Purpose(规范的目的)61.2Readers (阅读的人员)61.3Glossary (术语)61.4Reference (参考资料)62Unified criterion for Naming (统一的命名规范)62.1Overall Principle (整体性原则)62.2Database alias (数据别名)72.3Object Schema (对象概述)72.4Table(表)72.4.1Table Name(表名称)72.4.2Table Index(表索引)72.4.3Table Field(表字段)72.5View(视图)82.6Stored procedure(存储过程)82.7Function(函数)82.8Variant or Parameter(变量 参数)83Unified criterion for Development (统一的开发规范)93.1Statement (语句)93.1.1Overall Principle (整体性原则)93.1.2Nesting (语句嵌套)93.2Comments(备注)93.2.1Field(字段)93.2.2Parameter (参数)93.2.3Function(函数)103.2.4Procedure(过程)103.2.5View(视图)103.2.6Key Arithmetic (关键算法)113.3Create Table(表创建)113.3.1Table Index(索引)113.3.2[删除]Paradigm Requirement (范式要求，原则上属于设计要求)113.4View(视图)113.5Function (函数)113.6Procedure (过程)123.7Trigger (触发器)133.8Isolation Level (隔离集使用)134Attachment (附件)134.1[删除，系统设计的范畴]Table Normal Form134.2Isolation Level13Introduction (引言)Purpose(规范的目的)Guide the developer how to name the DB objects (Tables, views, stored procedure, etc)(指引开发人员如何去规范对DB中对象进行命名)；Readers (阅读的人员)Developer, the members of the review board, Development Manager；(开发人员；Review board成员；开发经理)；Glossary (术语)Table Normal form: Refer the attachment;表的范式：参考附件；Isolation Level: Refer the attachment;隔离级：参考附件；Reference (参考资料)NoneUnified criterion for Naming (统一的命名规范)Overall Principle (整体性原则)The characters range for all names: A-Z, a-z, 0-9, _ (Underscore). Not allowed to use other characters as the name. (所有名称的字符范围为：A-Z, a-z, 0-9 和_ (下划线)。不允许使用其他字符作为名称).Please use English words or English phrases (including abbreviations) as name, but cannot be used as the name of meaningless characters or Chinese Pinyin. (采用英文单词或英文短语（包括缩写）作为名称，不能使用无意义的字符或汉语拼音。)Name should be clarity, the ability to accurately express the meaning of things, and readable. Please follow