Database Systems: A Pragmatic Approach, 3rd edition

This book provides a concise but comprehensive guide to the disciplines of database design, construction, implementation, and management. Based on the authors' professional experience in the software engineering and IT industries before making a career switch to academia, the text stresses sound database design as a necessary precursor to successful development and administration of database systems. The discipline of database systems design and management is discussed within the context of the bigger picture of software engineering. Students are led to understand from the outset of the text that a database is a critical component of a software infrastructure, and that proper database design and management is integral to the success of a software system. Additionally, students are led to appreciate the huge value of a properly designed database to the success of a business enterprise.

The text was written for three target audiences. It is suited for undergraduate students of computer science and related disciplines who are pursuing a course in database systems, graduate students who are pursuing an introductory course to database, and practicing software engineers and information technology (IT) professionals who need a quick reference on database design.

Database Systems: A Pragmatic Approach, 3rd Edition discusses concepts, principles, design, implementation, and management issues related to database systems. Each chapter is organized into brief, reader-friendly, conversational sections with itemization of salient points to be remembered. This pragmatic approach includes adequate treatment of database theory and practice based on strategies that have been tested, proven, and refined over several years. Features of the third edition include:

• Short paragraphs that express the salient aspects of each subject
• Bullet points itemizing important points for easy memorization
• Fully revised and updated diagrams and figures to illustrate concepts to enhance the student's understanding
• Real-world examples
• Original methodologies applicable to database design
• Step-by-step, student-friendly guidelines for solving generic database systems problems
• Opening chapter overviews and concluding chapter summaries
• Discussion of DBMS alternatives such as the Entity-Attributes-Value model, NoSQL databases, database-supporting frameworks, and other burgeoning database technologies
• A chapter with sample assignment questions and case studies

This textbook may be used as a one-semester or two-semester course in database systems, augmented by a DBMS (preferably Oracle). After its usage, students will come away with a firm grasp of the design, development, implementation, and management of a database system.

本書提供了一個簡潔但全面的指南，介紹了數據庫設計、構建、實施和管理的相關學科。作者在轉向學術界之前在軟件工程和IT行業擁有豐富的專業經驗，本書強調良好的數據庫設計是成功開發和管理數據庫系統的必要前提。數據庫系統設計和管理的學科在軟件工程的大背景下進行討論。從本書的一開始，學生就會明白數據庫是軟件基礎設施的關鍵組成部分，正確的數據庫設計和管理對軟件系統的成功至關重要。此外，學生還會意識到正確設計的數據庫對企業的成功具有巨大價值。

本書針對三個目標讀者群體進行了撰寫。它適合計算機科學及相關學科的本科生修讀數據庫系統課程，研究生修讀數據庫入門課程的學生，以及需要快速參考數據庫設計的軟件工程師和信息技術（IT）專業人士。

《數據庫系統：實用方法，第三版》討論了與數據庫系統相關的概念、原則、設計、實施和管理問題。每一章都以簡短、讀者友好的對話式部分組織，列舉了要記住的重點。這種實用方法包括對數據庫理論和實踐的充分處理，基於多年的測試、驗證和改進的策略。第三版的特點包括：

- 簡短的段落表達每個主題的要點
- 簡要列舉重要點以便易於記憶的項目
- 完全修訂和更新的圖表和圖示，以增強學生的理解
- 真實世界的例子
- 適用於數據庫設計的原則
- 逐步、學生友好的解決通用數據庫系統問題的指南
- 開章概述和結章總結
- 討論DBMS的替代方案，如實體-屬性-值模型、NoSQL數據庫、支持數據庫的框架和其他新興數據庫技術
- 一章節有樣本作業問題和案例研究

本教材可用作一學期或兩學期的數據庫系統課程，並配合一個DBMS（最好是Oracle）使用。在使用本書後，學生將對數據庫系統的設計、開發、實施和管理有牢固的掌握。

Elvis C. Foster is a Professor of Computer Science at Keene State College. He holds a Bachelor of Science (BS.) in Computer Science and Electronics, as well as a Doctor of Philosophy (PhD) in Computer Science (specializing in software engineering and database systems) from University of the West Indies, Mona Jamaica. His research interests include the development as well as evaluation of management support systems for contemporary organizations.

Shripad V. Godbole is an independent database administrator and consultant with more than 20 years of experience in diverse business environments, information infrastructure planning, diagnostics, and administration. He is also the Vice President for Technology Management at State Street Global Advisors, Boston. His qualifications include Bachelor of Science (BS) in Physics, Bachelor of Computer Science (BCS), Master of Science (MS) in Physics with specialization in Electronics, all from Poona University in Pune, India. He is also an Oracle Certified Professional Database Administrator (OCPDBA) and holds a Master of Business Administration (MBA) in Technology Management from University of Phoenix.

Elvis C. Foster是Keene State College的計算機科學教授。他擁有西印度大學蒙納分校的計算機科學和電子學學士學位，以及計算機科學博士學位（專攻軟件工程和數據庫系統）。他的研究興趣包括開發和評估現代組織的管理支持系統。

Shripad V. Godbole是一位獨立的數據庫管理員和顧問，擁有20多年在不同商業環境中的經驗，包括信息基礎設施規劃、診斷和管理。他還是波納大學（印度浦那）的物理學學士、計算機科學學士和物理學碩士（專攻電子學）的資格。他還是Oracle認證的專業數據庫管理員（OCPDBA），並擁有鳳凰城大學的技術管理碩士學位。他還擔任波士頓State Street Global Advisors的技術管理副總裁。