Database

Principles Programming Performance

Patrick O'Neil

• Editorial: Morgan Kaufmann
• Año: 2014
• ISBN:
  9781483184043
• Categoría: Computer Science
• Categoría: Databases

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.

Índice

• Front Cover
• Database: Principles Programming Performance
• Copyright Page
• Table of Contents
• Preface
• Chapter 1. Introduction
• Chapter 2. The Relational Model
• Chapter 3. Query Language SQL
• Chapter 4. Programs to Access a Database
• Chapter 5. Database Design
• Chapter 6. Integrity, Views, Security, and Catalogs
• Chapter 7. Indexing
• Chapter 8. Query Processing
• Chapter 9. Update Transactions
• Chapter 10. Parallel and Distributed Databases
• Appendix A: Introductory Tutorial
• Appendix B: Statement Syntax
• Appendix C: Set Query Counts
• Solutions to Selected Exercises
• Index