joe celko sql programming style外语英文电子书

《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