C S D LIU PHN TN ( Distributed database ) 1.

Thng tin chung v mn hc Tn mn hc: C s d liu phn tn

M mn hc: CNTT1206 S vht: 3

Loi mn hc: c s ngnh bt buc Cc mn hc tin quyt: C s d liu, h qun tr c s d liu, mng my tnh, lp trnh mng. Phn b gi i vi cc hot ng:

Ging l thuyt

: 39 tit 6 tit

Hng dn bi tp trn lp :

Khoa/B mn ph trch mn hc: Cng ngh thng tin/ H thng thng tin

2. Mc tiu ca mn hc Kin thc: nguyn l c s d liu phn tn K nng: thit k, lp trnh, cp nht thng tin v kin thc mi Thi , chuyn cn: tch cc

3. Tm tt ni dung mn hc Cung cp nhng kin thc c bn v nguyn l cc h c s d liu phn tn, bao gm cc ni dung v cc chin lc thit k v kim sot d liu. L thuyt phn mnh khng tn tht thng tin v bi ton cp pht d liu phn tn trn mng my tnh. Vn v qun l giao dch, c trng v cc tnh cht giao dch. Vn tng tranh v hiu nng x l phn tn. 4. Ni dung chi tit mn hc Chng 1: Khi nim c bn v c s d liu phn tn 1.1 X l d liu phn tn 1.2 H c s d liu phn tn l g. 1.3 Cc c im ca c s d liu phn tn 1.4 Trin vng ca h c s d liu phn tn 1.8 Mt s vn cn bn khi nghin cu c s d liu phn tn Chng 2: Kin trc h qun tr c s d liu phn tn LT2 LT4

2.1 Chun ca h qun tr c s d liu 2.2 Cc m hnh kin trc ca h qun tr c s d liu phn tn 2.3 Kin trc ca h qun tr c s d liu phn tn Chng 3: Thit k cc h c s d liu phn tn 2.1 Cc chin lc thit k 2.2 Cc vn trong thit k phn tn 2.3 Khi nim phn mnh v cc kiu phn mnh. 2.4 Cp pht d liu 2.8 Kim sot d liu ng ngha Chng 4: Tng quan v x l truy vn 4.1 Khi nim v truy vn 4.2 Mc tiu ca truy vn 4.3 Cc php ton i s quan h 4.4 c trng ca x l truy vn 4.5 Phn lp x l truy vn 4.6 Phn r truy vn 4.7 Cc b ha d liu phn tn 4.8 Ti u ha truy vn phn tn. 4.9 Cc thut ton ti u ha truy vn phn tn Chng 5: Qun l giao dch 5.1 Khi nim giao dch 5.2 c trng ca giao dch 5.3 Cc loi giao dch 5.4 iu khin ng thi phn tn 5.5 tin cy ca h qun tr c s d liu phn tn Chng 6: Gii thiu mt s ni dung thc t hoc m rng LT4 LT10/BT2 LT10/BT2 LT8/BT2

6.1 Gii thiu mt h thng c s d liu phn tn c xy dng trong thc t 6.2 H c s d liu di ng 6.3 H c s d liu song song

6.4 H c s d liu hng i tng phn tn 5. Hc liu Hc liu bt buc: - Sch, gio trnh chnh M.Tamer Ozsu And Patricle Valduriez, Principles of Distributed Database Systems, Second Edition, Prentive Hall Upper Saddle River, New Jersy, 1999. Hc liu tham kho Hc liu b tr

6. Hnh thc t chc dy hc: Lch trnh dy-hc Yu cu Gi ln lp Thc T sinh hnh, hc, vin th Hng t chun nghim L dn Tho nghin b trc ( thuyt Bi lun cu khi ln quy tp (Gi) lp i) c Quyn 1, chng 1 c Quyn 1, chng 4 Hnh thc t chc dy-hc

Thi gian

Ni dung

Ghi ch

Tun 1:

Chng 1: Khi nim c bn v c s d liu phn tn

Tun 2:

1.8 Mt s vn cn bn khi nghin cu c s d liu phn tn Chng 2: Kin trc h qun tr c s d liu phn tn Chng 3: Thit k cc h c s d liu phn tn 3.1 Cc chin lc thit k 3.2 Cc vn trong thit

Tun 3:

c Quyn 1, chng 5

k phn tn 3.3 Khi nim phn mnh v cc kiu phn mnh. 3.4 Cp pht d liu c Quyn 1, chng 5 c Quyn 1, chng 6 c Quyn 1, chng 7

Tun 4:

Tun 5:

3.5 Kim sot d liu ng ngha Bi tp

Tun 6:

Chng 4: Tng quan v x l truy vn 4.1 Khi nim v truy vn 4.2 Mc tiu ca truy vn 4.3 Cc php ton i s quan h 2 1

Tun 7:

4.4 c trng ca x l truy vn 4.5 Phn lp x l truy vn 4.6 Phn r truy vn 4.7 Cc b ha d liu phn tn 4.8 Ti u ha truy vn phn tn.

c Quyn 1, chng 7

Tun 8:

c Quyn 1, chng 8 c Quyn 1, chng 9 2 c Quyn 1, chng

Tun 9:

4.9 Cc thut ton ti u ha truy vn phn tn Kim tra gia k 1 tit

Tun 10:

Chng 5: Qun l giao dch LT10/BT2

5.1 Khi nim giao dch 5.2 c trng ca giao dch 5.3 Cc loi giao dch

10 c Quyn 1, chng 10 c Quyn 1, chng 11 c Quyn 1, chng 12 c Quyn 1, chng 16 c phn 1 cc chng 13,14

Tun 11:

Tun 12:

5.4 iu khin ng thi phn tn

Tun 13:

5.5 tin cy ca h qun tr c s d liu phn tn

Tun 14:

Chng 6: Gii thiu mt s ni dung thc t hoc m rng

Tun 15:

Chng 6: Gii thiu mt s ni dung thc t hoc m rng

Ghi ch: Thng nht ton b cc mn hc s thc hin kim tra gia k vo tun th 7. Thang im nh gi: t 0 n 10 8. Phng php, hnh thc kim tra - nh gi kt qu hc tp mn hc: bao gm cc phn sau (hnh thc kim tra cui k, trng s cc ni dung cn phi thng qua Trng B mn). 8.1 Cc loi im kim tra v hnh thc nh gi: Tham gia hc tp trn lp: (i hc y , chun b bi tt v tch cc tho lun,); Phn t hc, t nghin cu c hng dn ca ging vin: bi tp c nhn Hot ng theo nhm:

Kim tra - nh gi gia k: Kim tra - nh gi cui k: thi vit

8.2 Trng s cc loi im kim tra: Tham gia hc tp trn lp: Kim tra gia k: Kim tra cui k: 10 % 20 % 70 %