Database Design and Implementation, 2/e (Paperback)

Sciore, Edward

  • 出版商: Springer
  • 出版日期: 2020-02-28
  • 售價: $2,450
  • 貴賓價: 9.5$2,328
  • 語言: 英文
  • 頁數: 458
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 3030338355
  • ISBN-13: 9783030338350
  • 相關分類: 資料庫
  • 立即出貨 (庫存 < 3)

商品描述

This textbook examines database systems from the viewpoint of a software developer. This perspective makes it possible to investigate why database systems are the way they are. It is of course important to be able to write queries, but it is equally important to know how they are processed. We e.g. don’t want to just use JDBC; we also want to know why the API contains the classes and methods that it does. We need a sense of how hard is it to write a disk cache or logging facility. And what exactly is a database driver, anyway?
The first two chapters provide a brief overview of database systems and their use. Chapter 1 discusses the purpose and features of a database system and introduces the Derby and SimpleDB systems. Chapter 2 explains how to write a database application using Java. It presents the basics of JDBC, which is the fundamental API for Java programs that interact with a database. In turn, Chapters 3-11 examine the internals of a typical database engine. Each chapter covers a different database component, starting with the lowest level of abstraction (the disk and file manager) and ending with the highest (the JDBC client interface); further, the respective chapter explains the main issues concerning the component, and considers possible design decisions. As a result, the reader can see exactly what services each component provides and how it interacts with the other components in the system. By the end of this part, s/he will have witnessed the gradual development of a simple but completely functional system. The remaining four chapters then focus on efficient query processing, and focus on the sophisticated techniques and algorithms that can replace the simple design choices described earlier. Topics include indexing, sorting, intelligent buffer usage, and query optimization.
This text is intended for upper-level undergraduate or beginning graduate courses in Computer Science. It assumes that the reader is comfortable with basic Java programming; advanced Java concepts (such as RMI and JDBC) are fully explained in the text. The respective chapters are complemented by “end-of-chapter readings” that discuss interesting ideas and research directions that went unmentioned in the text, and provide references to relevant web pages, research articles, reference manuals, and books. Conceptual and programming exercises are also included at the end of each chapter.  Students can apply their conceptual knowledge by examining the SimpleDB (a simple but fully functional database system created by the author and provided online) code and modifying it.

商品描述(中文翻譯)

本教科書從軟體開發者的角度探討資料庫系統。這種觀點使我們能夠研究為什麼資料庫系統會是現在的樣子。當然,能夠撰寫查詢是重要的,但了解查詢如何處理同樣重要。我們不僅僅想使用JDBC,還想知道為什麼API包含了特定的類和方法。我們需要了解撰寫磁碟快取或日誌記錄設施有多困難。那麼,資料庫驅動程式到底是什麼呢?

前兩章簡要介紹了資料庫系統及其使用。第一章討論了資料庫系統的目的和特點,並介紹了Derby和SimpleDB系統。第二章解釋了如何使用Java撰寫資料庫應用程式。它介紹了JDBC的基礎知識,JDBC是Java程式與資料庫互動的基本API。接下來,第3至11章探討了典型資料庫引擎的內部結構。每一章都涵蓋了不同的資料庫組件,從最低層次的抽象(磁碟和檔案管理器)到最高層次(JDBC客戶端介面)。此外,各章還解釋了有關組件的主要問題,並考慮了可能的設計決策。因此,讀者可以清楚地看到每個組件提供了哪些服務,以及它如何與系統中的其他組件互動。在這部分結束時,讀者將見證一個簡單但完全功能的系統的逐步發展。接下來的四章專注於高效的查詢處理,並介紹了可以替代前面所描述的簡單設計選擇的複雜技術和演算法。主題包括索引、排序、智能緩衝區使用和查詢優化。

本教材適用於計算機科學的高年級本科生或初級研究生課程。它假設讀者對基本的Java編程感到舒適;高級Java概念(如RMI和JDBC)在教材中有詳細解釋。各章還配有“章末閱讀”,討論了教材中未提及的有趣想法和研究方向,並提供相關網頁、研究文章、參考手冊和書籍的參考資料。每章末尾還包含概念和編程練習。學生可以通過檢查作者提供的SimpleDB(一個簡單但完全功能的資料庫系統)代碼並對其進行修改來應用他們的概念知識。

作者簡介

Edward Sciore is a recently retired Associate Professor at the Computer Science Department, Boston College. He is the author of numerous research articles on database systems, which span both theory and practice. His favorite activity, however, is to teach database courses to captive students. These teaching experiences, accumulated over a 35-year period, are what led to the writing of this text.

作者簡介(中文翻譯)

Edward Sciore是波士頓學院計算機科學系的最近退休副教授。他是關於資料庫系統的許多研究文章的作者,涵蓋了理論和實踐兩方面。然而,他最喜歡的活動是教授資料庫課程給學生們。這些教學經驗是在35年的時間裡累積起來的,也是寫作這本書的原因。