最 低 价：￥31.90
| 本套教学用书的特点： 权威性——教育部高等教育司推荐、教育部高等学校信息科学与技术引进教材专家组遴选 系统性——覆盖计算机专业主干课程和非计算机专业计算机基础课程 先进性——著名计算机专家近两年的最新著作，内容体系先进 经济性——价格与国内自编教材相当、是国内引进教材价格最低的 |
| 作者Philip M. Lewis、Arthur Bernstein、Michael Kifer均在美国纽约州立大学Stony Brook分校计算机科学系任教。 |
| Preface PART One Introduction 1 Overview of Databases and Transactions 1.1 What Are Databases and Transactions? 1.2 Features of Modern Database and Transaction Processing Systems 1.3 Major Players in the Implementation and Support of Database and Transaction Processing Systems 1.4 Decision Support Systems OLAP and OLTP 1.5 Exercises 2 A Closer Look 2.1 Case Study: A Student Registration System 2.2 IntToduction to Relational Databases 2.3 What Makes a Program a Transaction? 2.4 BibliographicNotes 2.5 Exercises 3 Case Study: Starting the Student Registration System 3.1 Software Engineering Methodology 3.2 Requirements Document 3.3 Requirements Analysis New Issues 3.4 Application Generators 3.5 GUIs and Objects 3.6 Events and Procedures 3.7 Accessing Databases and Executing Transactions 3.8 Specifying the Student Registration System 3.9 Specification Document 3.10 Bibliographic Notes 3.11 Exercises PART Two Database Management 4 The Relational Data Model 4.1 What Is a Data Model? 4.2 The Relational Model 4.3 SQL Data Definition Sublanguage 4.4 Bibliographic Notes 4.5 Exercises 5 Database Design l: The Entity-Relationship Model 5.1 Conceptrial Modeling with the E-R Approach 5.2 Entities and Entity Types 5.3 Relationships and Relationship Types 5.4 Advanced Features of the E-R Approach 5.5 A Brokerage Firm Example 5.6 Limitations of the E-R Approach 5.7 Case Study: A Design for the Student Registration System 5.8 Bibliographic Notes 5.9 Exercises 6 Query Languages l: Relational Algebra and SQL 6.1 Relational Algebra: Under the Hood of SQL 6.2 The Query Sublanguage of SQL 6.3 Modifying Relation Instances in SQL 6.4 Bibliographic Notes 6.5 Exercises 7 Query Languages II: Relational Calculus and Visual Query Languages 7.1 Tuple Relational Calculus 7.2 Understanding SQL through Tuple Relational Calculus 7.3 Domain Relational Calculus and Visual Query Languages 7.4 Visual Query Languages: QBE and PC Databases 7.5 The Relationship between Relational Algebra and the Calculi 7.6 Recursive Queries in SQL:1999 7.7 Bibliographic Notes 7.8 Exercises 8 Database Design II: Relational Normalization Theory 8.1 The Problem of Redundancy 8.2 Decompositions 8.3 Functional Dependencies 8.4 Properties of Functional Dependencies 8.5 Normal Forms 8.6 Properties of Decompositions 8.7 An Algorithm for BCNF Decomposition 8.8 Synthesis of 3NF Schemas 8.9 The Fourth Normal Form 8.10 Advanced 4NF Design 8.11 Sununary of Normal Form Decomposition 8.12 Case Study: Schema Refinement for the Student Registration System 8.13 Tuning Issues: To Decompose or Not to Decompose? 8.14 Bibliographic Notes 8.15 Exercises 9 Triggers and Active Databases 9.1 Semantic Issues in Trigger Handling 9.2 Triggers in SQL:1999 9.3 Avoiding a Chain Reaction 9.4 BibliographicNotes 9.5 Exercises 10 SQL in the Real World 10.1 Executing SQL Statements within an Application Program 10.2 Emtredded SQL 10.3 More on Integrity Constraints 10.4 DynandcSQL 10.5 JDBC and SQLJ 10.6 ODBC 10.7 Comparison 10.8 Bibliographic Notes 10.9 Exercises 11 Physical Data Organization and Indexing 11.1 Disk Organization 11.2 Heap Files 11.3 Sorted Files 11.4 Indices 11.5 Multilevel Indexing 11.6 Hash Indexing 11.7 Special--Purpose Indices 11.8 Tuning Issues: Choosing Indices for an Application 11.9 Bibliographic Notes 11.10 Exercises 12 Case Study: Completing the Student Registration System 12.1 The Design Document 12.2 TestPlan 12.3 Project Planning 12.4 Coding 12.5 Incremental Development 12.6 Design and Code for the Student Registration System 12.7 Bibliographic Notes 12.8 Exercises 1 3 The Basics of Query Processing 13.1 EXternalSorting 13.2 Computing Projection, Union, and Set Difference 13.3 Computing Selection 13.4 Computing Joins 13.5 Multi--RelationalJoins 13.6 Computing Aggregate Functions 13.7 Tuning Issues: Impact on Physical Database Design 13.8 Bibliographic Notes 13.9 Exercises 14 An Overview of Query Optimization 14.1 OVerview of Query Processing 14.2 Heuristic Optimization Based on Algebraic Equivalences 14.3 Estimating the Cost of a Query Execution Plan 14.4 Estimating the Size of the Outout 14.5 Choosing a Plan 14.6 Tuning Issues: Impact on Query Design 14.7 Bibliographic Notes 14.8 Exercises 15 An Overview of Transaction Processing 15.1 Isolation 15.2 Atomicity and Durability 15.3 Implementing Distributed Transactions 15.4 Bibliographic Notes 15.5 Exercises PART Three Advanced Topics in Databases PART Four Transaction Processing |
内容加载中，请稍后...
商品评论（0条）