📄 分布式数据库系统（2007年秋季学期）.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0043)http://dbgroup.cs.tsinghua.edu.cn/ddb/2007/ -->
<HTML><HEAD><TITLE>分布式数据库系统（2007年秋季学期）</TITLE>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<STYLE type=text/css>.style7 {
FONT-WEIGHT: bold; FONT-SIZE: 18px
}
.style8 {
COLOR: #000000
}
</STYLE>
<META content="MSHTML 6.00.2900.3157" name=GENERATOR></HEAD>
<BODY>
<TABLE height=625 cellSpacing=10 width=806 align=center border=0>
<TBODY>
<TR>
<TD vAlign=top width=800>
<H1 align=center>分布式数据库系统（2007年秋季学期）</H1>
<P class=style7 align=center>Distributed Database Systems - Autumn,
2007</P>
<P align=center>(beta version)</P>
<DIV align=center>
<TABLE width=417 border=0>
<TBODY>
<TR>
<TD width=85><SPAN class=STYLE2>授课教师：</SPAN></TD>
<TD width=100>
<DIV align=left><A href="http://dbgroup.cs.tsinghua.edu.cn/zhoulz/"
target=_blank>周立柱</A> 教授</DIV></TD>
<TD width=218><A
href="mailto:dcszlz@tsinghua.edu.cn">dcszlz@tsinghua.edu.cn</A></TD></TR>
<TR>
<TD><SPAN class=STYLE2>课程助教：</SPAN></TD>
<TD><A href="http://dbgroup.cs.tsinghua.edu.cn/wuhao/"
target=_blank>吴 昊</A></TD>
<TD><A
href="mailto:haowu06@mails.tsinghua.edu.cn">haowu06@mails.tsinghua.edu.cn</A></TD></TR></TBODY></TABLE>
<P> </P></DIV>
<H2>课程简介</H2>
<P>本课程主要学习分布式数据库系统的基本原理，同时对分布式数据库管理系统设计和实现的关键环节进行了介绍。通过学习，学生不仅要掌握基本的原理和方法，还必须以小组为单位设计并实现一个分布式数据库管理系统，通过最后的系统测试。除此之外，在本课程的中期和期末各有一次测验，计入最终成绩。</P>
<P>授课时间、地点：周四第二大节 (09:50)，六教6A316</P>
<H2>参考教材</H2>
<P><A href="http://softbase.uwaterloo.ca/~tozsu/ddbook.html">Principles of
Distributed Database Systems, Second Edition</A> - M. Tamer Özsu and
Patrick Valduriez, Prentice Hall, 1999</P>
<P>该书由清华大学出版社影印，名为《分布式数据库系统原理（第2版）》，各大书店均有销售。</P>
<P><A
href="http://dbgroup.cs.tsinghua.edu.cn/ddb/2007/Materials/Ozsu.rar">这里</A>是相关的PPT。</P>
<P>第二版的中文影印版可以在东主楼十区一层计算机系教学办公室张文忠老师处购买。</P>
<H2>往年课件：<A
href="http://dbgroup.cs.tsinghua.edu.cn/ddb/2007/Materials/ddb(doc).rar">ddb(doc).rar</A></H2>
<H2>教学日历</H2>
<TABLE cellSpacing=4 cellPadding=0 border=1>
<TBODY>
<TR>
<TD vAlign=top width=70>
<DIV align=center>日期 </DIV></TD>
<TD vAlign=top width=418>
<DIV class=style8 align=center>
<DIV align=center>内容</DIV></DIV></TD>
<TD vAlign=top width=272>
<DIV align=center>课件下载</DIV></TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>09.20 </DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>Chapter 1 Introduction
<LI>Chapter 4 DDB Architecture </LI></UL></TD>
<TD vAlign=top width=272><A
href="http://dbgroup.cs.tsinghua.edu.cn/ddb/2007/Slides/00.%20Welcome.pdf">00.
Welcome.pdf</A><BR><A
href="http://dbgroup.cs.tsinghua.edu.cn/ddb/2007/Slides/01.%20Introduction.pdf">01.
Introduction.pdf</A><BR><A
href="http://dbgroup.cs.tsinghua.edu.cn/ddb/2007/Slides/04.%20Distributed%20DBMS%20Architecture.pdf">04.
Distributed DBMS Architecture.pdf</A></TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>09.26</DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>Chapter 5 Distributed Database Design
<LI>完成COM_MIN、P_HORIZONTAL算法、Derived Horizontal Fragmentation算法
</LI></UL></TD>
<TD vAlign=top width=272> </TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>10.11</DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>Chapter5 Checking for Correctness, Data Allocation
<LI>Chapter7 Overview of Query Processing
<LI>讨论如何启动课程设计 (Read Project Kick-off file) </LI></UL></TD>
<TD vAlign=top width=272> </TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>10.18</DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>Chapter8 Query Decomposition and Localization
<LI>Chapter 9 Optimization of Distributed Query </LI></UL></TD>
<TD vAlign=top width=272> </TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>10.25</DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>示范系统演示(吴昊) 与课程设计讨论 </LI></UL></TD>
<TD vAlign=top width=272> </TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>11.11</DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>Centralized INGRES, DB2 Algorithms
<LI>Chapter 9 Join Ordering, Distributed INGRES </LI></UL></TD>
<TD vAlign=top width=272> </TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>11.08</DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>课堂练习(期中测验)一节 </LI></UL></TD>
<TD vAlign=top width=272> </TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>11.15</DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>R* Algorithm
<LI>Chapter 10 Introduction to Transaction Management
<LI>Chapter 11 Distributed Concurrency Control and Serializability
Theory </LI></UL></TD>
<TD vAlign=top width=272> </TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>11.22</DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>课程设计中期检查：每组15分钟，讨论5分钟。检查（抽查）6个组。 </LI></UL></TD>
<TD vAlign=top width=272> </TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>11.29</DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>Chapter 11 Distributed Concurrency Control Taxonomy of
Concurrency Algorithms: Locking Based Method, Timestamp
<LI>总结中期检查报告 </LI></UL></TD>
<TD vAlign=top width=272> </TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>12.06</DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>Optimistic Algorithms
<LI>Chapter12 Distributed DBMS Reliability: 12.4 LRM Commands,
Checkpoint
<LI>研究生助教课程项目答疑，各小组讨论实验系统 </LI></UL></TD>
<TD vAlign=top width=272> </TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>12.13</DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>12.5 2PC Protocol: 12.5.3. Variant of 2PC </LI></UL></TD>
<TD vAlign=top width=272> </TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>12.20</DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>12.6 Dealing with site failures
<LI>Summary of DDB </LI></UL></TD>
<TD vAlign=top width=272> </TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>12.27</DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>期末课堂考试。各组报告演示时间与地点。 </LI></UL></TD>
<TD vAlign=top width=272> </TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>01.03</DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>（待定） </LI></UL></TD>
<TD vAlign=top width=272> </TD></TR>
<TR>
<TD vAlign=top width=70>
<DIV align=center>01.10</DIV></TD>
<TD vAlign=top width=418>
<UL>
<LI>系统评测 </LI></UL></TD>
<TD vAlign=top width=272> </TD></TR></TBODY></TABLE>
<H2>关于实验</H2>
<P>目前提供一个<A
href="http://dbgroup.cs.tsinghua.edu.cn/ddb/2007/Materials/sample.zip">去年的实验说明</A>，与周老师共同讨论之后，我会把最新的实验要求贴上来：）</P></TD></TR></TBODY></TABLE></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -