Database System Management and Tuning (Fall 2014 at Fudan)#


Course Description#

Instructor#

Yanghua Xiao, shawyh@fudan.edu.cn

Office: 217-3, Software Building, Zhangjiang Branch

Goals#

To study the internals of database systems as an introduction to research and as a basis for rational performance tuning.

The study of internals will concern topics at the intersection of database system, operating system, and distributed computing research and development. Specific to databases is the support of the notion of transaction: a multi-step atomic unit of work that must appear to execute in isolation and in an all-or-nothing manner. The theory and practice of transaction processing is the problem of making this happen efficiently and reliably.

Tuning is the activity of making your database system run faster. The capable tuner must understand the internals and externals of a database system well enough to understand what could be affecting the performance of a database application. We will see that interactions between different levels of the system, e.g., index design and concurrency control, are extremely important, so will require a new optic on database management design as well as introduce new research issues. Our discussion of tuning will range from the hardware to conceptual design, touching on operating systems, transactional subcomponents, index selection, query reformulation, normalization decisions, and the comparative advantage of object-oriented database systems. This portion of the course will be heavily sprinkled with case studies from database tuning in biotech, telecommunications, and finance.


Schedule#

Teaching will take place in room Z2302 from 13:30 to 15:10 on each Thursday.

The Final Exam will take place at Jan.2 on Z2310(last year).

The schedule is preliminary. It will be updated during the course. Literature in parenthesis ( ) is background reading that might be helpful (e.g. to brush up old knowledge before lectures), but not curriculum. Literature in square brackets is part of the curriculum.

WeekDateSubjectLiteratureMaterial
1 Sep 12 Introduction(slides(info))(RG 1.5-1.8, RG 4.2); SP 1
2 Sep.26Schema Refinement(slides(info)) SP 4; RG 19
3 Oct.10 Data Storage(slides(info)) HG 11.1-11.5
4 Oct.17 Storage Refinement(slides(info)) SP 2.5, HG 11.6-11.7
5 Oct.24 Disk Organization(slides(info)) HG 12
6 Oct.31 Index Tuning-Convential Index(slides(info))HG 13.1-13.2
7Nov.7Index Tuning-B+tree(slides(info)) RG 10, HG 13.3
8Nov.14 External Sorting(slides(info)),Index Tuning-Hash Index(slides(info)), Index Performance Tuning(slides(info)) HG13.4,RG 11, SP 3
9 Nov.21 Operator Evaluation(slides(info))RG14
10 Nov.28 Query Optimization(slides(info))RG15
11 Dec.5 NoSQL overview(slides(info)) DB Tuning Project dbtune_project2014.rar(info),chenyuhong.doc(info)
12 Dec.12 Query Tuning (slides(info)) SP 4.6-4.7
13 Dec.19 Overview of Transaction Management(slides(info)), Lock Tuning(slides(info)),Log Tuning(slides(info)),Troubleshooting(slides(info)),API Tuning(slides(info)),Buffer management(slides(info)) HG 16-17, SP 2.2, HG 18, SP 2.3 ,SB 7,SB 5
14 Jan.2 Exam
14 Jan.15 Project Deadline

所有PPT列表,svn下载地址(包含三本reference),用户名guest,密码guest#

http://gdm.fudan.edu.cn/svn/Dbtune/#

Files List

Literatures#

The course uses the following textbooks :

Primary text#

  1. Database Tuning. Principles, Experiments, and Troubleshooting Techniques, by Dennis Shasha and Philippe Bonnet, Morgan Kaufmann, 2003. ISBN: 1558607536, which is denoted by SP.

