資源標準WORD格式排版共66頁 34851字 附開題報告書.doc 中期檢查表.doc 等相關文件

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

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

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)的模式結構分析..........................................4
2.3 數(shù)據(jù)庫系統(tǒng)的體系結構分析..........................................6
2.4 數(shù)據(jù)庫管理系統(tǒng)分析................................................6
第三章 人事管理系統(tǒng)設計和實現(xiàn).........................................8
3.1 在局域/廣域網(wǎng)絡上管理數(shù)據(jù)的方法...................................8
3.1.1 三層或多層的C/S基本框架結構.....................................8
3.1.2 三層C/S的功能...................................................10
3.1.3 三層C/S結構的優(yōu)點...............................................11
3.1.4 三層C/S應用的開發(fā)...............................................13
3.1.5 三層C/S應用中的核心.............................................14
3.1.6 三層C/S應用的現(xiàn)狀...............................................15
3.2 數(shù)據(jù)庫設計基本方法探討............................................15
3.2.1 查詢與視圖設計..................................................15
3.2.2 索引設計........................................................17
3.2.3 完整性約束設計..................................................19
3.2.4 數(shù)據(jù)庫的事務處理................................................21
3.2.5 數(shù)據(jù)并發(fā)和一致性................................................23
3.2.6 數(shù)據(jù)庫系統(tǒng)安全性設計............................................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)構建分析...........................................34
4.1 功能層模塊劃分....................................................35
4.1.1 系統(tǒng)軟件結構....................................................35
4.1.2 科研、教學人員管理子系統(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)應用程序設計..............................................46
4.2.1 面向對象的編程技術..............................................46
4.2.2 對服務器數(shù)據(jù)庫的訪問技術........................................47
4.2.3 OLE DB..........................................................48
4.2.4 ADO.............................................................49
4.2.5 數(shù)據(jù)環(huán)境和數(shù)據(jù)環(huán)境設計器........................................50
4.2.6 程序關鍵部分分析................................................52
結束語.................................................................