Agenda SQL Server Overview SQL Server Architecture Storage and Access Methods Query Processing and Optimization Iransaction Processing Other Topics

应用程序1 应用程序2 应用程序N

《数据库原理》第4章(图3)

一、影响事务ACID特性的因素: 二、强行中止事务 三、并发事务的交叉执行 6.1恢复引论

7.1并发控制概述 7.2封锁 7.3封锁协议 7.4活锁和死锁 7.5并发调度的可串行性 76两段锁协议 7.7封锁的粒度 7.8 Oracle的并发控制 7.9小结

4.1关系系统 一、关系系统的定义 二、关系系统的分类 三、全关系系统12条准则

Chapter 2: Entity-Relationship Model Basic Concepts Constraints Keys Design Issues E-R Diagram Weak Entity Sets Extended E-R Features Design of an E-R Database Schema Reduction of an E-R Schema to Tables

Chapter 4: SQL Background Basic Structure Set Operations Aggregate Functions Null Values Nested Subqueries Derived Relations Views Modification of the Database Joined Relations

Chapter 7: Relational Database Design First Normal Form Pitfalls in Relational Database Design Functional Dependencies Decomposition Boyce-Codd Normal Form Third Normal Form Multivalued Dependencies and Fourth Normal Form

设计一个数据库应用系统需要经历六个阶段: 需求分析 概念设计 逻辑结构设计 物理设计 实施 运行维护 设计过程中往往还会有许多反复