【作者】 王再堂；

【导师】 刘衍珩；

【作者基本信息】 吉林大学 ， 软件工程， 2005， 硕士

【摘要】 本文详细讨论了如何在开发一套具有实用性、稳定性、高效性的信金CRM 系统的BATCH 处理。信金CRM 系统是一个实时信息处理系统,通过信金CRM 系统,银行为顾客提供更加个人化的服务以提高客户满意度,从而达到提高市场占有率的目的,更好的发挥银行的资金,使银行承担很低的风险,同时能够为银行带来很多收益,象提高满意度、扩大市场份额、提高效率、降低成本、降低维护培训费用等。在设计上,注重提高系统情报处理效能,在强化系统后台数据处理上下功夫,实现了各种数据的高效的BATCH 处理,系统整体保障能力有了显著提高。本文主要介绍了如何用ORACLE 中的PL/SQL 实现信金CRM 系统的存储过程,以及在处理过程中需要用到相关的技术。最后结合实例具体阐述了信金CRM系统的存储过程的流程和具体实现以及实际测试和具体代码的优化方面进行了探讨。更多还原

【Abstract】 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更多还原