上海交通大学：《数据库系统原理 The principle of Database System》课程教学资源（课件讲稿）Chapter1 Introduction

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~14th Lectures Time: Tuesday 8.00AM-9.40AM Thursday 8.00AM-9.40AM Place: 东中院3-403 Week 10th 18th:Project Grading: Attendance Homework:20% Final examination: 80%

Lecture Time & Grading Week 1th~ 14th : Lectures Time: Tuesday 8.00AM-9.40AM Thursday 8.00AM-9.40AM Place: 东中院 3-403 Week 10th ~ 18th: Project 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. A first course in database systems (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.) „ A first course in database systems (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(机械工业出版社) 2)Database Principles,Programming,and Performance by Patrick O'Neil,etal.(高等教育出版社) 3)数据库系统实现 database System Implementation Stanford university)中，英文版（机械工业出版 社) 4)数据库系统概论 (萨师煊，王珊) 高等教育出版 社

Other reference books 1) Database System Concepts by Abraham Silberschatz, et al (机械工业出版社 ) 2 ）Database Principles, Programming, and Performance by Patrick O’Neil, et al.（高等教育出版社） 3）数据库系统实现 database System Implementation (Stanford university）中，英文版（机械工业出版 社） 4）数据库系统概论 （萨师煊，王珊）高等教育出版 社

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

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? )

Introduction (Chapter 1) The history of Database System Overview of a database Management System (DBMS) Three aspects of database- system studies

Introduction (Chapter 1) „ The history of Database System „ Overview of a database Management System (DBMS) „ Three aspects of database￾system studies

Introduction to Database Systems What is a Database System? Database (data metadata) Hardware (disks) Software (DBMS) People (users,database designers and database administrators DBA)

Introduction to Database Systems What is a Database System? „ Database (data , metadata) „ Hardware (disks) „ Software (DBMS) „ People (users, database designers and database administrators DBA)

The history of Database Systems Early database management systems evolved from file system Network DBMS,Hierarchical DBMS Relational database Systems (in 1970, Ted Codd proposed tables called relations as a view of data in database) Object-oriented database Web database and XML

The history of Database Systems „ Early database management systems evolved from file system Network DBMS, Hierarchical DBMS „ Relational database Systems (in 1970, Ted Codd proposed tables called relations as a view of data in database) „ Object-oriented database „ Web database and XML