Complex Data Types and Object Orientation Structured Data Types and Inheritance in SQL Table Inheritance Array and Multiset Types in SQL Object Identity and Reference Types in SQL Implementing O-R Features Persistent Programming Languages Comparison of Object-Oriented and Object-Relational Databases

Chapter 15: Transactions Transaction Concept Transaction State Implementation of Atomicity and Durability Concurrent Executions Serializability Recoverability Implementation of Isolation Transaction Definition in SQL

Transaction Concept Transaction State Concurrent Executions Serializability Recoverability Implementation of Isolation Transaction Definition in SQL Testing for Serializability

Transaction Concept Transaction State Concurrent Executions Serializability Recoverability Implementation of Isolation Transaction Definition in SQL Testing for Serializability

Basic Concepts Ordered Indices B+-Tree Index Files B-Tree Index Files Static Hashing Dynamic Hashing Comparison of Ordered Indexing and Hashing Index Definition in SQL Multiple-Key Access

Basic Concepts Ordered Indices B+-Tree Index Files B-Tree Index Files Static Hashing Dynamic Hashing Comparison of Ordered Indexing and Hashing Index Definition in SQL Multiple-Key Access

▪ Transaction Concept ▪ Transaction State ▪ Concurrent Executions ▪ Serializability ▪ Recoverability ▪ Implementation of Isolation ▪ Transaction Definition in SQL ▪ Testing for Serializability

User Interfaces and Tools Web Interfaces to Databases Web Fundamentals Servlets and JSP Building Large Web Applications Triggers Authorization in SQL Application Security

1. 什么是SQL？ SQL，翻译成中文就是“结构化查询语言”。其发音是“S-Q-L”，也可以读 作“sequel”。 SQL是一种计算机语言，它是为了从存储在关系数据库中的数据中获得信息 而设计的，即通过SQL可以从大量收集的数据中查找想要的信息。 SQL不同于其他计算机语言，我们使用SQL描述想要的信息类型，然后计算机 会确定出获得它的最好过程，并运行这个过程。这就是所谓的“说明性”计算机 语言，因为它注重的是结果：我们可以详细说明结果的外表特征。计算机允许使 用任意数据处理方法，只要它获得正确结果。 其他计算机语言大部分是“过程性”的，如汇编、Pascal、C、Java等

第15章数据转换 15-1数据转换概 15-2导入数据 15-3导出数据 15-4DTS设计器 SQL Server2000为了支持企事业决策支持中浩瀚数据的处理,提供了令人欣慰的数据转换服务。本章介绍了DTS包、DTS任务、DTS连接和DTS工具,并叙述了 SQL Server中导入数据与导出数据的方法和DTS设计器的运用