Implementation And Research Of Stored Procedure For Credit Bank CRM System

With the progress of computer technique, how to achieve CRMby computer is a hot research point across the world. Whether anenterprise can survive or not is depended on Customer relationship,especially for a bank. Only if the bank focuses its services onthe customers, not only serving them positively, but alsoenlarging clients, improving the relationship with the clients,can it get a promoting future. The more automatic a bank tradeoperation is, the more client data are stored in the operativesystem which are treasures regarding the bank. But as a matter offact, there are so profuse data that our managers are in a sorryplight to deal them with poor related knowledge.Most of the present developed CRM software applications areoperational systems and writing systems. CRM is the softwaresystem that has the function of data analysis. Compared with thefirst two kinds of systems, CRM system can give the bank more spaceand opportunities to give a rise to the profits. The system is notonly to simply record the information of customers and to resolvethe problems coming up in the process of service to customers, butalso to make the best influence in maintaining customerrelationship and gaining more clients. So further management andanalysis of the customer information is needed to mine valuableinformation, and with the help of the system, to implement "oneto one"customer enlargement strategy and cares to all clients.If we want to adopt CRM, the crucial job is to build up anintegral system, taking customers as the center. This systemrecords, looks up, manages, and analyses characteristics ofcustomers and relative trade information between bank andcustomers. In CRM, CIF is comprised of static custom informationand dynamic custom information. CRM's main task is building up,looking up, maintaining, etc., and the focus is how to collectvaluable data, so we can analyse custom credit, take full advantageof bankroll, and make the bank take a very low risk.This paper mainly introduces how to use PL/SQL in ORACLE toimplement the credit bank stored procedure in the CRM system, aswell as the relative technologies in this implementation procedure.According to different demands which is that a batch of data aredealed with every fixed time, credit bank CRM is divided intoevery-day implementation, every-month implementation, andmultiple-replacement implementation. This paper takes every-dayimplement as an example, that is, because some data in the bankoperation system need be implemented every day, the latest datashould be displayed the next day, data in database should beconstant with the data in the foreground. The data implemented inthe foreform are put into a temporary chart which will be underBATCH implement, if the chart is not in use in that night. In theend, after the implementation of a series of charts, we willabstract some valuable information (for instance, custom credit),so we can learn who are customers with credit, distinguish thecustom consume laws from valuable information which will instructbank departments operation, so more quick and satisfying servicewill be received to help the bank to promote custom satisfactionrate and loyalty rate, to make the best use of the bankroll whichmakes the bank at less risk, finally the bank market competitionability will be developed. At last, on the base of theimplementation of stored procedure, we analyse which language ismore effective to make sure that the codes written are fastimplemented, highly qualitative, effective, and high customsatisfaction rate.This paper has five chapters. Chapter One. the exordium whichis the integral introductive part of this paper. Brieflyintroduces the background and the meaning of this paper, as wellas development trend in the research status of CRM in China.Chapter Two. CRM research and theoretic analysis. Mainlyintroduces what is CRM and concrete content of CRM, including itsmain component model and strategy, and introduces present CRMdevelopment trend of civil enterprises and CRM life cycle.Chapter Three. Credit bank CRM construction and crucialtechnologies. In this chapter, mainly introduces credit bank CRMconstruction and crucial technologies of database implementation,focusing the knowledge on database and stored procedure, and thecircumstance which is needed in the process of stored procedure.Chapter Four. The implementation of credit bank CRM storedprocedure. Mainly describes how to use PL/SQL in Oracle toimplement stored procedure, the technologies used in storedprocedure and relative optimizing status, such as implementation...