数据库系统原理(英文)-0--courseintroduction-16讲解.ppt

Contents of Class Teaching(cont.) 4. CASE STUDIES PART9(Chapter26-29) PostgreSQL, SQL Server, Oracle, DB2 Contents of Class Teaching(cont.) Relations to Other Courses 数据结构： — data model: 复杂数据结构 + 语义描述 + 数据操作 离散数学：关系模型 操作系统： 文件子系统，I/O子系统，进程管理 编译原理： 查询处理与优化 软件工程：DBS系统的设计方法 面向对象技术：object-oriented DBS C++ programs 词法/语法/语义分析 中间代码生成 (中间)代码优化 目标代码生成 程 序 编 译 / 编译器 程序执行 / OS 进程管理 进程调度 并发控制 死锁处理 SQL query 扫描和语法/语义分析 查询优化 (优化后)查询执行计划 查询代码生成 Query processing / DBMS process / thread 事务处理 / DBMS Chapter13, 14 Chapter 15,16, 17 transaction 关系代数表达式查询树 查询计划执行的代码 事务管理 目标程序代码 (§14) 事务调度 并发控制 死锁处理 恢复技术 (§13) (§15) (§16) (§17) In parallel with course learning, each student is directed to make several basic after-class Experiments on SQL Server independently, to get the students to have a better grasp of their knowledge about DBS learned in the classes and become skilled at operating practical DBS like SQL Server The experiment on SQL Server to learn SQL’s functionality of data definition, including defining of tables and views The experiment on SQL Server to learn SQL’s functionality of data query, including simple query, complex query, and nested query PART4Basic Experiments on SQL Server,DB2, Sybase The experiment on SQL Server Enterprise Manager to learn building and maintaining of DBS, including Insert, Delete, and Update operations on DB The experiment on SQL Server to learn security mechanisms, including users, roles, and privileges on data access The experiment on SQL Server to learn integrity mechanisms, including defining constraints and triggers in Transaction-SQL The experiment on SQL Server to learn backup and recovery mechanisms in DBS Basic Experiments (cont.) 实验安排 2人一组 随着课堂学习的进度逐步布置8组实验 由院实验中心的专职指导老师负责实验指导和上机验收 实验指导老师： ( )； 时间、地点：??，主楼院实验中心 913室 Basic Experiments on DB2, Sybase (cont.) As the seamless part of computer discipline specified in China Computer Curriculum 2005/2008, the Professional Practice of Da