資源標(biāo)準(zhǔn)WORD格式排版共66頁 34851字 附開題報告書.doc 中期檢查表.doc 等相關(guān)文件

摘 要
信息管理是一項古老的活動，但管理方式卻沒有停止過變化:從手工記錄到計算機(jī)存儲；從平面文件到關(guān)系對象型數(shù)據(jù)庫；從單機(jī)單用戶數(shù)據(jù)庫訪問模式到客戶/服務(wù)器模式……信息管理的技術(shù)越來越先進(jìn)、科學(xué)和客觀。同時，可管理的信息容量也越來越大，更適應(yīng)信息膨脹時代的要求。本論文就人事系統(tǒng)設(shè)計實現(xiàn)進(jìn)行了分析探討:首先概要性地介紹了數(shù)據(jù)庫的基本理論；然后就該人事系統(tǒng)設(shè)計要點的指導(dǎo)理論進(jìn)行了敘述；最后介紹了該人事系統(tǒng)的功能模塊劃分，簡要列舉了各功能模塊的功能，并列出了一些程序代碼以說明該人事系統(tǒng)應(yīng)用程序設(shè)計中所采用的技術(shù)。

關(guān)健詞:關(guān)系型數(shù)據(jù)庫，三層客戶/服務(wù)器，對象，數(shù)據(jù)訪問技術(shù)，插口接口

Abstract
Management of information is an old activity,while the means of managing is developing during all the time: from handwork to computer technology；from flat file to relational object database；from single computer mode to client/server mode……, the technology for management is more developed, more scientific and more objective.Meanwhile,the datum that can be managed is much more,which matches the development of information era.According to the requirements of person management in one university, this dissertation analyzes and discusses the system design and realization:it first briefly introduces the basic theories of
database；then according to the experience gotten during the period of design for this person management system, this dissertation expounds the theories which are instructional to the main design points；at last, this article introduces the functional modules and the main functions of each module, further more, some codes are listed to demonstrate the technologies which are adopted in application programs.

Keywords: RDBMS,Three-tierC/S,Object,Data Accessing Technology,Socket

目 錄
摘 要..............................................................ⅢAbstract.............................................................Ⅳ
第一章 緒論...........................................................1
第二章 數(shù)據(jù)庫基本理論.................................................4
2.1 數(shù)據(jù)庫模型分析....................................................4
2.2 數(shù)據(jù)庫系統(tǒng)的模式結(jié)構(gòu)分析..........................................4
2.3 數(shù)據(jù)庫系統(tǒng)的體系結(jié)構(gòu)分析..........................................6
2.4 數(shù)據(jù)庫管理系統(tǒng)分析................................................6
第三章 人事管理系統(tǒng)設(shè)計和實現(xiàn).........................................8
3.1 在局域/廣域網(wǎng)絡(luò)上管理數(shù)據(jù)的方法...................................8
3.1.1 三層或多層的C/S基本框架結(jié)構(gòu).....................................8
3.1.2 三層C/S的功能...................................................10
3.1.3 三層C/S結(jié)構(gòu)的優(yōu)點...............................................11
3.1.4 三層C/S應(yīng)用的開發(fā)...............................................13
3.1.5 三層C/S應(yīng)用中的核心.............................................14
3.1.6 三層C/S應(yīng)用的現(xiàn)狀...............................................15
3.2 數(shù)據(jù)庫設(shè)計基本方法探討............................................15
3.2.1 查詢與視圖設(shè)計..................................................15
3.2.2 索引設(shè)計........................................................17
3.2.3 完整性約束設(shè)計..................................................19
3.2.4 數(shù)據(jù)庫的事務(wù)處理................................................21
3.2.5 數(shù)據(jù)并發(fā)和一致性................................................23
3.2.6 數(shù)據(jù)庫系統(tǒng)安全性設(shè)計............................................26
3.3 數(shù)據(jù)庫系統(tǒng)性能優(yōu)化分析............................................29
3.3.1 性能及其影響因素................................................29
3.3.2 對查詢優(yōu)化器的理解..............................................30
3.3.3 存儲過程........................................................32
第四章 人事管理系統(tǒng)構(gòu)建分析...........................................34
4.1 功能層模塊劃分....................................................35
4.1.1 系統(tǒng)軟件結(jié)構(gòu)....................................................35
4.1.2 科研、教學(xué)人員管理子系統(tǒng)........................................38
4.1.3 行政人員管理子系統(tǒng)..............................................41
4.1.4 工人管理子系統(tǒng)..................................................43
4.1.5 人事統(tǒng)計子系統(tǒng)..................................................44
4.2 人事系統(tǒng)應(yīng)用程序設(shè)計..............................................46
4.2.1 面向?qū)ο蟮木幊碳夹g(shù)..............................................46
4.2.2 對服務(wù)器數(shù)據(jù)庫的訪問技術(shù)........................................47
4.2.3 OLE DB..........................................................48
4.2.4 ADO.............................................................49
4.2.5 數(shù)據(jù)環(huán)境和數(shù)據(jù)環(huán)境設(shè)計器........................................50
4.2.6 程序關(guān)鍵部分分析................................................52
結(jié)束語.................................................................