數(shù)據(jù)庫系統(tǒng)基礎(chǔ)教程

內(nèi)容概要

本書由美國斯坦福大學(xué)知名計(jì)算機(jī)科學(xué)家Jeffrey Ullman和Jennifer Widom合作編寫。書中介紹了核心DBMS概念、理論和模型，描述了如何使用抽象語言和SQL查詢與更新DBMS。在介紹了SQL擴(kuò)展內(nèi)容（包括嵌入式SQL程序設(shè)計(jì)和對(duì)象關(guān)系特征）后，又介紹了使用XML的系統(tǒng)。設(shè)計(jì)語言包括XML模式，查詢語言包括XPath和XQuery。

作者簡介

Jeffrey D．UIIman斯坦福大學(xué)計(jì)算機(jī)科學(xué)系．Stanford W．Ascherman教授，數(shù)據(jù)庫技術(shù)專家。他獨(dú)立或與人合作出版了15本著作，發(fā)表了170多篇技術(shù)論文。他的研究興趣包括數(shù)據(jù)庫理論．?dāng)?shù)據(jù)庫集成、數(shù)據(jù)挖掘和利用信息基礎(chǔ)設(shè)施進(jìn)行教育。他是美國國家工程院成員，曾獲得Knuth

書籍目錄

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Ⅰ  Relational Database Modeling2  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 23  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 Models5  Algebraic and Logical Query Languages6  The Database Language SQL7  Constraints and Triggers8  Views and Indexes9  SQL in a Server Environment10  Advanced Topics in Relational Databases11  The Semistructured-Data Model12  Programming Languages for XMLIndex

章節(jié)摘錄

4.6.3Using Null Values to Combine RelationsThere is one more approach to representing information ab out a hier ar chy ofentity sets.If we axe allowed to use NULL（the null value aS in SQL）as avalue in t uples，we can h andle a hier archy of entity sets with a single relationThis relation has all the att rib utes b elonging to any entity set of the hierarchy.An entity is then represented by a single tup le.This tuple has NuLL in eachattribute that is not defined for that entity.Example 4.33：If we applied this approach to the diagram of Fig.4.3 1，wewould create a single relation whose schema iS：Movie（title，year，length，genre，weapon）Those movies t hat are not mur der mysteries would have NULL in the weapon comp onent of their tuple.It would also be necessary to have a relation Voicesto connect those movies that are cartoons to t he starts performing the voices，as in Example.

編輯推薦

《華章圖書·數(shù)據(jù)庫系統(tǒng)基礎(chǔ)教程(英文版)(第3版)》由機(jī)械工業(yè)出版社出版。

圖書封面

圖書標(biāo)簽Tags

無

評(píng)論、評(píng)分、閱讀與下載

---

    數(shù)據(jù)庫系統(tǒng)基礎(chǔ)教程 PDF格式下載

---