Databases and transaction processing : an application-oriented approach / Philip M. Lewis, Arthur Bernstein & Michael Kifer.

Contents

Part One
Introduction

1. Overview of databases and transactions
1.1 what are databases and transactions?
1.2 features of modern database and transaction processing systems, etc

2. A Closer look
2.1 case study: a student registration system
2.2 introduction to relational databases, etc

3. Case study: starting the student registration system
3.1 software engineering methodology
3.2 requirements document, etc

Part two
Database Management

4. The relational data model
4.1 what is a data model?
4.2 the relational model, etc

5. Database Design I: The Entity-Relationship
5.1 conceptual Modeling with the E-R approach
5.2 entities and entity types, etc

6. Query Languages I: Relational Algebra and SQL
6.1 relational algebra: under the hood of SQL
6.2 the query sublanguage of SQL, etc

7. Query Languages II: Relationship calculus and visual query languages
7.1 tuple relational calculus
7.2 understanding SQL through tuple relational calculus, etc

8. Database Design II: Relational Normalized Theory
8.1 the problem of redundancy
8.2 decompositions, etc

9. Triggers and Active Databases
9.1 sematic issues in trigger handling
9.2 trigger in SQL:1999, etc

10. SQL in the real world
10.1 executing SQL statements within an application program
10.2 embedded SQL, etc

11. Physical Data Organisation and Indexing
11.1 disk organisation
11.2 heap files, etc

12. Case study: Completing the student registration system
12.1 the design document
12.2 test plan, etc

13. The basics of query processing
13.1 external sorting
13.2 computing projection, union, and set difference, etc

14. Av Overview of Query Optimization
14.1 overview of query processing
14.2 heuristic optimization based on algebraic equivalences, etc

15. An Overview of Transaction Processing
15.1 isolation
15.2 atomicity and durability, etc

Part three
Advanced Topics in Databases

16. Object databases
16.1 shortcoming of the relational data model
16.2 historical developments, etc

17. XML and Web Data
17.1 semi structured data
17.2 overview of XML, etc

18. Distributed Databases
18.1 the application designers
18.2 distributing data among different databases, etc

19. OLAP and Data Mining
19.1 OLAP and Data warehouses-Old and new
19.2 A multidimensional model for OLAP Applications, etc

Part four
Transaction Processing

20. Acid properties of transactions
20.1 consistency
20.2 atomicity, etc

21. Models of Transactions
21.1 flat transactions
21.2 providing structure within a transaction, etc

22. Architecture of Transaction Processing Systems
22.1 transaction processing in a centralised system
22.2 transaction processing of a single-user system, etc

23. Implementing Isolation
23.1 schedules and their equivalence
23.2 recoverability cascaded aborts, and strictness, etc

24. Isolation in Relational Databases
24.1 locking
24.2 locking and the SQL isolation levels, etc

25. Atomicity and Durability
25.1 crash, abort, and media failure
25.2 immediate-update systems and write-ahead logs, etc

26. Implementing Distributed Transactions
26.1 implementing the ACID properties
26.2 atomic termination, etc

27. Security and Internet Commerce
27.1 authentication, authorization, and encryption, etc

References : p. 963-977. _ Index : p. 979-1014