推 fluteoner:歐買尬的...超多的 06/28 06:50
推 drkkimo:這本書好像不錯耶 06/28 09:15
※ 引述《Fujirou (秀吉)》之銘言：
: ※ 引述《fluteoner (NCU_CS)》之銘言：
: : 我大概講一下我們的主題
: : 1.DB環境概論、歷史與發展
: : 2.Database Analysis, 包含ER model與 Enhanced ER model
: : 3.Database Design, 就是第一第二第三正規化, Denormalization, RAID等等
: : 4.SQL語法, 我們教SQL Server2000 (只教一點點)
: : 然後兩學期就差不多結束了
: : 其他像是
: : Client/Server DB, Data warehouse, Distributed DB, Object-Orented DB,
: : 等等進階的領域都可以另外再開課，真是太可怕啦
: : 會問這個是因為我考到資工所，現在要作Data Warehouse相關的東西，
: : 想知道資工比較著重在哪一部份，難道你們只有學SQL??
: 資工課程
: 課本是Database Management Systems 3e, by R. Ramakrishnan and J. Gehrke
: 1. Overview of Database Systems
: 2. ER Model
: 3. Relational Model
: 4. Relational Algebra (Relational Calculus skipped)
: 5. SQL
: 8. Overview of Storage and Indexing
: 9. Storing Data: Disks and Files (RAID, Buffer Manager, Page formats,...)
: 10. Tree-Structured Indexing (ISAM, B+ Tree)
: 11. Hash-Based Indexing
: 12. Overview of Query Evaluation
: 13. External Sorting
: 14. Evaluating Relational Operators
: 16. Overview of Transaction Management (Strict 2PL, Deadlocks)
: 17. Concurrency Control
: 18. Crach Recovery (ARIES)
: 有幾章的後面會跳過，是哪幾章我也忘了…
: 這是一個學期的課
交大資工的資料庫
課本 : Fundamentals of Database Systems 4th Edi. ,by Elmasri && Navathe
課程內容包括 :
1.Databases and Database Use
2.Database System Concepts and Architecture
3.Data Modeling Using the Entity-Relationship Model
4.Enhanced Entity-Relationship and UML Modeling
5.The Relational Data Model and Relational Database Constraints
6.The Relational Algebra and Relational Calculus(Calculus的部分沒有教)
7.Relational Database Design by ER- and EER-to-Relational Mapping
8.SQL-99: Schema Definition,Basic Constraints and Queries
9.More SQL: Assertions,Views,and Programming Techniques
10.Functional Dependencies and Normalization for Relational Databases
13.Disk Storage,Basic File Structures, and Hashing
14.Indexing Structures for Files
17.Introduction to Transaction Processing Concepts and Theory
18.Concurrency Control Techniques
26.XML and Internet Database
27.Data Mining Concepts
28.Overview of Data Warehousing and OLAP
--
今天剛考完
囧
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.113.93.86