数据库系统概念(第4版)(影印版)
¥59.50定价
作者: ABRAHAM SILBERSCHATZ,HENRY F.
出版时间:2002-05-15
出版社:高等教育出版社
- 高等教育出版社
- 9787040110494
- 1
- 252559
- 平装
- 16开
- 2002-05-15
- 1480
- 1088
- 工学
- 计算机科学与技术
内容简介
本书介绍了数据库的基本概念,包括数据库设计、语言和系统实现。所有概念都通过直接描述来介绍,有清晰的、组织结构良好的图形和一些取代形式化证明的示例。书中通过一个生动的商业银行案例将核心的概念代入实际情境。本书修订和新增内容包括:实体关系模型及UML表示;结构查询语言;实例查询语言包括微软的Access QBE实现;规范化;面向对象和对象关系模型;新增的XML章节;查询处理;数据库管理;应用开发问题,包括通过Web访问数据库;数据仓库、OLAP和数据挖掘;信息检索内容的更新和扩展。新增附录还介绍了商用数据库系统的内核设计。
目录
目 录
Prefacexv
Chapter1Introduction
1.1DatabaseSystemApplications1
1.2DatabaseSystemsversusFileSystems3
1.3ViewofData5
1.4DataModels7
1.5DatabaseLanguages11
1.6DatabaseUsersandAdministrators13
1.7TransactionManagement15
1.8DatabaseSystemStructure16
1.9ApplicationArchitectures18
1.10HistoryofDatabaseSystems18
1.11Summary21
Exercises23
BibliographicalNotes24
PART1DATAMODELS
Chapter2Entity-RelationshipModel
2.1BasicConcepts27
2.2Constraints33
2.3Keys35
2.4DesignIssues37
2.5Entity-RelationshipDiagram42
2.6WeakEntitySets47
2.7ExtendedE-RFeatures49
2.8DesignofanE-RDatabaseSchema56
2.9ReductionofanE-RSchematoTables62
2.10TheUnifiedModelingLanguage
UML68
2.11Summary70
Exercises72
BibliographicalNotes77
Chapter3RelationalModel
3.1StructureofRelationalDatabases79
3.2TheRelationalAlgebra89
3.3ExtendedRelational-Algebra
Operations103
3.4ModificationoftheDatabase111
3.5Views113
3.6TheTupleRelationalCalculus118
3.7TheDomainRelationalCalculus122
3.8Surnmaryl26
Exercises127
BibliographicalNotes131
PART2RELATIONALDATABASES
Chapter4SQL
4.1Background135
4.2BasicStructure137
4.3SetOperations1M
4.4AggregateFunctionsl46
4.5NullValues148
4.6NestedSubqueries149
4.7Views154
4.8ComplexQueriesl55
4.9ModificationoftheDatabase157
4.10JoinedRelationsl63
4.11Data-DefinitionLanguage168
4.12EmbeddedSQL172
4.13DynamicSQL175
4.14OtherSQLFeatures180
4.15Summary182
Exercises183
BibliographicalNotes186
Chapter5OtherRelationalLanguages
5.1Query-by-Examplel89
5.2Datalog203
5.3UserInterfacesandTools217
5.4Summary2l9
Exercises220
BibliographicalNotes223
Chapter6IntegrityandSecurity
6.1DomainConstraints225
6.2ReferentialIntegrity227
6.3Assertions232
6.4Triggers233
6.5SecurityandAuthorization238
6.6AuthorizationinSQL244
6.7EncryptionandAuthentication248
6.8Summary250
Exercises252
BibliographicalNotes254
Chapter7Relational-DatabaseDesign
irstNormalForm257
7.2PitfallsinRelational-Database
Design258
7.3FunctionalDependencies260
7.4Decomposition271
7.5DesirablePropertiesof
Decomposition275
7.6Boyce--CoddNormalForm279
7.7ThirdNormalForm284
7.8FourthNormalForm289
7.9MoreNormalForms293
7.10OverallDatabaseDesignProcess293
7.11Surrunary297
Exercises299
BibliographicalNotes303
PART3OBJECT-BASEDDATABASESANDXML
Chapter8Object-OrientedDatabases
8.1NeedforComplexDataTypes307
8.2TheObject-OrientedDataModel308
8.3Object-OrientedLanguages318
8.4PersistentProgrammingLanguages318
8.5PersistentC++Systems322
8.6PersistentJavaSystems330
8.7Summary331
Exercises332
BibliographicalNotes333
Chapter9Object-RelationalDatabases
9.1NestedRelations335
9.2ComplexTypes337
9.3Inheritance342
9.4ReferenceTypes346
9.5QueryingwithComplexTypes348
9.6FunctionsandProcedures351
9.7Obect-Orientedversus
Object-Relational356
9.8Summary357
Exercises358
BibliographicalNotes360
Chapter10XML
10.1Background361
10.2StructureofXMLData364
10.3XMLDocumentSchema367
10.4QueryingandTransformation372
10.5TheApp1icationProgramInterface380
10.6StorageofXMLData381
10.7XMLApplications384
10.8Summary386
Exercises388
BibliographicalNotes390
PART4DATASTORAGEANDQUERYING
Chapter11StorageandFileStructure
11.1Ov
Prefacexv
Chapter1Introduction
1.1DatabaseSystemApplications1
1.2DatabaseSystemsversusFileSystems3
1.3ViewofData5
1.4DataModels7
1.5DatabaseLanguages11
1.6DatabaseUsersandAdministrators13
1.7TransactionManagement15
1.8DatabaseSystemStructure16
1.9ApplicationArchitectures18
1.10HistoryofDatabaseSystems18
1.11Summary21
Exercises23
BibliographicalNotes24
PART1DATAMODELS
Chapter2Entity-RelationshipModel
2.1BasicConcepts27
2.2Constraints33
2.3Keys35
2.4DesignIssues37
2.5Entity-RelationshipDiagram42
2.6WeakEntitySets47
2.7ExtendedE-RFeatures49
2.8DesignofanE-RDatabaseSchema56
2.9ReductionofanE-RSchematoTables62
2.10TheUnifiedModelingLanguage
UML68
2.11Summary70
Exercises72
BibliographicalNotes77
Chapter3RelationalModel
3.1StructureofRelationalDatabases79
3.2TheRelationalAlgebra89
3.3ExtendedRelational-Algebra
Operations103
3.4ModificationoftheDatabase111
3.5Views113
3.6TheTupleRelationalCalculus118
3.7TheDomainRelationalCalculus122
3.8Surnmaryl26
Exercises127
BibliographicalNotes131
PART2RELATIONALDATABASES
Chapter4SQL
4.1Background135
4.2BasicStructure137
4.3SetOperations1M
4.4AggregateFunctionsl46
4.5NullValues148
4.6NestedSubqueries149
4.7Views154
4.8ComplexQueriesl55
4.9ModificationoftheDatabase157
4.10JoinedRelationsl63
4.11Data-DefinitionLanguage168
4.12EmbeddedSQL172
4.13DynamicSQL175
4.14OtherSQLFeatures180
4.15Summary182
Exercises183
BibliographicalNotes186
Chapter5OtherRelationalLanguages
5.1Query-by-Examplel89
5.2Datalog203
5.3UserInterfacesandTools217
5.4Summary2l9
Exercises220
BibliographicalNotes223
Chapter6IntegrityandSecurity
6.1DomainConstraints225
6.2ReferentialIntegrity227
6.3Assertions232
6.4Triggers233
6.5SecurityandAuthorization238
6.6AuthorizationinSQL244
6.7EncryptionandAuthentication248
6.8Summary250
Exercises252
BibliographicalNotes254
Chapter7Relational-DatabaseDesign
irstNormalForm257
7.2PitfallsinRelational-Database
Design258
7.3FunctionalDependencies260
7.4Decomposition271
7.5DesirablePropertiesof
Decomposition275
7.6Boyce--CoddNormalForm279
7.7ThirdNormalForm284
7.8FourthNormalForm289
7.9MoreNormalForms293
7.10OverallDatabaseDesignProcess293
7.11Surrunary297
Exercises299
BibliographicalNotes303
PART3OBJECT-BASEDDATABASESANDXML
Chapter8Object-OrientedDatabases
8.1NeedforComplexDataTypes307
8.2TheObject-OrientedDataModel308
8.3Object-OrientedLanguages318
8.4PersistentProgrammingLanguages318
8.5PersistentC++Systems322
8.6PersistentJavaSystems330
8.7Summary331
Exercises332
BibliographicalNotes333
Chapter9Object-RelationalDatabases
9.1NestedRelations335
9.2ComplexTypes337
9.3Inheritance342
9.4ReferenceTypes346
9.5QueryingwithComplexTypes348
9.6FunctionsandProcedures351
9.7Obect-Orientedversus
Object-Relational356
9.8Summary357
Exercises358
BibliographicalNotes360
Chapter10XML
10.1Background361
10.2StructureofXMLData364
10.3XMLDocumentSchema367
10.4QueryingandTransformation372
10.5TheApp1icationProgramInterface380
10.6StorageofXMLData381
10.7XMLApplications384
10.8Summary386
Exercises388
BibliographicalNotes390
PART4DATASTORAGEANDQUERYING
Chapter11StorageandFileStructure
11.1Ov