chapter 1 introduction
1.1 database-system applications
1.2 purpose of database systems
1.3 view of data
1.4 database languages
1.5 relational databases
1.6 database design
1.7 data storage and querying
1.8 transaction management
1.9 database architecture
1.10 data mining and information retrieval
1.11 specialty databases
1.12 database users and administrators
1.13 history of database systems
1.14 summary
review terms
practice exercises
exercises
tools
bibliographical notes
part one relational databases
chapter 2 introduction to the relational model
2.1 structure of relational databases
2.2 database schema
2.3 keys
2.4 schema diagrams
2.5 relational query languages
2.6 relational operations
2.7 summary
review terms
practice exercises
exercises
bibhographical notes
chapter 3 introduction to sql
3.1 overview of the sql query language
3.2 sql data definition
3.3 basic structure of sql queries
3.4 additional basic operations
3.5 set operations
3.6 null values
3.7 aggregate functions
3.8 nested subqueries
3.9 modification of the database
3.10 summary
review terms
practice exercises
exercises
tools
bibliographical notes
chapter 4 intermediate sql
4.1 join expressions
4.2 views
4.3 transactions
4.4 integrity constraints
4.5 sql data types and schemas
4.6 authorization
4.7 summary
review terms
practice exercises
exercises
bibliographical notes
chapter 5 advanced sql
5.1 accessing sql from a programming language
5.2 functions and procedures
5.3 triggers
5.4 recursive queries**
5.5 advanced aggregation features**
5.60lap**
5.7 summary
review terms
practice exercises
exercises
tools
bibliographical notes
chapter 6 formal relational query languages
6.1 the relational algebra
6.2 the tuple relational calculus
6.3 the domain relational calculus
6.4 summary
review terms
practice exercises
exercises
bibliographical notes
part two database design
chapter 7 database design and the e-r model
7.1 overview of the design process
7.2 the entity-relationship model
7.3 constraints
7.4 removing redundant attributes in entity sets
7.5 entity-relationship diagrams
7.6 reduction to relational schemas
7.7 entity-relationship design issues
7.8 extended e-r features
7.9 alternative notations for modeling data
7.10 other aspects of database design
7.11 summary
review terms
practice exercises
exercises
tools
bibliographical notes
chapter 8 relational database design
8.1 features of good relational designs
8.2 atomic domains and first normal form
8.3 decomposition using functional dependencies
8.4 functional-dependency theory
8.5 algorithms for decomposition
8.6 decomposition using multivalued dependencies
8.7 more normal forms
8.8 database-design process
8.9 modeling temporal data
8.10 summary
review terms
practice exercises
exercises
bibliographical notes
chapter 9 application design and development
9.1 application programs and user interfaces
9.2 web fundamentals
9.3 servlets and jsp
9.4 application architectures
9.5 rapid application development
9.6 application performance
9.7 application security
9.8 encryption and its applications
9.9 summary
review terms
practice exercises
exercises
project suggestions
tools
bibliographical notes
part three data storage,querying,and transaction management
chapter 10 data storage and data access
10.1 overview of physical storage media
10.2 magnetic disk and flash storage
10.3 organization of files and records
10.4 data-dictionary storage
10.5 database buffer
10.6 basic concepts of index
10.7 ordered indices
10.8 b+-tree index files
10.9 hash file organization and hash index
10.10 index definition in sql
10.11 summary
review terms
practice exercises
exercises
bibliographical notes
chapter 11 query processing and query optimization
11.1 overview
11.2 measures of query cost
11.3 implementation of relational algebra operation
11.4 evaluation of expressions
11.5 query optimization
11.6 summary
review terms
practice exercises
exercises
bibliographical notes
chapter 12 transaction management
12.1 transaction concept
12.2 transaction atomicity and durability
12.3 transaction isolation
12.4 serializability
12.5 recoverability
12.6 concurrency control
12.7 recovery system
12.8 summary
review terms
practice exercises
exercises
bibliographical notes
part four advanced topics
chapter 13 data warehousing and mining
13.1 decision-support systems
13.2 data warehousing
13.3 data mining
13.4 summary
review terms
practice exercises
exercises
tools
bibliographical notes
chapter 14 object-based databases
14.1 overview
14.2 complex data types
14.3 structured types and inheritance in sql
14.4 table inheritance
14.5 array and multiset types in sql
14.6 object-identity and reference types in sql
14.7 implementing o-r features
14.8 persistent programming languages
14.9 object-relational mapping
14.10 object-oriented versus object-relational
14.11 summary
review terms
practice exercises
exercises
tools
bibliographical notes
chapter 15 xml
15.1 motivation
15.2 structure of xml data
15.3 xml document schema
15.4 querying and transformation
15.5 application program interfaces to xml
15.6 storage of xml data
15.7 xml applications
15.8 summary
review terms
practice exercises
exercises
tools
bibliographical notes
chapter 16 advanced application development
16.1 performance tuning
16.2 performance benchmarks
16.3 other issues in application development
16.4 standardization
16.5 summary
review terms
practice exercises
exercises
bibliographical notes
bibliography