Fundamentals of database systems / Ramez Elmasri, Shamkant B. Navathe.

Contents

Part 1
Introduction and conceptual modelling

chapter 1 Databases and database users
1.1 introduction
1.2 an example
1.3 characteristics of database approach, etc

chapter 2 Database system concept and Architecture
2.1 data models, schemas, and instances
2.2 three-schema architecture and data independence
2.3 database languages and interfaces, etc

chapter 3. Data Modelling Using the Entity-Relationship Model
3.1 using high conceptual data models for database design
3.2 an example database application
3.3 entity types, entity sets, attributes and keys, etc

chapter 4 The Enhanced Entity -Relationship (EER) Model
4.1 subclasses, super classes, and inheritance
4.2 specialization and generalization
4.3 constraints and characteristics of specialization, etc

Part 2
Relational model: Concepts, constraints, languages, design, and programming

chapter 5 The relational data model and relational database constraints
5.1 relational model concepts
5.2 relational model constraints and relational database schemas
5.3 update operations, transactions and dealing with constraint violation, etc

chapter 6 The relational algebra and relational calculus
6.1 Unary relational operations: SELECT and PROJECT
6.2 relational algebra operations from set theory
6.3 binary relational operations: JOIN and DIVISION, etc

chapter 7 Relational Database Design by ER-and EER-to Relational Mapping
7.1 relational database design using ER-realtional mapping
7.2 mapping EER model constructs to relations
7.3 summery

chapter 8 SQL-99: Schema Definition Constraits Queries, and Views
8.1 SQL data definition and data types
8.2 specifying constraints in SQL
8.3 schema change statements in SQL, etc

chapter 9 Introduction to SQL programming techniques
9.1 database programming: Issues and techniques
9.2 embedded SQL, Dynamics SQL and SQLJ
9.3 database programming with function calls : SQL/ CLI and JDBC, etc

Part 3
Database design theory and methodology

chapter 10 Functional Dependencies and Normalization for Relational Databases
10.1 informal design guidelines foe relation schemas
10.2 functional dependencies
10.3 normal forms based on primary keys, etc

chapter 11 Relational database design algorithms and Dependencies
11.1 properties of relational decompositions
11.2 Algorithms for relational database schema design
11.3 multivated dependencies and fourth normal form, etc

chapter 12 Practical Database Design Methodology and use of UML Diagrams
12.1 the role of information systems a in organisation
12.2 the database design and implementation processes
12.3 use of UML diagrams As an Aid to database, etc

Part 4
Data Storage, Indexing, Query Processing, and Physical Design

chapter 13 Disk storage, basic file structures, and hashing
13.1 introduction
13.2 secondary storage devices
13.3 buffering of blocks, etc

chapter 14 Indexing structures for Files
14.1 types of single-level ordered indexes
14.2 multilevel indexes
14.3 dynamic multilevel indexes using B-Trees and B+-Trees, etc

chapter 15 Algorithms for Query Processing and Optimization
15.1 translating SQL Queries into relational algebra
15.2 algorithms for external sorting
15.3 algorithms for SELECT and JOIUN operations, etc

chapter 16 Physical databases design and tuning
16.1 physical database design in relational databases
16.2 an overview of database tuning in relational systems
16.3 summery, etc

Part 5
Transaction Processing Concepts

chapter 17 Introduction to transaction processing process and theory
17.1 introduction to transactional processing
17.2 transactional and system concepts
17.3 desirable properties of transaction, etc

chapter 18 Concurrency Control Techniques
18.1 two-phase ;locking techniques for concurrency control
18.2 concurrency control based on time stop ordering
18.3 multiversion concurrency control techniques, etc

chapter 19 Database Recovery Techniques
19.1 recovery concepts
19.2 recovery techniques based on deferred update
19.3 recovery techniques based on immediate update, etc


Part 6
Object and Object-Relational Databases

chapter 20 Concepts for object databases
21.1 overview of object oriented concepts
20.2 object identity, object structure, and and type constructors
20.3 encapsulation of operations, methods, and persistence, etc

chapter 21 Object Databases Standards, Languages, and Design
21.1 overview of object model of ODMG
21.2 the object definition language ODL
21.3 overview of the C++ language binding, etc

chapter 22 Object-Relational and Extended-Relational systems
22.1 overview of SQL and its object-relational features
22.2 evolution of data models and current trends of database technology
22.3 the Informix universal server, etc

Part 7
Further Topic: Security, Advanced Modelling, and Distribution

chapter 23 Database security
23.1 introduction to database security
23.2 discretionary Access control based on granting and revoking privileges, etc

chapter 24 Enhanced Data Models for Advanced Applications
24.1 active database concepts and triggers
24.2 temporal database concepts
24.3 spatial and multimedia databases, etc

chapter 25 Distributed Databases and Client-Server Architecture
25.1 distributed database concepts
25.2 data fragmentation, replication, and Allocation techniques for distributed database design
25.3 types of distributed database design, etc

Part 8
Emerging Technologies

chapter 26 Web database programming using PHP
26.1 structured, semi structured, and un-structured data
26.2 a simple PHP example
26.3 overview of basic features of PHP, etc

chapter 27 XML: Extensible Mark-up Language
27.1 XML hierarchical data model
27.2 XML documents, DTD and XML schema, etc

chapter 28 Data mining concepts
28.1 overview of data mining technology
28.2 association rules
28.3 classification, etc

chapter 29 Overview of data warehousing and OLAP
29.1 introduction, definitions and technology
29.2 characteristics of data warehouse
29.3 data modelling for data warehouses. etc

chapter 30 Emerging Database Technologies and Applications
30.1 Mobile databases
30.2 multimedia databases
30.3 geographical information systems, etc.

Bibliographic references : p.1051-1079 . _ Index : p.1081-1123

"This book introduces the fundamental concepts necessary for designing, using, and implementing database systems and database applications. Our presentation stresses the fundamentals of database modeling and design, the languages and models provided by the database management systems, and database system implementation techniques"--Page vii.