作者：MICHAEL KIFER
页数：666
出版社：高等教育出版社
出版日期：2005
ISBN：9787040178173
电子书格式：pdf/epub/txt
内容简介
本书以计算机和通信技术为代表的信息科学和技术对世界经济、科技、军事、教育和文化等产生的深刻影响，涵盖了许多关于数据库和事务处理应用程序的实用内容。
目录
PrefacePART ONE Introduction1 Overview of Databases and Transactions1.1 What Are Databases and Transactions?
1.2 Features of Modern Database and Transaction Processing Systems1.3 Major Players in the Implementation and Support of Databaseand Transaction Processing Systems1.4 Decision Support Systems——-OLAP and OLTP2 The Big Picture2.1 Case Study：A Student Registration System2.2 Introduction to Relational Databases2.3 What Makes a Program a Transaction——The ACID PropertiesBibliographic NotesExercisesPART Two Database Management3 The RelationaI Data ModeI3.1 What Is a Data Model?
3.2 The Relational Model3.2.1 Basic Concepts3.2.2 Integrity Constraints3.3 SQData Definition Sublanguage3.3.1 Specifying the Relation Type3.3.2 The System Catalog3.3.3 Key Constraints3.3.4 Dealing with Missing Information3.3.5 Semantic Constraints3.3.6 User.Defined Domains3.3.7 Foreign.Key Constraints3.3.8 Reactive Constraints3.3.9 Database Views3.3.10 Modifying Existing Definitions3.3.11 SOL.Schemas3.3.12 Access ControlBibliographic NotesExercises4 Conceptual Modeling of Databases with Entity-Relationship Diagrams and the Unified Modeling Language4.1 Conceptual Modeling with the E-R Approach4.2 Entities and Entity Types4.3 Relationships and Relationship Types4.4 Advanced Features in Conceptual Data Modeling4.4.1 Entity Type Hierarchies4.4.2 Participation Constraints4.4.3 The Part.of Relationship4.5 From E.R Diagrams to Relational Database Schemas4.5.1 Representation of Entities4.5.2 Representation of Relationships4.5.3 Representing IsA Hierarchies in the Relational Model4.5.4 Representation of Participation Constraints4.5.5 Representation of the Part—of Relationship4.6 UML：A New Kid on the Block4.6.1 Representing Entities in UML4.6.2 Representing Relationships in UML4.6.3 Advanced Modeling Concepts in UML4.6.4 Translation to SQL4.7 A Brokerage Firm Example4.7.1 An Entity－Relationship Design4.7.2 A UML Design4.8 Case Study：A Database Design for the Student Registration System4.8.1 The Database Part of the Requirements Document4.8.2 The Database Design4.9 Limitations of Data Modeling MethodologiesBibliographic NotesExercises5 Relational Algebra and SQL5.1 Relational Algebra: Under the Hood of SQL5.1.1 Basic Operators5.1.2 Derived Operators5.2 The Query Sub]ansuage of SQL5.2.1 Simple SQL Queries5.2.2 Set Operations5.2.3 Nested Queries5.2.4 Quantified Predicates5.2.5 Aggregation over Data5.2.6 Join Expressions in the FROM Clause5.2.7 A Simple Query Evaluation Algorithm5.2.8 More on Views in SQL5.2.9 Materialized Views5.2.10 The Null Value Quandary5.3 Modifying Relation Instances in SQL5.3.1 Inserting Data5.3.2 Deleting Data5.3.3 Updating Existing Data5.3.4 Updates on ViewsBibliographic NotesExercises6 Database Design with the Relational Normalization Theory6.1 The Problem of Redundancy6.2 Decompositions6.3 Functional Dependencies6.4 Properties of Functional Dependencies6.5 Normal Forms6.5.1 The Boyce-Codd Normal Form6.5.2 The Third Normal Form6.6 Properties of Decompositions6.6.1 Lossless and Lossy Decompositions6.6.2 Dependency-Preserving Decompositions6.7 An Algorithm for BCNF Decomposition6.8 Synthesis of 3NF Schemas6.8.1 Minimal Cover6.8.2 3NF Decomposition through Schema Synthesis6.8.3 BCNF Decomposition through 3NF Synthesis6.9 The Fourth Normal Form6.10 Advanced 4NF Design6.10.1 MVDs and Their Properties6.10.2 The Difficulty of Designing for 4NF6.10.3 A 4NF Decomposition How-To6.11 Summary of Normal Form Decomposition6.12 Case Study: Schema Refinement for the Student Registration System6.13 Tuning Issues: To Decompose or Not to Decompose?
Bibliographic NotesExercises7 Triggers and Active Databases7.1 What Is a Trigger?
7.2 Semantic Issues in Trigger Handling7.3 Triggers in SQL:19997.4 Avoiding a Chain ReactionBibliographic NotesExercises8 Using SQL in an Application8.1 What Are the Issues Involved?
8.2 Embedded SQL8.2.1 Status Processing8.2.2 Sessions， Connections， and Transactions8.2.3 Executing Transactions8.2.4 Cursors8.2.5 Stored Procedures on the Server8.3 More on Integrity Constraints8.4 Dynamic SQL8.4.1 Statement Preparation in Dynamic SQL8.4.2 Prepared Statements and the Descriptor Area8.4.3 Cursors8.4.4 Stored Procedures on the Server8.5 JDBC and SQLJ8.5.1 JDBC Basics8.5.2 Prepared Statements8.5.3 Result Sets and Cursors8.5.4 Obtaining Information about a Result Set8.5.5 Status ProcessingprocessingPART THREE Optimizing DBMS Performance and Traansaction ProcessingPART FOUR Software Engineering lssues and documentationPART FIVE Advanced topics in databasesBibliographyIndex
1.2 Features of Modern Database and Transaction Processing Systems1.3 Major Players in the Implementation and Support of Databaseand Transaction Processing Systems1.4 Decision Support Systems——-OLAP and OLTP2 The Big Picture2.1 Case Study：A Student Registration System2.2 Introduction to Relational Databases2.3 What Makes a Program a Transaction——The ACID PropertiesBibliographic NotesExercisesPART Two Database Management3 The RelationaI Data ModeI3.1 What Is a Data Model?
3.2 The Relational Model3.2.1 Basic Concepts3.2.2 Integrity Constraints3.3 SQData Definition Sublanguage3.3.1 Specifying the Relation Type3.3.2 The System Catalog3.3.3 Key Constraints3.3.4 Dealing with Missing Information3.3.5 Semantic Constraints3.3.6 User.Defined Domains3.3.7 Foreign.Key Constraints3.3.8 Reactive Constraints3.3.9 Database Views3.3.10 Modifying Existing Definitions3.3.11 SOL.Schemas3.3.12 Access ControlBibliographic NotesExercises4 Conceptual Modeling of Databases with Entity-Relationship Diagrams and the Unified Modeling Language4.1 Conceptual Modeling with the E-R Approach4.2 Entities and Entity Types4.3 Relationships and Relationship Types4.4 Advanced Features in Conceptual Data Modeling4.4.1 Entity Type Hierarchies4.4.2 Participation Constraints4.4.3 The Part.of Relationship4.5 From E.R Diagrams to Relational Database Schemas4.5.1 Representation of Entities4.5.2 Representation of Relationships4.5.3 Representing IsA Hierarchies in the Relational Model4.5.4 Representation of Participation Constraints4.5.5 Representation of the Part—of Relationship4.6 UML：A New Kid on the Block4.6.1 Representing Entities in UML4.6.2 Representing Relationships in UML4.6.3 Advanced Modeling Concepts in UML4.6.4 Translation to SQL4.7 A Brokerage Firm Example4.7.1 An Entity－Relationship Design4.7.2 A UML Design4.8 Case Study：A Database Design for the Student Registration System4.8.1 The Database Part of the Requirements Document4.8.2 The Database Design4.9 Limitations of Data Modeling MethodologiesBibliographic NotesExercises5 Relational Algebra and SQL5.1 Relational Algebra: Under the Hood of SQL5.1.1 Basic Operators5.1.2 Derived Operators5.2 The Query Sub]ansuage of SQL5.2.1 Simple SQL Queries5.2.2 Set Operations5.2.3 Nested Queries5.2.4 Quantified Predicates5.2.5 Aggregation over Data5.2.6 Join Expressions in the FROM Clause5.2.7 A Simple Query Evaluation Algorithm5.2.8 More on Views in SQL5.2.9 Materialized Views5.2.10 The Null Value Quandary5.3 Modifying Relation Instances in SQL5.3.1 Inserting Data5.3.2 Deleting Data5.3.3 Updating Existing Data5.3.4 Updates on ViewsBibliographic NotesExercises6 Database Design with the Relational Normalization Theory6.1 The Problem of Redundancy6.2 Decompositions6.3 Functional Dependencies6.4 Properties of Functional Dependencies6.5 Normal Forms6.5.1 The Boyce-Codd Normal Form6.5.2 The Third Normal Form6.6 Properties of Decompositions6.6.1 Lossless and Lossy Decompositions6.6.2 Dependency-Preserving Decompositions6.7 An Algorithm for BCNF Decomposition6.8 Synthesis of 3NF Schemas6.8.1 Minimal Cover6.8.2 3NF Decomposition through Schema Synthesis6.8.3 BCNF Decomposition through 3NF Synthesis6.9 The Fourth Normal Form6.10 Advanced 4NF Design6.10.1 MVDs and Their Properties6.10.2 The Difficulty of Designing for 4NF6.10.3 A 4NF Decomposition How-To6.11 Summary of Normal Form Decomposition6.12 Case Study: Schema Refinement for the Student Registration System6.13 Tuning Issues: To Decompose or Not to Decompose?
Bibliographic NotesExercises7 Triggers and Active Databases7.1 What Is a Trigger?
7.2 Semantic Issues in Trigger Handling7.3 Triggers in SQL:19997.4 Avoiding a Chain ReactionBibliographic NotesExercises8 Using SQL in an Application8.1 What Are the Issues Involved?
8.2 Embedded SQL8.2.1 Status Processing8.2.2 Sessions， Connections， and Transactions8.2.3 Executing Transactions8.2.4 Cursors8.2.5 Stored Procedures on the Server8.3 More on Integrity Constraints8.4 Dynamic SQL8.4.1 Statement Preparation in Dynamic SQL8.4.2 Prepared Statements and the Descriptor Area8.4.3 Cursors8.4.4 Stored Procedures on the Server8.5 JDBC and SQLJ8.5.1 JDBC Basics8.5.2 Prepared Statements8.5.3 Result Sets and Cursors8.5.4 Obtaining Information about a Result Set8.5.5 Status ProcessingprocessingPART THREE Optimizing DBMS Performance and Traansaction ProcessingPART FOUR Software Engineering lssues and documentationPART FIVE Advanced topics in databasesBibliographyIndex
