Database Design on Customer Relationship Management System

Customer relationship is occurred around the customer life cycle and the development of the information collection. This paper is based on the DB2 database design to provide technical support for the system development. First, DB2 database management system, including product components and database structure; Then, carries on the concept of database structure design, through the E-R model expressed entities, attributes, and relations between entities; Finally, database logic structure design, mainly "Salesman, Contact, the Product and the Customer" four entities such as logical structure. In this paper, the application of research results, to improve the efficiency and quality of software development, and promote the management informationization level, improve the economic benefit and core competence plays an important role in such aspects. Introduction In the traditional enterprise customer information management model, the leader and sales workers by manual approach to customer information recorded on their laptop or computer, the information is not updated in time and sharing. Therefore, often can cause the loss of customer information, or make the product submission period delay cause unnecessary loss, may be because the information loss and missed opportunities. Application of customer information management system design, computer and database technology to the enterprise customer information to conduct a comprehensive management is a new type of management mode. Customer relationship is occurred around the customer life cycle and the development of the information collection. Customer relationship management is the enterprise to enhance core competitiveness, using the corresponding information technology and Internet technology to coordination between enterprises and customers in sales, marketing and service of interaction, so as to enhance their management style, to provide customers innovative personalized customer interaction service process [1]. The ultimate goal is to attract new customers, retain old customers as well as the existing customers into loyal customers, increase market share. Database design is an important work for software development phase, the means for a given application environment, constructing the optimal database model, establish a database and application systems, to store data effectively and meet the application requirements of various users. DB2 Database Management System IBM DB2 is the IBM developed a set of relational database management system, mainly used in large application system, has good scalability, and can support from mainframes to a single user environment, apply to all common server operating systems’ platform. Provides a high level of data utilization, integrity, security, and recoverability, as well as small to large scale application execution ability, has the basic function of the has nothing to do with the platform and SQL command. Used the data classification technology, can make the mainframe data easily download to LAN database server, make the client/server users and applications can access mainframe data based on LAN, and makes the database localization and transparency of the remote connection. Have a very complete query optimizer, its external connection improves query performance, and support multitasking parallel query. 2nd International Conference on Economics, Social Science, Arts, Education and Management Engineering (ESSAEME 2016) © 2016. The authors Published by Atlantis Press 770 DB2 database management system has the following advantages [2, 3]: (1) open/portability. From the network protocol support to the programming interface for the application development, database stored procedures and triggers, distributed operation between the server and DB2 are based on the latest international standards; (2) processing performance. IBM invented the relational database and optimization technology, and continuous development, DB2 in various performance tests of leading position; (3) the ability of parallel. DB2 support bitmap index and object relations, has better scalability and performance; (4) distributed database. The processing of distributed database and DB2 connect function based on the core, do not need to use other products accessories. Performance is good, easy to use, reduce expenditure; (5) the operation is simple. DB2 provides a GUI and command line at the same time, operation is the same in the Windows and Unix; (6) replication ability. DB2 provides the best efficiency and open replication, provides automated conflict detection and solving methods; (7) support for electronic commerce. DB2 is the foundation of e-commerce, provides a JDBC interface, can write Java language stored procedures, and user-defined functions; (8) support for business intelligence. IBM business intelligence solutions have data mining tools; (9) software quality and reliability. DB2 database’s product components are as shown in Fig. 1. DB2 UDB (Universal Database) Database structure is shown in Fig. 2. Fig. 2, the Drive/Directory, specified in the Create database command Drive or Directory; DB2 Instance name, the name of the DB2 Instance owner. NODE0000 is database partition number. 0 means non-partitioned database; SQL00001, starting from 1 database ID; SQLOGDIR is the default log directory database; SQLT0000.0 Syscatspace catalog table space; SQLT0001.0, temporary tablespace Tempspace1; SQLT0002.0, user table space Userspace1. Fig. 2. Product components of DB2 database Drive/Directory