|
鍙嬫儏鎻愮ず锛氭湰绔欐彁渚涘叏鍦�(gu贸)400澶氭墍楂樼瓑闄㈡牎鎷涙敹纰╁＋銆佸崥澹爺绌剁敓鍏ュ(xu茅)鑰冭│姝峰勾鑰冪爺鐪熼銆佽€冨崥鐪熼銆佺瓟妗�锛岄儴鍒嗗(xu茅)鏍℃洿鏂拌嚦2012骞�锛�2013骞�锛涘潎鎻愪緵鏀惰不(f猫i)涓嬭級銆� 涓嬭級娴佺▼锛� 鑰冪爺鐪熼 榛�(di菐n)鎿娾€�鑰冪爺瑭﹀嵎鈥濃€濅笅杓�; 鑰冨崥鐪熼 榛�(di菐n)鎿娾€�鑰冨崥瑭﹀嵎搴�(k霉)鈥� 涓嬭級
銆婃暩(sh霉)鎿�(j霉)搴�(k霉)鍘熺悊銆嬪叆瀛�(xu茅)鑰冭│鍒濊│锛堝京(f霉)瑭︼級澶х侗
涓€銆佽€冭│瑾�(shu艒)鏄�
1锛� 鍙冭€冩暀鏉�
? 銆婃暩(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)鏁欑▼锛堢 3 鐗堬級銆� 鏂戒集妯�(l猫)銆佷竵瀵跺悍銆佹豹琛�(w猫i) 楂樼瓑鏁欒偛鍑虹増绀�
2锛� 椤屽瀷鍙婂垎?j菒n)?sh霉)姣斾緥
? 閬告搰椤� 20%
? 濉┖椤� 20%
? 鍚嶈瑙ｉ噵 15%
? 绨�(ji菐n)绛旈 45%
浜�銆佽€冭│鍏�(n猫i)瀹�
绗� 1 绔狅細鏁�(sh霉)鎿�(j霉)搴�(k霉)姒傝珫
1.1 DB銆丏BMS 鍜� DBS 鐨勫畾缇�
1.2 鏁�(sh霉)鎿�(j霉)绠＄悊鎶€琛�(sh霉)鐨勭櫦(f膩)灞曢殠娈�
浜哄伐绠＄悊闅庢銆佹枃浠剁郴绲�(t菕ng)闅庢銆佹暩(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)闅庢鍜岄珮绱�(j铆)鏁�(sh霉)鎿�(j霉)搴�(k霉)鎶€琛�(sh霉)闅庢绛夊悇闅庢鐨勭壒榛�(di菐n)銆�
1.3 鏁�(sh霉)鎿�(j霉)鎻忚堪
姒傚康瑷�(sh猫)瑷�(j矛)銆侀倧杓ō(sh猫)瑷�(j矛)鍜岀墿鐞嗚ō(sh猫)瑷�(j矛)绛夊悇闅庢涓暩(sh霉)鎿�(j霉)鎻忚堪鐨勮(sh霉)瑾�(y菙)锛屾蹇佃ō(sh猫)瑷�(j矛)涓(sh铆)楂旈枔浜屽厓鑱�(li谩n)
绯荤殑鎻忚堪锛�1:1锛�1:N锛孧:N锛夈€�
1.4 鏁�(sh霉)鎿�(j霉)妯″瀷
鏁�(sh霉)鎿�(j霉)妯″瀷鐨勫畾缇�锛屽叐椤炴暩(sh霉)鎿�(j霉)妯″瀷锛岄倧杓ā鍨嬬殑褰㈠紡瀹氱京锛孍R 妯″瀷锛屽堡娆℃ā鍨�銆佺恫(w菐ng)鐙€妯�
鍨�銆侀棞(gu膩n)绯绘ā鍨嬪拰闈㈠悜?q奴)慰绔斤及鍋疯噭?sh霉)鎿�(j霉)绲�(ji茅)妲�(g貌u)浠ュ強鑱�(li谩n)绯荤殑瀵�(sh铆)鐝�(xi脿n)鏂瑰紡銆�
1.5 DB 鐨勯珨绯荤祼(ji茅)妲�(g貌u)
涓夌礆(j铆)绲�(ji茅)妲�(g貌u)锛屽叐绱�(j铆)鏄犲儚锛屽叐绱�(j铆)鏁�(sh霉)鎿�(j霉)鐛�(d煤)绔嬫€�锛岄珨绯荤祼(ji茅)妲�(g貌u)鍚勫€�(g猫)灞ゆ涓閷勭殑鑱�(li谩n)绯汇€�
1.6 DBMS
DBMS 鐨勫伐浣滄ā寮�銆佷富瑕佸姛鑳藉拰妯″绲勬垚銆�
1.7 DBS
DBS 鐨勭祫鎴愶紝DBA锛孌BS 鐨勫叏灞€绲�(ji茅)妲�(g貌u)锛孌BS 绲�(ji茅)妲�(g貌u)鐨勫垎椤�銆�
绗� 2 绔狅細 闂�(gu膩n)绯绘ā鍨嬪拰闂�(gu膩n)绯婚亱(y霉n)绠楃悊璜�
2.1 闂�(gu膩n)绯绘ā鍨嬬殑鍩烘湰姒傚康
闂�(gu膩n)绯绘ā鍨�锛岄棞(gu膩n)閸电⒓锛堜富閸靛拰澶栭嵉锛�锛岄棞(gu膩n)绯荤殑瀹氱京鍜屾€ц唱(zh矛)锛屼笁椤炲畬鏁存€ц(gu墨)鍓�锛孍R 妯″瀷鍒伴棞(gu膩n)绯�
妯″瀷鐨勮綁(zhu菐n)鎻涜(gu墨)鍓�锛岄亷(gu貌)绋嬫€ц獮(y菙)瑷€鑸囬潪閬�(gu貌)绋嬫€ц獮(y菙)瑷€銆�
2.2 闂�(gu膩n)绯讳唬鏁�(sh霉)
浜斿€�(g猫)鍩烘湰鎿嶄綔锛屽洓鍊�(g猫)绲勫悎鎿嶄綔锛屼竷鍊�(g猫)鎿�(ku貌)鍏呮搷浣溿€�
2.3 闂�(gu膩n)绯绘紨绠�
鍏冪祫闂�(gu膩n)绯绘紨绠楀拰鍩熼棞(gu膩n)绯绘紨绠楃殑鍘熷瓙鍏紡銆佸叕寮忕殑瀹氱京銆傞棞(gu膩n)绯绘紨绠楃殑瀹夊叏鎬у拰绛夊児(ji脿)鎬�銆�
2.4 闂�(gu膩n)绯讳唬鏁�(sh霉)琛ㄩ仈(d谩)寮忕殑鍎�(y艒u)鍖�
闂�(gu膩n)绯讳唬鏁�(sh霉)琛ㄩ仈(d谩)寮忕殑绛夊児(ji脿)鍙婄瓑鍍�(ji脿)杞�(zhu菐n)鎻涜(gu墨)鍓�锛屽暉鍖栧紡鍎�(y艒u)鍖栫畻娉�銆�
绗� 3 绔狅細闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴�(k霉)瑾�(y菙)瑷€ SQL
3.1 SQL 鐨勯珨绯荤祼(ji茅)妲�(g貌u)
3.2 SQL 鐨勬暩(sh霉)鎿�(j霉)瀹氱京
3.3 SQL 鐨勬暩(sh霉)鎿�(j霉)鏌ヨ
3.4 SQL 鐨勬暩(sh霉)鎿�(j霉)鏇存柊
3.5 瑕栧湒鐨勫畾缇╁拰鎿嶄綔
绗� 4 绔狅細闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴�(k霉)鐨勭殑瑕�(gu墨)鑼冨寲瑷�(sh猫)瑷�(j矛)
4.1 闂�(gu膩n)绯绘ā寮忕殑瑷�(sh猫)瑷�(j矛)鍟�(w猫n)椤�
闂�(gu膩n)绯绘ā寮忕殑鍐椾綑鍜岀暟甯稿晱(w猫n)椤�
4.2 鍑芥暩(sh霉)渚濊炒
FD 鐨勫畾缇�銆侀倧杓槉(y霉n)娑�銆侀枆鍖�銆佹帹鐞嗚(gu墨)鍓�銆佽垏闂�(gu膩n)閸电⒓鐨勮伅(li谩n)绯伙紱骞冲嚒鐨� FD锛涘爆鎬ч泦
鐨勯枆鍖�锛涙帹鐞嗚(gu墨)鍓囩殑姝ｇ⒑鎬у拰瀹屽倷鎬э紱FD 闆嗙殑绛夊児(ji脿)锛涙渶灏忎緷璩撮泦銆�
4.3 闂�(gu膩n)绯绘ā寮忕殑鍒嗚В鐗规€�
鐒�(w煤)鎼嶅垎瑙ｇ殑瀹氱京銆佹€ц唱(zh矛)銆佹脯(c猫)瑭�锛涗繚鎸佷緷璩撮泦鐨勫垎瑙�銆�
4.4 闂�(gu膩n)绯绘ā寮忕殑鑼冨紡
1NF锛�2NF锛�3NF锛孊CNF銆傚垎瑙ｆ垚 2NF銆�3NF 妯″紡闆嗙殑绠楁硶銆�
绗� 5 绔狅細鏁�(sh霉)鎿�(j霉)搴�(k霉)鐨勮ō(sh猫)瑷�(j矛)鍜� ER 妯″瀷
5.1 鏁�(sh霉)鎿�(j霉)搴�(k霉)瑷�(sh猫)瑷�(j矛)姒傝堪
DBS 鐢熷瓨鏈熷強鍏� 7 鍊�(g猫)闅庢鐨勪换鍕�(w霉)鍜屽伐浣滐紝DBD 閬�(gu貌)绋嬬殑杓稿叆鍜岃几鍑�銆�
5.2 鏁�(sh霉)鎿�(j霉)搴�(k霉)瑷�(sh猫)瑷�(j矛)鐨勫叏閬�(gu貌)绋�
姒傚康瑷�(sh猫)瑷�(j矛)鐨勯噸瑕佹€с€佷富瑕佹椹�銆傞倧杓ō(sh猫)瑷�(j矛)闅庢鐨勪富瑕佹椹熴€�
5.3 ER 妯″瀷
ER 妯″瀷鐨勫熀鏈厓绱�锛屽爆鎬х殑鍒嗛锛岃伅(li谩n)绯荤殑鍏冩暩(sh霉)銆侀€ｉ€氳銆佸熀鏁�(sh霉)銆傞噰鐢� ER 鏂规硶鐨勬蹇�
瑷�(sh猫)瑷�(j矛)姝ラ銆�
5.4 ER 妯″瀷鍒伴棞(gu膩n)绯绘ā鍨嬬殑杞�(zhu菐n)鎻�
绗� 7 绔狅細 绯荤当(t菕ng)瀵�(sh铆)鐝�(xi脿n)鎶€琛�(sh霉)
7.1 绯荤当(t菕ng)鐩寗
绯荤当(t菕ng)鐩寗鍙婂叾鍜� DBMS 鍚勫瓙绯荤当(t菕ng)鐨勮伅(li谩n)绯�銆�
7.2 浜嬪嫏(w霉)
瀹氱京銆丆OMMIT 鍜� ROLLBACK 鐨勮獮(y菙)缇�锛屼簨鍕�(w霉)鐨� ACID 鎬ц唱(zh矛)锛屼簨鍕�(w霉)鐨勭媭鎱�(t脿i)璁婇伔鍦栥€�
7.3 鏁�(sh霉)鎿�(j霉)搴�(k霉)鐨勬仮寰�(f霉)
瀹氱京銆佸熀鏈師鍓囧拰瀵�(sh铆)鐝�(xi脿n)鏂规硶锛屾晠闅滅殑椤炲瀷锛屾鏌ラ粸(di菐n)鎶€琛�(sh霉)锛孯EDO 鍜� UNDO 鎿嶄綔锛岄亱(y霉n)琛�
瑷橀寗鍎�(y艒u)鍏堝師鍓�銆�
7.4 鏁�(sh霉)鎿�(j霉)搴�(k霉)鐨勫苟鐧�(f膩)鎺у埗
骞剁櫦(f膩)鎿嶄綔甯朵締(l谩i)鐨勫晱(w猫n)椤�锛孹 閹�銆丳X 鍗�(xi茅)璀�銆丳XC 鍗�(xi茅)璀�锛孲 閹�銆丳S 鍗�(xi茅)璀�銆丳SC 鍗�(xi茅)璀�锛屾椿閹�銆�
椁撴鍜屾閹栵紝骞剁櫦(f膩)瑾�(di脿o)搴�锛屼覆琛岃(di脿o)搴�锛屽苟鐧�(f膩)瑾�(di脿o)搴︾殑鍙覆琛屽寲锛屽叐娈靛皝閹栨硶锛孲QL 涓簨鍕�(w霉)鐨勫瓨
鍙栨ā寮忓拰闅旈洟绱�(j铆)鍒�銆�
7.5 鏁�(sh霉)鎿�(j霉)搴�(k霉)鐨勫畬鏁存€�
瀹屾暣鎬у瓙绯荤当(t菕ng)鐨勫姛鑳�锛屽畬鏁存€ц(gu墨)鍓囩殑绲勬垚銆係QL 涓殑涓夊ぇ椤炲畬鏁存€х磩鏉�锛孲QL3 涓殑
瑙哥櫦(f膩)鍣ㄦ妧琛�(sh霉)銆傚畨鍏ㄦ€х殑瀹氱京銆佺礆(j铆)鍒�锛屾瑠(qu谩n)闄愶紝SQL 涓殑瀹夊叏鎬ф(j墨)鍒�锛屽咕绋父鐢ㄧ殑瀹夊叏鎬ф帾鏂斤紝
鑷劧鐠�(hu谩n)澧冪殑瀹夊叏鎬�銆�
7.6 鏁�(sh霉)鎿�(j霉)搴�(k霉)鐨勬仮寰�(f霉)
鍩烘湰鍘熷墖銆佸(sh铆)鐝�(xi脿n)鏂规硶銆佹鏌ラ粸(di菐n)鎶€琛�(sh霉)
绗� 8 绔狅細灏�(du矛)璞℃暩(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)
8.1 灏�(du矛)璞¤伅(li谩n)绯诲湒
8.2 闈㈠悜?q奴)慰楂�?sh霉)鎿�(j霉)椤炲瀷绯荤当(t菕ng)
8.3 ORDB 鐨勫畾缇╄獮(y菙)瑷€
8.4ORDB 鐨勬煡瑭�
8.5 OODBS 鐨勬杩�
绗� 9 绔狅細鍒嗗竷寮忔暩(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)
9.1 闆嗕腑寮忓拰鍒嗗竷寮忚▓(j矛)绠�
9.2 瀹㈡埗姗�(j墨)/鏈嶅嫏(w霉)鍣ㄧ郴绲�(t菕ng)
9.3 鍒嗗竷寮忔暩(sh霉)鎿�(j霉)搴�(k霉)绯荤当(t菕ng)鐨勬杩�
9.4 鍒嗗竷寮忔暩(sh霉)鎿�(j霉)瀛樺劜(ch菙)
9.5 鍒嗗竷寮忔暩(sh霉)鎿�(j霉)搴�(k霉)鐨勯珨绯荤祼(ji茅)妲�(g貌u)
9.6 鍒嗗竷寮忔暩(sh霉)鎿�(j霉)鐨勬煡瑭�
绗� 10 绔狅細涓枔浠舵妧琛�(sh霉)
10.1 涓枔浠�
瀹氱京鍙婁綔鐢�
10.2 ODBC 绲�(ji茅)妲�(g貌u)
10.3 ODBC 鎺ュ彛
10.4 ODBC 鐨勭鍚堟€х礆(j铆)鍒�
绗� 11 绔狅細鏁�(sh霉)鎿�(j霉)搴�(k霉)鑸� WWW
11.1 WWW 鑸囨暩(sh霉)鎿�(j霉)搴�(k霉)
11.2 ASP銆丄SP.NET銆丣SP 绛夋妧琛�(sh霉)
绗� 12 绔狅細XML 鎶€琛�(sh霉)
12.1 XML 姒傝堪
12.2 XML 鏌ヨ瑾�(y菙)瑷€
12.3 鍩轰簬闂�(gu膩n)绯绘暩(sh霉)鎿�(j霉)搴�(k霉)鐨� XML 铏曠悊
鍏嶈铂(z茅)鑱叉槑锛氭湰鏂囩郴杞�(zhu菐n)杓夎嚜缍�(w菐ng)绲�(lu貌)锛屽鏈変镜鐘�锛岃珛(q菒ng)鑱�(li谩n)绯绘垜鍊戠珛鍗冲埅闄�锛屽彟锛氭湰鏂囧儏浠ｈ〃浣滆€呭€�(g猫)浜鸿榛�(di菐n)锛岃垏鏈恫(w菐ng)绔欑劇(w煤)闂�(gu膩n)銆傚叾鍘熷壍(chu脿ng)鎬т互鍙婃枃涓櫝杩版枃瀛楀拰鍏�(n猫i)瀹规湭缍�(j墨ng)鏈珯璀夊(sh铆)锛屽皪(du矛)鏈枃浠ュ強鍏朵腑鍏ㄩ儴鎴栬€呴儴鍒嗗収(n猫i)瀹�銆佹枃瀛楃殑鐪熷(sh铆)鎬�銆佸畬鏁存€�銆佸強鏅�(sh铆)鎬ф湰绔欎笉浣滀换浣曚繚璀夋垨鎵胯锛岃珛(q菒ng)璁€鑰呭儏浣滃弮鑰冿紝骞惰珛(q菒ng)鑷鏍稿(sh铆)鐩搁棞(gu膩n)鍏�(n猫i)瀹�銆�
|
鏂囩珷鎼滅储
鎮ㄧ従(xi脿n)鍦ㄧ殑浣嶇疆锛� 
