The Structure of the Relational Database Model

1. Front Matter

   Pages I-X

   PDF

2. Relational Database Model

   • Jan Paredaens, Paul De Bra, Marc Gyssens, Dirk Van Gucht

   Pages 1-18

3. Query Systems

   • Jan Paredaens, Paul De Bra, Marc Gyssens, Dirk Van Gucht

   Pages 19-60

4. Constraints

   • Jan Paredaens, Paul De Bra, Marc Gyssens, Dirk Van Gucht

   Pages 61-112

5. Vertical Decompositions

   • Jan Paredaens, Paul De Bra, Marc Gyssens, Dirk Van Gucht

   Pages 113-131

6. Horizontal Decompositions

   • Jan Paredaens, Paul De Bra, Marc Gyssens, Dirk Van Gucht

   Pages 132-155

7. Incomplete Information

   • Jan Paredaens, Paul De Bra, Marc Gyssens, Dirk Van Gucht

   Pages 156-176

8. The Nested Relational Database Model

   • Jan Paredaens, Paul De Bra, Marc Gyssens, Dirk Van Gucht

   Pages 177-201

9. Updates

   • Jan Paredaens, Paul De Bra, Marc Gyssens, Dirk Van Gucht

   Pages 202-219

10. Back Matter

    Pages 220-233

    PDF

This book presents an overview of the most fundamental aspects of the theory that underlies the Relational Database Model. As such it is self-contained though experience with formal models and abstract data manipulating on the one hand and with the practical use of a relational system on the other hand can help the reader. Such experience will offer the reader a better understanding of and a motivation for the different concepts, theories and results mentioned in the book. We have focussed on the most basic concepts and aspects of the relational model, without trying to give a complete overview of the state of the art of database theory. Recently a lot of books on databases in general and on the relational model in particular have been published. Most of them describe the use of database systems. 'Some clarify how information has to be structured and organized before it can be used to build applications. Others help the user in writing down his applications or in finding tricky ways to optimize the running time or the necessary space. Another category of books treat more fundamental and more general aspects such as the description of the relational model, independent of any implementation, the decomposition in normal forms or the global design of distributed databases. Few, however, are the books that describe in a formal way some of the subjects mentioned above.

• Datenbank
• Rationale Datenbank
• SQL
• classification
• database
• database theory
• information
• relational database

• Department of Mathematics and Computer Science, Universiteit Antwerpen, Antwerpen, Belgium

  Jan Paredaens, Paul Bra, Marc Gyssens

• Computer Science Department, Indiana University, Bloomington, USA

  Dirk Gucht

Policies and ethics