《中铁上海工程局P3墩人工挖孔桩安全专项方案.doc》由会员分享，可在线阅读，更多相关《中铁上海工程局P3墩人工挖孔桩安全专项方案.doc（67页珍藏版）》请在三一文库上搜索。
1、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 pro
2、blem 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,
3、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 st
4、rategy 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 SQ
5、L 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
6、 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
7、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
8、 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
9、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 p
10、ass 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 in
11、ternal 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 data Water data integ
12、rity 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
13、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
14、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 need to select the real-time
15、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-
16、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 comp
17、arison, 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 Subs
18、criber; 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
19、 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 folde
20、r. 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, v
21、iew, 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
22、updated in real time database. So do not use snapshot replication the synchronization mode Data 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 modifie
23、d 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 netwo
24、rking 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
25、 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 software developed for the synchronization, you must meet the following requirements: in order to ensure synchro
26、nous backup software can start on Windows startup, and are not easily shut down by the operation, it should be developed using a Windows service. Synchronize backup software is the software that runs 24 hours, must be able to steady operation. In order to reduce network bandwidth to the greatest deg
27、ree in the backup, and only need to back up the tolling system generates the new data table. The backup software should be able to automatically filter the add new data in a database table, and synchronized backups of data that meets the conditions of form. Flags field of the current charging system
28、 using a dedicated TransferMark, any kind of toll system software after changing the record, both on the field is zero, this record has been changed to notify other software. Use this field as a flag to identify whether data has changed. In addition to this field, 重庆红岩村嘉陵江大桥主塔基础施工 P3 墩人工挖孔桩专项安全方案墩人工
29、挖孔桩专项安全方案 编制： 魏飞 复核：刘道风 审核：徐建兵 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 dat
30、abase 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
31、 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
32、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 sys
33、tem 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
34、 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
35、, 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
36、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, branc
37、h-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 fro
38、m 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 th
39、e 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 th
40、e station data Water 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, lan
41、e 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,
42、 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, yo
43、u 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 sele
44、cted 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
45、 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 P
46、ublisher, 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 ke
47、ep 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 wr
48、ites 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 proced
49、ure 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 mode Data 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 p