注冊(cè) | 登錄讀書(shū)好,好讀書(shū),讀好書(shū)!
讀書(shū)網(wǎng)-DuShu.com
當(dāng)前位置: 首頁(yè)出版圖書(shū)科學(xué)技術(shù)計(jì)算機(jī)/網(wǎng)絡(luò)數(shù)據(jù)庫(kù)數(shù)據(jù)庫(kù)理論數(shù)據(jù)庫(kù)(原理編程與性能影印版)

數(shù)據(jù)庫(kù)(原理編程與性能影印版)

數(shù)據(jù)庫(kù)(原理編程與性能影印版)

定 價(jià):¥49.50

作 者: (美)奧尼爾著
出版社: 高等教育出版社
叢編項(xiàng): 國(guó)外優(yōu)秀信息科學(xué)與技術(shù)系列教學(xué)用書(shū)
標(biāo) 簽: 數(shù)據(jù)庫(kù)理論 數(shù)據(jù)庫(kù) 計(jì)算機(jī)/網(wǎng)絡(luò)

ISBN: 9787040100402 出版時(shí)間: 2001-05-01 包裝: 平裝
開(kāi)本: 16開(kāi) 頁(yè)數(shù): 870 字?jǐn)?shù):  

內(nèi)容簡(jiǎn)介

  《數(shù)據(jù)庫(kù):原理編程與性能(影印版)(第2版)》自1994年初版以來(lái),已成為學(xué)習(xí)、設(shè)計(jì)及使用關(guān)系數(shù)據(jù)庫(kù)人員的一本經(jīng)典教材。它從理論和實(shí)踐兩方面對(duì)數(shù)據(jù)庫(kù)設(shè)計(jì)和編程均做了嚴(yán)謹(jǐn)?shù)谋硎觥F鋬?nèi)容包括關(guān)系理論、數(shù)據(jù)庫(kù)設(shè)計(jì)、數(shù)據(jù)庫(kù)編程及運(yùn)行-轉(zhuǎn)儲(chǔ)結(jié)果。每一部分均從基本原理出發(fā),再用實(shí)際系統(tǒng)中的實(shí)例來(lái)說(shuō)明。本次修訂版反映了6年來(lái)數(shù)據(jù)庫(kù)領(lǐng)域總體的進(jìn)步和發(fā)展動(dòng)態(tài),書(shū)中重點(diǎn)講述了對(duì)象關(guān)系模型;介紹了一些系統(tǒng)(如Oracle、DB2和Informix等)中通用的新概念;對(duì)隔離技術(shù)作了更新介紹;對(duì)運(yùn)行結(jié)果的表述更現(xiàn)代。相對(duì)于初始標(biāo)準(zhǔn)來(lái)說(shuō),SQL數(shù)據(jù)庫(kù)語(yǔ)言有了非常重要的變化,所以對(duì)對(duì)象關(guān)系給予特別講述。《數(shù)據(jù)庫(kù):原理編程與性能(影印版)(第2版)》還介紹了SQL-99設(shè)計(jì)方法及與之相關(guān)的原理方法及主要產(chǎn)品?!稊?shù)據(jù)庫(kù):原理編程與性能(影印版)(第2版)》的作者是在數(shù)據(jù)庫(kù)界工作30多年的資深專家,富于教學(xué)和實(shí)踐經(jīng)驗(yàn)?!稊?shù)據(jù)庫(kù):原理編程與性能(影印版)(第2版)》力圖在數(shù)據(jù)庫(kù)領(lǐng)域各不相同的思想和趨勢(shì)中找到一個(gè)統(tǒng)一的觀點(diǎn)提供給讀者?!稊?shù)據(jù)庫(kù):原理編程與性能(影印版)(第2版)》對(duì)于初接觸數(shù)據(jù)庫(kù)系統(tǒng)的讀者不啻為一本極好的教材;對(duì)于那些對(duì)數(shù)據(jù)庫(kù)領(lǐng)域的發(fā)展還未給予足夠關(guān)注的人是一本易于接受的參考書(shū);同時(shí)也是設(shè)計(jì)人員和編程人員及時(shí)更新知識(shí)的有用的參考書(shū)。內(nèi)容: 1. 簡(jiǎn)介 2. 關(guān)系模型 3. 基本SQL查詢語(yǔ)言 4. 對(duì)象關(guān)系SQL 5. 數(shù)據(jù)庫(kù)編程訪問(wèn) 6. 數(shù)據(jù)庫(kù)設(shè)計(jì) 7. 完整性、視圖、安全性和目錄 8. 索引 9. 查詢處理 10. 事務(wù)更新 11. 并行與分布式數(shù)據(jù)庫(kù) 附錄A 介紹性指南 附錄B 編程細(xì)節(jié) 附錄C SQL語(yǔ)句語(yǔ)言 附錄 D 設(shè)置查詢計(jì)數(shù)。

