網(wǎng)絡(luò)工程專業(yè)外文翻譯

1、畢業(yè)設(shè)計(jì)外文資料翻譯題 目 基于web的網(wǎng)上選課系統(tǒng)的設(shè)計(jì)與實(shí)現(xiàn) key techniques for web coursechoosing system design and constructionabstract：the web coursechoosing is the core that the credit system management reforms ，at present，the web coursechoosing system that every enterprises and colleges and universities already develop ou

2、t，13o sttong or because of the diversity managing a pattern or because of system general availability，can be used being put in use directly having pretty big difficultydeveloped out the web coursechoosing adapting to our college credit system requiresin this paper，three key techniques of w eb co urs

3、echoosing design were given：o0，system security。data optimizedusing jsp technology，the web coursechoosing system with the functions of data input，query，statistics was also givengave technical and methodology supports for understanding the web coursechoosing system structural design，making full use of

4、 current practical projects，and solving the practical problems as well as paved the way of implementation of the web coursechoosing system based credit support systemkey words：web coursechoosing ；system design；key techniques；constructionintroductiononline course selection is an important part of tea

5、ching management of credit system, its characteristics can be summarized as a training model of diversity, autonomy of selective learning content, learning processes, learning flexibility of time and space. flexible teaching management mode of a significant increase in impact of traditional, manual

6、approach does not suit the new management mode, all colleges and universities in research to adapt to the new mode of teaching administration of network course selection system. at present, the college developed a system for close connection with the college teaching management mode, so the software

7、 versatility is not high, often only apply to colleges and universities. software versatility of enterprise development was strong, but later maintenance and redevelopment more difficult. based on the above reasons, nanyang institute of technology has developed online course selection system based o

8、n teaching management of credit system.1. analysis of course-choosing system requirements 1.1 students on course selection system functional requirements analysis students in the courses of the requirements within the time period, log on to the system as an optional course, by-election, in the cours

9、e selection process to be able to query the professional teaching program, instructors, such as scientific research, after the end of the course to be able to browse individual curricula, while allowing students access to personal files and all subjects.1.2 teachers course-selecting system functiona

10、l requirements analysisteachers can use the system, maintain their own research and archival information, other teachers have access to part of the research, to be able to query your course schedule, can query the courses students, to entry the students, to on course score for statistical analysis,

11、inspection under the teaching plan and teaching schedule, and so on.1.3 manager course-selecting system functional requirements analysismanagers use the system to develop the teaching plan, have access to teaching schedule tasks, have access to all courses, students and teachers have access to basic

12、 information, to carry out all kinds of statistics, and so on.2. key technologies for design of network course selection system and method 2.1 system design process2.1.1 database designdatabase design is reasonable, is the key to the smooth running of the office software system. online course select

13、ion through to serious research, teaching and foreign colleges and universities in the province runs the entire process means of tracking the implementation of requirements analysis, design of the e-r model, associate system functions and data structures, and are reflected in the database design pro

14、cess. the system database reference education management information standard under, combination i school actual of senate teaching management mode for design, while meet relationship database of entity integrity, and reference integrity, and user defined integrity requirements, using main key and o

15、utside key implementation data of integrity, using since defined of constraints conditions to reduced entry of complex of and errors rate, using trigger mechanism enhanced reference integrity and control database of changes, using storage process reduced database development personnel workload, impr

16、ove database implementation speed. foreground and background common to access a database server systems, taking into account the large amounts of data the system itself (such as students basic information basic information basic information, courses, teachers and more than more than 40) and the rela

17、tionships between data, in accordance with the relational database paradigm of 3nf, as much as possible but without redundant data interdependence.2.1.2 server configuration server configuration requirements (with pc server as an example): operating system: windows 2003, linux, and unixjava runtime

18、environment-jdk1. 3. 1application server: tomcat 4. 0 percent database server: sql server 2000, oracle 8i& oracle 9i、mysql3 23 pcserver hardware requirements: cpu: intel piii 800 or more (recommended p4 1. 6g) memory: 512m (recommend 1g) hard disk: 40g (reference 80g) problem to focus on addressing

19、the security server with the server configuration: (1) using the security features of the operating system, the operating system, such as users, user groups and access rights for strict rules, turn off services that may lead to security vulnerabilities, such as telnet, ftp, sendmail, etc; (2) in res

20、pect of hardware disk array technology, guarantee the security of server-side data.2.1.3 client development development tools use the most popular web programming language of jsp and javabean and servlet technologies used in conjunction. its advantage program page once compiled, dramatically improve

21、s program speed, followed by its good cross-platform.2.1.4 commissioning and publishing online course selection in three stages, namely normal course, lessons confirmed election results, and a by-election. trial operation of the system 2003-level undergraduate students, students in the school to fil

