The principle of Database System Teacher:Li Fang(李芳) Email:li-fang@cs.sjtu.edu.cn Office:电院楼群3号楼533房间 Slides will be put on: ftp://ftp.cs.sjtu.edu.cn/li-fang/ My sides are based on Stanford's slides,from http://infolab.stanford.edu/~ullman/fcdb.html
The principle of Database System Teacher: Li Fang (李芳 ) Email: li-fang@cs.sjtu.edu.cn Office : 电院楼群 3号楼 533房间 Slides will be put on: ftp://ftp.cs.sjtu.edu.cn/li-fang/ My sides are based on Stanford’s slides, from http://infolab.stanford.edu/~ullman/fcdb.html
Lecture Time Grading Week 1th~13th:Lectures Time: Tuesday 10.00AM-11.40AM Thursday 8.00AM-9.40AM Place: 东上院501 Lectures Grading: Attendance Homework:20% Final examination: 80%
Lecture Time & Grading Week 1th~ 13th : Lectures Time: Tuesday 10.00AM-11.40AM Thursday 8.00AM-9.40AM Place: 东上院 501 Lectures Grading: Attendance & Homework: 20% Final examination: 80%
Textbook A first course in database systems (Third edition) Authors:Jeffrey D.Ullman,Jennifer Widom Stanford University 书名：数据库系统基础教程（英文版·第3 数据库系统基记教程 版) ISB:7-111-24733-3 原书名：A First Course in Database Systems Third Edition 丛书名：经典原版书库 f作者：Jeffrey D.llman:Jennifer Widom 译者：无 出版日期：2008-07-26 机械工业出版社 页数：565 价格：￥45.00 www.china-pub.com
Textbook A first course in database systems (Third edition) Authors: Jeffrey D.Ullman, Jennifer Widom Stanford University 机械工业出版社 www.china-pub.com
Textbook (cont. The book of the Second edition can be borrowed from me. Major changes in the third edition: 1. Begin with a discussion of relational design,rather than E/R design. 2. Add coverage of high-level design using UML 3.Add index selection and use of materialized views 4.Add database aspectd of PHP 5.Two new chapters on XML-related materials 6. OQL and recursive Datalog have been deleted
Textbook (cont.) The book of the Second edition can be borrowed from me. Major changes in the third edition: 1. Begin with a discussion of relational design, rather than E/R design. 2. Add coverage of high-level design using UML 3. Add index selection and use of materialized views 4. Add database aspectd of PHP 5. Two new chapters on XML-related materials 6. OQL and recursive Datalog have been deleted
Other Reference Books 1)Database System Concepts by Abraham Silberschatz, etal(机械工业出版社)(Sixth edition)from Yale University 2)Database System Implementation(Stanford university)Chinese and English version(机械工业 出版社) 3)An introduction to Database System数据库系统概 论高等教育出版社（中国人民大学萨师煊，王珊）
Other Reference Books 1) Database System Concepts by Abraham Silberschatz, et al (机械工业出版社) (Sixth edition) from Yale University 2 ）Database System Implementation (Stanford university ）Chinese and English version（机械工业 出版社） 3 ）An introduction to Database System 数据库系统概 论 高等教育出版社 (中国人民大学萨师煊，王珊）
Contents of the Courses Database Modeling and Programming: s Relational Database Modeling Basic concepts,design theory,high level models (E/R model,UML,ODL) Relational database Programming Relational algebra and Datalog,SQL Semistructured data modeling and Programming XML,DTD,three query languages for XML
Contents of the Courses Database Modeling and Programming: Relational Database Modeling Basic concepts, design theory, high level models (E/R model, UML, ODL) Relational database Programming Relational algebra and Datalog, SQL Semistructured data modeling and Programming XML, DTD, three query languages for XML
Lecture content 1: Database Modeling Relational model of data (chapter 2) Design theory for relational model (chapter 3) High-level database model (chapter 4) E/R model,UML,ODL and E/R,UML,ODL relational models
Lecture content 1: Database Modeling Relational model of data (chapter 2) Design theory for relational model (chapter 3) High-level database model (chapter 4) E/R model, UML, ODL and E/R, UML, ODL Æ relational models
Content 2:Relational database programming Abstract programming language (chapter 5):algebra and logic The Standard Database Language SQL: 1. DML introduction (chapter 6) 2. Constraints (chapter 7) 3. Views and Indexes (chapter 8) 4. SQL in a server environment (chapter 5. Advanced topics in Relational databases (chapter 10)
Content 2: Relational database programming Abstract programming language (chapter 5) : algebra and logic The Standard Database Language SQL: 1. DML introduction (chapter 6 ) 2. Constraints (chapter 7 ) 3. Views and Indexes (chapter 8 ) 4. SQL in a server environment (chapter 9 ) 5. Advanced topics in Relational databases (chapter 10 )
Content 3:Modeling and Programming for semi-structured data Semistructured-data model (chapter 11) Programming language for XML (chapter 12)
Content 3: Modeling and Programming for semi-structured data Semistructured-data model (chapter 11 ) Programming language for XML (chapter 12 )
Aim of the course Basic concepts (what is DBMS? What is Database system?... Design of database (how does one build a useful database?What kind of information is stored in database?What is the structure of data?) Database Programming (how to query and operate on database?)
Aim of the course Basic concepts (what is DBMS? What is Database system?…) Design of database (how does one build a useful database? What kind of information is stored in database? What is the structure of data?) Database Programming (how to query and operate on database?)