Database : principles, programming, performance

Content: Front Matter, Page i Copyright, Page ii Preface, Pages ix-xiv 1 - Introduction, Pages 1-24 2 - The Relational Model, Pages 25-87 3 - Query Language SQL, Pages 89-200 4 - Programs to Access a Database, Pages 201-291 5 - Database Design, Pages 293-384 6 - Integrity, Views, Security, and Catalogs, Pages 385-443 7 - Indexing, Pages 445-518 8 - Query Processing, Pages 519-644 9 - Update Transactions, Pages 645-726 10 - Parallel and Distributed Databases, Pages 727-753 A - Introductory Tutorial, Pages 755-772 B - Statement Syntax, Pages 773-811 C - Set Query Counts, Pages 813-815 Solutions to Selected Exercises, Pages 817-859 Index, Pages 860-873 The Morgan Kaufmann Series in Data Management Systems, Page ibc1 Database: Principles Programming Performance provides an introduction to the fundamental principles of database systems. This book focuses on database programming and the relationships between principles, programming, and performance. Organized into 10 chapters, this book begins with an overview of database design principles and presents a comprehensive introduction to the concepts used by a DBA. This text then provides grounding in many abstract concepts of the relational model. Other chapters introduce SQL, describing its capabilities and covering the statements and functions of the programming language. This book provides as well an introduction to Embedded SQL and Dynamic SQL that is sufficiently detailed to enable students to immediately start writing database programs. The final chapter deals with some of the motivations for database systems spanning multiple CPUs, including client-server and distributed transactions. This book is a valuable resource for database administrators, application programmers, specialist users, and end users. An introduction to database management systems for anyone who is, or wishes to become, a database administrator, application programmer, or sophisticated SQL user. Starting with fundamental relational concepts, the author presents a full range of information about database standards and products.