Design And Implementing Of Web-based Customer Relationship Management System

CRM is short for Customer Relationship Management. In fact,CRM is theconcept ofthemanagement thinkingofmarketing. It is theresult that the marketing thinking, whose center is the customer, isadoptedintheenterprise.CustomerRelationshipManagement,literally,is consisted of three key words: Customer, Relationship andManagement. But if we analyze the three key words logically, theyshould be explained from back to former. Management means CRM isbelong to the category of enterprise management. It refers to severalcontents, such as marketing stratagem, operation flow and enterpriseculture. Relationship means that the management is a kind ofbased-relationship management.As earlyas societyis formed, it existsrelationship among the people; after industry manufacture and scopeeconomy appear, the relationship, between enterprise and enterprise,between enterprise and people, is much more important than ever, andit impacts gradually the development of the enterprise. As a result, itgives birth to the concept of relationship management. Customermeans that the center of relationship management is customer. Thecustomer is focus. In the three key words, customer is maybe the onethat buy the product or service, and is maybe employee in theenterprise, team comrade, and is even maybe the opponent. So thecustomer of CRM is not only the one that pays for the product orservice, but also anyone that is related to the enterprise marketing.However,therelationshipbetweenenterpriseandcustomerisnotstaticor fixed. It is the based-study relationship, that is, enterprise andcustomer should communicate each other, comprehend each other andinfluence each other. Enterprise should study more in the process inorder to understand customer better and provide customer better product and service. Furthermore, management is utility of theenterprise resource. Concretely, the management of CRM is the utilityof customer information resource. How the enterprise takes advantageof the customer resource to increase the sale profit in the marketingthinkingandoperationflow,isapermanenttheme.Although CRM is the concept of marketing and management,their rapid development goes with the quick development of softwareindustryandpopularizationofInternetintheninetieslastcentury.Thatis, software industry and Internet is the carrier of the rapiddevelopment of CRM. The rapid development of software industrymakes it possible that the new CRM system is designed andimplemented or the old CRM system is modified and maintainedquicklyand canonically according to the actual needs of enterprise. Atthe same time, the popularization of Internet makes the informationsend and received quickly. Both of them are the basis of CRM rapiddevelopment.CRMbecomesafieldofcomputerapplication.CRM system in this paper is designed and developed under .NET2.0 framework and SQL Server 2005 database. .NET provides a newenvironment. In this environment, all of the application of Windowsoperatingsystem can be developed and ran. Because this CRM systemis a Web application, the technology we use is ASP.NET, which is thepart of .NET framework. ASP.NET sends content through IIS toresponse HTTP request. When document is established to respond theHTTP request, ASP.NET can establish document dynamically on theWeb server. Most of the documents are HTML document. In theprocess of ASP.NET transacting, it can access all of .NET classes, thecustomizationcontrolswhichareestablishedbyC#orotherlanguages,database. But how do we access the database? .NET framework usesbased-API ADO.NET technology to access database. ADO.NET uses the classes of database connection, command and result in the designaspect to cooperate with other framework and developmentenvironment (Visual Studio IDE). This CRM system is released onInternet, so safety is one of the factors which should be considered inthe design aspect. Internet is not dependable network, so the CRMsystem needs higher level safety authentication. Because formauthentication has higher level safety authentication than windowsauthentication, the former is adopted. This CRM system also adoptsthe AJAX technology which is popular. The traditional Webapplication allows user to fill form. When the form is submitted, theclient sends a request to Web server. Server receives this form andprocesses it, then sends back a new page. This mode wastes muchbandwidth, because the two pages are almost the same. Everytime therequest must be sent to server, so the response time of the applicationdepends onthe response timeoftheserver.As aresult,theresponse ofuser interface is much slower than the one of local application. Insteadof that mode, AJAX application can only send the data that is neededto the server, and it use SOAP or other based-XML Web serviceinterface, and the response from the server is processed in the clientthrough JavaScript. Because the data which is transmitted between theserver and thebrowse is muchless than before, wecan get responseofapplication more quickly than before. Simultaneity, a lot of work canbe done in the client which send request, so the time of the serverprocessing decreases. This mode can reduce the burden of the server,and can decreases the time of the response of the client, and make theuserfellbetter.The whole application adopts Browse/Server architecture,because the users of application are not professional computer users.Theircomputerknowledgeisverylimited.Soitisveryreasonablethat theserverisdominant whentheapplicationruns. AnotherfactoristhatB/S architecture is more flexible than C/S architecture. In the codedesign, we adopt three logic layers. From bottom to top, they are datalayer, operation layer and page layer. Data layer is responsible for theaccesstothedatabase,suchasquery,insert,updateanddeletingrecord.And database can be changed seamlessly. Operation layer isresponsible for manipulating with the abstract data source provided bydata layer. All of the operation of CRM system is centralized in thelayer. Page layeris responsibleforthepage content that is sent back tothe client, and the page content uses the function interface provided byoperationlayer.This CRM system includes several function modules. This papertakesexampleforthecustomermanagementmodule,andworkflowofthe system is introduced below: at first, the client sends request of theweb page to the server to enter into the page layer. In the page layer,The data of the form of the request is extracted. Then the page layercalls the function provided by the operation layer with the data in theform. The cache mechanism is added in the operation layer. The cacheis searchedwiththe data from thepagelayer. If theresult is not null, itis returned to the page layer after unboxing operation. If the result isnull, the flow enter into the data layer to access the database. In thedata layer, the factory class is used for getting the abstract data sourceaccess class. It accesses database, then the result is returned to theoperation layer. In that layer, the result is added to the cache. Inaddition, this CRM system uses the cache in the server, encapsulatesthe codes in the bottom to the share DLL, protects the inject attack,uses OLAP analytical processing, cluster analyze on customer and getthetimeintheserversidebyAJAX.Several primaryuserinterfaces incustomermanagementmodulearegiveninthispaper.