22、l out course selection form within the required time, selected courses, which lasted a week. normal course after the end of deans office in the normal course results to remove are not eligible for classes teaching 8 classes in, while another 4 course class class. students can be viewed on the course

23、-choosing system web site was removed, fill out the course teaching class list information, confirm the election results. after withdrawal, combined classes allow re-election of the same category of students in other courses. normal course results when processing is complete, 143 people have a by-el

24、ection. deans office manager for by-election results are processed, are still not eligible classes of the class withdrawn (that is no longer offering the course next semester). students on the course to confirm the results, you can log in course selection system to print their own curricula. through

25、 the trial operation of the system and achieve the goal of college book, since 2004 in the hospital.2.2 design of key technologies and methods2.2.1 object-oriented programming technology method of object-oriented programming is a kind of support software reuse and modular design method of practical

26、programming, its basic idea is to encapsulate and scalability. packaging to bring software modularity, security, and so on, because there is no data coupling, objects with no action taken as a result of boundary effects, therefore, easier to maintain and modify . scalability to leave system interfac

27、es for easy integration with other systems, this system to work with the library, personnel management system management system, scientific management system, the institute of financial management systems, office oa system integration, people of the smooth realization of data export.2.2.2 system sec

28、urity technologyinformation security system construction of the first issue, of course-choosing system key information (such as student achievement, student information, and so on) safety is essential, must be developed at the design stage of the system construction of reliable security policy. this

29、 system from network traffic, server security, database management systems, systems, procedures, computer virus prevention and cure of the five regard provide security: (1) network communications: virtual local area network (vi, an) services and firewall technologies. your web server and database se

30、rver system on college campus virtual subnet, only allow internal users to access, shielded external user access. for network protocol for qualifying, cute as h, p protocol allows you to access, such as frp, tenet protocol implementation. (2) server security. (3) the database account permissions and

31、 database, database view, account operations record operating information, concurrency control, trigger actions, such as time tracking, in addition, enables automatic data backup data, and so on. (4) system. a designed to dynamically set the user information in your application, access information,

32、illegal may be effective in preventing the program from the system the client logs on to the system, and b. application security control for database operations, will not cause half of the data submitted, or submitted error; c. data encryption technology, the system user (such as students, teachers,

33、 and so on) registered passwords are encrypted to eliminate user session such as technology gets the password. (5) computer virus prevention: install legitimate antivirus on the server side with anti-virus and firewall software, ensure that the functioning of the system.2.2.3 database optimization t

34、echniques.(1) sql statement optimization: sql statement into the same purpose to be poor performance the performance of sql statements. using artificial intelligence, automatically overriding sql statements, so as to find the best performance of an equivalent sql statement. (2) indexed: improving qu

35、ery speed of the system.(3) create views and stored procedures3. online course system construction 3.1 construction of management systemsystems using microsoft sqlserver2000 database in the background, foreground mining technology of jsp+javabean+servlet and b/s mode tomcat5. 0 as a web server, inte

36、rnet course-selecting system features such as data entry, modification, querying, and statistics. figure 1 is a system function module 3.2 system function(1) data maintenance functions: you can add, delete or modify data in a database operation, such as, and to deal with emergencies in the course se

37、lection process. (2) search function: can be based on user needs, such as students, teachers, and retrieve compliance data in a library. (3) data and statistics: statistical data in the database, and displayed as an icon, which found laws, provide reference for managers. (4) help: to provide users w

38、ith timely, easy online help service. figure 2 gives the student the normal course interface, figure 3 shows the students schedule.4. concluding remarks(1) after the course-choosing system, inputs to leap up in the students first, after four students course selection action, constantly modifying sys

39、tem functions, the current system has been improved, and user more human. (2) policy, system security. throughout the development phase of the system, had a number of discussions around the policy of credit system in college, due to prior implementation and to develop policies, resulting in wide ran

40、ge adjustment system modules, the progress made in the development of the system. (3) course-choosing system data processing algorithms that require further study and discussion. current system is used in the optimization level and first-come, first-served approach, courses are not guaranteed a fair

41、 and just.references:1 hu shijun, wei-chun yan, rui zhiyuan. study on the current situation of credit system and its j. gansu technology, 2004,20 (2): 151-153. 2-sa divisions warmth, wang shan. an introduction to database systems m. beijing: higher education press, 2002. 3 tang yang, wei xiong, chen

42、 hongcheng. , and so on. mechanism design and implementation of database triggers j. application of electronic technology. 2005 (2): 16-18. 4 liu de chung hom kok. principle and application of database system m. wuhan: hubei people s press. 2003.5 guo haifeng. yang guogui. oracle database performanc

