专业教学资源库建设建议.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专业教学资源库主要建设内容建议一、专业资源库的功能：1.学生：课程学习、学习评价、虚拟实训、在线测试、培训考证、咨询交流。2.教师：专业建设、教学参考、技术进修、沟通交流3.社会学习者：学习、交流、实践、考证、求职。 4.企业：企业宣传、员工培训、技术交流、经验分享、人才招聘。二、专业资源库的主要内容（一）专业资源：目的是准确定位专业人才培养目标和主要就业岗位，对课程体系和课程设置提供建议。包含专业就业岗位、职业岗位能力分析、人才培养方案库、人才培养规格、课程体系、人才培养模式、实验实训基地建设等。子资源名称子资源分类专业概况库专业概况专业建设依据分析库数据调查（行业发展及人才市场数据调查报告）政府规划与政策数据分析报告（国际、人才需求、职业能力及行业前景分析报告）培养方案库人才培养模式报告人才培养方案课程标准库专业开设条件库要求和条件保障（师资队伍结构、实践教学条件和环境及过程质量保证）人才培养质量及评价体系（包括证书及社会评价）专业成果共享库(市、省、国家)品牌/特色专业成果示范/骨干院校建设成果省、国家精品课程成果（二）课程资源：目的是建成集自主学习与教学功能为一体的个性化学习与教学平台，具备自主学习、在线交流的功能。对资源进行统一整合，从专业方向、课程、层次等角度进行组织，方便用户快速搜索，在线浏览和下载。主要内容是主干课程的课程标准、学习指南、整体设计、单元设计（教案）、教学视频、考核方案、案例库、电子教材、电子课件、习题试题库等内容。子资源名称子资源分类具体建设内容主干课程课程标准课程标准学习指南学习引导，学习方法、学习路径整体设计整体设计、内容选取与组织、教学安排等单元设计学习情境设计教学课件全部学习情境的电子课件教学视频整体设计录像和学习情境教学视频习题、试题库配套习题库、试题库项目库包括课程综合案例和学生作品库考核方案考核评价方案（三）行业资源：收集和整理行业资源，集中展示专业领域的国内外著名企业、领军人物，满足企业品牌宣传、产品推广、人才招聘等多方面的需求，企业可以获悉前沿技术动态，提升产品市场竞争力和企业创新能力。主要内容包括行业概况、行业产品、行业岗位、技术前沿、政策法规、标准规范、企业风采、领军人物、人才供求、行业新闻等建设子项目。子资源名称子资源分类行业概况行业、行业协会行业产品系统软件行业岗位工作岗位技术前沿技术前沿政策法规政策法规标准规范标准规范企业风采企业风采领军人物领军人物人才供求企业招聘信息行业新闻行业新闻（四）素材资源：建成便于用户集成创新、直接使用和消化吸收的满足基本需求和个性需求的素材资源。主要包括教学素材（教学文档模板、习题库、试题库、课程项目案例库、学生作品库）和课程学习所需的各类素材。子资源名称子资源分类具体建设内容教学素材教学文档模板课程标准、整体教学设计、单元设计、授课计划、教案与备课笔记等。习题库、试题库各门课程习题、各门课程完整试题等。课程项目案例库学生作品库学生作品简介、设计过程、实施结果等。（500）课程素材各类素材（五）培训资源：根据行业、职业标准，建成涵盖师资培训、企业证书培训、行业证书培训、项目开发与管理、前沿技术等在内的各种培训包，形成在线培训资源。各类培训包中包括培训指南、培训内容、培训资源、培训证书、合作单位信息等。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