An Introduction toDatabase Systems 资料库系统.ppt

1、1,An Introduction toDatabase Systems資料庫系統,陳日昌 Fall 2009,2,Contents 內容綱要,Introduction (1 wk) SQL: DML and DDL (4 wks) Constraints and Triggers (1 wk), E/R modeling (2 wks) and E/R CASE Tool (2 wks) Functional Dependencies (1 wk), Sqlite or Postgres (optional) Drills and Exams,3,Why learn this?我可以學到什麼

2、？,目標 資料庫系統的基本知識 操作資料庫的方法 (Data Manipulation) 分析並定義資料庫 (Modeling and Definition) 程式介面 (Programming Interface) 工作與就業能力,4,Prerequisites 預修與要件,Data structures 基本的資料結構知識 C/C+ programming language 作業系統操作與概念 平台: MS Windows或Linux MySQL: Oracle (甲骨文): Feb. 2008 SUN acquired MySQL ($1Bn),

3、July 2009 Oracle acquired SUN ($7.4Bn) Watch out!,5,Syllabus 授課規定,時間：每週三小時 Textbook 課本：講義與Internet 作業就是考試題目 課堂時間規定：請尊重他人權益 聯絡：.tw Subject: DB4S主旨 例如: DB4S考試時間?,6,主要參考書與網路資料,Database Systems The Complete Book, (“DSCB”) Garcia-Molina, Ullman, Widom Jeff Ullmans offering of the CS145 c

4、ourse in the Autumn of 2004 Chap 1-2 Free Download 滄海書局,7,圖書館指定參考書,“Database Design, Application Development 音樂/電影資料庫的播放,24,XML Databases,XML (eXtensible Markup Language) as the data definition language (DDL) Flexible Web (http) oriented but not limited to web,25,Overview of a DBMS(Fig. 1.1, DSCB),DML processing Query compiler Execution engine File manager, buffer manager, storage manager Transaction processing Transaction manager Logging and recovery Concurrency control Database administration DDL compiler,26,Next Week,Installation of MySQL Basic Administr