43、e tuning techniques and implementation j. computer engineering. 2006. 32 (19): 82-94.網(wǎng)上選課系統(tǒng)設(shè)計(jì)的關(guān)鍵技術(shù)及系統(tǒng)的構(gòu)建摘要：學(xué)生選課是學(xué)分制管理制度改革的核心。目前，各企業(yè)及高校已經(jīng)研制出的網(wǎng)上選課系統(tǒng)，或因管理模式不同或因系統(tǒng)通用性不強(qiáng)，使得直接投入使用有相當(dāng)大的困難，為適應(yīng)南陽(yáng)理工學(xué)院學(xué)分制管理制度的改革需要，自主研發(fā)了網(wǎng)上選課系統(tǒng)。給出了網(wǎng)上選課系統(tǒng)設(shè)計(jì)的三個(gè)關(guān)鍵技術(shù)：面向?qū)ο?、系統(tǒng)安全、數(shù)據(jù)優(yōu)化，并利用jsp技術(shù)構(gòu)建了網(wǎng)上選課系統(tǒng)，實(shí)現(xiàn)了數(shù)據(jù)錄入、查詢檢索、報(bào)表統(tǒng)計(jì)等功能。為整體認(rèn)識(shí)和解決基于學(xué)分

44、制網(wǎng)上選課系統(tǒng)的結(jié)構(gòu)方案設(shè)計(jì)，解決設(shè)計(jì)中的各種實(shí)際問(wèn)題提供了技術(shù)、方法和手段的支持，也為全面系統(tǒng)地實(shí)現(xiàn)學(xué)分制教學(xué)管理模式的構(gòu)建奠定了基礎(chǔ)。關(guān)鍵詞：網(wǎng)上選課；系統(tǒng)設(shè)計(jì)；關(guān)鍵技術(shù)；構(gòu)建引 言網(wǎng)上選課是學(xué)分制教學(xué)管理的重要組成部分，其特點(diǎn)可以概括為培養(yǎng)模式的多樣性、學(xué)習(xí)內(nèi)容的選擇性、學(xué)習(xí)進(jìn)程的自主性、學(xué)習(xí)時(shí)間與空間的靈活性等。靈活性的大量增加嚴(yán)重沖擊傳統(tǒng)的教學(xué)管理模式，手工處理方式已不能適應(yīng)新的管理模式，各高校都在探索研究適應(yīng)新的教學(xué)管理模式的網(wǎng)上選課系統(tǒng)。目前各高校自主研發(fā)的系統(tǒng)因緊密結(jié)合所在院校的教學(xué)管理模式，所以軟件通用性不高，往往僅適用于所在高校。企業(yè)開發(fā)的軟件通用性雖強(qiáng)，但后期維護(hù)及二次開

45、發(fā)比較困難?；谏鲜鲈?，南陽(yáng)理工學(xué)院自主研發(fā)了基于學(xué)分制教務(wù)管理的網(wǎng)上選課系統(tǒng)。1 網(wǎng)上選課系統(tǒng)需求分析11 學(xué)生用戶對(duì)選課系統(tǒng)功能需求分析學(xué)生要求在規(guī)定的選課時(shí)間段內(nèi)，登錄系統(tǒng)進(jìn)行選課、補(bǔ)選，在選課過(guò)程中能夠查詢本專業(yè)教學(xué)計(jì)劃、任課教師的科研情況等，選課結(jié)束后能夠?yàn)g覽個(gè)人課程表等，同時(shí)允許學(xué)生查閱個(gè)人檔案及各科成績(jī)。12 教師對(duì)選課系統(tǒng)功能需求分析教師能夠通過(guò)使用該系統(tǒng)，維護(hù)自已的科研及檔案信息，能夠查閱其他教師部分科研情況，能夠查詢自己的課程安排情況，能夠查詢所帶課程的學(xué)生情況，能夠?qū)W(xué)生成績(jī)進(jìn)行錄入，能夠?qū)φn程成績(jī)情況進(jìn)行統(tǒng)計(jì)分析，能夠查閱專業(yè)教學(xué)計(jì)劃及下期教學(xué)安排等等。13 管理者對(duì)

46、選課系統(tǒng)功能需求分析管理者使用該系統(tǒng)，能夠制定各專業(yè)教學(xué)計(jì)劃，能夠查閱教學(xué)任務(wù)安排情況，能夠查閱全院課表，能夠查閱學(xué)生及教師的基本情況，能夠進(jìn)行各類統(tǒng)計(jì)等等。2 網(wǎng)上選課系統(tǒng)設(shè)計(jì)的關(guān)鍵技術(shù)與方法21 系統(tǒng)設(shè)計(jì)的過(guò)程211 數(shù)據(jù)庫(kù)設(shè)計(jì)數(shù)據(jù)庫(kù)設(shè)計(jì)是否合理，是軟件系統(tǒng)能否順利運(yùn)行的關(guān)鍵之處。網(wǎng)上選課系統(tǒng)通過(guò)到省內(nèi)、外高校認(rèn)真調(diào)研、教學(xué)運(yùn)行全過(guò)程追蹤等手段實(shí)施需求分析，進(jìn)行er模型設(shè)計(jì)，將系統(tǒng)功能與數(shù)據(jù)的結(jié)構(gòu)關(guān)聯(lián)起來(lái)，并反映在數(shù)據(jù)庫(kù)設(shè)計(jì)過(guò)程中。該系統(tǒng)數(shù)據(jù)庫(kù)參照教育管理信息化標(biāo)準(zhǔn)，結(jié)合我校實(shí)際的教務(wù)教學(xué)管理模式進(jìn)行設(shè)計(jì)，同時(shí)滿足關(guān)系數(shù)據(jù)庫(kù)的實(shí)體完整性、參照完整性、用戶定義完整性要求，利用主鍵和外鍵實(shí)現(xiàn)數(shù)