作者簡(jiǎn)介

  Parick ONeil is a professor of computer science at the Uniersity of Massachusetts at Boston. He is responsible for a number of important results in transactonal performance and disk access algorithms,and he holds patents for his work in these and other database areas.Elizabeth ONeil is a professor of computer science at the University of Massachusetts at Boston.She serves as a comsult-ant to Sybase IQin Concor, Massachusetts,and has worked with a number of other corporations,includin Microsoft adn Bolt,Beranek,and Newman.

圖書(shū)目錄

Contents:
Foreword
Preface
Chapter 1 Introduction
1.1 Fundamental Database Concepts
  History of Database Systems
  The Relational and Object-Relational Models
  The Database Systems Covered
  A Relational Database Example
  An Object-Relational Database Example
1.2 Database Users
1.3 Overview of Relational and Object-Relational DBMS
  Chapter 2: The Relational Model
  Chapter 3: Basic SQL Query Language
  Chapter 4: The Object-Relational Model
  Chapter 5: Programs to Access a Database
  Chapter 6: Database Design
  Chapter 7: Integrity, Views, Security, and Catalogs
  Chapter 8: Indexing
  Chapter 9: Query Processing
  Chapter 10: Update Transactions
  Chapter 11: Parallel and Distributed Databases
1.4 Putting It All Together
Chapter 2 The Relational Model
2.1 The CAP Database
2.2 Naming the Parts of a Database
  Domains and Datatypes
  Tables and Relations
2.3 Relational Rules
2.4 Keys, Superkeys, and Null Values
  Null Values
2.5 Relational algebra
  Fundamental Operations of Relational Algebra
2.6 Set-Theoretic Operations
  The Union, Intersection, and Difference Operations
  Assignment and Alias
  The Product Operation
2.7 Native Relational Operations
  The Projection Operation
  The Selection Operation
  Precedence of Relational Operations
  The Join Operation
  The Division Operation
2.8 The Interdependence of Operations
2.9 Illustrative Examples
2.10 Other Relational Operations
  Outer Join
  Theta Join
Chapter 3 Basic SQL Query Language
3.1 Introduction
  SQL Capabilities
  SQL History-Standards and Dialects
3.2 Setting Up the Database
  Standard Typographical Conventions
  A Practical Exercise
3.3 Simple Select Statements
3.4 Subqueries
  The IN Predicate
  The Quantified Comparison Predicate
  The EXISTS Predicate
  A Weakness of SQL: Too Many Equivalent Forms
3.5 UNION Operators and FOR ALL Conditions
  The UNION Operator
  Division: SQL "FOR ALL..." Conditions
3.6 Some Advanced SQL Syntax
  The INTERSECT and EXCEPT Operators in Advanced SQL
  Join Forms in Advanced SQL
  OUTER JOIN
  Join Forms Implemented in Database Systems
3.7 Set Functions in SQL Handling Null Values
3.8 Groups of Rows in SQL
3.9 A Complete Dexcription of SQL Select
  Identifiers
  Expressions, Predicates, and the search_condition
  Scalar Subqueries as Expressions:Advanced SQL
  Basic SQL versus Advanced SQL: Summary
  A Discussion of the Predicates
3.10 Insert, Update, and Delete Statements
  The Insert Statement
  The Update Statement
  The Delete Statement
3.11 The Power of the Select Statement
  The Non-Procedural Select Statement
  Turing Power
  Limited Power of the Basic SQL Select Statement
