Database Systems: A Practical Approach to Design, Implementation and Management, 6/e (IE-Paperback)【內含Access Code,經刮除不受退】

CONNOLLY

  • 出版商: Prentice Hall
  • 出版日期: 2014-07-31
  • 定價: $1,180
  • 售價: 9.5$1,121
  • 語言: 英文
  • 頁數: 1440
  • 裝訂: Paperback
  • ISBN: 1292061189
  • ISBN-13: 9781292061184
  • 相關分類: 資料庫
  • 立即出貨 (庫存=1)

買這商品的人也買了...

商品描述

<內容簡介>

Database design methodologyis explicitly divided into three phases based on the widely accepted Entity—Relationship model: conceptual, logical, and physical. Each phase is described in a separate chapter with an integrated case study of the methodology working in practice.
 •To help the reader use the methodology and understand the important issues, the methodology has been described using a realistic worked example, based on an integrated case study, DreamHome. 
 •Three additional case studies are provided in Appendix B to allow readers to try out the methodology for themselves. 
•The methodology in each phase is presented as a series of steps. For the inexperienced designer, it is expected that the steps will be followed in the order described, and guidelines are provided throughout to help with this process. For the experienced designer, the methodology can be less prescriptive, acting more as a framework or checklist. 
•An easy-to-use, step-by-step methodology for physical database design, covers the mapping of the logical design to a physical implementation, the selection of file organizations and indexes appropriate for the applications, and when to introduce controlled redundancy. The integrated case study shows how to use the methodology. 
•Separate chapters show how database design fits into the overall database systems development lifecycle, how fact-finding techniques can be used to identify the system requirements, and how UML fits into the methodology.

 

<章節目錄>

Part I Background
Chapter 1 Introduction to Databases
Chapter 2 Database Environment
Chapter 3 Database Architectures and the Web
Part 2 The Relational Model and Languages
Chapter 4 The Relational Model
Chapter 5 Relational Algebra and Relational Calculus
Chapter 6 SQL: Data Manipulation
Chapter 7 SQL: Data Definition
Chapter 8 Advanced SQL
Chapter 9 Object-Relational DBMSs
Part 3 Database Analysis and Design
Chapter 10 Database System Development Lifecycle
Chapter 11 Database Analysis and the DreamHome Case Study
Chapter 12 Entity-Relationship Modeling
Chapter 13 Enhanced Entity-Relationship Modeling
Chapter 14 Normalization
Chapter 15 Advanced Normalization
Part 4 Methodology
Chapter 16 Methodology
Conceptual Database Design
Chapter 17 Methodology
Logical Database Design for the Relational Model
Chapter 18 Methodology
Physical Database Design for Relational Databases
Chapter 19 Methodology
Monitoring and Tuning the Operational System
Part 5 Selected Database Issues
Chapter 20 Security and Administration
Chapter 21 Professional, Legal, and Ethical Issues in Data Management
Chapter 22 Transaction Management
Chapter 23 Query Processing
Part 6 Distributed DBMSs and Replication
Chapter 24 Distributed DBMSs
Concepts and Design
Chapter 25 Distributed DBMSs
Advanced Concepts
Chapter 26 Replication and Mobile Databases8
Part 7 Object DBMSs
Chapter 27 Object-Oriented DBMSs
Concepts and Design
Chapter 28 Object-Oriented DBMSs
Standards and Systems
Part 8 The Web and DBMSs
Chapter 29 Web Technology and DBMSs
Chapter 30 Semistructured Data and XML
Part 9 Business Intelligence
Chapter 31 Data Warehousing Concepts
Chapter 32 Data Warehousing Design
Chapter 33 OLAP
Chapter 34 Data Mining
Appendices
A Users' Requirements Specification for DreamHome Case Study
B Other Case Studies
C Alternative ER Modeling Notations
D Summary of the Database Design Methodology for Relational Databases
E Introduction to Pyrrho: A Lightweight RDBMS
F File Organizations and Indexes (Online)
G When Is a DBMS Relational? (Online)
H Commercial DBMSs: Access® and Oracle
®(Online)
I Programmatic SQL (Online)
J Estimating Disk Space Requirements (Online)
K Introduction to Object-Oriented Concepts (Online)
L Example Web Scripts (Online)
M Query-By-Example (QBE) (Online)
N Third Generation Manifestos (Online)
0 Postgres
An Early ORDBMS (Online)

 

商品描述(中文翻譯)

內容簡介:

資料庫設計方法論根據廣泛接受的實體-關係模型,明確分為三個階段:概念、邏輯和物理。每個階段在不同的章節中進行描述,並附有一個整合的案例研究,展示方法論在實踐中的應用。

- 為了幫助讀者使用方法論並理解重要問題,使用一個基於整合案例研究DreamHome的實際工作範例來描述方法論。
- 附錄B提供了三個額外的案例研究,讓讀者自行嘗試使用方法論。
- 每個階段的方法論以一系列步驟呈現。對於沒有經驗的設計師,預期按照描述的順序遵循這些步驟,並提供了指南來幫助這個過程。對於有經驗的設計師,方法論可以更少地作為指導,更像是一個框架或檢查表。
- 一個易於使用的逐步方法論用於物理資料庫設計,包括將邏輯設計映射到物理實現、選擇適用於應用程序的文件組織和索引,以及何時引入受控冗余。整合案例研究展示了如何使用方法論。
- 獨立的章節展示了資料庫設計如何融入整個資料庫系統開發生命週期,如何使用事實查找技術來識別系統需求,以及統一建模語言如何融入方法論。

章節目錄:

第一部分 背景
第1章 資料庫簡介
第2章 資料庫環境
第3章 資料庫架構和網絡

第二部分 關聯模型和語言
第4章 關聯模型
第5章 關聯代數和關聯演算
第6章 SQL:資料操作
第7章 SQL:資料定義
第8章 高級SQL
第9章 物件-關聯資料庫管理系統

第三部分 資料庫分析和設計
第10章 資料庫系統開發生命週期