47、據(jù)的完整性，利用自定義的約束條件來(lái)減少錄入的復(fù)雜度和出錯(cuò)率，利用觸發(fā)器機(jī)制增強(qiáng)引用完整性和控制數(shù)據(jù)庫(kù)的變動(dòng)，利用存儲(chǔ)過(guò)程減少數(shù)據(jù)庫(kù)開發(fā)人員工作量，提高數(shù)據(jù)庫(kù)執(zhí)行速度。系統(tǒng)的前臺(tái)與后臺(tái)共同訪問(wèn)一個(gè)數(shù)據(jù)庫(kù)服務(wù)器，考慮到系統(tǒng)本身大量數(shù)據(jù)信息(如：學(xué)生基本信息、教師基本信息、課程基本信息等40多個(gè))及數(shù)據(jù)之間的關(guān)系，依照關(guān)系數(shù)據(jù)庫(kù)的3nf范式，盡量做到數(shù)據(jù)相互依賴但不造成冗余。212 服務(wù)器配置服務(wù)器配置需求(以pc server為例)：操作系統(tǒng)：windows 2003、linux、unixjava運(yùn)行環(huán)境-jdk131應(yīng)用服務(wù)器：tomcat 40以上數(shù)據(jù)庫(kù)服務(wù)器：sql server 2000、

48、oracle 8i&oracle 9i、mysql323pcserver硬件需求：cpu：intel piii 800以上(推薦p4 16g)內(nèi)存：512m 以上(推薦1g)硬盤：40g以上(推薦80g)服務(wù)器配置后要著重解決服務(wù)器的安全問(wèn)題：(1)利用操作系統(tǒng)安全功能，對(duì)操作系統(tǒng)用戶、用戶組及訪問(wèn)權(quán)限等作嚴(yán)格規(guī)定，關(guān)掉可能導(dǎo)致安全漏洞的服務(wù)，如telnet、ftp、sendmail等；(2)在硬件方面采用磁盤陣列技術(shù)，保證服務(wù)器端數(shù)據(jù)的安全性。213 客戶端開發(fā)開發(fā)工具選用目前最為流行的網(wǎng)絡(luò)編程語(yǔ)言jsp，并結(jié)合使用javabean 和servlet技術(shù)。其優(yōu)點(diǎn)在于程序頁(yè)面一次性編譯，大大提

49、高了程序的訪問(wèn)速度，其次是其具備良好的跨平臺(tái)性。214 試運(yùn)行及發(fā)布網(wǎng)上選課分三個(gè)階段，即正常選課、確認(rèn)選課結(jié)果、退補(bǔ)選課。該系統(tǒng)在2003級(jí)本科生中試運(yùn)行，學(xué)生在學(xué)院規(guī)定的時(shí)間內(nèi)進(jìn)行填寫選課單、選定課程，歷時(shí)一周。正常選課結(jié)束后，教務(wù)處根據(jù)正常選課結(jié)果，撤銷不符合開班條件的課程教學(xué)班8個(gè)，同時(shí)對(duì)另外4個(gè)課程教學(xué)班進(jìn)行合班。學(xué)生可以在網(wǎng)上選課系統(tǒng)網(wǎng)站上查看被撤課程、補(bǔ)撤教學(xué)班的學(xué)生名單等信息，確認(rèn)選課結(jié)果。撤、合班后允許學(xué)生改選同一類別的其它課程教學(xué)班。正常選課結(jié)果處理完畢后，有143人進(jìn)行了補(bǔ)選。教務(wù)處管理人員針對(duì)補(bǔ)選結(jié)果進(jìn)行處理，對(duì)仍有不符合開班條件的教學(xué)班進(jìn)行撤銷(即下學(xué)期不再開設(shè)該門課程)。學(xué)生對(duì)選課結(jié)果進(jìn)行確認(rèn)，可以登錄選課系統(tǒng)打印自己課程表。通過(guò)系統(tǒng)試運(yùn)行，達(dá)到學(xué)院預(yù)定的目