Reference:#

  1. Database Management Systems, 3rd edition, by Raghu Ramakrishnan and Johannes Gehrke, McGraw-Hill, 2002. ISBN: 0071230572, which is denoted by RG
  2. Database Systems -- The Complete Book, Hector Garcia-Molina, Jeffrey D. Ullman, and Jennifer Widom: Prentice Hall, 2001, which is denoted by HG
  3. Database Performance Tuning and Optimization, Springer,2003 Sitansu S.Mittra,
  4. Oracle Performance Tuning 10.1.G. J. Vaidyanatha, K. Deshpande and J. Kostelac: Osborne/Mc-Graw-Hill. 2001.
  5. Jim Gray (ed): The Benchmark handbook : for database and transaction processing systems. M. Kaufmann Publishers, 1991.
  6. Richard J.Niemiec, Oracle Database 10g Performance Tuning tips and techniques, Mc Graw Hill Education,2009
  7. 牛新庄, DB2 数据库性能调整与优化, 清华大学出版社, 2009
  8. 胡百敬,等, SQL Server 2005 Performance tuning, 电子工业出版社,2008

  1. Oracle 10g reference. Free, but requires registration.
  2. Oracle Performance Tuning Guide (Query Execution Plans)
  3. "Database Management Systems" website with supporting material.
  4. "Database Tuning" website.

Previous courses#

  1. Fall 2013 at Fudan
  2. Fall 2012 at Fudan
  3. Fall 2010 at Fudan
  4. Fall 2009 at Fudan

添加新附件

只有授权的用户才能上传新附件。

附件列表

