專業(yè)教學(xué)資源庫建設(shè)建議.doc

With the Shaanxi Expressway networking toll, toll extension business is now weighing charges for storage charges database security and backup of business data has become more prominent. After two years of operation, more and more awareness of the operating units to database stability issues is a problem not to be ignored. Simple examples such as: failure of the servers and databases, general maintenance and management staff, in many cases, cannot be independent and quick recovery, had an impact on production. So we need a proper data backup solutions. Database is the core of the whole system, database security should pay more attention. Therefore, the formulation of appropriate database backup strategy, is to maintain database security norms as well as the guidelines, to backup the data it needs from the technical, as well as administratively regulated. In data security, data security strategy is to maintain the integrity, confidentiality and availability of information. Therefore, database security policy will focus on these three points, including physical security, access control, data backup and emergency response. Here, in the toll collection system in the province uses the SQL Server database as an example to illustrate the idea of developing its security policy. 1 research background of construction of networked Expressway toll collection system reduced the number of drivers vehicles in the road network and improve road capacity, reducing environmental pollution due to parking, enhance the economic benefits of Highway and social image. Shaanxi Provincial Expressway networking toll began in May 2004, as of now there are more than 200 data server, as more sections of grid-connected charges, charges data as the core of the whole system, it is necessary to establish a set of data security and reliable solution. 2 purpose this time through the analysis of network data in server health, Shaanxi Provincial Expressway networking toll system based on data, statistical methods of data storage, data research, original charge as possible security, integrity and privacy of data. For the opening section after incorporation fees provide a reliable set of data security policies. 3 database security situation in the province Shaanxi Provincial Expressway networking toll system overview 3.1 database-tier systems, management systems, branch-level management system, the provincial network centre split and transfer system, four-level system. Each system has its own separate data server is used to store their collection of premium business data, provide the basis for statistical analysis. 1, stand-level server storage fees collected from toll lanes flowing data and pass on this site blessing Kaku, cartridge information within this site, card box allocation, cartridge combination of information and frequency information. 2, the main storage server server charges collected water from under the jurisdiction of the station data and the pass of blessing Kaku, the internal cartridge information, reallocation of the cartridge and cartridge combination, personnel information, flight information, charges the actual payment data entry work. 3, Center-class server storage server charges collected water from under the jurisdiction of the station dataWater data integrity can be up and running. So when a database server fails, you do not need to pass data to recover, simply through the collection procedure for charging water data collection to complete the fast recovery of server failures. 4.4 analysis summary summary analysis, lane because it is not a complete station level data, so there is no need for dedicated backup. Stand-level server data because it is at the front of the charge as a whole, its fault directly affects the exercise normally, you need a complete offsite backup solution. Management, and data center server, due to its operations without manual data entry, so just use common artificial scheduled backups can be. 5 solutions in order to ensure that when the server after a hardware failover, backup data without changes or only minor changes can be quick and easy troubleshooting of server data recovery, you專業(yè)教學(xué)資源庫主要建設(shè)內(nèi)容建議一、專業(yè)資源庫的功能：1.學(xué)生：課程學(xué)習(xí)、學(xué)習(xí)評價、虛擬實訓(xùn)、在線測試、培訓(xùn)考證、咨詢交流。2.教師：專業(yè)建設(shè)、教學(xué)參考、技術(shù)進(jìn)修、溝通交流3.社會學(xué)習(xí)者：學(xué)習(xí)、交流、實踐、考證、求職。 4.企業(yè)：企業(yè)宣傳、員工培訓(xùn)、技術(shù)交流、經(jīng)驗分享、人才招聘。二、專業(yè)資源庫的主要內(nèi)容（一）專業(yè)資源：目的是準(zhǔn)確定位專業(yè)人才培養(yǎng)目標(biāo)和主要就業(yè)崗位，對課程體系和課程設(shè)置提供建議。包含專業(yè)就業(yè)崗位、職業(yè)崗位能力分析、人才培養(yǎng)方案庫、人才培養(yǎng)規(guī)格、課程體系、人才培養(yǎng)模式、實驗實訓(xùn)基地建設(shè)等。子資源名稱子資源分類專業(yè)概況庫專業(yè)概況專業(yè)建設(shè)依據(jù)分析庫數(shù)據(jù)調(diào)查（行業(yè)發(fā)展及人才市場數(shù)據(jù)調(diào)查報告）政府規(guī)劃與政策數(shù)據(jù)分析報告（國際、人才需求、職業(yè)能力及行業(yè)前景分析報告）培養(yǎng)方案庫人才培養(yǎng)模式報告人才培養(yǎng)方案課程標(biāo)準(zhǔn)庫專業(yè)開設(shè)條件庫要求和條件保障（師資隊伍結(jié)構(gòu)、實踐教學(xué)條件和環(huán)境及過程質(zhì)量保證）人才培養(yǎng)質(zhì)量及評價體系（包括證書及社會評價）專業(yè)成果共享庫(市、省、國家)品牌/特色專業(yè)成果示范/骨干院校建設(shè)成果省、國家精品課程成果（二）課程資源：目的是建成集自主學(xué)習(xí)與教學(xué)功能為一體的個性化學(xué)習(xí)與教學(xué)平臺，具備自主學(xué)習(xí)、在線交流的功能。對資源進(jìn)行統(tǒng)一整合，從專業(yè)方向、課程、層次等角度進(jìn)行組織，方便用戶快速搜索，在線瀏覽和下載。主要內(nèi)容是主干課程的課程標(biāo)準(zhǔn)、學(xué)習(xí)指南、整體設(shè)計、單元設(shè)計（教案）、教學(xué)視頻、考核方案、案例庫、電子教材、電子課件、習(xí)題試題庫等內(nèi)容。子資源名稱子資源分類具體建設(shè)內(nèi)容主干課程課程標(biāo)準(zhǔn)課程標(biāo)準(zhǔn)學(xué)習(xí)指南學(xué)習(xí)引導(dǎo)，學(xué)習(xí)方法、學(xué)習(xí)路徑整體設(shè)計整體設(shè)計、內(nèi)容選取與組織、教學(xué)安排等單元設(shè)計學(xué)習(xí)情境設(shè)計教學(xué)課件全部學(xué)習(xí)情境的電子課件教學(xué)視頻整體設(shè)計錄像和學(xué)習(xí)情境教學(xué)視頻習(xí)題、試題庫配套習(xí)題庫、試題庫項目庫包括課程綜合案例和學(xué)生作品庫考核方案考核評價方案（三）行業(yè)資源：收集和整理行業(yè)資源，集中展示專業(yè)領(lǐng)域的國內(nèi)外著名企業(yè)、領(lǐng)軍人物，滿足企業(yè)品牌宣傳、產(chǎn)品推廣、人才招聘等多方面的需求，企業(yè)可以獲悉前沿技術(shù)動態(tài)，提升產(chǎn)品市場競爭力和企業(yè)創(chuàng)新能力。主要內(nèi)容包括行業(yè)概況、行業(yè)產(chǎn)品、行業(yè)崗位、技術(shù)前沿、政策法規(guī)、標(biāo)準(zhǔn)規(guī)范、企業(yè)風(fēng)采、領(lǐng)軍人物、人才供求、行業(yè)新聞等建設(shè)子項目。子資源名稱子資源分類行業(yè)概況行業(yè)、行業(yè)協(xié)會行業(yè)產(chǎn)品系統(tǒng)軟件行業(yè)崗位工作崗位技術(shù)前沿技術(shù)前沿政策法規(guī)政策法規(guī)標(biāo)準(zhǔn)規(guī)范標(biāo)準(zhǔn)規(guī)范企業(yè)風(fēng)采企業(yè)風(fēng)采領(lǐng)軍人物領(lǐng)軍人物人才供求企業(yè)招聘信息行業(yè)新聞行業(yè)新聞（四）素材資源：建成便于用戶集成創(chuàng)新、直接使用和消化吸收的滿足基本需求和個性需求的素材資源。主要包括教學(xué)素材（教學(xué)文檔模板、習(xí)題庫、試題庫、課程項目案例庫、學(xué)生作品庫）和課程學(xué)習(xí)所需的各類素材。子資源名稱子資源分類具體建設(shè)內(nèi)容教學(xué)素材教學(xué)文檔模板課程標(biāo)準(zhǔn)、整體教學(xué)設(shè)計、單元設(shè)計、授課計劃、教案與備課筆記等。習(xí)題庫、試題庫各門課程習(xí)題、各門課程完整試題等。課程項目案例庫學(xué)生作品庫學(xué)生作品簡介、設(shè)計過程、實施結(jié)果等。（500）課程素材各類素材（五）培訓(xùn)資源：根據(jù)行業(yè)、職業(yè)標(biāo)準(zhǔn)，建成涵蓋師資培訓(xùn)、企業(yè)證書培訓(xùn)、行業(yè)證書培訓(xùn)、項目開發(fā)與管理、前沿技術(shù)等在內(nèi)的各種培訓(xùn)包，形成在線培訓(xùn)資源。各類培訓(xùn)包中包括培訓(xùn)指南、培訓(xùn)內(nèi)容、培訓(xùn)資源、培訓(xùn)證書、合作單位信息等。need to select the real-time synchronization method of the programme. Typically backup system comes with backup solutions should be preferred. If the system comes with a backup plan if it cannot meet the requirements, software development methods is needed. Or third-party software systems are selected for backup. Because third-party backup software is usually priced very high, charging units require high price, so for only the first two methods are studied below. 5.1 use MS SQL2000 synchronized backups of SQL 2000 database in three ways, namely snapshot replication, transactional replication and merge replication. By comparison, excluding the first two programmes, select synchronization transactional replication and database Nothwind database, for example, for testing. The three parts of the main considerations in the synchronization of the data, can be thought of as three hosts. The Publisher, Distributor, and Subscriber; can be understood from the literal meaning, function is actually implemented to keep subscribers through the Distributor data timely and consistent data at the Publisher. 1, about snapshot replication to copy data changes infrequently, or are not required to keep the data current values (low latency), snapshot data is one of the best methods of data replication. When synchronization occurs, complete snapshot is generated and sent to the Subscriber. Because snapshot replication bulk copies released (items collection) a complete copy, it will publish all writes made to the snapshot folder. Project is to specify that you want to copy tables, data partitioning, or database objects. Projects can be a full table and certain columns (using a vertical filter), certain rows (using a horizontal filter), a stored procedure or view definition, the stored procedure execution, view, indexed, view, or user-defined function. Snapshot replication does not maintain data the fastest real-time updates, and the bulk copy released (items collection) a full copy of the mechanism will generate a lot of network traffic. Only small volumes of replication used, data is static and does not need to be updated in real time database. So do not use snapshot replication the synchronization modeData table, add a new data field MSrepl_tran_version, publishing software depending on whether the contents of this field changes to determine whether you need to publish the data. And SQL 2000 data is modified judging is managed by the kernel, not for external programming. Such as modify the structure of the original data table, a direct result of running lanes and management software that doesnt work. Due to the above test results to prove that this scenario is not suitable as a backup method for networking toll system in Shaanxi Province. 5.2 using specially developed backup software after the above tests, through the systems subscriptions, publish method in Shanxi province under the networking software sync backup, demand cannot be met, backup software so I decided to use for the development of synchronization, synchronize backups. As a result of independent development, it has a high degree of flexibility in backup. Easier for seamless integration with existing systems. Backup sof