In the new era, as responsible for the computer management system functions and personnel, should be fully aware of the importance of the security of the computer management system, and based on the current computer management system of the problems that exist in the system, targeted to the development of preventive and control strategies in order to ensure that the system's security. The following is what I recommend to you, I hope you like it!
Part I"Enterprise Computer Management System Maintenance Research"
Abstract: Enterprises have entered the era of computer management, business personnel less and less manual intervention, a large amount of information is completed by the computer system, business personnel from the original daily handling of a large amount of information on the affairs of the release, paper vouchers single with the automation of the realization of the enterprise has been less and less, the enterprise's data management on the The dependence on computer is getting stronger and stronger, and the requirements for the stability and security of the computer system are getting higher and higher. According to the practical experience of engaging in computer system maintenance work, combined with actual cases, the computer system to perform maintenance work.
Keywords: computer management system; maintenance A corner; maintenance B corner; MIT; DISTINCT; distribution submission
Author's introduction: Artemisia Yajun ***1980-***, female, Shanghai Baoshin Softwares Co., Ltd. ERP Software Division of the senior engineers, the direction of the research for the steel industry ERP management information system software design and implementation, maintenance. The research direction for the steel industry ERP management information system software design and implementation, maintenance.
0Introduction
With the advent of the information age, the management of large and small enterprises need to rely on computer systems. At present, many software companies specializing in custom information management system for the enterprise, often pay more attention to consulting planning and software implementation, and for the project on the line after the operation and maintenance work is relatively neglected. I believe that the maintenance of computer systems and the implementation of the project is equally important, operation and maintenance work is mainly responsible for the daily application of the computer system in the process of abnormalities, in the event of anomalies in a timely and rapid manner to deal with the operation of the business staff does not have an impact. And regularly back up the system information, daily check the system's implementation of regular efficiency and load, regularly check the system to deal with the data program is normal, and so on.
1 computer system operation and maintenance
In recent years, I engaged in computer system operation and maintenance. Iron and steel production and marketing management system has been running for 10 years, I am responsible for one of the modules, take over the module, the overall structure of this large-scale system do not understand, and even do not know how to log on to the system, so as soon as possible to learn the system, learn how to find the program, how to compile, how to enter the database. After that, we were faced with new requirements or information that needed to be modified by business people in their daily work. For the new demands raised by users, the first step is to understand the business and locate the understood business in the system. Whether it is necessary to modify the programs already existing in the system or to write new programs requires the judgment of the maintenance staff. After having an understanding of these basics, you can basically deal with simple problems in daily operation and maintenance.
1.1 The main content of the computer system maintenance work
Business side of the expansion of business, the need to add new features, then the need to communicate with the user of the new business, to understand the needs of the user, the user's needs will be applied to the system. The new features in the system should minimize the impact of the current business in the system, so that the new features do not affect the original normal implementation of the business.
The main contents of the computer system maintenance work are:
①System regular downtime for data backup, garbage cleanup, etc.;
②Daily regular review of the system's performance efficiency and system load;
③The regular inspection of the UPS device;
④On the server and the personal terminal computer hardware monitoring and maintenance;
5The system is not a computer system.
5) The business side often asks questions about the system when analyzing data, and when the business side questions the data, explain the logic of the data before and after;
6) The business side occasionally makes mistakes in entering data, and requires maintenance staff to modify the data, and when modifying the data, it is necessary to modify all the tables involved accordingly;
7) When the business side asks for advice on processing logic for computer systems, it is necessary to patiently explain the logic;
8) When the business side asks for advice on processing logic for computer systems, it is necessary to patiently explain the logic.
8 For some of the background batch processing program, daily regular monitoring of the results of its implementation is correct, in the case of incorrect processing failures;
9 to be the first time to respond to the call.
1.2 Characteristics of operation and maintenance work
Operation and maintenance work is trivial and complicated, once a problem occurs to be resolved in a timely manner, otherwise it will have an impact on the other modules, resulting in a longer time to deal with the impact of the surface to become larger. Timely troubleshooting is a basic requirement for O&M work, and to be able to do so in a timely manner depends on the usual accumulation of experience and accurate positioning of the problem.
Operation and maintenance personnel are on the front line and the user to deal with people, in dealing with day-to-day operation and maintenance work, should be more understanding of the user's needs, some of the potential projects is this time to be tapped, so that the user to solve the problem at the same time also for the company to increase the number of project opportunities. Operation and maintenance personnel on behalf of the company's image, computer system operation and maintenance is a service, operation and maintenance personnel should have a sense of service, so that the user trust, at the same time, operation and maintenance personnel should be put forward by the user to bring back some of the recommendations, in the future project to take into account, so that the company's software to continue to improve, improve market competitiveness.
For the operation and maintenance work, each post has A, B corner, the so-called A, B corner is the same post of different roles in the name of the A corner is the main operation and maintenance personnel to serve as the post, is the person in charge of the maintenance of the post, in the A corner of the vacation or sick period, the operation and maintenance of the work by the B corner to complete, so that does not hold up the user's work. Of course, as the A corner of the person at the same time as the other modules of the B corner, that is, the operation and maintenance personnel should not only be responsible for their own module is familiar with, at the same time on the other modules should also be familiar with.
1.3 Relationship between O&M and project
The relationship between O&M and project means that the project implementation team and the O&M team in general will have a change in personnel, and when the project is implemented, not only do we have to consider the problem from the perspective of the project, but also for the future of O&M considerations. For example, to deal with a batch of information, the need to take out the information in the A table in accordance with a certain logic written to the B table, if the system server efficiency, then the way back to the circle will be taken out of all the information in the A table, one by one, one by one back to the circle, each piece of information to deal with the logic of the good, added to the B table until the A table of all the information processed; if the efficiency of the system server is not very high, then the INSERT ... SELECT ... query at the same time the way to add, so that the efficiency is higher, but the logic of the SELECT statement is more complex. In doing the project both ways to write feasible, if you can take into account the later operation and maintenance work, the first way is relatively good, for the operation and maintenance to take over the program to read the program than modify the program is easy to get started, and the program on the line after the implementation of the program is not easy to have errors. The second way of writing, in the operation and maintenance phase, if the user proposes to increase the logic or modify the logic, then to read the logic of the original SELECT is not very easy to write, even if you read and understand the logic of the increase in the basis of the logic or modify the logic is prone to error, the program is easy to go online after the data errors and other problems.
Operation and maintenance should also pay attention to: for batch data processing program, the amount of data is very large, when adding new information, do the mit of the processing, then when such a program abnormal error, we must examine whether there is already information added to the data to be in the data with the time or other columns to do the mark, so as to quickly find out has been the mit of the information to find the information to be deleted, and re-execute the program.
1.4 Operation and maintenance process management
Operation and maintenance process each time the handling of events, problems and new requirements raised by the user, should be recorded, the person who raised the problem needs to record the problem, operation and maintenance personnel to deal with the problem after the problem, to describe the cause and the process of dealing with the problem and then close the problem. Users of the new requirements, the same needs to be recorded by the user first requirements, the requirements will be described clearly, the operation and maintenance personnel to get the requirements and the user to communicate, system design, programming, testing, and finally on-line application. The operation and maintenance personnel will record the process according to the recorded requirement list, and then close the requirement list. The process is a process of operation and maintenance management, the operation and maintenance process all recorded, on the one hand, the audit requirements of the system, on the other hand, and the user's interaction with the process of record-keeping.
Operation and maintenance work also requires a lot of communication, because the systems are associated with the interface, when the system fails, the need to carry out system repair, the associated systems have to make the corresponding adjustments, the need to communicate with other systems of operation and maintenance personnel. Communication should pay attention to the tone of voice, more from the point of view of others to describe the problem, operation and maintenance personnel need to communicate effectively with the user, the need for effective communication with the neighboring systems operation and maintenance personnel, good communication on the operation and maintenance of the work to play a multiplier effect.
1.5 Actual cases
Business people need operation and maintenance personnel to deal with the incident process is as follows: the operation and maintenance personnel received the system operation and maintenance platform on the cell phone to deal with the incident of the newsletter, log in to the operation and maintenance platform, the event to judge, telephone contact with the event of the business people, through the communication, to understand the specific events, looking for a solution, and sometimes after the communication of the business people to find out that the understanding deviation, to the business personnel, to the business people, and to the business people, to the business people, and to the business people. Sometimes the communication reveals that it is the deviation of the business person's understanding, explains to the business person, and then describes the solution to the incident on the operation and maintenance platform, and then closes the incident.
Sometimes the event to be handled requires analysis of the data, such as a program to handle a large amount of data, in the system is executing the program and the system to the database of the normal backup of the system there is a conflict, the database backup of the first table to lock, it is just that the program to deal with the batch of data to this table to add the new will be prone to error. When we receive such an event, we will first review the error program to see if the program has distributed the data submission, generally when dealing with a large amount of data, it is necessary to distribute the submission, for the database, the one-time submission of millions of pieces of data, there will be a situation of overflow, so the program developers are asked to code 1000 pieces of data mit once, so that the load on the library has been significantly reduced. However, for the error just described, first of all, we have to see whether the program has written mit, if it exists, then we have to check whether there has been a new successful data in the table being written, as for how to find out the data, it involves doing the project when the coding should be taken into account to mark the time or other fields, so that we can query the data when the data is in error. Write the program with the time field for marking, so that when dealing with faults, the time field for DISTINCT operation to see whether the time point in the failure of the information, if there is information, the information to delete the operation, to be backed up to the database is complete, re-submit the program to deal with the information, so that there will be no duplication of data phenomenon. After the event is processed, the O&M platform describes the processing of the event and closes the event, marking the end of event processing.
2 Conclusion
Maintenance of computer systems and the implementation of the work is equally important, whether it is the implementation of the project or maintenance system, I believe that the most important thing is to learn by heart, no matter how cumbersome things, if you can be quiet and clear thinking, will be solved. The author combined with their own work experience, through the example of computer system maintenance work carried out research, in order to peer staff engaged in related work to provide some reference.
References:
[1] Ji Rui, Shen Hui. Discussion on the maintenance method of computer laboratory software system[J]. Journal of Xi'an Institute of Posts and Telecommunications, 2007***5***.
[2]Men Yunhui. A study on cost accounting ACTX balance in steel manufacturing industry[C]. Baosteel International Conference, 2013.
Click on the next page and more>>> ?