类型 附件名称 大小 版本 修改日期 作者 变更注释
docx
13210240121_杨振东_dbtune_nosql_p... 173.7 kB 1 20-一月-2014 15:54 zhangkezun
ppt
ApiTuning.ppt 277.0 kB 1 19-十二月-2013 21:52 zhangkezun
ppt
Buffer management.ppt 121.3 kB 1 19-十二月-2013 21:52 zhangkezun
ppt
Data Storage.ppt 610.3 kB 1 12-十月-2012 11:35 shawyh
ppt
Disk organization.ppt 818.2 kB 2 19-十月-2012 13:21 shawyh
ppt
External Sorting.ppt 218.6 kB 1 30-十月-2013 10:54 shawyh
ppt
Index Performance tuning.ppt 155.6 kB 1 30-十月-2013 11:00 shawyh
ppt
Index tuning-Hash Index.ppt 439.3 kB 1 30-十月-2013 10:55 shawyh
ppt
Index-B+tree.ppt 1,014.3 kB 1 30-十月-2013 10:54 shawyh
ppt
Index-conventional index.ppt 632.3 kB 1 30-十月-2013 10:54 shawyh
ppt
Introduction.ppt 329.2 kB 2 14-九月-2012 10:06 shawyh
ppt
LockTuning.ppt 408.1 kB 1 19-十二月-2013 21:52 zhangkezun
ppt
LogTuning.ppt 557.1 kB 1 19-十二月-2013 21:52 zhangkezun
pptx
NoSQL overview.pptx 1,676.7 kB 1 19-十二月-2013 22:04 zhangkezun
ppt
Operator Evaluation.ppt 1,284.6 kB 1 19-十二月-2013 21:53 zhangkezun
ppt
Query Optimization.ppt 536.6 kB 1 19-十二月-2013 21:53 zhangkezun
ppt
Query Tuning.ppt 250.9 kB 1 19-十二月-2013 21:53 zhangkezun
ppt
SchemaTuning.ppt 391.7 kB 1 21-九月-2012 10:36 shawyh
ppt
Storage refinement.ppt 369.7 kB 1 19-十月-2012 13:20 shawyh
ppt
Transaction Management Overvie... 349.7 kB 1 19-十二月-2013 21:54 zhangkezun
ppt
Troubleshooting.ppt 1,035.3 kB 1 19-十二月-2013 21:54 zhangkezun
ppt
chapter10-slide1-Query Optimiz... 429.6 kB 1 23-十月-2012 16:24 zhangkezun
ppt
chapter10-slide2-Query Optimiz... 316.4 kB 1 23-十月-2012 16:24 zhangkezun
ppt
chapter11-slide1-Query Tuning.... 137.2 kB 1 23-十月-2012 16:24 zhangkezun
ppt
chapter11-slide2-Query Tuning.... 157.2 kB 1 23-十月-2012 16:24 zhangkezun
ppt
chapter11-slide3-Query Tuning.... 144.9 kB 1 23-十月-2012 16:24 zhangkezun
ppt
chapter11-slide4-Query Tuning.... 129.5 kB 1 23-十月-2012 16:24 zhangkezun
ppt
chapter12-slide1-Transaction M... 281.6 kB 1 23-十月-2012 16:24 zhangkezun
ppt
chapter12-slide2-Transaction M... 160.8 kB 1 23-十月-2012 16:24 zhangkezun
ppt
chapter12-slide3-Transation Ma... 154.1 kB 1 23-十月-2012 16:25 zhangkezun
ppt
chapter12-slide4-Lock Tuning.p... 139.3 kB 1 23-十月-2012 16:25 zhangkezun
ppt
chapter12-slide5-Lock Tuning.p... 208.4 kB 1 23-十月-2012 16:25 zhangkezun
ppt
chapter12-slide6-Lock Tuning.p... 219.1 kB 1 23-十月-2012 16:25 zhangkezun
ppt
chapter13-slide1-Log Tuning.pp... 242.7 kB 1 23-十月-2012 16:32 zhangkezun
ppt
chapter13-slide2-Log Tuning.pp... 332.8 kB 1 23-十月-2012 16:32 zhangkezun
ppt
chapter13-slide3-Log Tuning.pp... 289.3 kB 1 23-十月-2012 16:32 zhangkezun
ppt
chapter14-slide1-DBMS Performa... 560.1 kB 1 23-十月-2012 16:32 zhangkezun
ppt
chapter14-slide2-DBMS Performa... 439.3 kB 1 23-十月-2012 16:33 zhangkezun
ppt
chapter14-slide3-DBMS Performa... 284.2 kB 1 23-十月-2012 16:33 zhangkezun
ppt
chapter15-slide1-Communicating... 229.9 kB 1 23-十月-2012 16:33 zhangkezun
ppt
chapter15-slide2-Communicating... 191.0 kB 1 23-十月-2012 16:33 zhangkezun
ppt
chapter6-slide1-index tuning o... 400.9 kB 1 23-十月-2012 16:01 zhangkezun
ppt
chapter6-slide2-index tuning D... 349.7 kB 1 23-十月-2012 16:01 zhangkezun
ppt
chapter6-slide3-index tuning S... 350.7 kB 1 23-十月-2012 16:02 zhangkezun
ppt
chapter7-slide1-B+tree.ppt 581.1 kB 1 23-十月-2012 16:09 zhangkezun
ppt
chapter7-slide2-B+Tree.ppt 535.6 kB 1 23-十月-2012 16:09 zhangkezun
ppt
chapter7-slide3-B+Tree.ppt 498.7 kB 1 23-十月-2012 16:09 zhangkezun
ppt
chapter7-slide4-B+Tree.ppt 182.8 kB 1 23-十月-2012 16:09 zhangkezun
ppt
chapter8-slide-1-Hash Index.pp... 472.1 kB 1 23-十月-2012 16:16 zhangkezun
ppt
chapter8-slide2-Hash Index.ppt 363.5 kB 1 23-十月-2012 16:16 zhangkezun
ppt
chapter8-slide3-performance tu... 211.5 kB 1 23-十月-2012 16:16 zhangkezun
ppt
chapter8-slide4-Additional kno... 167.4 kB 1 23-十月-2012 16:17 zhangkezun
ppt
chapter8-slide5-External Sorti... 442.9 kB 1 23-十月-2012 16:17 zhangkezun
ppt
chapter9-slide1-Relational Ope... 160.8 kB 1 23-十月-2012 16:17 zhangkezun
ppt
chapter9-slide2-Relational Ope... 319.0 kB 1 23-十月-2012 16:17 zhangkezun
ppt
chapter9-slide3-Relational Ope... 431.1 kB 1 23-十月-2012 16:17 zhangkezun
doc
chenyuhong.doc 1,178.6 kB 1 13-一月-2014 19:45 zhangkezun
rar
dbtune_project.rar 661.0 kB 1 19-十二月-2013 22:54 zhangkezun
rar
dbtune_project2014.rar 660.7 kB 1 04-十二月-2014 13:19 jxulie
jpg
image001.jpg 36.9 kB 1 26-七月-2012 17:09 shawyh fudanlogo
jpg
image002.jpg 3.2 kB 1 26-七月-2012 17:11 shawyh
png
list.PNG 12.0 kB 1 19-十二月-2013 22:45 zhangkezun
« 该页面(修订版 )最后由 jxulie04-十二月-2014 13:24 修改。