數(shù)據(jù)庫管理系統(tǒng)（英文版·第3版）

定　價(jià)：￥45.00

作　者：	（美）波斯特（Post,G.V.）著
出版社：	機(jī)械工業(yè)出版社
叢編項(xiàng)：	經(jīng)典原版書庫
標(biāo)　簽：	數(shù)據(jù)庫存儲(chǔ)與管理

購買這本書可以去

ISBN：	9787111178521	出版時(shí)間：	2005-12-01	包裝：	膠版紙
開本：	小16開	頁數(shù)：	424	字?jǐn)?shù)：

內(nèi)容簡介

　　對(duì)于管理和信息技術(shù)的專業(yè)人員來說，數(shù)據(jù)庫是最重要和最實(shí)用的工具之一。數(shù)據(jù)庫為在機(jī)構(gòu)內(nèi)集成、組織和共享數(shù)據(jù)提供了基礎(chǔ)。數(shù)據(jù)庫管理方法提供了很多傳統(tǒng)編程技術(shù)無法比擬的優(yōu)勢，主要包括更短的開發(fā)時(shí)間、更容易修改、更好的數(shù)據(jù)完整性與安全性以及更強(qiáng)的數(shù)據(jù)共享和集成。而DBMS是最復(fù)雜的實(shí)用技術(shù)工具之一。本書涵蓋了構(gòu)建數(shù)據(jù)庫前的兩個(gè)關(guān)鍵主題：數(shù)據(jù)庫設(shè)計(jì) （規(guī)范化）和SQL （查詢）。所有主要的數(shù)據(jù)庫系統(tǒng)都涉及這兩個(gè)主題。規(guī)范化說明了如何細(xì)致設(shè)計(jì)數(shù)據(jù)庫以獲得DBMS能力。SQL是一種標(biāo)準(zhǔn)查詢語言，事實(shí)上用于應(yīng)用程序開發(fā)的每一步。 1. 側(cè)重于現(xiàn)代業(yè)務(wù)應(yīng)用程序開發(fā)。 ●根據(jù)業(yè)務(wù)模型來闡述數(shù)據(jù)庫設(shè)計(jì)。 ●通過很多示例和練習(xí)強(qiáng)調(diào)動(dòng)手實(shí)踐應(yīng)用。 ●側(cè)重于新型圖形用戶界面應(yīng)用程序。 ●包含數(shù)據(jù)庫編程和應(yīng)用程序開發(fā)的內(nèi)容。 ●關(guān)于編程和開發(fā)細(xì)節(jié)內(nèi)容的附錄。 2. 熱點(diǎn)主題。 ●介紹并使用統(tǒng)一建模語言（UML）來建模和繪制系統(tǒng)圖表。 ●關(guān)于數(shù)據(jù)庫環(huán)境下安全主題的深入討論。 ●因特網(wǎng)和內(nèi)聯(lián)網(wǎng)的數(shù)據(jù)庫開發(fā)。 ●強(qiáng)調(diào)SQL 92，同時(shí)介紹SQL 99和SQL 200x的XML特性。 ●數(shù)據(jù)庫中完整的應(yīng)用程序和對(duì)象。 3. 實(shí)用的業(yè)務(wù)練習(xí)和案例。 ●很多數(shù)據(jù)庫設(shè)計(jì)問題。 ●涵蓋應(yīng)用程序開發(fā)所有方面的練習(xí)。 ●適用于期末實(shí)踐項(xiàng)目的案例。 4. 一個(gè)完整的示例數(shù)據(jù)庫應(yīng)用程序（滾雷自行車）。 ●功能完善的業(yè)務(wù)數(shù)據(jù)庫。 ●示例數(shù)據(jù)和數(shù)據(jù)產(chǎn)生例程。 ●一般數(shù)據(jù)庫操作的示例程序代碼。 5. 用于比較和附加任務(wù)的第二個(gè)數(shù)據(jù)庫（Sally的寵物商店）。 6. PowerPoint幻燈片形式的講課記錄。 7. 為特定數(shù)據(jù)庫技術(shù)編制的工作手冊。

作者簡介

　　GGerald V.Post，1983年于艾奧瓦州立大學(xué)獲得博士學(xué)位，現(xiàn)為太平洋大學(xué)管理信息系統(tǒng)教授，講授管理信息系統(tǒng)、數(shù)據(jù)庫管理、系統(tǒng)開發(fā)、網(wǎng)站開發(fā)等課程。其網(wǎng)站http：//jerrypost.com/DBBook/index.html提供本書相關(guān)資源下載。

圖書目錄