Chapter 4 Object-Relational SQL
4.1 Introduction
  ORSQL Capabilities
  Form of Presentation for This Chapter
  Object-Relational History
4.2 Objects and Tables
  4.2.1 Object Types in ORACLE
    Definition of the REF Object Reference
  4.2.2 INFORMIX Row Types for Objects
    Absence of Refs in INFORMIX
    Type Inheritance in INFORMIX
  4.2.3 Objects and Tables: Summary
    Object Orientation
4.3 Collection Types
  4.3.1 Collection Types in ORACLE
    Table Types and Nested Tables
    Two Techniques for Retrieving from a Table of Tables
    Unnesting via Table Products
    Nested Cursors
    Array Types for VARRAYs
    SQL SYntax for Collections in ORACLE
    Inserts and Updates in ORACLE
  4.3.2 Collection Types in INFORMIX
    Sets in INFORMIX
    Lists in INFORMIX
    SQL Syntax for Collections in INFORMIX
    inserts and Updates in INFORMIX
  4.3.3 Collection Types:Summary
4.4 Procedural SQL, User-Defined Functions (UDFs), and Methods
  4.4.1 ORACLE PL/SQL Procedures, UDFs, and Methods
    PL/SQL: ORACLE's Procedural SQL Language
    Using PL/LQL to Implement Methods in ORACLE
    Update Methods
  4.4.2 INFORMIX User-Defined Functions
    SPL:INFORMIX's Procedural SQL Language
    Using SPL to Implement UDFs in INFORMIX
    Update Functions
  4.4.3 User-Defined Functions:Summary
4.5 External Functions and Packaged User-Defined Types(UDTs)
  Binary Data and BLOBs
  External Functions
  Encapsulation
  Distinct Types
  BLOB Objects
  Packaged UDTs and Other Encapsulated UDTs
  Summary
Chapter 5 Programs to Access a Database
5.1 Introduction to Embedded SQL in C
  A Simple Program Using Embedded SQL
  Selecting Multiple Rows with a Cursor
5.2 Condition Handling
  Whenever Statement:Scope and Flow of Control
  Explicit Error Checking
  Handling Errors:Getting Error Messages from the Database
  Indicator Variables
5.3 Some Common Embedded SQL Statements
  The Select Statement
  The Declare Cursor Statement
  The Delete
  Statement
  The Update Statement
  The Insert Statement
  Cursor Open, Fetch, and Close
  Other Embedded SQL Operations
5.4 Programming for Transactions
  The Concept of a Transaction
  How Transactions Are Specified in Programs
  A Transaction Example
  The Transaction Isolation Guarantee and Locking
  Special Considerations in Transactions
5.5 The Power of Procedural SQL Programs
  Customized Set Functions
5.6 Dynamic SQL
  Execute Immediate
  Prepare, Execute, and Using
  Dynamic Select: The Describe Statement and the SQLDA
5.7 Some Advanced Programming Concepts
  Scrollable Cursors
  Cursor Sensitivity
  Other Development Environments for Database Programming
Chapter 6 Database Design
6.1 Introduction to E-R Concepts
  Entities, Attributes, and Simple E-R Diagrams
  Transforming Entities and Attributes to Relations
  Relationships among Entities
6.2 Further Details of E-R Modeling
  Cardinality of Entity Participation in a Relationship
  One-to-One, Many-to-Many, and Many-to-One Relationships
  Transforming Binary Relationships to Relations
6.3 Additional E-R Concepts
  Cardinality of Attributes
  Weak Entities
  Generalization Hierarchies
6.4 Case Study
6.5 Normalization: Preliminaries
  A Running Example: Employee Information
  Anomalies of a Bad Database Design
6.6 Functional Dependencies
  Logical Implications among Functional Dependencies
  Armstrong's Axioms
  Closure, Cover, and Minimal Cover
6.7 Lossless Decompositions
6.8 Normal Forms
  A Succession of Decompositions to Eliminate Anomalies
  Normal Forms: BCNE 3NF, and 2NF
  An Algorithm to Achieve Well-Behaved 3NF Decomposition
  A Review of Normalization
6.9 Additional Design Considerations
  Database Design Tools
