Database system concepts / Abraham Silberschatz, Henry F. Korth, S. Sudarshan.

Chapter 1 Introduction
1.1 Database-system applications
1.2 Purpose of database systems
1.3 View of data
1.4 Database languages
etc.

PART 1 RELATIONAL DATABASES
Chapter 2 Relational model
2.1 Structure of relational databases
2.2 Fundamental relational algebra
2.3 Additional relational algebra operations
2.4 Extended relational algebra operations
etc.

Chapter 3 SQL
3.1 Background
3.2 Data definition
3.3 basic structure of SQL queries
3.4 Set operators
etc.

Chapter 4 Advanced SQL
4.1 SQL data types and schemas
4.2 Integrity constraints
4.3 Authorization
4.4 Embedded SQL
etc.

Chapter 5 Other relational languages
5.1 Tuple relational calculus
5.2 The domain relational calculus
5.3 Query-by-example
5.4 Datalog
etc.

PART 2 DATABASE DESIGN
Chapter 6 Database design and the E-R model
6.1 Overview of the design process
6.2 The entity relationship model
6.3 Constraints
6.4 Entity relationships
etc.

Chapter 7 Relational database design
7.1 Features of good relational designs
7.2 Atomic domains and first normal formal
7.3 Decomposition using functional dependencies
7.4 Functional-dependency
etc.

Chapter 8 Application design and development
8.1 User interfaces and tools
8.2 Web interfaces
8.3 Web fundamentals
8.4 Servlets and JSP
etc.

PART3 OBJECT-BASED DATABASES AND XML
Chapter 9 Object-based databases
9.1 Overview
9.2 Complex data types
9.3 Structured types and inheritance in SQL
9.4 Table inheritance
etc.

Chapter 10 XML
10.1 Motivation
10.2 Structure of XML data
10.3 XML document schema
10.4 Querying and transformation
etc.

PART 4 DATA STORAGE AND QUERYING
Chapter 11 Storage and file structure
11.1 Overview of physical
11.2 Magnetic disks
11.3 RAID
11.4 Tertiary storage
etc.

Chapter 12 Indexing and hashing
12.1 Basic concepts
12.2 Ordered indices
12.3 B+-tree index files
12.4 B-tree index files
etc.

Chapter 13 Query processing
13.1 Overview
13.2 Measures of query cost
13.3 Selection operation
13.4 Sorting
etc.

Chapter 14 Query optimization
14.1 Overview
14.2 Transformation of relational expressions
14.3 Estimating statistics of expression results
14.4 Choice of evaluation plans
etc.

PART 5 TRANSACTION MANAGEMENT
Chapter 15 Transactions
15.1 Transaction concept
15.2 transaction state
15.3 Implementation of atomicity and durability
15.4 concurrent executions
etc.

Chapter 16 Concurrency control
16.1 Lock-based protocols
16.2 Timestamp-based protocols
16.3 Validation-based protocols
16.4 Multiple granularity
etc.

Chapter 17 Recovery system
17.1 Failure classification
17.2 Storage structure
17.3 Recovery and atomicity
17.4 Log-based recovery
etc.

PART 6 DATA MINING AND INFORMATION RETRIEVAL
Chapter 18 Data analysis and mining
18.1 Decision support systems
18.2 Data analysis
18.3 Data warehousing
18.4 Data mining
etc.

Chapter 19 Information retrieval
19.1 Overview
19.2 Relevance ranking using terms
19.3 Relevance using hyperlinks
19.4 Synonyms, homonyms and ontologies
etc.

PART 7 SYSTEM ARCHITECTURE
Chapter 20 Database system architecture
20.1 Centralized and client server architectures
20.2 Server system architectures
20.3 Parallel systems
20.4 Distributed systems
etc.

Chapter 21 Parallel databases
21.1 Introduction
21.2 I/O parallelism
21.3 Interquery parallelism
21.4 Intraquery parallelism
etc.

Chapter 22 Distributed databases
22.1 Homogeneous and heterogeneous databases
22.2 Distributed data storage
22.3 Distributed transactions
22.4 Commit protocols
etc.

PART 8 OTHER TOPICS
Chapter 23 Advanced application development
23.1 Performance tuning
23.2 Performance benchmarks
23.3 Standardization
23.4 Application migration
etc.

Chapter 24 Advanced data types and new applications
24.1 Motivation
24.2 Time in databases
24.3 Spatial and geographic data
24.4 Multimedia databases
etc.

Chapter 25 Advanced transaction processing
25.1 Transaction processing monitors
25.2 Transaction workflows
25.3 E-commerce
25.4 Main memory databases
etc.

PART 9 CASE STUDIES
Chapter 26 Poatgre SQL
26.1 Introduction
26.2 User interface
26.3 SQL variations and extensions
26.4 Transaction management in postgre SQL
etc.

Chapter 27 Oracle
27.1 Database design and querying tools
27.2 SQL variations and extensions
27.3 Storage and indexing
27.4 Concurrency
etc.

Chapter 28 IBM DB2 Universal database
28.1 Overview
28.2 Database design tools
28.3 SQL variations and extensions
28.4 Storage and indexing
etc.

Chapter 29 Microsoft SQL server
29.1 Management, design and querying
29.2 SQL variations and extensions
29.3 Storage and indexing
29.4 Query processing and optimization
etc.

Bibliography : p. 1101 - 1128 .-- Index : p. 1129 - 1142