圖書信息
出版社: 機械工業出版社; 第3版 (2008年8月1日)
平裝: 565頁
正文語種: 英語
開本: 32
ISBN: 7111247337, 9787111247333
條形碼: 9787111247333
尺寸: 20.8 x 14.4 x 2.6 cm
重量: 522 g
作者簡介
作者:(美國)厄爾曼(Jeffrey D. Ullman) (美國)懷德姆(Jennifer Widom)
Jeffrey D.UIIman史丹福大學計算機科學系.Stanford W.Ascherman教授,資料庫技術專家。他獨立或與人合作出版了15本著作,發表了170多篇技術論文。他的研究興趣包括資料庫理論.資料庫集成、數據挖掘和利用信息基礎設施進行教育。他是美國國家工程院成員,曾獲得Knuth獎、SIGMOD貢獻獎、Karlstrom傑出教育家獎和Edgar E Codd發明獎。
內容簡介
《華章圖書·資料庫系統基礎教程(英文版)(第3版)》由美國史丹福大學知名計算機科學家Jeffrey Ullman和Jennifer Widom合作編寫。書中介紹了核心DBMS概念、理論和模型,描述了如何使用抽象語言和SQL查詢與更新DBMS。在介紹了SQL擴展內容(包括嵌入式SQL程式設計和對象關係特徵)後,又介紹了使用XML的系統。設計語言包括XML模式,查詢語言包括XPath和XQuery。
目錄
1 The Worlds of Database Systems
1.1 The Evolution of Database Systems
1.1.1 Early Database Management Systems
1.1.2 Relational Database Systems
1.1.3 Smaller and Smaller Systems
1.1.4 Bigger and Bigger Systems
1.1.5 Information Integration
1.2 overview of a Database Management System
1.2.1 Data-Definition Language Commands
1.2.2 Overview of Query Processing
1.2.3 Storage and Buffer Management
1.2.4 Transaction Processing
1.2.5 The Query Processor
1.3 Outline of Database-System Studies
1.4 References for Chapter 1
2 Relational Database Modeling
2 The Relational Model of Data
2.1 An Overview of Data Models
2.1.1 What is a Data Model?
2.1.2 Important Data Models
2.1.3 The Relational Model in Brief
2.1.4 The Semistructured Model in Brief
2.1.5 Other Data Models
2.1.6 Comparison of Modeling Approaches
2.2 Basics of the Relational Model
2.2.1 Attributes
2.2.2 Schemas
2.2.3 tuples
2.2.4 Domains
2.2.5 Equivalent Representations of a Relation
2.2.6 Relation Instances
2.2.7 Keys of Relations
2.2.8 An Example Database Schema
2.2.9 Exercises for Section 2.2
2.3 Defining a Relation Schema in SQL
2.3.1 Relations in SQL
2.3.2 Data Types
2.3.3 Simple Table Declarations
2.3.4 Modifying Relation Schemas
2.3.5 Default Values
2.3.6 Declaring Keys
2.3.7 Exercises for Section 2.3
2.4 An Algebraic Query Language
2.4.1 Why Do We Need a Special Query Language?
2.4.2 What is an Algebra?
2.4.3 Overview of Relational Algeebra
2.4.4 Set Operations on Relations
2.4.5 Projection
2.4.6 Selection
2.4.7 Cartesian Product
2.4.8 Natural Joins
2.4.9 Theta-Joins
2.4.10 Combining Operations to Form Queries
2.4.11 Naming and Renaming
2.4.12 Relationships Among Operations
2.4.13 A Linear Notation for Algebraic Expressions
2.4.14 Exercises for Section 2.4
2.5 Constraints on Relations
2.5.1 Relational Algebra as a Constraint Language
2.5.2 Referential Integrity Constraints
2.5.3 Key Constraints
2.5.4 Additional Constraint Examples
2.5.5 Exercises for Secticn 2.5
2.6 Summary of Chapter 2
2.7 References for Chapter 2
3 Design Theory for Relational Databases
3.1 Functional Dependencies
3.1.1 Definition of Functional Dependency
3.1.2 Keys of Relations
3.1.3 Superkeys
3.1.4 Exercises for Section 3.1
3.2 Rules About Functional Dependencies
3.2.1 Reasoning About Functional Dependencies
3.2.2 The Splitting/Combining Rule
……
4 High-Level Database Models
5 Algebraic and Logical Query Languages
6 The Database Language SQL
7 Constraints and Triggers
8 Views and Indexes
9 SQL in a Server Environment
10 Advanced Topics in Relational Databases
11 The Semistructured-Data Model
12 Programming Languages for XML
Index