Chapter 7 Integrity, Views, Security, and Catalogs
7.1 Integrity Constraints
  Integrity Constraints in the Create Table Statement
  Primary Keys, Foreign Keys, and Referential Integrity
  Foreign Key Constraints: Product Variations
  The Alter Table Statement
  Non-Procedural and Procedural Integrity Constraints: Triggers
7.2 Creating Views
  Updatable and Read-Only Views
  The Value of Views
7.3 Security:The Grant Statement in SQL
  Variations in Database Products
7.4 System Catalogs and Schemas
  Schemas
  Catalog Variations in Database Products
  The INFORMIX System Catalog
  Catalog Tables for Object-Relational Constructs:ORACLE and INFORMIX
Chapter 8 Indexing
8.1 The Concept of Indexing
8.2 Disk Storage
  Disk Access Is Excruciatingly Slow
  The DBA and Disk Resource Allocation in ORACLE
  Data Storage Pages and Row Pointers:ORACLE and DB2 UDB
8.3 The B-Tree Index
  Dynamic Changes in the B-Tree
  Properties of the B-Tree
  Index Node Layout and Free Space
  The Create Index Statement in ORACLE and DB2 UDB
  Duplicate Key Values in an Index
  The ORACLE Bitmap Index
8.4 Clustered and Non-Clustered Indexes
  Clustering Indexes in DB2 UDB
  ORACLE Special Indexing Features
8.5 A Hash Primary Index
  Tuning HASHKEYS and SIZE in a Hash Cluster
  No Incremental Changes in the Number of Slots Used
  Advantages and Disadvantages of a hash Primary Index
8.6 Throwing Darts at Random Slots
  Unlimited Slot Occupancy:How Many Slots Are Occupied?
  Slot Occupancy of One:Number of Retries (Rehash Chain)
  When Do Hash Pages Fill Up
Chapter 9 Query Processing
9.1 Introductory Concepts
  Query Resource Utilization
  Gathering Statistics
  Retrieving the Query Plan
9.2 Tablespace Scans and I/O
  Assumptions about I/O
9.3 Simple Indexed Access in DB2
  Equal Unique Match Index Access
  Index-Only Retrieval
9.4 Filter Factors and Statistics
  DB2 Statistics
  Filter Factors in DB2
9.5 Matching Index Scans, Composite Indexes
  Definition of a Matching Index Scan
  Predicate Screening and Screening Predicates
  Indexable Predicates and Performance
9.6 Multiple Index Access
  List Prefetch and the RID Pool
  Point of Diminishing Returns in Multiple Index Access
9.7 Methods for Joining Tables
  Nested-Loop Join
  Merge Join
  Hybrid Join
  Multiple Table Joins
  Transforming Nested Queries to Joins
9.8 Disk Sorts
  The N-Way Merge Disk Sort Algorithm
9.9 Query Performance Benchmarks:A Case Study
  The BENCH Table
  Load Measurements
9.10 Query Performance Measurements
  Query Q1
  Query Q2A
  Query Q2B
  Query Q3A
  Query Q3B
  Query Q4A and Q4B
  Query Q5
  Query Q6A
  Query Q6B
9.11 Cost-Performance Assessment
  Elapsed Time versus CPU Time Rating
  Customizing the Rating
  Varations in Indexing Use between DB2 and ORACLE
Chapter 10 Update Transactions
10.1 Transactional Histories
  Fundamental Atomic Read and Write Actions in the Database
  Predicate Read Actions
  Transactional Histories with Reads and Writes
10.2 Interleaved Read-Write Operations
10.3 Serializability and the Precedence Graph
  The Precedence Graph
10.4 Locking to Ensure Serializability
  The Waits-For Graph
10.5 Levels of Isolation
  The Read Uncommitted Isolation Level
  The Read Committed Isolation Level and Cursor Stability
  Repeatable Read Isolation Level
  Serializability and Phantom Updates
10.6 Transactional Recovery
10.7 Recovery in Detail:Log Formats
  Guarantees That N

本目錄推薦

掃描二維碼
Copyright ? 讀書(shū)網(wǎng) m.ranfinancial.com 2005-2020, All Rights Reserved.
鄂ICP備15019699號(hào) 鄂公網(wǎng)安備 42010302001612號(hào)