数据库系统基础教程

1TheWorldsofDatabaseSystems

1.1TheEvolutionofDatabaseSystems

1.1.1EarlyDatabaseManagementSystems

1.1.2RelationalDatabaseSystems

1.1.3SmallerandSmallerSystems

1.1.4BiggerandBiggerSystems

1.1.5InformationIntegration

1.2OverviewofaDatabaseManagementSystem

1.2.1Data-DefinitionLanguageCommands

1.2.2OverviewofQueryProcessing

1.2.3StorageandBufferManagement

1.2.4TransactionProcessing

1.2.5TheQueryProcessor

1.3OutlineofDatabase-SystemStudies

1.4ReferencesforChapter1

ⅠRelationalDatabaseModeling

2TheRelationalModelofData

2.1AnOverviewofDataModels

2.1.1WhatisaDataModel?

2.1.2ImportantDataModels

2.1.3TheRelationalModelinBrief

2.1.4TheSemistructuredModelinBrief

2.1.5OtherDataModels

2.1.6ComparisonofModelingApproaches

2.2BasicsoftheRelationalModel

2.2.1Attributes

2.2.2Schemas

2.2.3Tuples

2.2.4Domains

2.2.5EquivalentRepresentationsofaRelation

2.2.6RelationInstances

2.2.7KeysofRelations

2.2.8AnExampleDatabaseSchema

2.2.9ExercisesforSection2.2

2.3DefiningaRelationSchemainSQL

2.3.1RelationsinSQL

2.3.2DataTypes

2.3.3SimpleTableDeclarations

2.3.4ModifyingRelationSchemas

2.3.5DefaultValues

2.3.6DeclaringKeys

2.3.7ExercisesforSection2.3

2.4AnAlgebraicQueryLanguage

2.4.1WhyDoWeNeedaSpecialQueryLanguage?

2.4.2WhatisanAlgebra?

2.4.3OverviewofRelationalAlgeebra

2.4.4SetOperationsonRelations

2.4.5Projection

2.4.6Selection

2.4.7CartesianProduct

2.4.8NaturalJoins

2.4.9Theta-Joins

2.4.10CombiningOperationstoFormQueries

2.4.11NamingandRenaming

2.4.12RelationshipsAmongOperations

2.4.13ALinearNotationforAlgebraicExpressions

2.4.14ExercisesforSection2.4

2.5ConstraintsonRelations

2.5.1RelationalAlgebraasaConstraintLanguage

2.5.2ReferentialIntegrityConstraints

2.5.3KeyConstraints

2.5.4AdditionalConstraintExamples

2.5.5ExercisesforSecticn2.5

2.6SummaryofChapter2

2.7ReferencesforChapter2

3DesignTheoryforRelationalDatabases

3.1FunctionalDependencies

3.1.1DefinitionofFunctionalDependency

3.1.2KeysofRelations

3.1.3Superkeys

3.1.4ExercisesforSection3.1

3.2RulesAboutFunctionalDependencies

3.2.1ReasoningAboutFunctionalDependencies

3.2.2TheSplitting/CombiningRule

……

　　本书由美国斯坦福大学知名计算机科学家JeffreyUllman和JenniferWidom合作编写。书中介绍了核心DBMS概念、理论和模型，描述了如何使用抽象语言和SQL查询与更新DBMS。在介绍了SQL扩展内容(包括嵌入式SQL程序设计和对象关系特征)后，又介绍了使用XML的系统。设计语言包括XML模式，查询语言包括XPath和XQuery。