Chapter1Introduction.1
ADeveloper'sView2
Introduction2
DatabasesandApplicationDevelopment2
ComponentsofaDatabaseManagementSystem4
DatabaseEngine4
DataDictionary5
QueryProcessor6
ReportWriter6
FormsGenerator8
ApplicationGenerator9
CommunicationandIntegration9
SecurityandOtherUtilities10
AdvantagesoftheDatabaseManagementSystemApproach10
FocusonData11
DataIndependence12
DataIndependenceandClient/ServerSystems13
LeadingCommercialDatabases13
BriefHistoryofDatabaseManagementSystems14
HierarchicalDatabases14
NetworkDatabases14
RelationalDatabases16
Object-OrientedDatabases16
ApplicationDevelopment20
Sally'sPetStore21
RollingThunderBicycles22
TheFeasibilityStudy22
Costs23
Benefits24
Summary25
KeyTerms26
ReviewQuestions26
Exercises26
WebsiteReferences28
AdditionalReading28
PARTONESYSTEMSDESIGN29
Chapter2DatabaseDesign30
ADeveloper'sView31
Introduction31
GettingStarted32
DesigningDatabases33
IdentifyingUserRequirements33
BusinessObjects34
TablesandRelationships35
Definitions35
PrimaryKey36
ClassDiagrams37
ClassesandEntities37
AssociationsandRelationships38
ClassDiagramDetails39
Sally'sPetStoreClassDiagram47
DataTypes(Domains)49
Text50
Numbers50
DatesandTimes51
BinaryObjects52
ComputedValues52
User-DefinedTypes
(Domains/Objects)53
Events53
LargeProjects55
RollingThunderBicycles56
ApplicationDesign61
Summary62
KeyTerms63
ReviewQuestions63
Exercises64
WebsiteReferences69
AdditionalReading69
Appendix:DatabaseDesignSystem70
SampleProblem:CustomerOrders70
GettingStarted:ldentifyingColumns70
CreatingaTableandAdding
Columns71
Relationships:ConnectingTables73
Grading:DetectingandSolving
Problems73
SpecifyingDataTypes76
Chapter3DataNormalization77
ADeveloper'sView78
Introduction78
Tables,Classes,andKeys79
CompositeKeys79
SurrogateKeys80
Notation81
SampleDatabaseforaVideoStore83
InitialObjects84
InitialFormEvaluation85
ProblemswithRepeatingSections87
FirstNormalForm89
RepeatingGroups89
NestedRepeatingGroups90
SecondNormalForm91
ProblemswithFirstNormalForm91
SecondNormalFormDefinition92
Dependence93
ThirdNormalForm94
ProblemswithSecondNormalForm94
ThirdNormalFormDefinition95
CheckingYourWork97
BeyondThirdNormalForm98
Boyce-CoddNormalForm98
FourthNormalForm99
Domain-KeyNormalForm100
DataRulesandIntegrity102
TheEffectsofBusinessRules104
ConvertingaClassDiagramtoNormalizedTables106
One-to-ManyRelationships106
Many-to-ManyRelationships108
N-aryAssociations108
GeneralizationorSubtypes108
Composition110
ReflexiveAssociations111
Summary112
Sally'sPetStoreExample112
ViewIntegration115
Sally'sPetStoreExample115
RollingThunderSampleIntegrationProblem117
DataDictionary123
DBMSTableDefinition123
DataVolumeandUsage127
Summary129
KeyTerms130
ReviewQuestions130
Exercises131
WebsiteReferences138
AdditionalReading138
Appendix:FormalDefinitionsofNormalization139
InitialDefinitions139
NormalFormDefinitions140
PARTTWOQUERIES143
Chapter4DataQueries144
ADeveloper'sView145
Introduction145
ThreeTasksofaQueryLanguage146
FourQuestionstoRetrieveData146
WhatOutputDoYouWanttoSee?147
WhatDoYouAlreadyKnow?147
WhatTablesAreInvolved?147
HowAretheTablesJoined?147
Sally'sPetStore148
VendorDifferences149
QueryBasics149
SingleTables149
IntroductiontoSQL151
SortingtheOutput151
Distinct152
Criteria153
BooleanAlgebra154
DeMorgan'sLaw155
UsefulWHEREClauses158
Computations159
BasicArithmeticOperators159
Aggregation159
Functions162
SubtotalsandGROUPBY163
ConditionsonTotals(HAVING)164
WHEREversusHAVING165
TheBestandtheWorst166
MultipleTables166
JoiningTables167
IdentifyingColumnsinDifferentTables168
JoiningManyTables169
HintsonJoiningTables170
TableAlias172
CreateView172
Summary174
KeyTerms175
ReviewQuestions175
Exercises175
WebsiteReferences178
AdditionalReading178
Appendix:SQLSyntax179
ALTERTABLE179
COMMITWORK179
CREATEINDEX179
CREATETABLE179
CREATETRIGGER179
CREATEVIEW180
DELETE180
DROP180
INSERT180
GRANT180
REVOKE180
ROLLBACK181
SELECT181
SELECTINTO181
UPDATE181
Chapter5AdvancedQueriesandSubqueries182
ADeveloper'sView183
Introduction..183
Sally'sPetStore184
Subqueries184
CalculationsorSimpleLookup184
SubqueriesandSetsofData185
SubquerywithANYandALL185
Subtraction:NOTIN187
OUTERJOINS188
CorrelatedSubqueriesAreDangerous190
MoreFeaturesandTrickswithSQLSELECT193
UNION,INTERSECT,EXCEPT193
MultipleJOINColumns194
ReflexiveJoin195
CASEFunction196
InequalityJoins197
Questionswith"Every"NeedtheEXISTSClauseI97
SQLSELECTSummary199
SQLDataDefinitionCommands199
SQLDataManipulationCommands201
INSERTandDELETE201
UPDATE202
Quality:TestingQueries203
Summary205
KeyTerms206
ReviewQuestions206
Exercises206
WebsiteReferences210
AdditionalReading210
Appendix:IntroductiontoProgramming211
VariablesandData211
VariableScope212
Computations213
StandardInternalFunctions214
InputandOutput215
Conditions216
Loops217
Subroutines218
Summary220
PARTTHREEAPPLICATIONS221
Chapter6Forms,Reports,andApplications222
ADeveloper'sView223
Introduction223
EffectiveDesignofReportsandForms224
HumanFactorsDesign224
WindowControls226
UserInterface--WebNotes228
UserInterface--AccessibilityIssues229
FormLayout230
TabularForms230
Single-RoworColumnar-Forms231
SubformForms232
SwitchboardForms233
CreatingForms235
UpdateableQueries235
LinkedForms236
PropertiesandControls236
ControlsonForms237
MultipleForms241
InternationalAttributes243
DirectManipulationofGraphicalObjects245
Sally'sPetStoreExample245
TheInternet246
ComplicationsandLimitationsofaGraphicalApproach247
Reports247
ReportDesign248
Terminology248
BasicReportTypes250
Graphs254
ApplicationFeatures255
MenusandToolbars255
CustomHelp257
Summary261
KeyTerms262
ReviewQuestions262
Exercises262
WebsiteReferences264
AdditionalReading264
Chapter7DatabaseIntegrityandTransactions265
ADeveloper'sView266
Introduction266
ProceduralLanguages266
WhereShouldCodeBeLocated?267
User-DefinedFunctions268
LookingUpData269
DataTriggers269
StatementversusRowTriggers270
CancelingDataChangesinTriggers271
CascadingTriggers272
INSTEADOFTriggers273
Transactions274
ATransactionExample274
StartingandEndingTransactions274
SAVEPOINT276
MultipleUsersandConcurrentAccess276
PessimisticLocks:Serialization277
MultiuserDatabases:ConcurrentAccessandDeadlock278
OptimisticLocks280
ACIDTransactions281
KeyGeneration283
DatabaseCursors285
CursorBasics285
ScrollableCursors286
ChangingorDeletingDatawithCursors287
CursorswithParameters288
MerchandiseInventoryatSally'sPet
Store289
Summary293
KeyTerms294
ReviewQuestions294
Exercises294
WebsiteReferences296
AdditionalReading297
Chapter8DataWarehousesandDataMining298
ADeveloper'sView299
Introduction299
Indexes300
BinarySearch300
PointersandIndexes301
BitmapIndexandStatistics301
Problemswith'Indexes302
DataWarehousesandOnlineAnalyticalProcessing303
DataWarehouseGoals303
DataWarehouseIssues305
OLAPConcepts306
OLAPDatabaseDesign308
OLAPDataAnalysis310
OLAPinSQL312
SQLAnalyticFunctions316
SQLOLAPWindows316
DataMining318
Classification320
AssociationRules/MarketBasketAnalysis321
ClusterAnalysis323
GeographicAnalysis324
Summary325
KeyTerms326
ReviewQuestions326
Exercises326
WebsiteReferences327
AdditionalReading328
PARTFOURDATABASEADMINISTRATION329
Chapter9DatabaseAdministration330
ADeveloper'sView331
Introduction331
DataAdministrator332
DatabaseAdministrator333
DatabaseStructure334
Metadata335
DatabaseTasksbyDevelopmentStages336
DatabasePlanning336
DatabaseDesign337
DatabaseImplementation338
DatabaseOperationandMaintenance338
BackupandRecovery339
SecurityandPrivacy341
DataPrivacy341
Threats342
PhysicalSecurity342
ManagerialControls344
LogicalSecurity344
DivisionofDuties349
SoftwareUpdates350
Encryption351
Sally'sPetStore353
Summary355
KeyTerms356
ReviewQuestions356
Exercises357
WebsiteReferences359
AdditionalReading359
Chapter10
DistributedDatabasesandtheInternet360
ADeveloper'sView361
Introduction361
Sally'sPetStore361
DistributedDatabases362
GoalsandRules363
AdvantagesandApplications364
CreatingaDistributedDatabaseSystem366
DistributedQueryProcessing367
DataReplication369
Concurrency,Locks,andTransactions370
IndependentTransactionManagers372
DistributedDesignQuestions372
Client/ServerDatabases373
Client/ServerversusFileServer374
Three-TierClient/ServerModel375
TheBackEnd:ServerDatabases377
TheFrontEnd:WindowsClients377
MaintainingDatabaseIndependenceintheClient378
ElectronicCommerceDatabases380
TheWebasaClient/ServerSystem381
HTMI,-LimitedClients381
WebServerDatabaseFundamentals383
DataTransmissionIssuesinApplications385
XML:TransferringDatatoDiverse
Systems387
JavaandJDBC391
Summary392
KeyTerms393
ReviewQuestions393
Exercises394
WebsiteReferences395
AdditionalReading...396