Design Of Database Of CRM System Based On Call Center

In this paper, according to the practical demands of Heilongjiang Science and Technology Museun, a CRM system for the Call Center is designed, which is included the designation of the forgrounding interface, the backgound data table, and the Class for the operation between foreground and background. For the security of the database in the designation, a mix encrypt algorithm is proposed and applied to the system.Firstly, the civil and international development of the CRM system, Call Center, and database encrypt technology is introduced,the adoptive technology of the designed system is chosen. According to the demands, system is divided into five modes, including system operation, management of information, query of multimedia information, query of operation information and monitor service.Secondly, in terms of solving the security,a new mix encrypt algorithm which is based on the conventional is proposed, The encrypt efficency and decrypt efficency of the proposed alogrithm is compared to the other alogrithm. Meanwhile, the secrect intension of the proposed algorithm is analyzed, and is applied to the system.In the background, for protecting the security of database, visiting permission to database is divided into ordinary staff permission, monitor staff permission and administrator permission.Lastly, the Web.Config document is configured in the process of coding, frequently-used code for operation of database is sealed into visiting Class, and the stored procedure is used for all stored operations. The experimental results indicate that the system is acknowledged by customers in running velocity, extent of convenience and work efficiency.