Research On Customer Relationship Management System For Petrochina Northwest Chemicals Marketing Company

Petrochina Northwest Chemicals Marketing Company is engaged in marketing the petrochemical products, is also responsible for the Petroleum Chemical products transportation of seven Petrochemical factories of west-China. By the information technology developing rapidly, it is necessary to use information technology tools to maintain relationships with customers by a customer relationship management system (CRM) because the customers of Petrochina Northwest Chemicals Marketing Company are the corporation. To combine the customer, product, marketing, sales, services, there need unify the science of management and information technology together. It will to standardize business processes, improve customer mining capacity and customer service quality and effective management of customer resources and improve the speed of the sales process, and to enhance the core competitiveness of enterprises overall purpose.MY company's CRM based on the B/S development pattern, JSP is the development kit, conforms to company's star network architecture, various subsidiary companies, sales outlet (B) only needs through company's network, then visits the establishment using WEB in the star structure middle server. The disposable arriving's development, may cause the different user, from the different place, the visit which and the operation common database (for instance LAN, VPN) facilitates by the different turning on way; This had already guaranteed server's security, reduced the development cost, but also reduced the database maintenance management work load, is one kind suits our company to manage the region broad, the various departments close coordination to cooperate and to sell the cross region the mode of administration, can protect the data platform and the management access authority effectively.Since JSP is based on the Java Servlet and the Java System Web development technologies, it can create a modern, safe, fast and cross-platform way of WEB landing. JSP constitutes the WEB in traditional HTML file using Java program fragment and JSP tags. Web server receives a request to access JSP WEB, the first implementation of the program fragment, then the implementation of the results in HTML format back to the customer. Program fragments can operate the database, re-orientation WEB, etc., it is the best use of satellite-based network capabilities. All program operations are executed on the server, network upload client is only given to the results obtained, the configuration of the client machine and browser requirements lower.Using Oracle database to define the different forms of various customer-related information and the links between information, using various forms of logic to design a variety of statistics, the query module, etc., using Oracle's query, modify the permissions, etc. reasonable distribution of features, configure the last CRM user permissions, relying on the stability of the Oracle database, the database compatibility to call the shots, Carries on the analysis to the company each selling operation (for example quantity price allocated proportion coefficient, customer plan execution rate and so on), but also the regeneration of the CRM system and lay a good foundation for scalability.The CRM customer relations management system management system, one kind of beneficial relations which establishes for between the company and the customer, (change) treats the customer through the choice the way, realizes the income which obtains from the customer body,provides the rallying customer organizational structure the convenient method and the basic structure, forms the strategic advantage, reduces the cost and the reduction product going on the market time. The CRM system has the client management, the order form management, the market regulation, the hard currency, work flow modules and so on management management, data mining, commercial intelligence, the data mining technology may make the support for enterprise's strategic tactic decision-making, the electronic commerce technology may provide the online interactive service for the customer.System administrator can control different users and can back up the data of security requirements on server. The interface "B" can be built using the JSP language of the WEB development tools, back-end database "S" can be built using the mainstream of the database (Oracle). It is to contribute the perfect combination of faster development of enterprises to the modern concept of marketing management and information technology by the amiable the WEB interface and simple landing approach and security measures.