7.5.3Ensure database’sstorage structure
7.5.4 Evaluation of physical structure
7.6Implementing and safeguard of database
7.6.1Data loading and Application debugging
7.6.2Test run of database
7.6.3Running and safeguard of database
CHAPTER8 Database programming
8.1Embedded SQL
8.1.1Processing procedure ofembedded SQL
8.1.2Communication between embeddedSQL statement and main language
8.1.3SQL statement that don’t use Cursors
8.1.4 SQL statement thatuse Cursors
8.1.5Dynamic SQL
8.2Stored Procedure
8.2.1PL/SQL’s block structure
8.2.2Definition of variable and constant
8.2.3 Control Structure
8.2.4 Stored Procedure
8.3ODBC programming
8.3.1Summary of Database Connectivity
8.3.2Summary of ODBC’sOperating Principle
8.3.3 ODBC API foundation
8.3.4ODBC’s Workflow
CHAPTER 9 Relational queryProcessingand query optimization
9.1QueryProcessing of relational database system
9.1.1 Steps of queryProcessing
9.1.2Algorithm example of Implementing query operation
9.2Query optimization of relational database system
9.2.1 Summary of query optimization
9.2.2An example
《数据库系统概论》第四版目录的英文翻译
9.3 Algebra optimization
9.3.1Relational algebraexpression equivalence transformation rules
9.3.2Query Tree’s heuristic optimization
9.4 Physics optimization
9.4.1Heuristic rule-basedaccess path optimization
9.4.2Cost-basedoptimization
CHAPTER10 Database recovery techniques
10.1 The basic concept ofTransaction
10.2 Database recovery overview
10.3 Fault types
10.4Implementationtechniquesof Recovery
10.4.1 Data dump
10.4.2 Registry logging
10.5 Recovery policy
10.5.1 Recoveryof Transaction failure
10.5.2 Recovery of System fault
10.5.3 Recovery of mediumfailure
10.6Recovery technology with Checkpoint
10.7 Database mirror
CHAPTER11Concurrency control
11.1 Summary of Concurrency control
11.2Locking
11.3 Livelock and deadlock
11.3.1Livelock
11.3.2 Deadlock
11.4Serializabilityof Concurrentschedules
11.4.1Serializable schedules
11.4.2 Conflict serializable schedules
11.5 Two phase locking protocol
11.6 Granularity of blockade
11.6.1 Multi-granularity blockade
11.6.2 Intent locks
CHAPTER12 Database management system(DBMS)
12.1 Basic function of DBMS
12.2 Process structure and Multi thread mechanism of DBMS
12.2.1 N Scheme: integrating DBMS with Application
12.2.2 2N Scheme:
12.2.3 N+1 Scheme:
12.2.4 N+M Scheme
12.2.5 Concept of Multi_Threaded of DBMS
12.3 DBMS System structure
《数据库系统概论》第四版目录的英文翻译
12.3.1 Hierarchical structure of DBMS
12.3.2 Exampleof RDBMS’s Operation process
12.4Language processing
12.4.1Task and work steps of Language processing layer
12.4.2Interpretation method
12.4.3 Pre compilation method
CHAPTER13 New Development of database technology
13.1 Summary
13.2Three Stage of Development of database
13.2.1 First generationdatabase system
13.2.2 The second generationdatabase system
13.2.3The third generationdatabase system
13.3DevelopmentCharacteristics of database system
13.3.1Developmentof Data model
13.2.2Combining Database technologywith other technology
13.3.3New Database technology that face Application field
13.4 Development trend of database technology
CHAPTER14 DistributedDatabase System
14.1Summary
14.1.1 DistributedDatabase System
14.1.2 The characteristics of distributed database system
14.2The System structureof distributed database system
14.2.1 The Mode structureof distributed database system
14.2.2 Data slice
14.2.3 Distributed transparency
14.2.4 Distributed database management system
14.3 Query processing and optimization
14.3.1An example
14.3.2Problems need to solve of Query processing and optimization
14.3.3Aim of Query optimization
14.3.4Optimization ofJoin query
14.4 Distributed transaction management
14.4.1Recovery of Distributed transaction
14.4.2 Concurrency control
CHAPTER15 Object relational database system
15.1 Object oriented data model
15.1.1 The core concept of OO Model
15.1.2Class hierarchy
15.1.3Inheritance
15.1.4The nested objects
15.2Object- relational database
《数据库系统概论》第四版目录的英文翻译
15.2.1Extended relational data type in the Object relational database system
15.2.2Extended Object type in the Object relational database system and its definition 15.2.3Reference type
15.2.4Inheritance
15.2.5 Child table and Super Table
CHAPTER16 XML（Extensible Markup Language）Database