欢迎来到天天文库
浏览记录
ID:7890984
大小:1.75 MB
页数:232页
时间:2018-03-01
《joe celko sql programming style外语英文电子书》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、JOECELKO’SSQLPROGRAMMINGSTYLEJoeCelkoCONTENTSIntroductionxv1NamesandDataElements11.1Names21.1.1WatchtheLengthofNames21.1.2AvoidAllSpecialCharactersinNames31.1.3AvoidQuotedIdentifiers41.1.4EnforceCapitalizationRulestoAvoidCase-SensitivityProblems61.2FollowtheISO-11179StandardsN
2、amingConventions71.2.1ISO-11179forSQL81.2.2LevelsofAbstraction91.2.3AvoidDescriptivePrefixes101.2.4DevelopStandardizedPostfixes121.2.5TableandViewNamesShouldBeIndustryStandards,Collective,Class,orPluralNouns141.2.6CorrelationNamesFollowtheSameRulesasOtherNames...Almost151.2.7R
3、elationshipTableNamesShouldBeCommonDescriptiveTerms171.2.8MetadataSchemaAccessObjectsCanHaveNamesThatIncludeStructureInformation181.3ProblemsinNamingDataElements181.3.1AvoidVagueNames181.3.2AvoidNamesThatChangefromPlacetoPlace191.3.3DoNotUseProprietaryExposedPhysicalLocators21
4、2Fonts,Punctuation,andSpacing232.1TypographyandCode232.1.1UseOnlyUpper-andLowercaseLetters,Digits,andUnderscoresforNames252.1.2LowercaseScalarsSuchasColumnNames,Parameters,andVariables25viiiCONTENTS2.1.3CapitalizeSchemaObjectNames262.1.4UppercasetheReservedWords262.1.5Avoidthe
5、UseofCamelCase292.2WordSpacing302.3FollowNormalPunctuationRules312.4UseFullReservedWords332.5AvoidProprietaryReservedWordsifaStandardKeywordIsAvailableinYourSQLProduct332.6AvoidProprietaryStatementsifaStandardStatementIsAvailable342.7RiversandVerticalSpacing372.8Indentation382
6、.9UseLineSpacingtoGroupStatements393DataDeclarationLanguage413.1PuttheDefaultintheRightPlace413.2TheDefaultValueShouldBetheSameDataTypeastheColumn423.3DoNotUseProprietaryDataTypes423.4PlacethePRIMARYKEYDeclarationattheStartoftheCREATETABLEStatement443.5OrdertheColumnsinaLogica
7、lSequenceandClusterTheminLogicalGroups443.6IndentReferentialConstraintsandActionsundertheDataType453.7GiveConstraintsNamesintheProductionCode463.8PutCHECK()ConstraintNearwhattheyCheck463.8.1ConsiderRangeConstraintsforNumericValues473.8.2ConsiderLIKEandSIMILARTOConstraintsforCh
8、aracterValues473.8.3RememberThatTemporalValuesHaveDuration483
此文档下载收益归作者所有